P_ACDOCD

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ACDOCD.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_ACDOCD AS
SELECT
  cast(acdocd.rldnr as fins_ledger_pers preserving type) AS rldnr,
  cast(acdocd.rbukrs as fis_bukrs preserving type) AS rbukrs,
  cast(acdocd.gjahr as fis_gjahr_no_conv preserving type) AS gjahr,
  cast(acdocd.belnr as fis_belnr preserving type) AS belnr,
  cast(acdocd.docln as fis_docln preserving type) AS docln,
  cast(acdocd.ryear as fis_ryear_no_conv preserving type) AS ryear,
  acdocd.rrcty AS rrcty,
  cast(acdocd.docnr_ld as fis_docnr_ld preserving type) AS DOCNR_LD,
  cast(rmvct as fis_rmvct preserving type) AS rmvct,
  cast(vorgn as fis_vorgn preserving type ) AS vorgn,
  vrgng,
  cast(bttype as fis_bttype preserving type) AS bttype,
  cast(cbttype as fis_custbttype preserving type) AS cbttype,
  cast(closingstep as fis_closingstep preserving type) AS closingstep,
  cast(awtyp as fis_awtyp preserving type) AS awtyp,
  cast(awsys as logsystem preserving type) AS awsys,
  cast(aworg as fis_aworg preserving type) AS aworg,
  awref,
  awitem,
  awitgrp,
  subta,
  xreversing,
  xreversed,
  xtruerev,
  awtyp_rev,
  aworg_rev,
  awref_rev,
  cast( subta_rev as fis_subta_rev preserving type ) AS subta_rev,
  xsettling,
  xsettled,
  prec_awtyp,
  prec_aworg,
  prec_awref,
  prec_awitem,
  prec_subta,
  prec_bukrs,
  cast( prec_gjahr as fins_prec_gjahr_gfc_no_conv preserving type ) AS prec_gjahr,
  prec_belnr,
  prec_docln,
  src_awtyp,
  src_awsys,
  src_aworg,
  src_awref,
  src_awitem,
  src_awsubit,
  xcommitment,
  cast( obs_reason as fis_obsolete_item_reason preserving type ) AS obs_reason,
  cast( xsecondary as journalentryissecondaryentry ) AS XSECONDARY,
  orgl_change,
  cast(racct as fis_racct preserving type) AS racct,
  cast(rcntr as fis_kostl preserving type) AS rcntr,
  cast(prctr as fis_prctr preserving type) AS prctr,
  cast(rfarea as fm_farea preserving type) AS rfarea,
  cast(rbusa as fis_rbusa preserving type) AS rbusa,
  cast(kokrs as fis_kokrs preserving type) AS kokrs,
  segment,
  cast(scntr as fis_skost preserving type) AS scntr,
  cast(pprctr as fis_pprctr preserving type) AS pprctr,
  cast(sfarea as fis_sfkber preserving type) AS sfarea,
  cast(sbusa as fis_pargb preserving type) AS sbusa,
  cast(rassc as fis_rassc preserving type) AS rassc,
  psegment,
  cast(rtcur as fis_rtcur preserving type) AS rtcur,
  cast(tsl as fis_tsl preserving type) AS tsl,
  cast(rwcur as fis_rwcur preserving type) AS rwcur,
  cast(wsl as fis_wsl preserving type) AS wsl,
  cast(rhcur as fis_hwaer preserving type) AS rhcur,
  cast(hsl as fis_hsl preserving type) AS hsl,
  hvkwrt,
  cast(rkcur as fis_rkcur preserving type) AS rkcur,
  cast(ksl as fis_ksl preserving type) AS ksl,
  rfccur,
  cast(fcsl as fis_vfccur12 preserving type) AS fcsl,
  cast(rocur as fis_rocur preserving type) AS rocur,
  cast(osl as fis_osl preserving type) AS osl,
  cast(rvcur as fis_rvcur preserving type) AS rvcur,
  cast(vsl as fis_vsl preserving type) AS vsl,
  rbcur,
  cast(bsl as fis_bsl preserving type) AS bsl,
  rccur,
  cast(csl as fis_csl preserving type) AS csl,
  rdcur,
  cast(dsl as fis_dsl preserving type) AS dsl,
  recur,
  cast(esl as fis_esl preserving type) AS esl,
  cast(rfcur as fis_rfcur preserving type) AS rfcur,
  cast(fsl as fis_fsl preserving type) AS fsl,
  rgcur,
  cast(gsl as fis_gsl preserving type) AS gsl,
  cast(kfsl as fis_kfsl preserving type) AS kfsl,
  kfsl2,
  kfsl3,
  cast(psl as fis_psl preserving type) AS psl,
  psl2,
  psl3,
  cast(pfsl as fis_pfsl preserving type) AS pfsl,
  pfsl2,
  pfsl3,
  rco_ocur,
  co_osl,
  rgm_ocur,
  gm_osl,
  hstprs,
  hpvprs,
  runit,
  msl,
  mfsl,
  cast(rvunit as fis_co_meinh preserving type) AS rvunit,
  vmsl,
  vmfsl,
  cast( rrunit as fis_ref_qty_uom preserving type ) AS rrunit,
  rmsl,
  qunit1,
  quant1,
  qunit2,
  quant2,
  qunit3,
  quant3,
  cast(drcrk as fis_shkzg preserving type) AS drcrk,
  cast(poper as fins_fiscalperiod preserving type) AS poper,
  cast(acdocd.periv as fis_periv preserving type) AS periv,
  cast(fiscyearper as fis_jahrper_conv preserving type ) AS fiscyearper,
  cast(budat as fis_budat preserving type) AS budat,
  cast(bldat as fis_bldat preserving type) AS bldat,
  cast(blart as fis_blart preserving type) AS blart,
  cast(buzei as fis_buzei preserving type) AS buzei,
  cast(zuonr as fis_zuonr preserving type) AS zuonr,
  cast(bschl as fis_bschl preserving type) AS bschl,
  cast(bstat as fis_bstat preserving type) AS bstat,
  cast(linetype as fis_linetype preserving type ) AS linetype,
  cast(ktosl as fac_ktosl preserving type) AS ktosl,
  slalittype,
  xsplitmod,
  cast(usnam as fis_usnam preserving type) AS usnam,
  timestamp,
  eprctr,
  cast(rhoart as fis_hoart preserving type) AS rhoart,
  cast(ktopl as fis_ktopl preserving type) AS ktopl,
  cast(lokkt as fis_altkt_skb1 preserving type) AS lokkt,
  cast(ktop2 as fis_ktop2 preserving type) AS ktop2,
  cast( rbunit as fis_md_bunit preserving type ) AS rbunit,
  cast( rbuptr as fis_md_buptr preserving type ) AS rbuptr,
  cast( rcomp as fis_rcomp preserving type ) AS rcomp,
  cast( ritclg as fis_itclg preserving type ) AS ritclg,
  cast( ritem as fis_fsi_item preserving type ) AS ritem,
  cast( sityp as fis_fc_sityp preserving type ) AS sityp,
  cast( subit as fis_fc_sitem preserving type ) AS subit,
  cast(rebzg as fis_rebzg preserving type) AS rebzg,
  cast(rebzj as fis_rebzj_no_conv preserving type) AS rebzj,
  cast(rebzz as fis_rebzz preserving type) AS rebzz,
  cast(rebzt as farp_rebzt preserving type) AS rebzt,
  cast(rbest as fis_refbtyp preserving type) AS rbest,
  cast(ebeln as fis_ebeln preserving type) AS ebeln,
  cast(ebelp as fis_ebelp preserving type) AS ebelp,
  zekkn,
  cast(sgtxt as farp_sgtxt preserving type) AS sgtxt,
  cast(kdauf as vdm_sales_order preserving type) AS kdauf,
  cast(kdpos as sales_order_item preserving type) AS kdpos,
  matnr,
  werks,
  cast(lifnr as md_supplier preserving type) AS lifnr,
  cast(kunnr as kunnr preserving type) AS kunnr,
  fbuda,
  perop_beg,
  perop_end,
  coco_num,
  wwert,
  cast(koart as farp_koart preserving type) AS koart,
  cast(umskz as fac_umskz preserving type) AS umskz,
  cast(mwskz as fis_mwskz preserving type) AS mwskz,
  tax_country,
  cast(hbkid as farp_hbkid preserving type) AS hbkid,
  cast(hktid as fac_hktid preserving type) AS hktid,
  cast(xopvw as fis_xopvw preserving type) AS xopvw,
  cast(augdt as fis_augdt preserving type) AS augdt,
  cast(augbl as fis_augbl preserving type) AS augbl,
  cast(auggj as fis_auggj_no_conv preserving type) AS auggj,
  valut,
  cast(aging as fis_aging preserving type) AS AGING,
  cast(aging_incrmnt as fis_incrmnt preserving type) AS AGING_INCRMNT,
  cast(afabe as fis_afabe_d preserving type) AS afabe,
  cast(anln1 as fis_anln1 preserving type) AS anln1,
  cast(anln2 as fis_anln2 preserving type) AS anln2,
  bzdat,
  anbwa,
  movcat,
  cast(depr_period as fis_peraf preserving type) AS depr_period,
  cast(anlgr as fis_anlgr preserving type) AS anlgr,
  cast(anlgr2 as fis_anlgr2 preserving type) AS anlgr2,
  anlkl,
  ktogr,
  cast(panl1 as fis_panl1 preserving type ) AS panl1,
  cast(panl2 as fis_panl2 preserving type ) AS panl2,
  cast(kalnr as fis_kalnr preserving type) AS kalnr,
  vprsv,
  mlast,
  cast(kzbws as inventoryspecialstockvalntype preserving type) AS kzbws,
  xobew,
  cast(sobkz as inventoryspecialstocktype preserving type) AS sobkz,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  mat_ps_posid,
  cast(mat_lifnr as fis_mlmat_lifnr preserving type) AS mat_lifnr,
  bwtar,
  bwkey,
  hpeinh,
  mlptyp,
  mlcateg,
  qsbvalt,
  qsprocess,
  perart,
  bukrs_sender,
  cast(racct_sender as fis_racct_sender preserving type) AS racct_sender,
  accas_sender,
  objnr,
  hrkft,
  hkgrp,
  parob1,
  parobsrc,
  cast( uspob as fis_uspob preserving type) AS uspob,
  co_belkz,
  beltp,
  muvflg,
  cast(gkont as fis_gkont preserving type) AS gkont,
  cast(gkoar as farp_gkoar preserving type) AS gkoar,
  cast(erlkz as fis_kblerlkz preserving type) AS erlkz,
  pernr,
  paobjnr,
  cast(scope as fis_scope_cv_conv_co preserving type) AS scope,
  logsyso,
  pbukrs,
  cast(pscope as fis_pscope_cv_conv_co preserving type) AS pscope,
  logsysp,
  bwstrat,
  objnr_hk,
  cast( aufnr_org as fco_aufnr_org preserving type) AS aufnr_org,
  cast(ukostl as fis_usp_kostl preserving type) AS ukostl,
  cast(ulstar as fins_usp_lstar preserving type) AS ulstar,
  cast(umatnr as fis_origin_matnr preserving type) AS UMATNR,
  cast(varc_uacct as fis_varc_origin_acct preserving type) AS VARC_UACCT,
  uprctr,
  accas,
  lstar,
  cast(aufnr as fis_aufnr preserving type) AS aufnr,
  autyp,
  cast(ps_psp_pnr as ps_posnr preserving type) AS ps_psp_pnr,
  ps_posid,
  ps_prj_pnr,
  ps_pspid,
  nplnr,
  cast( nplnr_vorgn as fis_npvrg_no_conv preserving type ) AS nplnr_vorgn,
  prznr,
  kstrg,
  cast(bemot as fis_bemot preserving type) AS bemot,
  cast(rsrce as fis_co_resource preserving type) AS rsrce,
  qmnum,
  cast( vtkey as fis_vtkey_kk preserving type ) AS vtkey,
  cast( vtpos as fis_vtpos_kk preserving type ) AS vtpos,
  cast( ra_pob_id as fis_pob_id preserving type ) AS ra_pob_id,
  erkrs,
  cast(paccas as fis_paccas preserving type) AS paccas,
  cast(plstar as fis_par_lstar preserving type) AS plstar,
  cast(paufnr as fis_par_aufnr preserving type) AS paufnr,
  cast(pautyp as fis_par_auftyp preserving type) AS pautyp,
  cast(pps_posid as fis_par_posid preserving type) AS pps_posid,
  cast(pps_pspid as fis_par_pspid preserving type) AS pps_pspid,
  cast(pkdauf as fis_par_kdauf preserving type) AS pkdauf,
  cast(pkdpos as fis_par_kdpos preserving type) AS pkdpos,
  ppaobjnr,
  pnplnr,
  cast( pnplnr_vorgn as fis_par_vornr_auf_no_conv preserving type ) AS pnplnr_vorgn,
  pprznr,
  pkstrg,
  co_zlenr,
  co_belnr,
  co_buzei,
  co_refbz,
  overtimecat,
  work_item_id,
  co_beknz,
  uprznr,
  pps_psp_pnr,
  pps_prj_pnr,
  varc_hkgrp,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  re_bukrs,
  re_account,
  fikrs,
  fipex,
  cast(fistl as farp_fistl preserving type) AS fistl,
  measure,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  bdgt_account,
  cast(kblnr as fis_kblnr_fi preserving type ) AS kblnr,
  cast(kblpos as fis_kblpos preserving type ) AS kblpos,
  cast(fs_product_group as fis_ffs_product_group preserving type ) AS FS_PRODUCT_GROUP,
  cast(branch_id as fis_ffs_branch_id preserving type ) AS BRANCH_ID,
  cast(datasource_id as fis_ffs_datasource_id preserving type ) AS DATASOURCE_ID,
  vname,
  egrup,
  recid,
  vptnr,
  btype,
  etype,
  prodper,
  billm,
  pom,
  cbrunid,
  jvactivity,
  pvname,
  pegrup,
  s_recind,
  cbracct,
  cbobjnr,
  cast(swenr as rebdvdmbeno preserving type ) AS SWENR,
  cast(sgenr as rebdvdmbuno preserving type ) AS SGENR,
  cast(sgrnr as rebdvdmprno preserving type ) AS SGRNR,
  cast(smenr as rebdvdmrono preserving type ) AS SMENR,
  cast(recnnr as recnvdmcnnr preserving type ) AS RECNNR,
  cast(snksl as rescvdmsckey preserving type ) AS snksl,
  cast(sempsl as rescvdmsuid preserving type ) AS sempsl,
  cast(dabrz as farp_dabrbez preserving type) AS dabrz,
  cast(pswenr as rebdvdmpbeno preserving type ) AS pswenr,
  cast(psgenr as rebdvdmpbuno preserving type ) AS psgenr,
  cast(psgrnr as rebdvdmpprno preserving type ) AS psgrnr,
  cast(psmenr as rebdvdmprono preserving type ) AS psmenr,
  cast(precnnr as recnvdmpcnnr preserving type ) AS precnnr,
  cast(psnksl as rescvdmpsckey preserving type ) AS psnksl,
  cast(psempsl as rescvdmpsuid preserving type ) AS psempsl,
  cast(pdabrz as fins_par_dabrbez preserving type ) AS pdabrz,
  acrobjtype,
  acrlogsys,
  acrobj_id,
  acrsobj_id,
  acritmtype,
  cast( acrrefobj_id as fis_acr_refobj_id preserving type ) AS acrrefobj_id,
  acrvaldat,
  valobjtype,
  valobj_id,
  valsobj_id,
  cast(netdt as faedt_fpos preserving type) AS netdt,
  cast(risk_class as credit_risk_class preserving type) AS risk_class,
  arbid,
  cast( vornr as fis_vornr_no_conv preserving type ) AS vornr,
  aufps,
  paufps,
  cast( uvorn as fis_uvorn_no_conv preserving type ) AS uvorn,
  equnr,
  tplnr,
  istru,
  ilart,
  plknz,
  artpr,
  priok,
  maufnr,
  matkl_mm,
  cast( vornr_org as fis_origin_order_operation preserving type) AS vornr_org,
  cast(mig_source as fis_acdoc_mig_source preserving type) AS mig_source
FROM acdocd
;