I_CacheMaterial

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_CacheMaterial.
-- 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: ICACHEMATERIAL

CREATE VIEW I_CacheMaterial AS
SELECT
  pph_cache_mat.mandt AS Client,
  pph_cache_mat.material AS Material,
  pph_cache_mat.mrparea AS MRPArea,
  pph_cache_mat.mrpplant AS MRPPlant,
  pph_cache_mat.mrpcontroller AS MRPController,
  cast (pph_cache_mat.materialsafetystockqty as materialsafetystockqty) AS MaterialSafetyStockQty,
  cast (pph_cache_mat.materialreorderpointqty as materialreorderpointqty) AS MaterialReorderPointQty,
  pph_cache_mat.materialbaseunit AS MaterialBaseUnit,
  pph_cache_mat.materialtype AS MaterialType,
  pph_cache_mat.productionsupervisor AS ProductionSupervisor,
  pph_cache_mat.factorycalendarid AS FactoryCalendar,
  cast (pph_cache_mat.materialreplnmtleaddurnenddate as mrpleaddurnenddate) AS MaterialReplnmtLeadDurnEndDate,
  cast (pph_cache_mat.totalreplnmtleaddurnenddate as totalreplnmtleaddurnenddate) AS TotalReplnmtLeadDurnEndDate,
  cast (pph_cache_mat.manualplanninghorizonenddate as manualplanninghorizonenddate) AS ManualPlanningHorizonEndDate,
  cast (pph_cache_mat.mrpsafetydurationenddate as mrpsafetydurationenddate) AS MRPSafetyDurationEndDate,
  pph_cache_mat.materialprocurementprofile AS MaterialProcurementProfile,
  pph_cache_mat.materialprocurementcategory AS MaterialProcurementCategory,
  pph_cache_mat.mrptype AS MRPType,
  pph_cache_mat.materialplanneddeliverydurn AS MaterialPlannedDeliveryDurn,
  pph_cache_mat.materialplannedproductiondurn AS MaterialPlannedProductionDurn,
  pph_cache_mat.mrpsafetyduration AS MRPSafetyDuration,
  pph_cache_mat.planningtimefenceindays AS PlanningTimeFenceInDays,
  pph_cache_mat.purchasinggroup AS PurchasingGroup,
  pph_cache_mat.materialgoodsreceiptduration AS MaterialGoodsReceiptDuration,
  pph_cache_mat.materialgroup AS MaterialGroup,
  pph_cache_mat.materialabcclassification AS MaterialABCClassification,
  pph_cache_mat.mrpgroup AS MRPGroup,
  pph_cache_mat.totalreplenishmentleadduration AS TotalReplenishmentLeadDuration,
  pph_cache_mat.lastupdated AS LastBufferUpdateDateTime,
  _MaterialType._Text[1: Language = $session.system_language ].MaterialTypeName AS MaterialTypeName,
  _MaterialGroup._Text[1: Language = $session.system_language ].MaterialGroupName AS MaterialGroupName,
  _MaterialText[ 1: Language = $session.system_language ].MaterialName AS MaterialName
FROM pph_cache_mat
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialType AS _MaterialType ON MaterialType = _MaterialType.MaterialType  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
;