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_VBSEGS_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_VBSEGS_COM AS
SELECT
vbsegs.ausbk AS ausbk,
cast( vbsegs.belnr as farp_belnr_d preserving type ) AS belnr,
cast( vbsegs.gjahr as fis_gjahr_no_conv preserving type ) AS gjahr,
vbsegs.bzkey AS bzkey,
cast( vbsegs.bukrs as fis_bukrs preserving type ) AS bukrs,
cast( vbsegs.buzei as farp_buzei preserving type ) AS buzei,
_P_VBKPF_COM.ktopl AS ktopl,
_P_VBKPF_COM.blart AS blart,
_P_VBKPF_COM.bstat AS bstat,
_P_VBKPF_COM.wwert AS wwert,
_P_VBKPF_COM.budat AS budat,
_P_VBKPF_COM.bldat AS bldat,
_P_VBKPF_COM.monat AS monat,
vbsegs.buzid AS buzid,
cast( vbsegs.bschl as fis_bschl preserving type ) AS bschl,
cast( vbsegs.koart as farp_koart preserving type ) AS koart,
cast( vbsegs.gsber as fis_rbusa preserving type ) AS gsber,
cast( vbsegs.pargb as fis_pargb preserving type ) AS pargb,
cast( vbsegs.mwskz as fis_mwskz preserving type ) AS mwskz,
vbsegs.mwart AS mwart,
vbsegs.kursr AS kursr,
vbsegs.valut AS valut,
cast( vbsegs.zuonr as fis_zuonr preserving type ) AS zuonr,
cast( vbsegs.sgtxt as farp_sgtxt preserving type ) AS sgtxt,
vbsegs.zinkz AS zinkz,
cast( vbsegs.vbund as fis_rassc preserving type ) AS vbund,
vbsegs.fdlev AS fdlev,
vbsegs.fdgrp AS fdgrp,
vbsegs.fdtag AS fdtag,
cast( vbsegs.kokrs as fis_kokrs preserving type ) AS kokrs,
cast( vbsegs.kostl as fis_kostl preserving type ) AS kostl,
cast( vbsegs.aufnr as fis_aufnr preserving type ) AS aufnr,
cast( vbsegs.anln1 as fis_anln1 preserving type ) AS anln1,
cast( vbsegs.anln2 as fis_anln2 preserving type ) AS anln2,
vbsegs.anbwa AS anbwa,
vbsegs.bzdat AS bzdat,
vbsegs.pernr AS pernr,
cast( vbsegs.xumsw as farp_xumsw preserving type ) AS xumsw,
vbsegs.xskrl AS xskrl,
cast( vbsegs.saknr as fis_racct preserving type ) AS saknr,
cast( vbsegs.hzuon as fins_hzuon preserving type ) AS hzuon,
vbsegs.zfbdt AS zfbdt,
vbsegs.lzbkz AS lzbkz,
cast( vbsegs.landl as fac_landl preserving type ) AS landl,
vbsegs.abper AS abper,
vbsegs.matnr AS matnr,
vbsegs.werks AS werks,
cast( vbsegs.ebeln as fis_ebeln preserving type ) AS ebeln,
cast( vbsegs.ebelp as fis_ebelp preserving type ) AS ebelp,
vbsegs.zekkn AS zekkn,
vbsegs.vprsv AS vprsv,
vbsegs.bwkey AS bwkey,
vbsegs.bwtar AS bwtar,
vbsegs.tbtkz AS tbtkz,
cast( vbsegs.stceg as farp_stceg preserving type ) AS stceg,
cast( vbsegs.rstgr as farp_rstgr preserving type ) AS rstgr,
cast( vbsegs.prctr as fis_prctr preserving type ) AS prctr,
vbsegs.vname AS vname,
vbsegs.recid AS recid,
cast( vbsegs.egrup as jv_egroup_cds preserving type ) AS egrup,
vbsegs.vptnr AS vptnr,
vbsegs.vertt AS vertt,
vbsegs.vertn AS vertn,
cast( vbsegs.vbewa as farp_sbewart preserving type ) AS vbewa,
cast( vbsegs.txjcd as fis_txjcd preserving type ) AS txjcd,
cast( vbsegs.imkey as farp_imkey preserving type ) AS imkey,
cast( vbsegs.dabrz as farp_dabrbez preserving type ) AS dabrz,
cast( vbsegs.fipos as fis_fipos preserving type ) AS fipos,
vbsegs.kstrg AS kstrg,
cast( vbsegs.ps_psp_pnr as ps_posnr preserving type) AS ps_psp_pnr,
vbsegs.nplnr AS nplnr,
cast( vbsegs.aufpl as orderinternalbillofoperations preserving type ) AS aufpl,
vbsegs.paobjnr AS paobjnr,
vbsegs.pasubnr AS pasubnr,
vbsegs.btype AS btype,
cast( vbsegs.etype as jv_etype_cds preserving type ) AS etype,
vbsegs.xegdr AS xegdr,
vbsegs.hrkft AS hrkft,
cast( vbsegs.hwmet as fac_hwmet preserving type ) AS hwmet,
cast( vbsegs.uzawe as farp_uzawe preserving type ) AS uzawe,
cast( vbsegs.fistl as farp_fistl preserving type ) AS fistl,
vbsegs.geber AS geber,
cast( vbsegs.xref1 as farp_xref1 preserving type ) AS xref1,
cast( vbsegs.xref2 as farp_xref2 preserving type ) AS xref2,
vbsegs.kblnr AS kblnr,
vbsegs.kblpos AS kblpos,
cast( vbsegs.fkber as fm_farea preserving type ) AS fkber,
cast( vbsegs.ccbtc as farp_ccbtc preserving type ) AS ccbtc,
cast( vbsegs.xref3 as farp_xref3 preserving type ) AS xref3,
vbsegs.gricd AS gricd,
vbsegs.grirg AS grirg,
vbsegs.gityp AS gityp,
vbsegs.idxsp AS idxsp,
vbsegs.kontt AS kontt,
vbsegs.kontl AS kontl,
vbsegs.hbkid_s AS hbkid_s,
vbsegs.hktid_s AS hktid_s,
cast( vbsegs.bupla as farp_bupla preserving type ) AS bupla,
vbsegs.lstar AS lstar,
vbsegs.prznr AS prznr,
vbsegs.grant_nbr AS grant_nbr,
vbsegs.measure AS measure,
vbsegs.ppa_ex_ind AS ppa_ex_ind,
vbsegs.segment AS segment,
vbsegs.psegment AS psegment,
cast( vbsegs.netdt as farp_netdt preserving type ) AS netdt,
cast( vbsegs.pgeber as bp_p_geber preserving type ) AS pgeber,
vbsegs.pgrant_nbr AS pgrant_nbr,
vbsegs.budget_pd AS budget_pd,
vbsegs.pbudget_pd AS pbudget_pd,
vbsegs.perop_beg AS perop_beg,
vbsegs.perop_end AS perop_end,
vbsegs.fastpay AS fastpay,
vbsegs.fmfgus_key AS fmfgus_key,
vbsegs.prodper AS prodper,
vbsegs.meins AS meins,
cast( cast( vbsegs.menge as abap.quan(23,3) ) as quan1_12 preserving type ) AS menge,
cast( vbsegs.peinh as fis_peinh preserving type ) AS peinh,
cast( _P_VBKPF_COM.hwaer as fis_hwaer preserving type ) AS hwaer,
cast( _P_VBKPF_COM.waers as fis_rwcur preserving type ) AS waers,
cast( _P_VBKPF_COM.hwae2 as fis_hwae2 preserving type ) AS hwae2,
cast( _P_VBKPF_COM.hwae3 as fis_hwae3 preserving type ) AS hwae3,
cast( vbsegs.xnegp as farp_xnegp preserving type ) AS xnegp,
cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) AS nbritm
FROM vbsegs
LEFT OUTER JOIN P_VBKPF_COM AS _P_VBKPF_COM ON ausbk = _P_VBKPF_COM.ausbk AND bukrs = _P_VBKPF_COM.bukrs AND belnr = _P_VBKPF_COM.belnr AND gjahr = _P_VBKPF_COM.gjahr -- association [1..1]
;