C_SupplyDemandViewMaterialList

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 C_SupplyDemandViewMaterialList.
-- 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.

CREATE VIEW C_SupplyDemandViewMaterialList AS
SELECT
  Material.MRPPlant AS MRPPlant,
  Material.MRPArea AS MRPArea,
  Material.Material AS Material,
  cast(Material.MRPPlanningSegmentType as plaab) AS MRPPlanningSegmentType,
  Material.MRPPlanningSegment AS MRPPlanningSegment,
  Material.MaterialShortageProfile AS MaterialShortageProfile,
  Material.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  Material.FactoryCalendar AS FactoryCalendar,
  concat(Material,concat(MRPPlant,concat(MRPArea,concat(MRPPlanningSegmentType,MRPPlanningSegmentExternalCode)))) AS MaterialSelectionIdentifier,
  _PlantVH.PlantName AS PlantName,
  _MRPAreaVH.MRPAreaText AS MRPAreaText,
  Material.MaterialName AS MaterialName,
  Material.PlantLanguage AS PlantLanguage,
  cast( '' as md_supplier) AS Supplier,
  cast ('' as suppliername_2) AS SupplierName,
  Material.NumberOfSupplier AS NumberOfSupplier,
  Material.MRPValidMaterialStatus AS MRPValidMaterialStatus,
  Material.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  Material.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _PurchasingGroupVH.PurchasingGroupName AS PurchasingGroupName,
  Material.MaterialTypeName AS MaterialTypeName,
  Material.MaterialGroupName AS MaterialGroupName,
  concat(Material.MaterialShortageProfile, Material.MaterialShortageProfileCount) AS MaterialShortageDefinition,
  Material.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  Material.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  cast ('' as char20 ) AS TimeTillShortageDurationText,
  Material.TotalReplnmtLeadDurnEndDate AS TotalReplnmtLeadDurnEndDate,
  Material.ManualPlanningHorizonEndDate AS ManualPlanningHorizonEndDate,
  Material.MRPSafetyDurationEndDate AS MRPSafetyDurationEndDate,
  Material.MaterialShortageStartDate AS MaterialShortageStartDate,
  Material.MaterialShortageEndDate AS MaterialShortageEndDate,
  Material.MaterialPlannedProductionDurn AS MaterialPlannedProductionDurn,
  Material.MRPSafetyDuration AS MRPSafetyDuration,
  Material.TotalReplenishmentLeadDuration AS TotalReplenishmentLeadDuration,
  Material.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  Material.PlanningTimeFenceInDays AS PlanningTimeFenceInDays,
  Material.EvaluationHorizonInDays AS EvaluationHorizonInDays,
  Material.DaysOfSupplyDuration AS DaysOfSupplyDuration,
  Material.IntraDaySupplyDuration AS IntraDaySupplyDuration,
  Material.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  Material.MRPAvailableStockQty AS MRPAvailableStockQty,
  cast (Material.MaterialShortageQuantity as materialshortageqty) AS MaterialShortageQuantity,
  Material.HasShortageTotalReplnmtLead AS HasShortageTotalReplnmtLead,
  Material.HasShortageManualPlanHorizon AS HasShortageManualPlanHorizon,
  Material.HasShortageMRPSafetyDuration AS HasShortageMRPSafetyDuration,
  case when _MRPTypeText[ 1: Language = $session.system_language ].MRPTypeName is not null and _MRPTypeText[ 1: Language = $session.system_language ].MRPTypeName != '' then _MRPTypeText[ 1: Language = $session.system_language ].MRPTypeName when _MRPTypeText[ 1: Language = 'E' ].MRPTypeName is not null and _MRPTypeText[ 1: Language = 'E' ].MRPTypeName != '' then _MRPTypeText[ 1: Language = 'E' ].MRPTypeName else Material.MRPType end as MRPTypeName AS MRPTypeendasMRPTypeName,
  Material.MaterialProcurementProfile AS MaterialProcurementProfile,
  Material.MaterialProcurementCategory AS MaterialProcurementCategory,
  Material.MRPGroup AS MRPGroup,
  Material.MaterialABCClassification AS MaterialABCClassification,
  _LastMRPRun.MaterialLastMRPDateTime AS MaterialLastMRPDateTime,
  Material._UnitOfMeasure AS _UnitOfMeasure
LEFT OUTER JOIN C_SupplyDemandItem AS _SupplyDemandItem ON MRPPlant = _SupplyDemandItem.MRPPlant AND Material = _SupplyDemandItem.Material AND MRPArea = _SupplyDemandItem.MRPArea  -- association [0..*]
LEFT OUTER JOIN C_MRPAvailability AS _MRPAvailability ON MRPPlant = _MRPAvailability.MRPPlant AND Material = _MRPAvailability.Material AND MRPArea = _MRPAvailability.MRPArea AND MRPPlanningSegmentType = _MRPAvailability.MRPPlanningSegmentType AND MRPPlanningSegment = _MRPAvailability.MRPPlanningSegment AND MaterialShortageProfile = _MRPAvailability.MaterialShortageProfile AND MaterialShortageProfileCount = _MRPAvailability.MaterialShortageProfileCount  -- association [0..*]
LEFT OUTER JOIN I_MRPController AS _MRPController ON MRPPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN C_PlantVH AS _PlantVH ON MRPPlant = _PlantVH.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPAreaVH AS _MRPAreaVH ON MRPArea = _MRPAreaVH.MRPArea  -- association [0..1]
LEFT OUTER JOIN C_MRPMaterialNoteInfo AS _Note ON Material = _Note.Material AND MRPPlant = _Note.MRPPlant  -- association [0..*]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupVH ON PurchasingGroup = _PurchasingGroupVH.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_MatlProcurementCategoryText AS _MatlProcurementCategoryText ON MaterialProcurementCategory = _MatlProcurementCategoryText.MaterialProcurementCategory  -- association [0..*]
LEFT OUTER JOIN I_MRPTypeText AS _MRPTypeText ON MRPType = _MRPTypeText.MRPType  -- association [0..*]
LEFT OUTER JOIN I_MatlProcurementProfile AS _MatlProcurementProfile ON MaterialProcurementProfile = _MatlProcurementProfile.MaterialProcurementProfile AND MRPPlant = _MatlProcurementProfile.Plant  -- association [1..1]
LEFT OUTER JOIN I_MatlProcurementProfileText AS _ProcurementProfileTextPlant ON MaterialProcurementProfile = _ProcurementProfileTextPlant.MaterialProcurementProfile AND MRPPlant = _ProcurementProfileTextPlant.Plant AND PlantLanguage = _ProcurementProfileTextPlant.Language  -- association [0..1]
LEFT OUTER JOIN I_MRPAreaPlanningFileEntry AS _LastMRPRun ON Material = _LastMRPRun.Material AND MRPPlant = _LastMRPRun.Plant AND MRPArea = _LastMRPRun.MRPArea AND _LastMRPRun.MRPPlanningScenario = '000'  -- association [0..1]
;