fiscds_litb_ev_03

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 fiscds_litb_ev_03.
-- 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: FISV_LITB_EV_03

CREATE VIEW fiscds_litb_ev_03 AS
SELECT
  bseg_add.bukrs AS bukrs,
  bseg_add.belnr AS belnr,
  bseg_add.gjahr AS gjahr,
  cast(SUBSTRING(bseg_add.buzei,4,3) as abap.numc(3)) AS buzei,
  bkpf.budat AS budat,
  bseg_add.buzid AS buzid,
  bseg_add.augdt AS augdt,
  bseg_add.augbl AS augbl,
  bseg_add.bschl AS bschl,
  bseg_add.koart AS koart,
  bseg_add.gsber AS gsber,
  bseg_add.pargb AS pargb,
  bseg_add.mwskz AS mwskz,
  bseg_add.valut AS valut,
  bseg_add.zuonr AS zuonr,
  bseg_add.sgtxt AS sgtxt,
  bseg_add.vbund AS vbund,
  bseg_add.bewar AS bewar,
  bseg_add.kostl AS kostl,
  bseg_add.aufnr AS aufnr,
  bseg_add.prctr AS prctr,
  bseg_add.pprct AS pprct,
  bseg_add.segment AS segment,
  bseg_add.psegment AS psegment,
  bseg_add.anln1 AS anln1,
  bseg_add.anln2 AS anln2,
  bseg_add.xopvw AS xopvw,
  bseg_add.ktosl AS ktosl,
  t001.ktopl AS ktopl,
  bseg_add.hkont AS hkont,
  bseg_add.zfbdt AS zfbdt,
  bseg_add.rebzg AS rebzg,
  bseg_add.rebzj AS rebzj,
  bseg_add.rebzz AS rebzz,
  bseg_add.rebzt AS rebzt,
  bseg_add.wverw AS wverw,
  bseg_add.werks AS werks,
  bseg_add.imkey AS imkey,
  bseg_add.dabrz AS dabrz,
  bseg_add.projk AS projk,
  bseg_add.xragl AS xragl,
  bseg_add.uzawe AS uzawe,
  bseg_add.geber AS geber,
  bseg_add.xref1 AS xref1,
  bseg_add.xref2 AS xref2,
  bseg_add.fkber AS fkber,
  bseg_add.xnegp AS xnegp,
  bseg_add.rfzei AS rfzei,
  bseg_add.ccbtc AS ccbtc,
  bseg_add.xref3 AS xref3,
  bseg_add.agzei AS agzei,
  bseg_add.bupla AS bupla,
  bseg_add.secco AS secco,
  bseg_add.grant_nbr AS grant_nbr,
  bseg_add.auggj AS auggj,
  bseg_add.pfkber AS pfkber,
  bseg_add.kstar AS kstar,
  bseg_add.egrup AS egrup,
  bseg_add.kokrs AS kokrs,
  bseg_add.vname AS vname,
  bseg_add.recid AS recid,
  bkpf.blart AS blart,
  bkpf.bldat AS bldat,
  bkpf.monat AS monat,
  bkpf.cpudt AS cpudt,
  bkpf.usnam AS usnam,
  bkpf.xblnr AS xblnr,
  bkpf.stblg AS stblg,
  bkpf.stjah AS stjah,
  bkpf.kursf AS kursf,
  bkpf.bstat AS bstat,
  bkpf.glvor AS glvor,
  bkpf.fikrs AS fikrs,
  bkpf.ldgrp AS ldgrp,
  bkpf.rldnr AS rldnr,
  bkpf.grpid AS grpid,
  bkpf.dbblg AS dbblg,
  bkpf.bvorg AS bvorg,
  bkpf.tcode AS tcode,
  bkpf.aedat AS aedat,
  bkpf.xref1_hd AS xref1_hd,
  bkpf.xref2_hd AS xref2_hd,
  bkpf.xblnr_alt AS xblnr_alt,
  bkpf.wwert AS wwert,
  bkpf.bktxt AS bktxt,
  bkpf.vatdate AS vatdate,
  bseg_add.shkzg AS shkzg,
  bkpf.waers AS waers,
  bkpf.hwaer AS hwaer,
  bkpf.hwae2 AS hwae2,
  bkpf.hwae3 AS hwae3,
  bseg_add.pswsl AS pswsl,
  case bseg_add.shkzg when 'H' then cast(-bseg_add.bdiff as abap.curr( 23,2)) when 'S' then cast( bseg_add.bdiff as abap.curr( 23,2)) else cast( bseg_add.bdiff as abap.curr( 23,2)) end as BDIFF_shl AS curr232endasBDIFF_shl,
  case bseg_add.shkzg when 'H' then cast(-bseg_add.bdif2 as abap.curr( 23,2)) when 'S' then cast( bseg_add.bdif2 as abap.curr( 23,2)) else cast( bseg_add.bdif2 as abap.curr( 23,2)) end as BDIF2_shl AS curr232endasBDIF2_shl,
  case bseg_add.shkzg when 'H' then cast(-bseg_add.bdif3 as abap.curr( 23,2)) when 'S' then cast( bseg_add.bdif3 as abap.curr( 23,2)) else cast( bseg_add.bdif3 as abap.curr( 23,2)) end as BDIF3_shl AS curr232endasBDIF3_shl,
  bseg_add.meins AS meins,
  bseg_add.menge AS menge,
  cast(1 as abap.int4) AS nbritm
LEFT OUTER JOIN bkpf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
;