P_ACDOCD_COM

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_COM.
-- 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.
-- SQL view name: PACDOCDCOM

CREATE VIEW P_ACDOCD_COM AS
SELECT
  cast(acdocd.rldnr as fins_ledger_pers preserving type) AS rldnr_pers,
  cast(acdocd.rbukrs as fis_bukrs preserving type) AS rbukrs,
  cast(acdocd.gjahr as fis_gjahr 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(finsc_ledger_rep.rldnr as fis_rldnr preserving type) AS rldnr,
  cast(acdocd.ryear as fis_ryear preserving type) AS ryear,
  acdocd.rrcty AS rrcty,
  cast(rmvct as fis_rmvct preserving type) AS rmvct,
  vorgn,
  vrgng,
  bttype,
  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,
  subta_rev,
  xsettling,
  xsettled,
  prec_awtyp,
  prec_aworg,
  prec_awref,
  prec_awitem,
  prec_subta,
  src_awtyp,
  src_awsys,
  src_aworg,
  src_awref,
  src_awitem,
  src_awsubit,
  xcommitment,
  obs_reason,
  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,
  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,
  hstprs,
  hpvprs,
  runit,
  msl,
  mfsl,
  cast(rvunit as fis_co_meinh preserving type) AS rvunit,
  vmsl,
  vmfsl,
  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,
  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(rebzg as fis_rebzg preserving type) AS rebzg,
  cast(rebzj as fis_rebzj 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,
  coco_num,
  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,
  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 preserving type) AS auggj,
  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,
  panl1,
  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,
  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 preserving type) AS scope,
  logsyso,
  pbukrs,
  cast(pscope as fis_pscope_cv_conv preserving type) AS pscope,
  logsysp,
  bwstrat,
  objnr_hk,
  aufnr_org,
  ukostl,
  cast(ulstar as fis_usp_lstar preserving type) AS ulstar,
  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,
  nplnr_vorgn,
  prznr,
  kstrg,
  cast(bemot as fis_bemot preserving type) AS bemot,
  cast(rsrce as fis_co_resource preserving type) AS rsrce,
  qmnum,
  vtkey,
  vtpos,
  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,
  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,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  re_bukrs,
  re_account,
  acdocd.fikrs AS fikrs,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  cast(fistl as farp_fistl preserving type) AS fistl,
  measure,
  vname,
  egrup,
  recid,
  vptnr,
  btype,
  etype,
  prodper,
  billm,
  pom,
  cbrunid,
  jvactivity,
  pvname,
  pegrup,
  s_recind,
  cbracct,
  cbobjnr,
  swenr,
  sgenr,
  sgrnr,
  smenr,
  recnnr,
  snksl,
  sempsl,
  cast(dabrz as farp_dabrbez preserving type) AS dabrz,
  pswenr,
  psgenr,
  psgrnr,
  psmenr,
  precnnr,
  psnksl,
  psempsl,
  pdabrz,
  acrobjtype,
  acrobj_id,
  acrsobj_id,
  acritmtype,
  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,
  vornr,
  aufps,
  uvorn,
  equnr,
  tplnr,
  istru,
  ilart,
  plknz,
  artpr,
  priok,
  maufnr,
  matkl_mm,
  cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) AS nbritm
FROM acdocd
INNER JOIN finsc_ledger_rep ON /* join condition not captured in parsed metadata */
;