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_Bseg_Add_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: PFIBSEGADDCOM
CREATE VIEW P_Bseg_Add_Com AS
SELECT
cast( P_Bseg_Add_Com1.bukrs as fis_bukrs preserving type ) AS bukrs,
cast( belnr as farp_belnr_d preserving type ) AS belnr,
cast( gjahr as fis_gjahr_no_conv preserving type ) AS gjahr,
buzei,
cast( ktopl as fis_ktopl preserving type ) AS ktopl,
buzid,
cast( augdt as fis_augdt preserving type ) AS augdt,
cast( augcp as fis_augcp preserving type ) AS augcp,
cast( augbl as fis_augbl preserving type ) AS augbl,
cast( bschl as fis_bschl preserving type ) AS bschl,
cast( koart as farp_koart preserving type ) AS koart,
cast( gsber as fis_rbusa preserving type ) AS gsber,
cast( pargb as fis_pargb preserving type ) AS pargb,
cast( mwskz as fis_mwskz preserving type ) AS mwskz,
cast( qsskz as fac_qsskz preserving type ) AS qsskz,
cast( ktosl as fac_ktosl preserving type ) AS ktosl,
valut,
cast( zuonr as fis_zuonr preserving type ) AS zuonr,
cast( sgtxt as farp_sgtxt preserving type ) AS sgtxt,
cast( vbund as fis_rassc preserving type ) AS vbund,
cast( bewar as fis_rmvct preserving type ) AS bewar,
cast( altkt as fis_bilkt_ska1 preserving type ) AS altkt,
vorgn,
fkont,
cast( kokrs as fis_kokrs preserving type ) AS kokrs,
cast( kostl as fis_kostl preserving type ) AS kostl,
cast( projn as ps_pspid ) AS projn,
cast( aufnr as fis_aufnr preserving type ) AS aufnr,
cast( anln1 as fis_anln1 preserving type ) AS anln1,
cast( anln2 as fis_anln2 preserving type ) AS anln2,
anbwa,
cast(xopvw as fis_xopvw) AS xopvw,
cast( xauto as fis_xauto) AS xauto,
xncop,
cast( hkont as fis_racct preserving type ) AS hkont,
cast( xbilk as fis_xbilk ) AS xbilk,
cast( gvtyp as fis_gvtyp preserving type ) AS gvtyp,
cast( zfbdt as fis_dzfbdt preserving type ) AS zfbdt,
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( wverw as farp_wverw preserving type ) AS wverw,
matnr,
werks,
bwkey,
bwtar,
cast( prctr as fis_prctr preserving type ) AS prctr,
vname,
recid,
cast( egrup as jv_egroup_cds preserving type ) AS egrup,
vptnr,
cast( vertt as fis_rantyp preserving type ) AS vertt,
cast( vertn as fis_ranl preserving type ) AS vertn,
cast( vbewa as farp_sbewart preserving type ) AS vbewa,
cast( imkey as fis_imkey preserving type ) AS imkey,
cast( dabrz as farp_dabrbez preserving type ) AS dabrz,
cast( fipos as fis_fipos preserving type ) AS fipos,
kstrg,
nplnr,
cast( aufpl as fis_ordintbillofops preserving type ) AS aufpl,
cast( aplzl as fis_ordintbillofopitm preserving type ) AS aplzl,
cast( projk as ps_posnr preserving type ) AS projk,
paobjnr,
pasubnr,
cast( xragl as fis_xragl ) AS xragl,
cast( uzawe as farp_uzawe preserving type ) AS uzawe,
cast( lokkt as fis_altkt_skb1 preserving type ) AS lokkt,
cast( fistl as farp_fistl preserving type ) AS fistl,
geber,
cast( pprct as fis_pprctr preserving type ) AS pprct,
cast( xref1 as fis_xref1 ) AS xref1,
cast( xref2 as fis_xref2 ) AS xref2,
kblnr,
kblpos,
cast( fkber as fm_farea preserving type ) AS fkber,
obzei,
cast( rfzei as fis_rfzei_cc ) AS rfzei,
cast( ccbtc as fis_ccbtc ) AS ccbtc,
cast( xref3 as fis_xref3 ) AS xref3,
kontt,
kontl,
cast( agzei as fis_agzei preserving type ) AS agzei,
cast( bupla as farp_bupla preserving type ) AS bupla,
cast( secco as fis_secco preserving type ) AS secco,
lstar,
prznr,
grant_nbr,
intreno,
measure,
cast( auggj as fis_auggj_no_conv preserving type ) AS auggj,
segment,
psegment,
cast(pfkber as fis_sfkber preserving type ) AS pfkber,
kstar,
xlgclr,
cast( netdt as farp_netdt preserving type ) AS netdt,
cast( gkont as fis_gkont preserving type ) AS gkont,
cast( gkart as farp_gkoar preserving type ) AS gkart,
ghkon,
cast( pgeber as bp_p_geber preserving type ) AS pgeber,
pgrant_nbr,
budget_pd,
pbudget_pd,
prodper,
re_bukrs,
re_account,
bdgt_account,
cast( h_hwaer as fis_hwaer preserving type ) AS h_hwaer,
cast( dmbtr_shl as fis_hsl ) AS dmbtr_shl,
cast( mwsts_shl as fis_mwsts ) AS mwsts_shl,
cast( bdiff_shl as fis_bdiff ) AS bdiff_shl,
rdiff_shl,
ppdiff_shl,
cast( h_waers as fis_rwcur preserving type ) AS h_waers,
cast( wrbtr_shl as fis_wsl ) AS wrbtr_shl,
cast( wmwst_shl as wmwst_shl ) AS wmwst_shl,
cast( pswsl as fis_rtcur preserving type ) AS pswsl,
cast( pswbt_shl as fis_tsl ) AS pswbt_shl,
cast( h_hwae2 as fis_hwae2 preserving type ) AS h_hwae2,
cast( bdif2_shl as fis_bdif2 ) AS bdif2_shl,
rdif2_shl,
cast( dmbe2_shl as fis_dmbe2 ) AS dmbe2_shl,
mwst2_shl,
ppdif2_shl,
cast( h_hwae3 as fis_hwae3 preserving type ) AS h_hwae3,
cast( dmbe3_shl as fis_dmbe3 ) AS dmbe3_shl,
mwst3_shl,
cast( bdif3_shl as fis_bdif3 ) AS bdif3_shl,
rdif3_shl,
ppdif3_shl,
rfccur,
cast( fcsl_shl as fis_vfccur12 preserving type) AS fcsl_shl,
meins,
cast( cast( menge as abap.quan(23,3) ) as quan1_12 ) AS menge,
cast( shkzg_calc as fis_shkzg ) AS shkzg,
nbritm,
cast( bstat as fis_bstat ) AS bstat,
buzei_sender
FROM P_Bseg_Add_Com1
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
;