P_Matrix_CnsldtnFndnWithHier

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 P_Matrix_CnsldtnFndnWithHier.
-- 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: PMCFNDVHIER
-- Parameters: P_ConsolidationUnitHierarchy : hryid, P_ConsolidationPrftCtrHier : hryid, P_ConsolidationSegmentHier : hryid, P_KeyDate : datbi

CREATE VIEW P_Matrix_CnsldtnFndnWithHier AS
SELECT
  rclnt,
  rldnr,
  rdimen,
  ryear,
  docnr,
  docln,
  rrcty,
  rvers,
  ConsolidationVersion,
  rtcur,
  rhcur,
  rkcur,
  runit,
  drcrk,
  cast(poper as fincs_ui_reporting_period) AS poper,
  fiscyearper,
  period_mode,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  rpflg,
  rtflg,
  docty,
  yracq,
  pracq,
  coicu,
  uppcu,
  tsl,
  hsl,
  ksl,
  msl,
  tsl_csign,
  hsl_csign,
  ksl_csign,
  msl_csign,
  sgtxt,
  autom,
  activ,
  bvorg,
  budat,
  wsdat,
  refdocnr,
  refryear,
  refdocln,
  refdocct,
  refactiv,
  timestamp,
  cpudt,
  cputm,
  usnam,
  rvsdocnr,
  orndocnr,
  coiac,
  coinr,
  revyear,
  awtyp,
  aworg,
  logsys,
  ktopl,
  racct,
  xblnr,
  zuonr,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  transaction_data.segment AS segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  aufnr,
  kunnr,
  lifnr,
  matnr,
  matkl_mm,
  werks,
  rmvct,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  adhocitem,
  adhocset,
  adhocsetitem,
  rcode,
  orig_type,
  orig_ref,
  bunnr,
  branch_id,
  ghgcategory,
  ghgscope,
  ghgenergymix,
  fikrs,
  rfund,
  rgrant_nbr,
  re_ktopl,
  re_account,
  bp_p_geber,
  :P_ConsolidationUnitHierarchy AS ConsolidationUnitHierarchy,
  :P_ConsolidationPrftCtrHier AS ConsolidationPrftCtrHier,
  :P_ConsolidationSegmentHier as ConsolidationSegmentHier AS P_ConsolidationUnitHierarchy,
  P_KeyDate : $parameters.P_KeyDate ) as derivation_cu on derivation_cu.hryid = $parameters.P_ConsolidationUnitHierarchy and derivation_cu.ConsolidationDimension = transaction_data.rdimen and derivation_cu.ValidFrom <= $parameters.P_KeyDate and derivation_cu.ValidTo >= $parameters.P_KeyDate and derivation_cu.ConsolidationUnit = transaction_data.rbunit and derivation_cu.PartnerConsolidationUnit = transaction_data.rbuptr left outer join P_Matrix_Hier_Derivation_PC( P_ConsolidationPrftCtrHier : $parameters.P_ConsolidationPrftCtrHier AS P_ConsolidationPrftCtrHier,
  P_KeyDate : $parameters.P_KeyDate ) as derivation_pc on derivation_pc.hryid = $parameters.P_ConsolidationPrftCtrHier and derivation_pc.ControllingArea = transaction_data.kokrs and derivation_pc.ValidFrom <= $parameters.P_KeyDate and derivation_pc.ValidTo >= $parameters.P_KeyDate and derivation_pc.ProfitCenter = transaction_data.prctr and derivation_pc.PartnerProfitCenter = transaction_data.pprctr left outer join P_Matrix_Hier_Derivation_SEG( P_ConsolidationSegmentHier : $parameters.P_ConsolidationSegmentHier AS P_ConsolidationSegmentHier,
  :P_ConsolidationSegmentHier AS ConsolidationSegmentHier
FROM P_Matrix_CnsldtnFndn AS transaction_data
LEFT OUTER JOIN P_Matrix_Hier_Leaf_CU ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Matrix_Hier_Leaf_PC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Matrix_Hier_Leaf_SEG ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Matrix_Hier_Derivation_CU ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Matrix_Hier_Derivation_PC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Matrix_Hier_Derivation_SEG ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Matrix_CnsldtnFndn
;