I_DemandDrivenMaterial

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 I_DemandDrivenMaterial.
-- 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: IDDMATERIAL

CREATE VIEW I_DemandDrivenMaterial AS
SELECT
  pph_ddl_mat.matnr AS Material,
  pph_ddl_mat.werks AS Plant,
  pph_ddl_mat.berid AS MRPArea,
  pph_ddl_mat.dispo AS MRPController,
  pph_ddl_mat.disgr AS MRPGroup,
  pph_ddl_mat.meins AS BaseUnitofMeasure,
  _Material.MaterialBaseUnit AS MaterialBaseUnit,
  pph_ddl_mat.disvf AS MRPProcedure,
  pph_ddl_mat.dismm AS MRPType,
  pph_ddl_mat.eisbe AS MaterialSafetyStockQty,
  pph_ddl_mat.eisbe_today AS MaterialSafetyStockTodayQty,
  pph_ddl_mat.mabst AS MaterialMaxStockLevelQuantity,
  cast(pph_ddl_mat.minbe as minbe) AS ReorderThresholdQuantity,
  case when _PlantProfile.OnHandAlertThldFctr>0 then pph_ddl_mat.eisbe * cast (_PlantProfile.OnHandAlertThldFctr as abap.quan(13,3)) else pph_ddl_mat.eisbe * cast(division(50,100,2) as abap.quan(13,3)) end as ThresholdPercentage AS quan133endasThresholdPercentage,
  pph_ddl_mat.matkl AS MaterialGroup
FROM PPH_DD_MAT
LEFT OUTER JOIN I_ProfileAssgmtToPlant AS _PlantProfile ON pph_ddl_mat.werks = _PlantProfile.Plant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON pph_ddl_mat.matnr = _Material.Material  -- association [1..1]
;