fac_cds_bseg_bkpf

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 fac_cds_bseg_bkpf.
-- 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: FACV_BSEG_BKPF

CREATE VIEW fac_cds_bseg_bkpf AS
SELECT
  bseg.bukrs AS bukrs,
  bseg.belnr AS belnr,
  bseg.gjahr AS gjahr,
  bseg.rldnr AS rldnr,
  bseg.buzei AS buzei,
  bseg.bschl AS bschl,
  bseg.koart AS koart,
  bseg.hkont AS hkont,
  bseg.shkzg AS shkzg,
  bseg.dmbtr AS dmbtr,
  bseg.wrbtr AS wrbtr,
  bseg.dmbe2 AS dmbe2,
  bseg.dmbe3 AS dmbe3,
  bseg.xnegp AS xnegp,
  bseg.sgtxt AS sgtxt,
  bseg.zuonr AS zuonr,
  bseg.mwskz AS mwskz,
  bseg.txbfw AS txbfw,
  bseg.txjcd AS txjcd,
  bseg.xskrl AS xskrl,
  bseg.hwmet AS hwmet,
  bseg.hwbas AS hwbas,
  bseg.fwbas AS fwbas,
  bseg.kursr AS kursr,
  bseg.augbl AS augbl,
  bseg.augdt AS augdt,
  cast(bseg.landl as fac_landl) AS landl,
  bseg.lzbkz AS lzbkz,
  bseg.xegdr AS xegdr,
  bseg.stceg AS stceg,
  bseg.egbld AS egbld,
  bseg.hbkid AS hbkid,
  bseg.hktid AS hktid,
  bseg.ccbtc AS ccbtc,
  bseg.uzawe AS uzawe,
  bseg.kidno AS kidno,
  bseg.bupla AS bupla,
  bseg.vbund AS vbund,
  bseg.rstgr AS rstgr,
  bseg.xref1 AS xref1,
  bseg.xref2 AS xref2,
  bseg.xref3 AS xref3,
  bseg.prctr AS prctr,
  bseg.PPRCTR AS PPRCTR,
  bseg.segment AS segment,
  bseg.psegment AS psegment,
  bseg.gsber AS gsber,
  bseg.pargb AS pargb,
  bseg.KDAUF AS KDAUF,
  bseg.KDPOS AS KDPOS,
  bseg.KDEIN AS KDEIN,
  bseg.ebeln AS ebeln,
  bseg.ebelp AS ebelp,
  bseg.zekkn AS zekkn,
  bseg.pernr AS pernr,
  bseg.abper AS abper,
  bseg.werks AS werks,
  bseg.matnr AS matnr_ext,
  bseg.menge AS menge,
  bseg.meins AS meins,
  bseg.RMVCT AS RMVCT,
  bseg.paobjnr AS paobjnr,
  bseg.projk AS projk,
  bseg.nplnr AS nplnr,
  bseg.aufpl AS aufpl,
  bseg.aplzl AS aplzl,
  bseg.kokrs AS kokrs,
  bseg.kostl AS kostl,
  bseg.kstrg AS kstrg,
  bseg.lstar AS lstar,
  bseg.prznr AS prznr,
  bseg.aufnr AS aufnr,
  bseg.imkey AS imkey,
  bseg.dabrz AS dabrz,
  bseg.fipos AS fipos,
  bseg.gmvkz AS gmvkz,
  bseg.srtype AS srtype,
  bseg.fkber AS fkber,
  bseg.pfkber AS pfkber,
  bseg.vname AS vname,
  bseg.recid AS recid,
  bseg.egrup AS egrup,
  bseg.vptnr AS vptnr,
  bseg.prodper AS prodper,
  bseg.qsskz AS qsskz,
  bseg.mwart AS mwart,
  bseg.pays_prov AS pays_prov,
  bseg.qsfbt AS qsfbt,
  bseg.qsshb AS qsshb,
  bseg.gityp AS gityp,
  bseg.gricd AS gricd,
  bseg.grirg AS grirg,
  bseg.idxsp AS idxsp,
  bseg.lifnr AS lifnr,
  bseg.kunnr AS kunnr,
  bseg.filkd AS filkd,
  bseg.umskz AS umskz,
  bseg.umsks AS umsks,
  bseg.zumsk AS zumsk,
  bseg.hzuon AS hzuon,
  bseg.wskto AS wskto,
  bseg.sknto AS sknto,
  bseg.skfbt AS skfbt,
  bseg.zterm AS zterm,
  bseg.zfbdt AS zfbdt,
  bseg.zbd1p AS zbd1p,
  bseg.zbd1t AS zbd1t,
  bseg.zbd2p AS zbd2p,
  bseg.zbd2t AS zbd2t,
  bseg.zbd3t AS zbd3t,
  bseg.zbfix AS zbfix,
  bseg.zlspr AS zlspr,
  bseg.zlsch AS zlsch,
  bseg.rebzg AS rebzg,
  bseg.rebzj AS rebzj,
  bseg.rebzz AS rebzz,
  bseg.rebzt AS rebzt,
  bseg.fdlev AS fdlev,
  bseg.fdgrp AS fdgrp,
  bseg.empfb AS empfb,
  bseg.bvtyp AS bvtyp,
  bseg.saknr AS saknr,
  bseg.xcpdd AS xcpdd,
  bseg.diekz AS diekz,
  bseg.samnr AS samnr,
  bseg.vertn AS vertn,
  bseg.vertt AS vertt,
  bseg.vbewa AS vbewa,
  bseg.dtws1 AS dtws1,
  bseg.dtws2 AS dtws2,
  bseg.dtws3 AS dtws3,
  bseg.dtws4 AS dtws4,
  bseg.pycur AS pycur,
  bseg.pyamt AS pyamt,
  bseg.mndid AS mndid,
  bseg.secco AS secco,
  bseg.maber AS maber,
  bseg.madat AS madat,
  bseg.manst AS manst,
  bseg.mansp AS mansp,
  bseg.mschl AS mschl,
  bseg.kkber AS kkber,
  bseg.cession_kz AS cession_kz,
  bseg.zinkz AS zinkz,
  bseg.btype AS btype,
  bseg.vrskz AS vrskz,
  bseg.vrsdt AS vrsdt,
  bseg.anfbn AS anfbn,
  bseg.anfbu AS anfbu,
  bseg.anfbj AS anfbj,
  bseg.xinve AS xinve,
  bseg.zollt AS zollt,
  bseg.zolld AS zolld,
  bseg.valut AS valut,
  bseg.vbeln AS vbeln,
  bseg.xauto AS xauto,
  bseg.nebtr AS nebtr,
  bseg.qsznr AS qsznr,
  bseg.qbshb AS qbshb,
  bsec.name1 AS bsec_name1,
  bsec.name2 AS bsec_name2,
  bsec.name3 AS bsec_name3,
  bsec.name4 AS bsec_name4,
  bsec.pstlz AS bsec_pstlz,
  bsec.ort01 AS bsec_ort01,
  bsec.land1 AS bsec_land1,
  bsec.stras AS bsec_stras,
  bsec.pfach AS bsec_pfach,
  bsec.pstl2 AS bsec_pstl2,
  bsec.pskto AS bsec_pskto,
  bsec.bankn AS bsec_bankn,
  bsec.bankl AS bsec_bankl,
  bsec.banks AS bsec_banks,
  bsec.stcd1 AS bsec_stcd1,
  bsec.stcd2 AS bsec_stcd2,
  bsec.stkzu AS bsec_stkzu,
  bsec.stkza AS bsec_stkza,
  bsec.regio AS bsec_regio,
  bsec.bkont AS bsec_bkont,
  bsec.dtaws AS bsec_dtaws,
  bsec.dtams AS bsec_dtams,
  bsec.xcpdk AS bsec_xcpdk,
  bsec.empfg AS bsec_empfg,
  bsec.spras AS bsec_spras,
  bsec.fityp AS bsec_fityp,
  bsec.stcdt AS bsec_stcdt,
  bsec.stkzn AS bsec_stkzn,
  bsec.stcd3 AS bsec_stcd3,
  bsec.stcd4 AS bsec_stcd4,
  bsec.bkref AS bsec_bkref,
  bsec.anred AS bsec_anred,
  bsec.adrnr AS bsec_adrnr,
  bsec.xrguh AS bsec_xrguh,
  bsec.begru AS bsec_begru,
  bsec.iban AS bsec_iban,
  bseg.vkorg AS vkorg,
  bseg.vtweg AS vtweg,
  cast(bseg.kna1_land1 as fac_kna1_land1) AS kna1_land1,
  bseg.kna1_stceg AS kna1_stceg,
  bseg.kna1_begru AS kna1_begru,
  bseg.kna1_xcpdk AS kna1_xcpdk,
  bseg.regio AS regio,
  bseg.brsch AS brsch,
  bseg.kunnr_txt AS kunnr_txt,
  bseg.lifnr_txt AS lifnr_txt,
  bseg.lfa1_stceg AS lfa1_stceg,
  cast(bseg.lfa1_land1 as fac_lfa1_land1) AS lfa1_land1,
  bseg.lfa1_begru AS lfa1_begru,
  bseg.lfa1_xcpdk AS lfa1_xcpdk,
  skb1.begru AS skb1_begru,
  cast(t001.land1 as fac_t001_land1) AS t001_land1,
  t001.ktopl AS ktopl,
  t005.land1 AS land1,
  t005.kalsm AS kalsm,
  t001.butxt AS bukrs_txt,
  t880.name1 AS vbund_txt,
  t001w.name1 AS werks_txt,
  bseg.anln1 AS anln1,
  bseg.anln2 AS anln2,
  bseg.bzdat AS bzdat,
  bseg.anbwa AS anbwa,
  to_next_item
FROM fac_cds_bseg_add AS bseg
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skb1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t880 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001w ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fac_cds_bsec_ev AS bsec ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fis_cds_bkpf_ev AS to_header ON bseg.bukrs = to_header.bukrs AND bseg.belnr = to_header.belnr AND bseg.gjahr = to_header.gjahr  -- association [1]
LEFT OUTER JOIN fac_cds_bseg_bkpf AS to_next_item ON bseg.bukrs = to_next_item.bukrs AND bseg.belnr = to_next_item.belnr AND bseg.gjahr = to_next_item.gjahr  -- association [*]
LEFT OUTER JOIN fac_cds_bseg_bkpf AS to_previous_item ON bseg.bukrs = to_previous_item.bukrs AND bseg.belnr = to_previous_item.belnr AND bseg.gjahr = to_previous_item.gjahr  -- association [*]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON bseg.rldnr = _Extension.SourceLedger AND bseg.bukrs = _Extension.CompanyCode AND bseg.gjahr = _Extension.FiscalYear AND bseg.belnr = _Extension.AccountingDocument AND bseg.buzei = _Extension.LedgerGLLineItem  -- association [0..1]
;