V_FGL_BCF_PL_EXT

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 V_FGL_BCF_PL_EXT.
-- 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: FGLV_BCF_PL_EXT
-- Parameters: p_rldnr : fagl_rldnr, p_bukrs : bukrs, p_fromYear : gjahr, p_toYear : gjahr

CREATE VIEW V_FGL_BCF_PL_EXT AS
SELECT
  BCF.belnr AS belnr,
  BCF.docln AS docln,
  BCF.unionCode AS unionCode,
  BCF.temp_appl AS temp_appl,
  BCF.temp_id AS temp_id,
  BCF.rldnr AS rldnr,
  BCF.rbukrs AS rbukrs,
  BCF.ryear AS ryear,
  BCF.poper AS poper,
  BCF.hsl AS hsl,
  BCF.ksl AS ksl,
  BCF.rhcur AS rhcur,
  BCF.rkcur AS rkcur,
  BCF.org_ryear AS org_ryear,
  BCF.gkont AS gkont,
  BCF.bcf_type AS bcf_type,
  BCF.xopvw AS xopvw,
  BCF.mitkz AS mitkz,
  BCF.racct AS racct,
  BCF.ktopl AS ktopl,
  BCF.tsl AS tsl,
  BCF.rtcur AS rtcur,
  BCF.wsl AS wsl,
  BCF.rwcur AS rwcur,
  BCF.lokkt AS lokkt,
  BCF.ktop2 AS ktop2,
  BCF.rmvct AS rmvct,
  BCF.cbrunid AS cbrunid,
  BCF.bdgt_account AS bdgt_account,
  BCF.osl AS osl,
  BCF.co_osl AS co_osl,
  BCF.pfsl AS pfsl,
  BCF.psl AS psl,
  BCF.vsl AS vsl,
  BCF.bsl AS bsl,
  BCF.csl AS csl,
  BCF.dsl AS dsl,
  BCF.esl AS esl,
  BCF.fsl AS fsl,
  BCF.gsl AS gsl,
  BCF.hvkwrt AS hvkwrt,
  BCF.fcsl AS fcsl,
  BCF.awsys AS awsys,
  BCF.awtyp AS awtyp,
  BCF.blart AS blart,
  BCF.eprctr AS eprctr,
  BCF.koart AS koart,
  BCF.kokrs AS kokrs,
  BCF.periv AS periv,
  BCF.pprctr AS pprctr,
  BCF.prctr AS prctr,
  BCF.psegment AS psegment,
  BCF.rassc AS rassc,
  BCF.rbusa AS rbusa,
  BCF.rcntr AS rcntr,
  BCF.rco_ocur AS rco_ocur,
  BCF.rfarea AS rfarea,
  BCF.rbcur AS rbcur,
  BCF.rccur AS rccur,
  BCF.rdcur AS rdcur,
  BCF.recur AS recur,
  BCF.rfcur AS rfcur,
  BCF.rgcur AS rgcur,
  BCF.rfccur AS rfccur,
  BCF.rhoart AS rhoart,
  BCF.rocur AS rocur,
  BCF.rrcty AS rrcty,
  BCF.rvcur AS rvcur,
  BCF.sbusa AS sbusa,
  BCF.scntr AS scntr,
  BCF.segment AS segment,
  BCF.sfarea AS sfarea,
  BCF.hbkid AS hbkid,
  BCF.hktid AS hktid,
  BCF.mwskz AS mwskz,
  BCF.anlkl AS anlkl,
  BCF.matnr AS matnr,
  BCF.re_account AS re_account,
  BCF.rbudget_pd AS rbudget_pd,
  BCF.sbudget_pd AS sbudget_pd,
  BCF.re_bukrs AS re_bukrs,
  BCF.fikrs AS fikrs,
  BCF.fistl AS fistl,
  BCF.measure AS measure,
  BCF.rfund AS rfund,
  BCF.rgrant_nbr AS rgrant_nbr,
  BCF.sfund AS sfund,
  BCF.sgrant_nbr AS sgrant_nbr,
  BCF.vname AS vname,
  BCF.egrup AS egrup,
  BCF.recid AS recid,
  BCF.btype AS btype,
  BCF.prodper AS prodper,
  BCF.jvactivity AS jvactivity,
  BCF.pvname AS pvname,
  BCF.pegrup AS pegrup,
  BCF.etype AS etype,
  BCF.aufnr AS aufnr,
  BCF.werks AS werks,
  BCF.bukrs_sender AS bukrs_sender,
  BCF.racct_sender AS racct_sender,
  BCF.vptnr AS vptnr,
  BCF.swenr AS swenr,
  BCF.sgenr AS sgenr,
  BCF.sgrnr AS sgrnr,
  BCF.acrlogsys AS acrlogsys,
  BCF.acritmtype AS acritmtype,
  BCF.acrobjtype AS acrobjtype,
  BCF.acrobj_id AS acrobj_id,
  BCF.acrsobj_id AS acrsobj_id,
  BCF.valobjtype AS valobjtype,
  BCF.valobj_id AS valobj_id,
  BCF.valsobj_id AS valsobj_id,
  BCF.mig_source AS mig_source,
  BCF.rbunit AS rbunit,
  BCF.rbuptr AS rbuptr,
  BCF.rcomp AS rcomp,
  BCF.ritclg AS ritclg,
  BCF.ritem AS ritem,
  BCF.sityp AS sityp,
  BCF.subit AS subit,
  BCF.kdgrp AS kdgrp,
  BCF.land1 AS land1
FROM FGL_BCF_PL_MOD
;