P_Bseg_Add_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_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.

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