P_PPH_MRP_MAT

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_PPH_MRP_MAT.
-- 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: P_PPH_MRP_MAT_V

CREATE VIEW P_PPH_MRP_MAT AS
SELECT
  d.matnr AS matnr,
  d.werks AS werks,
  d.berid AS berid,
  i.log_uuid AS log_uuid,
  d.dstmp AS MRP_timestamp,
  coalesce(i.msgid,'PPH_MRP') AS msgid,
  i.msgv1 AS msgv1,
  i.msgv2 AS msgv2,
  i.msgv3 AS msgv3,
  i.msgv4 AS msgv4,
  s.plan_in_abap AS plan_in_abap
FROM pph_dbvm AS d
LEFT OUTER JOIN pphdbvmset AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pph_mrp_issues AS i ON /* join condition not captured in parsed metadata */
;