PPH_DD_MAT_CTRL_0

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 PPH_DD_MAT_CTRL_0.
-- 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: V_PPH_DD_MAT_C0

CREATE VIEW PPH_DD_MAT_CTRL_0 AS
SELECT
  pph_dbvm.matnr AS matnr,
  pph_dbvm.werks AS werks,
  pph_dbvm.berid AS berid,
  mdlv.berty AS berty,
  mdma.loekz AS loekz,
  marc.dismm AS marc_dismm,
  mdma.dismm AS mdma_dismm,
  cast(mdma.eisbe as abap.dec( 13, 3)) AS mdma_eisbe,
  cast(marc.eisbe as abap.dec( 13, 3)) AS marc_eisbe,
  marc.wzeit AS wzeit,
  marc.dispo AS marc_dispo,
  mdma.dispo AS mdma_dispo,
  mdma.plifzx AS plifzx,
  mdma.plifz AS mdma_plifz,
  marc.plifz AS marc_plifz,
  marc.beskz AS beskz,
  marc.dzeit AS dzeit,
  mara.meins AS meins,
  mdma.sobsl AS mdma_sobsl,
  marc.sobsl AS marc_sobsl,
  mara.matkl AS matkl,
  mara.attyp AS attyp,
  marc.mabst AS marc_mabst,
  mdma.mabst AS mdma_mabst,
  marc.webaz AS webaz,
  marc.miskz AS miskz,
  mara.mtart AS mtart,
  marc.ahdis AS marc_ahdis,
  mdma.ahdis AS mdma_ahdis,
  marc.shpro AS marc_shpro,
  mdma.shpro AS mdma_shpro,
  marc.shzet AS marc_shzet,
  mdma.shzet AS mdma_shzet,
  marc.shflg AS marc_shflg,
  mdma.shflg AS mdma_shflg,
  marc.disgr AS marc_disgr,
  mdma.disgr AS mdma_disgr,
  cast(marc.minbe as abap.dec( 13, 3)) AS marc_minbe,
  cast(mdma.minbe as abap.dec( 13, 3)) AS mdma_minbe
FROM pph_dbvm
INNER JOIN mara ON /* join condition not captured in parsed metadata */
INNER JOIN marc ON /* join condition not captured in parsed metadata */
INNER JOIN mdlv ON /* join condition not captured in parsed metadata */
INNER JOIN P_DDMATERIAL AS DDMat ON /* join condition not captured in parsed metadata */
;