I_MRPProductionDemand

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_MRPProductionDemand.
-- 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 I_MRPProductionDemand AS
SELECT
  CacheMaterial.MRPPlant AS MRPPlant,
  CacheMaterial.MRPArea AS MRPArea,
  CacheMaterial.Material AS Material,
  MRPPlanningSegment.MRPPlanningSegment AS MRPPlanningSegment,
  cast( MRPPlanningSegment.MRPPlanningSegmentType as plaab ) AS MRPPlanningSegmentType,
  MRPPlanningSegment.MaterialShortageProfile AS MaterialShortageProfile,
  CacheItem.NumberOfShortages AS MaterialShortageProfileCount,
  CacheItem.MRPElement AS MRPElement,
  CacheItem.MRPElementItem AS MRPElementItem,
  CacheItem.MRPElementScheduleLine AS MRPElementScheduleLine,
  CacheItem.MRPElementCategory AS MRPElementCategory,
  CacheItem.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  cast( substring( CacheItem.MRPElementItem, 3, 4 ) as rspos ) AS ReservationItem,
  CacheMaterial.Material AS MaterialExternalID,
  concat(MRPPlanningSegment.MaterialShortageProfile, CacheItem.NumberOfShortages) AS MaterialShortageDefinition,
  MRPPlanningSegment.MRPPlanningSegmentExternalCode AS MRPPlanningSegmentExternalCode,
  CacheItem.MRPElementUncoveredQuantity + CacheItem.MRPElementDelayedQuantity AS MRPElementMissingQuantity,
  cast ( case when CacheItem.MRPElementAvailyOrRqmtDate <= CacheMaterial.MaterialReplnmtLeadDurnEndDate then 'X' else '' end as boolean preserving type ) AS HasMaterialShortageReplnmtLead,
  cast ( case when CacheItem.MRPElementAvailyOrRqmtDate <= CacheMaterial.TotalReplnmtLeadDurnEndDate then 'X' else '' end as boolean preserving type ) AS HasShortageTotalReplnmtLead,
  cast ( case when CacheItem.MRPElementAvailyOrRqmtDate <= CacheMaterial.ManualPlanningHorizonEndDate then 'X' else '' end as boolean preserving type) AS HasShortageManualPlanHorizon,
  cast ( case when CacheItem.MRPElementAvailyOrRqmtDate <= CacheMaterial.MRPSafetyDurationEndDate then 'X' else '' end as boolean preserving type ) AS HasShortageMRPSafetyDuration,
  MRPPlanningSegment.PlanningSegmentDocument AS PlanningSegmentDocument,
  MRPPlanningSegment.PlanningSegmentDocumentItem AS PlanningSegmentDocumentItem,
  CacheMaterial.FactoryCalendar AS FactoryCalendar,
  CacheMaterial.MaterialName AS MaterialName,
  CacheMaterial.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  CacheMaterial.MRPController AS MRPController,
  CacheMaterial.MaterialProcurementCategory AS MaterialProcurementCategory,
  CacheMaterial.MaterialBaseUnit AS MaterialBaseUnit,
  Uom.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  Uom.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  CacheMaterial.MaterialReplnmtLeadDurnEndDate AS MaterialReplnmtLeadDurnEndDate,
  CacheMaterial.TotalReplnmtLeadDurnEndDate AS TotalReplnmtLeadDurnEndDate,
  CacheMaterial.ManualPlanningHorizonEndDate AS ManualPlanningHorizonEndDate,
  CacheMaterial.MRPSafetyDurationEndDate AS MRPSafetyDurationEndDate,
  case when CacheMaterial.MRPType <> _MaterialMRPArea.MRPType and _MaterialMRPArea.MRPType <> '' then _MaterialMRPArea.MRPType else CacheMaterial.MRPType end as MRPType AS MRPTypeendasMRPType,
  cast ( -1 * CacheItem.MRPElementOpenQuantity as abap.dec( 20, 3 ) ) AS MRPElementOpenQuantity,
  CacheItem.SourceMRPElementCategory AS SourceMRPElementCategory,
  CacheItem.SourceMRPElement AS SourceMRPElement,
  CacheItem.SourceMRPElementItem AS SourceMRPElementItem,
  CacheItem.MRPElementTypeImportance AS MRPElementTypeImportance,
  CacheItem.MRPElementUncoveredQuantity AS MRPElementUncoveredQuantity,
  CacheItem.MRPElementDelayedQuantity AS MRPElementDelayedQuantity,
  CacheItem.MaximumDelayDate AS MaximumDelayDate,
  CacheItem.MaximumDelayInDays AS MaximumDelayInDays,
  CacheItem.MaximumDelayInWorkdays AS MaximumDelayInWorkdays,
  CacheItem.ProcurementProgress AS ProcurementProgress,
  CacheItem.StorageLocation AS StorageLocation,
  MRPPlant.PlantName AS PlantName,
  OrderBasic.OrderType AS OrderType,
  MRPController.MRPControllerName AS MRPControllerName,
  CustomizingMRPArea.MRPAreaText AS MRPAreaText,
  MRPReservations.ResvnItmRequiredQtyInBaseUnit AS OrderQuantity,
  OrderItem.Material AS ProducedMaterial,
  coalesce(LogisticsOrderBasic.ProductionSupervisor, '') AS ProductionSupervisor,
  coalesce(ProductionSupervisor.ProductionSupervisorName,'') AS ProductionSupervisorName,
  coalesce(OrderItem.ProductionVersion, '') AS ProductionVersion,
  coalesce(ProductionVersion.ProductionVersionText, '') AS ProductionVersionText,
  coalesce(OrderItem.ProductionPlant, '') AS ProductionPlant,
  ProductionVersion.ProductionLine AS ProductionLine,
  MRPPlant.AddressID AS AddressID
FROM I_CacheMaterial AS CacheMaterial
INNER JOIN I_MRPAreaOfResponsibility AS _AreaOfResponsibility ON /* join condition not captured in parsed metadata */
INNER JOIN I_MRPPlanningSegment AS MRPPlanningSegment ON /* join condition not captured in parsed metadata */
INNER JOIN I_MRPReservation AS MRPReservations ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrderBasic AS LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomizingMRPArea AS CustomizingMRPArea ON MRPArea = CustomizingMRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_Plant AS MRPPlant ON MRPPlant = MRPPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS Uom ON MaterialBaseUnit = Uom.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS MRPController ON MRPPlant = MRPController.Plant AND MRPController = MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_OrganizationAddress AS _Address ON addressid = _Address.AddressID AND _Address.AddressPersonID = '' AND _Address.AddressRepresentationCode = ''  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON MaterialBaseUnit = _UnitOfMeasureText.UnitOfMeasure AND _UnitOfMeasureText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _MRPElementCategoryText ON MRPElementCategory = _MRPElementCategoryText.MRPElementCategory AND _MRPElementCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _SrcMRPElementCategoryText ON SourceMRPElementCategory = _SrcMRPElementCategoryText.MRPElementCategory AND _SrcMRPElementCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OrderTypeText AS _OrderTypeText ON OrderType = _OrderTypeText.OrderType AND _OrderTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductionResourceText AS _ProductionLineText ON ProductionLine = _ProductionLineText.ProductionResourceInternalID AND _ProductionLineText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _ProducedMaterialText ON ProducedMaterial = _ProducedMaterialText.Material AND _ProducedMaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialMRPArea AS _MaterialMRPArea ON MRPPlant = _MaterialMRPArea.Plant AND Material = _MaterialMRPArea.Material AND MRPArea = _MaterialMRPArea.MRPArea  -- association [0..1]
;