ScmPrd_Marmt006

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 ScmPrd_Marmt006.
-- 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: SCMPRDMARMT006

CREATE VIEW ScmPrd_Marmt006 AS
SELECT
  mara.scm_matid_guid22 AS matid,
  marm.meinh AS meinh,
  marm.ty2tq AS ty2tq,
  marm.umrez AS umrez,
  marm.umren AS umren,
  marm.ean11 AS ean11,
  marm.numtp AS eancat,
  marm.gtin_variant AS gtin_variant,
  marm.brgew AS brgew,
  mara.gewei AS mara_gewei,
  mara.ntgew AS mara_ntgew,
  marm.gewei AS gewei,
  marm.volum AS volum,
  marm.voleh AS voleh,
  marm.laeng AS laeng,
  marm.breit AS breit,
  marm.hoehe AS hoehe,
  marm.meabm AS meabm,
  marm.max_stack AS maxstack,
  marm.nest_ftr AS nest_ftr,
  cast( marm.capause as /scwm/de_capause) AS capause
FROM marm
;