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_ACDOCA.
-- 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_ACDOCA AS
SELECT
cast(acdoca.rldnr as fins_ledger_pers preserving type) AS rldnr,
cast(acdoca.rbukrs as fis_bukrs preserving type) AS rbukrs,
cast(acdoca.gjahr as fis_gjahr_no_conv preserving type) AS gjahr,
cast(acdoca.belnr as fis_belnr preserving type) AS belnr,
cast(acdoca.docln as fis_docln preserving type) AS docln,
cast(acdoca.ryear as fis_ryear_no_conv preserving type) AS ryear,
cast(acdoca.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,
cast( acctg_notif_uuid as fis_hdr_technical_id preserving type ) AS ACCTG_NOTIF_UUID,
cast( offstg_docln as fis_offsetting_docln preserving type ) AS offstg_docln,
xreversing,
xreversed,
xtruerev,
cast(awtyp_rev as fis_awtyp_rev preserving type ) AS 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( co_meinh as fis_fco_meinh preserving type ) AS CO_MEINH,
cast( co_megbtr as fis_fco_megbtr preserving type ) AS CO_MEGBTR,
cast( co_mefbtr as fis_fco_mefbtr preserving type ) AS CO_MEFBTR,
cast(drcrk as fis_shkzg preserving type) AS drcrk,
cast(poper as fins_fiscalperiod preserving type) AS poper,
cast(acdoca.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,
cast(anbwa as fis_anbwa_vdm preserving type ) AS 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,
acdoca.rrcty AS rrcty
FROM acdoca
;