P_VECConsolidatedData_01

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_VECConsolidatedData_01.
-- 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: PVECCONSD_01
-- Parameters: p_rdimen : fc_dimen, p_ritclg : fc_itclg, p_rvers : fc_rvers, p_rldnr : rldnr, p_ryear : gjahr, p_poper : poper

CREATE VIEW P_VECConsolidatedData_01 AS
SELECT
  ryear,
  rkcur AS cons_cur,
  rdimen,
  docct,
  rcomp,
  rbunit,
  rcongr AS entity,
  ritclg,
  ritem,
  rbuptr,
  sityp,
  subit,
  sum( case when poper = '000' then ksl else 0 end ) AS cons_slvt,
  sum( case when poper = '001' then ksl else 0 end ) AS cons_sl01,
  sum( case when poper = '002' then ksl else 0 end ) AS cons_sl02,
  sum( case when poper = '003' then ksl else 0 end ) AS cons_sl03,
  sum( case when poper = '004' then ksl else 0 end ) AS cons_sl04,
  sum( case when poper = '005' then ksl else 0 end ) AS cons_sl05,
  sum( case when poper = '006' then ksl else 0 end ) AS cons_sl06,
  sum( case when poper = '007' then ksl else 0 end ) AS cons_sl07,
  sum( case when poper = '008' then ksl else 0 end ) AS cons_sl08,
  sum( case when poper = '009' then ksl else 0 end ) AS cons_sl09,
  sum( case when poper = '010' then ksl else 0 end ) AS cons_sl10,
  sum( case when poper = '011' then ksl else 0 end ) AS cons_sl11,
  sum( case when poper = '012' then ksl else 0 end ) AS cons_sl12,
  sum( case when poper = '013' then ksl else 0 end ) AS cons_sl13,
  sum( case when poper = '014' then ksl else 0 end ) AS cons_sl14,
  sum( case when poper = '015' then ksl else 0 end ) AS cons_sl15,
  sum( case when poper = '016' then ksl else 0 end ) AS cons_sl16,
  rtcur,
  sum( case when poper = :p_poper then tsl else 0 end ) AS tsl,
  rrcty,
  plevl,
  docty,
  yracq,
  pracq,
  coicu,
  autom,
  refdocct,
  coiac,
  coinr,
  ktopl,
  racct,
  runit,
  sum( case when poper = :p_poper then msl else 0 end ) AS msl,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  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,
  timestamp,
  robukrs
FROM P_CnsldtnDataWCnsldtnLogicYTD
INNER JOIN I_CnsldtnGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_Matrix_VecConsolidatedData
;