Pph_Ddl_Mkal

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_Ddl_Mkal.
-- 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_MKAL

CREATE VIEW Pph_Ddl_Mkal AS
SELECT
  mkal.matnr AS matnr,
  mkal.werks AS werks,
  mkal.verid AS verid,
  mb.MRPArea AS berid,
  mkal.adatu AS adatu,
  mkal.bstmi AS bstmi,
  mkal.text1 AS text1,
  mkal.plnty AS plnty,
  mkal.plnnr AS plnnr,
  mkal.alnal AS alnal,
  mkal.stlal AS stlal,
  mkal.stlan AS stlan,
  mkal.serkz AS serkz,
  mkal.alort AS alort,
  mkal.elpro AS elpro,
  mkal.prvbe AS prvbe
FROM mkal
INNER JOIN MDCV_E_T399D AS t399d ON /* join condition not captured in parsed metadata */
INNER JOIN tcs41 ON /* join condition not captured in parsed metadata */
INNER JOIN needed ON /* join condition not captured in parsed metadata */
INNER JOIN P_MatlMRPArea AS mb ON /* join condition not captured in parsed metadata */
INNER JOIN P_MatlMRPAreaStorLoc AS mbl ON /* join condition not captured in parsed metadata */
;