FGL_LIB_P_DOC_ITEM

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 FGL_LIB_P_DOC_ITEM.
-- 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: FILIBPDOCI

CREATE VIEW FGL_LIB_P_DOC_ITEM AS
SELECT
  item.ausbk AS ausbk,
  item.belnr AS belnr,
  item.gjahr AS gjahr,
  item.bukrs AS bukrs,
  item.bzkey AS bzkey,
  'S' AS union_key,
  cast( 1 as sydbcnt ) AS counter,
  case item.shkzg when 'H' then -cast(item.wrbtr as abap.dec(23,2)) else cast(item.wrbtr as abap.dec(23,2)) end AS wrbtr,
  case item.shkzg when 'H' then -cast(item.dmbtr as abap.dec(23,2)) else cast(item.dmbtr as abap.dec(23,2)) end AS dmbtr,
  case item.shkzg when 'H' then -cast(item.dmbe2 as abap.dec(23,2)) else cast(item.dmbe2 as abap.dec(23,2)) end AS dmbe2,
  case item.shkzg when 'H' then -cast(item.dmbe3 as abap.dec(23,2)) else cast(item.dmbe3 as abap.dec(23,2)) end AS dmbe3,
  case item.shkzg when 'H' then -cast(item.menge as abap.dec(23,2)) else cast(item.menge as abap.dec(23,2)) end AS menge,
  item.buzei AS buzei,
  item.bschl AS bschl,
  item.gsber AS gsber,
  item.pargb AS pargb,
  item.mwskz AS mwskz,
  item.hwmet AS hwmet,
  item.mwart AS mwart,
  item.kursr AS kursr,
  item.zfbdt AS zfbdt,
  item.valut AS valut,
  item.zuonr AS zuonr,
  item.sgtxt AS sgtxt,
  item.zinkz AS zinkz,
  item.fdlev AS fdlev,
  item.fdgrp AS fdgrp,
  item.fdtag AS fdtag,
  item.xumsw AS xumsw,
  item.hzuon AS hzuon,
  item.stceg AS stceg,
  item.vname AS vname,
  item.egrup AS egrup,
  item.vertn AS vertn,
  item.vbewa AS vbewa,
  item.dabrz AS dabrz,
  item.btype AS btype,
  item.xegdr AS xegdr,
  item.fipos AS fipos,
  item.xref3 AS xref3,
  item.rstgr AS rstgr,
  item.fistl AS fistl,
  item.fkber AS fkber,
  cast( '' as umskz ) AS umskz,
  cast( '' as umsks ) AS umsks,
  item.geber AS geber,
  cast( '' as xcpdd ) AS xcpdd,
  cast( '' as xinve ) AS xinve,
  cast( ' ' as lifnr ) AS lifnr,
  cast( ' ' as kunnr ) AS kunnr,
  cast( ' ' as filkd ) AS filkd,
  cast( ' ' as dzterm ) AS zterm,
  cast( 000 as dzbd1t ) AS zbd1t,
  cast( 000 as dzbd2t ) AS zbd2t,
  cast( 000 as dzbd3t ) AS zbd3t,
  fltp_to_dec( 00000.000 as dzbd1p ) AS zbd1p,
  fltp_to_dec( 00000.000 as dzbd2p ) AS zbd2p,
  cast( cast( 0 as abap.dec(23,2) ) as skfbt ) AS skfbt,
  cast( cast( 0 as abap.dec(23,2) ) as sknto ) AS sknto,
  cast( '' as schzw_bseg ) AS zlsch,
  cast( '' as dzlspr ) AS zlspr,
  item.uzawe AS uzawe,
  cast( ' ' as hbkid ) AS hbkid,
  cast( ' ' as bvtyp ) AS bvtyp,
  cast( ' ' as rebzg ) AS rebzg,
  cast( '0000' as rebzj ) AS rebzj,
  cast( '000' as rebzz ) AS rebzz,
  cast( '' as rebzt ) AS rebzt,
  cast( ' ' as dzollt ) AS zollt,
  cast( '00000000' as dzolld ) AS zolld,
  item.lzbkz AS lzbkz,
  item.landl AS landl,
  cast( '' as diekz ) AS diekz,
  cast( '' as vrskz ) AS vrskz,
  cast( '00000000' as vrsdt ) AS vrsdt,
  fltp_to_dec( 0000000.00 as blnpz ) AS blnpz,
  cast( '' as mschl ) AS mschl,
  cast( '' as mansp ) AS mansp,
  cast( ' ' as maber ) AS maber,
  cast( ' ' as esrnr ) AS esrnr,
  cast( '' as esrre ) AS esrre,
  cast( ' ' as esrpz ) AS esrpz,
  cast( '' as xhkom ) AS xhkom,
  item.vertt AS vertt,
  cast( '' as dzbfix ) AS zbfix,
  cast( '00000000' as madat ) AS madat,
  cast( '0' as mahns_d ) AS manst,
  item.xref1 AS xref1,
  item.xref2 AS xref2,
  cast( ' ' as empfb ) AS empfb,
  item.vbund AS vbund,
  item.meins AS meins,
  item.kokrs AS kokrs,
  item.kostl AS kostl,
  item.aufnr AS aufnr,
  item.pprctr AS pprct,
  item.imkey AS imkey,
  item.pernr AS pernr,
  item.xskrl AS xskrl,
  item.saknr AS hkont,
  item.matnr AS matnr,
  item.werks AS werks,
  item.ebeln AS ebeln,
  item.ebelp AS ebelp,
  item.zekkn AS zekkn,
  item.bwkey AS bwkey,
  item.bwtar AS bwtar,
  item.tbtkz AS tbtkz,
  item.prctr AS prctr,
  item.recid AS recid,
  item.vptnr AS vptnr,
  item.kstrg AS kstrg,
  item.nplnr AS nplnr,
  item.aufpl AS aufpl,
  item.ps_psp_pnr AS projk,
  item.etype AS etype,
  item.hrkft AS hrkft,
  item.koart AS koart,
  item.vprsv AS vprsv,
  item.peinh AS peinh,
  item.anln1 AS anln1,
  item.anln2 AS anln2,
  item.anbwa AS anbwa,
  item.bupla AS bupla,
  item.grant_nbr AS grant_nbr,
  item.idxsp AS idxsp,
  item.kblnr AS kblnr,
  item.kblpos AS kblpos,
  item.netdt AS netdt,
  item.xnegp AS xnegp,
  cast( 0 as abap.dec(23,2) ) AS pyamt,
  item.pycur AS pycur
FROM vbsegs AS item
-- UNION ALL with additional select branch(es): vbsegd, vbsegk
;