fgl_lib_p_doc

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.
-- 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: FILIBPDOC
-- Parameters: p_langu : spras, p_doc_type : abap.char(1)

CREATE VIEW fgl_lib_p_doc AS
SELECT
  i.ausbk AS ausbk,
  i.belnr AS belnr,
  i.gjahr AS gjahr,
  i.bukrs AS bukrs,
  i.bzkey AS bzkey,
  h.currkey_0d AS currkey_0d,
  h.currkey_10 AS currkey_10,
  h.currkey_11 AS currkey_11,
  h.currkey_12 AS currkey_12,
  h.currkey_30 AS currkey_30,
  h.currkey_31 AS currkey_31,
  h.currkey_32 AS currkey_32,
  h.currkey_40 AS currkey_40,
  h.currkey_50 AS currkey_50,
  h.currkey_60 AS currkey_60,
  cast(i.wrbtr as fagl_currval_0d) AS currval_0d,
  cast(i.dmbtr as fagl_currval_10 ) AS currval_10,
  i.meins AS quanunit,
  cast(i.menge as quan1_12 ) AS quantity,
  h.adisc AS adisc,
  h.aedat AS aedat,
  h.arcid AS arcid,
  h.awkey AS awkey,
  h.aworg_rev AS aworg_rev,
  h.awref_rev AS awref_rev,
  h.awsys AS awsys,
  h.awtyp AS awtyp,
  h.basw2 AS basw2,
  h.basw3 AS basw3,
  h.belnr_sender AS belnr_sender,
  h.bktxt AS bktxt,
  h.blart AS blart,
  h.bldat AS bldat,
  h.brnch AS brnch,
  h.bstat AS bstat,
  h.budat AS budat,
  h.bukrs_sender AS bukrs_sender,
  h.bvorg AS bvorg,
  h.cash_alloc AS cash_alloc,
  h.co_alebn AS co_alebn,
  h.co_refbt AS co_refbt,
  h.co_valdt AS co_valdt,
  h.co_vrgng AS co_vrgng,
  h.cpudt AS cpudt,
  h.cputm AS cputm,
  h.ctxkrs AS ctxkrs,
  h.curt2 AS curt2,
  h.curt3 AS curt3,
  h.dbblg AS dbblg,
  h.doccat AS doccat,
  h.dokid AS dokid,
  h.duefl AS duefl,
  h.fikrs AS fikrs,
  h.follow_on AS follow_on,
  h.frath AS frath,
  h.gjahr_sender AS gjahr_sender,
  h.glbtgrp AS glbtgrp,
  h.glvor AS glvor,
  h.grpid AS grpid,
  h.hwae2 AS hwae2,
  h.hwae3 AS hwae3,
  h.hwaer AS hwaer,
  h.iblar AS iblar,
  h.intsubid AS intsubid,
  h.kokrs_sender AS kokrs_sender,
  h.kur2x AS kur2x,
  h.kur3x AS kur3x,
  h.kurs2 AS kurs2,
  h.kurs3 AS kurs3,
  h.kursf AS kursf,
  h.kurst AS kurst,
  h.kursx AS kursx,
  h.kuty2 AS kuty2,
  h.kuty3 AS kuty3,
  h.kzkrs AS kzkrs,
  h.kzwrs AS kzwrs,
  h.ldgrp AS ldgrp,
  h.lotkz AS lotkz,
  h.monat AS monat,
  h.numpg AS numpg,
  h.ppdat AS ppdat,
  h.ppnam AS ppnam,
  h.pptcod AS pptcod,
  h.pptme AS pptme,
  h.propmano AS propmano,
  h.reindat AS reindat,
  h.resubmission AS resubmission,
  h.rldnr AS rldnr,
  h.stblg AS stblg,
  h.stgrd AS stgrd,
  h.stjah AS stjah,
  h.stodt AS stodt,
  h.subset AS subset,
  h.tcode AS tcode,
  h.txkrs AS txkrs,
  h.umrd2 AS umrd2,
  h.umrd3 AS umrd3,
  h.upddt AS upddt,
  h.usnam AS usnam,
  h.vatdate AS vatdate,
  h.wwert AS wwert,
  h.xblnr AS xblnr,
  h.xblnr_alt AS xblnr_alt,
  h.xmca AS xmca,
  h.xmwst AS xmwst,
  h.xnetb AS xnetb,
  h.xref1_hd AS xref1_hd,
  h.xref2_hd AS xref2_hd,
  h.xreorg AS xreorg,
  h.xreversal AS xreversal,
  h.xreversed AS xreversed,
  h.xreversing AS xreversing,
  h.xrueb AS xrueb,
  h.xsnet AS xsnet,
  h.xsplit AS xsplit,
  h.xstov AS xstov,
  h.xusvr AS xusvr,
  h.xwvof AS xwvof,
  h.ktopl AS ktopl,
  h.fiscper AS fiscper,
  i.counter AS counter,
  i.shkzg AS shkzg,
  i.buzei AS buzei,
  i.bschl AS bschl,
  i.gsber AS gsber,
  i.pargb AS pargb,
  i.mwskz AS mwskz,
  i.hwmet AS hwmet,
  i.mwart AS mwart,
  i.kursr AS kursr,
  i.zfbdt AS zfbdt,
  i.valut AS valut,
  i.zuonr AS zuonr,
  i.sgtxt AS sgtxt,
  i.zinkz AS zinkz,
  i.fdlev AS fdlev,
  i.fdgrp AS fdgrp,
  i.fdtag AS fdtag,
  i.xumsw AS xumsw,
  i.hzuon AS hzuon,
  i.stceg AS stceg,
  i.vname AS vname,
  i.egrup AS egrup,
  i.vertn AS vertn,
  i.vbewa AS vbewa,
  i.dabrz AS dabrz,
  i.btype AS btype,
  i.xegdr AS xegdr,
  i.fipos AS fipos,
  i.xref3 AS xref3,
  i.rstgr AS rstgr,
  i.fistl AS fistl,
  i.fkber AS fkber,
  i.umskz AS umskz,
  i.umsks AS umsks,
  i.geber AS geber,
  i.xcpdd AS xcpdd,
  i.xinve AS xinve,
  i.lifnr AS lifnr,
  i.kunnr AS kunnr,
  i.filkd AS filkd,
  i.zterm AS zterm,
  i.zbd1t AS zbd1t,
  i.zbd2t AS zbd2t,
  i.zbd3t AS zbd3t,
  i.zbd1p AS zbd1p,
  i.zbd2p AS zbd2p,
  i.skfbt AS skfbt,
  i.sknto AS sknto,
  i.zlsch AS zlsch,
  i.zlspr AS zlspr,
  i.uzawe AS uzawe,
  i.hbkid AS hbkid,
  i.bvtyp AS bvtyp,
  i.rebzg AS rebzg,
  i.rebzj AS rebzj,
  i.rebzz AS rebzz,
  i.rebzt AS rebzt,
  i.zollt AS zollt,
  i.zolld AS zolld,
  i.lzbkz AS lzbkz,
  i.landl AS landl,
  i.diekz AS diekz,
  i.vrskz AS vrskz,
  i.vrsdt AS vrsdt,
  i.blnpz AS blnpz,
  i.mschl AS mschl,
  i.mansp AS mansp,
  i.maber AS maber,
  i.esrnr AS esrnr,
  i.esrre AS esrre,
  i.esrpz AS esrpz,
  i.xhkom AS xhkom,
  i.vertt AS vertt,
  i.zbfix AS zbfix,
  i.madat AS madat,
  i.manst AS manst,
  i.xref1 AS xref1,
  i.xref2 AS xref2,
  i.empfb AS empfb,
  i.vbund AS vbund,
  i.kokrs AS kokrs,
  i.kostl AS kostl,
  i.aufnr AS aufnr,
  i.pprct AS pprct,
  i.imkey AS imkey,
  i.pernr AS pernr,
  i.xskrl AS xskrl,
  i.hkont AS hkont,
  i.matnr AS matnr,
  i.werks AS werks,
  i.ebeln AS ebeln,
  i.ebelp AS ebelp,
  i.zekkn AS zekkn,
  i.bwkey AS bwkey,
  i.bwtar AS bwtar,
  i.tbtkz AS tbtkz,
  i.prctr AS prctr,
  i.recid AS recid,
  i.vptnr AS vptnr,
  i.kstrg AS kstrg,
  i.nplnr AS nplnr,
  i.aufpl AS aufpl,
  i.projk AS projk,
  i.etype AS etype,
  i.hrkft AS hrkft,
  i.koart AS koart,
  i.vprsv AS vprsv,
  i.peinh AS peinh,
  i.anln1 AS anln1,
  i.anln2 AS anln2,
  i.anbwa AS anbwa,
  i.bupla AS bupla,
  i.grant_nbr AS grant_nbr,
  i.idxsp AS idxsp,
  i.kblnr AS kblnr,
  i.kblpos AS kblpos,
  i.netdt AS netdt,
  i.xnegp AS xnegp,
  i.pyamt AS pyamt,
  i.pycur AS pycur,
  rprctr.ktext AS rp_ktext,
  rprctr.ltext AS rp_ltext,
  sprctr.ktext AS sp_ktext,
  sprctr.ltext AS sp_ltext,
  rfkbt.fkbtx AS rf_fkbtx,
  rkostl.ktext AS cc_ktext,
  rkostl.ltext AS cc_ltext,
  aufk.ktext AS or_ktext,
  rmatnr.maktx AS mm_maktx,
  hkont.txt20 AS ga_txt20,
  hkont.txt50 AS ga_txt50
FROM FGL_LIB_P_DOC_ITEM AS i
INNER JOIN FGL_LIB_P_DOC_HEADER AS h ON /* join condition not captured in parsed metadata */
;