Pir_Keyfigures_Read_For_Sum

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 Pir_Keyfigures_Read_For_Sum.
-- 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: PIR_V_RD_SUM

CREATE VIEW Pir_Keyfigures_Read_For_Sum AS
SELECT
  sdm_aor.uname AS uname,
  marc.matnr AS matnr,
  marc.werks AS werks,
  coalesce(pir.berid, cast( marc.werks as berid)) AS berid,
  coalesce(pir.bedae, t461s.bedvp) AS bedae,
  coalesce(pir.versb, '00') AS versb,
  marc.perkz AS perkz_master,
  coalesce(pir.perkz_item,'') AS perkz_item,
  cast(pir.per_edat as pph_per_edat) AS per_edat,
  pir.loevr AS loevr,
  pir.acc_past AS acc_past,
  pir.draft_qty AS draft_qty,
  pir.plan_qty AS plan_qty,
  pir.withdr_qty AS withdr_qty,
  pir.open_qty AS open_qty,
  pir.meins AS item_meins,
  pir.pdatu AS pdatu,
  marc.lvorm AS marc_lvorm,
  mara.lvorm AS mara_lvorm,
  mara.meins AS mara_meins,
  t141_marc.dpbed AS marc_dpbed,
  t141_mara.dpbed AS mara_dpbed,
  0 AS lastchange,
  pir.aenam AS aenam,
  marc.dispo AS dispo
FROM marc
INNER JOIN mara ON /* join condition not captured in parsed metadata */
INNER JOIN sdm_aor ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Pir_All_Attributes AS pir ON /* join condition not captured in parsed metadata */
;