FGL_LIB_P_S

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_S.
-- 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: FILIBPS
-- Parameters: p_langu : spras

CREATE VIEW FGL_LIB_P_S AS
SELECT
  d.ausbk AS ausbk,
  d.belnr AS belnr,
  d.gjahr AS gjahr,
  d.bukrs AS bukrs,
  d.bzkey AS bzkey,
  d.currkey_0d AS currkey_0d,
  d.currkey_10 AS currkey_10,
  d.currkey_11 AS currkey_11,
  d.currkey_12 AS currkey_12,
  d.currkey_30 AS currkey_30,
  d.currkey_31 AS currkey_31,
  d.currkey_32 AS currkey_32,
  d.currkey_40 AS currkey_40,
  d.currkey_50 AS currkey_50,
  d.currkey_60 AS currkey_60,
  d.currval_0d AS currval_0d,
  d.currval_10 AS currval_10,
  d.currval_11 AS currval_11,
  d.currval_12 AS currval_12,
  d.currval_30 AS currval_30,
  d.currval_31 AS currval_31,
  d.currval_32 AS currval_32,
  d.currval_40 AS currval_40,
  d.currval_50 AS currval_50,
  d.currval_60 AS currval_60,
  d.quanunit AS quanunit,
  d.quantity AS quantity,
  d.adisc AS adisc,
  d.aedat AS aedat,
  d.arcid AS arcid,
  d.awkey AS awkey,
  d.aworg_rev AS aworg_rev,
  d.awref_rev AS awref_rev,
  d.awsys AS awsys,
  d.awtyp AS awtyp,
  d.basw2 AS basw2,
  d.basw3 AS basw3,
  d.belnr_sender AS belnr_sender,
  d.bktxt AS bktxt,
  d.blart AS blart,
  d.bldat AS bldat,
  d.brnch AS brnch,
  d.bstat AS bstat,
  d.budat AS budat,
  d.bukrs_sender AS bukrs_sender,
  d.bvorg AS bvorg,
  d.cash_alloc AS cash_alloc,
  d.co_alebn AS co_alebn,
  d.co_refbt AS co_refbt,
  d.co_valdt AS co_valdt,
  d.co_vrgng AS co_vrgng,
  d.cpudt AS cpudt,
  d.cputm AS cputm,
  d.ctxkrs AS ctxkrs,
  d.curt2 AS curt2,
  d.curt3 AS curt3,
  d.dbblg AS dbblg,
  d.doccat AS doccat,
  d.dokid AS dokid,
  d.duefl AS duefl,
  d.fikrs AS fikrs,
  d.follow_on AS follow_on,
  d.frath AS frath,
  d.gjahr_sender AS gjahr_sender,
  d.glbtgrp AS glbtgrp,
  d.glvor AS glvor,
  d.grpid AS grpid,
  d.hwae2 AS hwae2,
  d.hwae3 AS hwae3,
  d.hwaer AS hwaer,
  d.iblar AS iblar,
  d.intsubid AS intsubid,
  d.kokrs_sender AS kokrs_sender,
  d.kur2x AS kur2x,
  d.kur3x AS kur3x,
  d.kurs2 AS kurs2,
  d.kurs3 AS kurs3,
  d.kursf AS kursf,
  d.kurst AS kurst,
  d.kursx AS kursx,
  d.kuty2 AS kuty2,
  d.kuty3 AS kuty3,
  d.kzkrs AS kzkrs,
  d.kzwrs AS kzwrs,
  d.ldgrp AS ldgrp,
  d.lotkz AS lotkz,
  d.monat AS monat,
  d.numpg AS numpg,
  d.ppdat AS ppdat,
  d.ppnam AS ppnam,
  d.pptcod AS pptcod,
  d.pptme AS pptme,
  d.propmano AS propmano,
  d.reindat AS reindat,
  d.resubmission AS resubmission,
  d.rldnr AS rldnr,
  d.stblg AS stblg,
  d.stgrd AS stgrd,
  d.stjah AS stjah,
  d.stodt AS stodt,
  d.subset AS subset,
  d.tcode AS tcode,
  d.txkrs AS txkrs,
  d.umrd2 AS umrd2,
  d.umrd3 AS umrd3,
  d.upddt AS upddt,
  d.usnam AS usnam,
  d.vatdate AS vatdate,
  d.wwert AS wwert,
  d.xblnr AS xblnr,
  d.xblnr_alt AS xblnr_alt,
  d.xmca AS xmca,
  d.xmwst AS xmwst,
  d.xnetb AS xnetb,
  d.xref1_hd AS xref1_hd,
  d.xref2_hd AS xref2_hd,
  d.xreorg AS xreorg,
  d.xreversal AS xreversal,
  d.xreversed AS xreversed,
  d.xreversing AS xreversing,
  d.xrueb AS xrueb,
  d.xsnet AS xsnet,
  d.xsplit AS xsplit,
  d.xstov AS xstov,
  d.xusvr AS xusvr,
  d.xwvof AS xwvof,
  d.ktopl AS ktopl,
  d.fiscper AS fiscper,
  d.counter AS counter,
  d.shkzg AS shkzg,
  d.buzei AS buzei,
  d.bschl AS bschl,
  d.gsber AS gsber,
  d.pargb AS pargb,
  d.mwskz AS mwskz,
  d.hwmet AS hwmet,
  d.mwart AS mwart,
  d.kursr AS kursr,
  d.zfbdt AS zfbdt,
  d.valut AS valut,
  d.zuonr AS zuonr,
  d.sgtxt AS sgtxt,
  d.zinkz AS zinkz,
  d.fdlev AS fdlev,
  d.fdgrp AS fdgrp,
  d.fdtag AS fdtag,
  d.xumsw AS xumsw,
  d.hzuon AS hzuon,
  d.stceg AS stceg,
  d.vname AS vname,
  d.egrup AS egrup,
  d.vertn AS vertn,
  d.vbewa AS vbewa,
  d.dabrz AS dabrz,
  d.btype AS btype,
  d.xegdr AS xegdr,
  d.fipos AS fipos,
  d.xref3 AS xref3,
  d.rstgr AS rstgr,
  d.fistl AS fistl,
  d.fkber AS fkber,
  d.umskz AS umskz,
  d.umsks AS umsks,
  d.geber AS geber,
  d.xcpdd AS xcpdd,
  d.xinve AS xinve,
  d.lifnr AS lifnr,
  d.kunnr AS kunnr,
  d.filkd AS filkd,
  d.zterm AS zterm,
  d.zbd1t AS zbd1t,
  d.zbd2t AS zbd2t,
  d.zbd3t AS zbd3t,
  d.zbd1p AS zbd1p,
  d.zbd2p AS zbd2p,
  d.skfbt AS skfbt,
  d.sknto AS sknto,
  d.zlsch AS zlsch,
  d.zlspr AS zlspr,
  d.uzawe AS uzawe,
  d.hbkid AS hbkid,
  d.bvtyp AS bvtyp,
  d.rebzg AS rebzg,
  d.rebzj AS rebzj,
  d.rebzz AS rebzz,
  d.rebzt AS rebzt,
  d.zollt AS zollt,
  d.zolld AS zolld,
  d.lzbkz AS lzbkz,
  d.landl AS landl,
  d.diekz AS diekz,
  d.vrskz AS vrskz,
  d.vrsdt AS vrsdt,
  d.blnpz AS blnpz,
  d.mschl AS mschl,
  d.mansp AS mansp,
  d.maber AS maber,
  d.esrnr AS esrnr,
  d.esrre AS esrre,
  d.esrpz AS esrpz,
  d.xhkom AS xhkom,
  d.vertt AS vertt,
  d.zbfix AS zbfix,
  d.madat AS madat,
  d.manst AS manst,
  d.xref1 AS xref1,
  d.xref2 AS xref2,
  d.empfb AS empfb,
  d.vbund AS vbund,
  d.kokrs AS kokrs,
  d.kostl AS kostl,
  d.aufnr AS aufnr,
  d.pprct AS pprct,
  d.imkey AS imkey,
  d.pernr AS pernr,
  d.xskrl AS xskrl,
  d.hkont AS hkont,
  d.matnr AS matnr,
  d.werks AS werks,
  d.ebeln AS ebeln,
  d.ebelp AS ebelp,
  d.zekkn AS zekkn,
  d.bwkey AS bwkey,
  d.bwtar AS bwtar,
  d.tbtkz AS tbtkz,
  d.prctr AS prctr,
  d.recid AS recid,
  d.vptnr AS vptnr,
  d.kstrg AS kstrg,
  d.nplnr AS nplnr,
  d.aufpl AS aufpl,
  d.projk AS projk,
  d.etype AS etype,
  d.hrkft AS hrkft,
  d.koart AS koart,
  d.vprsv AS vprsv,
  d.peinh AS peinh,
  d.anln1 AS anln1,
  d.anln2 AS anln2,
  d.anbwa AS anbwa,
  d.bupla AS bupla,
  d.grant_nbr AS grant_nbr,
  d.idxsp AS idxsp,
  d.kblnr AS kblnr,
  d.kblpos AS kblpos,
  d.netdt AS netdt,
  d.xnegp AS xnegp,
  d.pyamt AS pyamt,
  d.pycur AS pycur,
  d.rp_ktext AS rp_ktext,
  d.rp_ltext AS rp_ltext,
  d.sp_ktext AS sp_ktext,
  d.sp_ltext AS sp_ltext,
  d.rf_fkbtx AS rf_fkbtx,
  d.cc_ktext AS cc_ktext,
  d.cc_ltext AS cc_ltext,
  d.or_ktext AS or_ktext,
  d.mm_maktx AS mm_maktx,
  d.ga_txt20 AS ga_txt20,
  d.ga_txt50 AS ga_txt50,
  ska1.xbilk AS ska1_xbilk,
  ska1.sakan AS ska1_sakan,
  ska1.bilkt AS ska1_bilkt,
  ska1.erdat AS ska1_erdat,
  ska1.ernam AS ska1_ernam,
  ska1.gvtyp AS ska1_gvtyp,
  ska1.ktoks AS ska1_ktoks,
  ska1.mustr AS ska1_mustr,
  ska1.vbund AS ska1_vbund,
  ska1.xloev AS ska1_xloev,
  ska1.xspea AS ska1_xspea,
  ska1.xspeb AS ska1_xspeb,
  ska1.xspep AS ska1_xspep,
  ska1.mcod1 AS ska1_mcod1,
  skb1.begru AS skb1_begru,
  skb1.busab AS skb1_busab,
  skb1.datlz AS skb1_datlz,
  skb1.erdat AS skb1_erdat,
  skb1.ernam AS skb1_ernam,
  skb1.fdgrv AS skb1_fdgrv,
  skb1.fdlev AS skb1_fdlev,
  skb1.fipls AS skb1_fipls,
  skb1.fstag AS skb1_fstag,
  skb1.hbkid AS skb1_hbkid,
  skb1.hktid AS skb1_hktid,
  skb1.kdfsl AS skb1_kdfsl,
  skb1.mitkz AS skb1_mitkz,
  skb1.mwskz AS skb1_mwskz,
  skb1.stext AS skb1_stext,
  skb1.vzskz AS skb1_vzskz,
  skb1.waers AS skb1_waers,
  skb1.wmeth AS skb1_wmeth,
  skb1.xgkon AS skb1_xgkon,
  skb1.xintb AS skb1_xintb,
  skb1.xkres AS skb1_xkres,
  skb1.xloeb AS skb1_xloeb,
  skb1.xnkon AS skb1_xnkon,
  skb1.xopvw AS skb1_xopvw,
  skb1.xspeb AS skb1_xspeb,
  skb1.zindt AS skb1_zindt,
  skb1.zinrt AS skb1_zinrt,
  skb1.zuawa AS skb1_zuawa,
  skb1.altkt AS skb1_altkt,
  skb1.xmitk AS skb1_xmitk,
  skb1.recid AS skb1_recid,
  skb1.fipos AS skb1_fipos,
  skb1.xmwno AS skb1_xmwno,
  skb1.xsalh AS skb1_xsalh,
  skb1.bewgp AS skb1_bewgp,
  skb1.infky AS skb1_infky,
  skb1.togru AS skb1_togru,
  skb1.xlgclr AS skb1_xlgclr
FROM fgl_lib_p_doc
;