FGL_BCF_HIST_ALLP

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_BCF_HIST_ALLP.
-- 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: BCFV_HIST_ALLP
-- Parameters: P_company_code : bukrs, P_ledger : fins_ledger, P_from_year : gjahr_pos, P_to_year : gjahr_pos, P_timestamp : timestamp

CREATE VIEW FGL_BCF_HIST_ALLP AS
SELECT
  belnr,
  docln,
  ryear,
  rbukrs,
  rldnr,
  $parameters.P_timestamp AS timestamp,
  xbilk,
  drcrk,
  poper,
  racct,
  glu1_account,
  vtkon,
  tsl,
  rtcur,
  t001_waers,
  rmvct,
  org_account,
  awsys,
  blart,
  co_osl,
  eprctr,
  bsl,
  csl,
  dsl,
  esl,
  fsl,
  gsl,
  hsl,
  kokrs,
  ksl,
  ktop2,
  ktopl,
  osl,
  periv,
  pfsl,
  pprctr,
  prctr,
  psegment,
  psl,
  rassc,
  rbusa,
  rclnt,
  rcntr,
  rco_ocur,
  rfarea,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  rhcur,
  rhoart,
  rkcur,
  rocur,
  rrcty,
  rvcur,
  rwcur,
  sbusa,
  scntr,
  segment,
  sfarea,
  vsl,
  wsl,
  re_account,
  fikrs,
  fistl,
  measure,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  bdgt_account,
  egrup,
  recid,
  aufnr,
  btype,
  prodper,
  cbrunid,
  jvactivity,
  pvname,
  pegrup,
  hbkid,
  hktid,
  werks,
  bukrs_sender,
  racct_sender,
  vptnr,
  sgenr,
  sgrnr,
  acrobjtype,
  acrobj_id,
  acrsobj_id,
  valobjtype,
  valobj_id,
  valsobj_id
FROM FGL_BCF_HIST_PREP
;