C_MRPInternalRequirement

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_MRPInternalRequirement.
-- 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_MRPInternalRequirement AS
SELECT
  I_MRPProductionDemand.MRPPlant AS MRPPlant,
  I_MRPProductionDemand.MRPArea AS MRPArea,
  I_MRPProductionDemand.Material AS Material,
  I_MRPProductionDemand.MRPPlanningSegment AS MRPPlanningSegment,
  I_MRPProductionDemand.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  I_MRPProductionDemand.MaterialShortageProfile AS MaterialShortageProfile,
  I_MRPProductionDemand.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  I_MRPProductionDemand.MRPElement AS MRPElement,
  I_MRPProductionDemand.MRPElementItem AS MRPElementItem,
  I_MRPProductionDemand.MRPElementScheduleLine AS MRPElementScheduleLine,
  I_MRPProductionDemand.MRPElementCategory AS MRPElementCategory,
  I_MRPProductionDemand.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  I_MRPProductionDemand.MRPPlanningSegmentExternalCode AS MRPPlanningSegmentExternalCode,
  I_MRPProductionDemand.MaterialExternalID AS MaterialExternalID,
  _MaterialShortageDef.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  I_MRPProductionDemand.MaterialShortageDefinition AS MaterialShortageDefinition,
  I_MRPProductionDemand._MRPElementCategoryText.MRPElementCategoryName AS MRPElementCategoryName,
  I_MRPProductionDemand._MRPElementCategoryText.MRPElementCategoryShortName AS MRPElementCategoryShortName,
  I_MRPProductionDemand._SrcMRPElementCategoryText.MRPElementCategoryName AS SourceMRPElementCategoryName,
  I_MRPProductionDemand._SrcMRPElementCategoryText.MRPElementCategoryShortName AS SrcMRPElementCategoryShortName,
  I_MRPProductionDemand.LatestPlannedAvailabilityDate AS LatestPlannedAvailabilityDate,
  I_MRPProductionDemand.FactoryCalendar AS FactoryCalendar,
  I_MRPProductionDemand.Material AS ComponentMaterial,
  I_MRPProductionDemand.MaterialName AS MaterialName,
  I_MRPProductionDemand._UnitOfMeasureText.UnitOfMeasureCommercialName AS UnitOfMeasureCommercialName,
  I_MRPProductionDemand.MRPController AS MRPController,
  I_MRPProductionDemand.MaterialBaseUnit AS MaterialBaseUnit,
  I_MRPProductionDemand.UnitOfMeasureNumberOfDecimals AS TargetQuantityUnitDcmls,
  I_MRPProductionDemand.UnitOfMeasureDspNmbrOfDcmls AS TargetQuantityUnitDisplayDcmls,
  I_MRPProductionDemand.SourceMRPElementCategory AS SourceMRPElementCategory,
  ltrim ( I_MRPProductionDemand.SourceMRPElement, '0' ) AS SourceMRPElement,
  _OrderBasic.OrderDescription AS OrderDescription,
  I_MRPProductionDemand.SourceMRPElementItem AS SourceMRPElementItem,
  I_MRPProductionDemand.MaximumDelayInDays AS MaximumDelayInDays,
  cast( '' as abap.char( 30 )) AS MaximumDelayInDaysText,
  I_MRPProductionDemand.MaximumDelayInWorkdays AS MaximumDelayInWorkdays,
  cast( '' as abap.char( 30 )) AS MaximumDelayInWorkDaysText,
  I_MRPProductionDemand.StorageLocation AS StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  I_MRPProductionDemand.PlantName AS PlantName,
  I_MRPProductionDemand.OrderType AS OrderType,
  I_MRPProductionDemand._OrderTypeText.OrderTypeName AS OrderTypeName,
  I_MRPProductionDemand.MRPControllerName AS MRPControllerName,
  I_MRPProductionDemand.MRPAreaText AS MRPAreaText,
  I_MRPProductionDemand.MRPType AS MRPType,
  _MRPTypeText.MRPTypeName AS MRPTypeName,
  case when I_MRPProductionDemand.SourceMRPElementItem is initial then cast ( ltrim ( I_MRPProductionDemand.SourceMRPElement, '0' ) as abap.char( 18 ) ) else cast ( concat( ltrim ( I_MRPProductionDemand.SourceMRPElement, '0' ), concat( '-', ltrim ( I_MRPProductionDemand.SourceMRPElementItem, '0' ) ) ) as abap.char( 18 ) ) end as SourceOrderName AS char18endasSourceOrderName,
  I_MRPProductionDemand.MRPElementOpenQuantity AS MRPElementOpenQuantity,
  I_MRPProductionDemand.MRPElementUncoveredQuantity AS MRPElementUncoveredQuantity,
  I_MRPProductionDemand.MRPElementDelayedQuantity AS MRPElementDelayedQuantity,
  I_MRPProductionDemand.OrderQuantity AS OrderQuantity,
  I_MRPProductionDemand.MRPElementOpenQuantity - I_MRPProductionDemand.MRPElementUncoveredQuantity - I_MRPProductionDemand.MRPElementDelayedQuantity AS MRPElementCoveredQuantity,
  cast ( case when I_MRPProductionDemand.OrderQuantity - I_MRPProductionDemand.MRPElementOpenQuantity > 0 then I_MRPProductionDemand.OrderQuantity - I_MRPProductionDemand.MRPElementOpenQuantity else 0 end as abap.dec( 20, 3 ) ) as MRPElementIssuedQuantity AS dec203asMRPElementIssuedQuantity,
  cast( '%' as abap.unit( 3 ) ) AS UnitUoM,
  I_MRPProductionDemand.HasShortageTotalReplnmtLead AS HasShortageTotalReplnmtLead,
  I_MRPProductionDemand.HasShortageManualPlanHorizon AS HasShortageManualPlanHorizon,
  I_MRPProductionDemand.HasShortageMRPSafetyDuration AS HasShortageMRPSafetyDuration,
  I_MRPProductionDemand.ProducedMaterial AS SourceMaterial,
  I_MRPProductionDemand._ProducedMaterialText.MaterialName AS ProducedMaterialName,
  I_MRPProductionDemand.ProductionSupervisor AS ProductionSupervisor,
  I_MRPProductionDemand.ProductionSupervisorName AS ProductionSupervisorName,
  I_MRPProductionDemand.ProductionVersion AS ProductionVersion,
  I_MRPProductionDemand.ProductionVersionText AS ProductionVersionText,
  I_MRPProductionDemand.ProductionLine AS ProductionLine,
  _WorkCenterTextBySemanticKey.WorkCenterText AS WorkCenterText,
  I_MRPProductionDemand.ProductionPlant AS ProductionPlant,
  I_MRPProductionDemand.ProcurementProgress AS ProcurementProgress,
  _ProcurementProgressText.ProcurementProgressDesc AS ProcurementProgressDesc,
  _LastMRPRun.MaterialLastMRPDateTime AS MaterialLastMRPDateTime,
  cast( 0 as int2 ) AS MRPCoverageStatusCode,
  cast( '' as char25 ) AS MRPCoverageStatusName,
  cast( '' as abap_boolean preserving type ) AS UICT_ShortageDefinitionAssign,
  cast( 'X' as abap_boolean preserving type ) AS UICT_BufferUpdateIndicator,
  cast( 0 as abap.int2 ) AS TimeTillShortageFilterId,
  cast( '' as abap.char( 50 ) ) AS TimeTillShortageFilterText,
  cast( '' as matnr ) AS UICT_BufferMaterial,
  _MRPMaterial.LotSizingProcedure AS LotSizingProcedure,
  _MRPMaterial.MaterialLotSizingProcedureName AS MaterialLotSizingProcedureName
FROM I_MRPProductionDemand
INNER JOIN I_MaterialShortageDefinition AS _MaterialShortageDef ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MRPProductionDemandDelay AS _WorkingDaysCount ON MRPPlant = _WorkingDaysCount.MRPPlant AND MRPArea = _WorkingDaysCount.MRPArea AND Material = _WorkingDaysCount.Material AND MRPPlanningSegment = _WorkingDaysCount.MRPPlanningSegment AND MRPPlanningSegmentType = _WorkingDaysCount.MRPPlanningSegmentType AND MaterialShortageProfile = _WorkingDaysCount.MaterialShortageProfile AND MaterialShortageProfileCount = _WorkingDaysCount.MaterialShortageProfileCount AND MRPElement = _WorkingDaysCount.MRPElement AND MRPElementItem = _WorkingDaysCount.MRPElementItem AND MRPElementScheduleLine = _WorkingDaysCount.MRPElementScheduleLine AND MRPElementCategory = _WorkingDaysCount.MRPElementCategory AND MRPElementAvailyOrRqmtDate = _WorkingDaysCount.MRPElementAvailyOrRqmtDate  -- association [0..1]
LEFT OUTER JOIN C_MRPExtRqmtMaterialOverview AS _MaterialOverview ON MRPPlant = _MaterialOverview.MRPPlant AND MRPArea = _MaterialOverview.MRPArea AND Material = _MaterialOverview.Material AND MRPPlanningSegment = _MaterialOverview.MRPPlanningSegment AND MRPPlanningSegmentType = _MaterialOverview.MRPPlanningSegmentType AND MaterialShortageProfile = _MaterialOverview.MaterialShortageProfile AND MaterialShortageProfileCount = _MaterialOverview.MaterialShortageProfileCount  -- association [0..1]
LEFT OUTER JOIN C_ProcurementProgressTextVH AS _ProcurementProgressText ON ProcurementProgress = _ProcurementProgressText.ProcurementProgress AND _ProcurementProgressText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND MRPPlant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterTextBySemanticKey AS _WorkCenterTextBySemanticKey ON ProductionLine = _WorkCenterTextBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterTextBySemanticKey.Plant AND _WorkCenterTextBySemanticKey.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_OrderBasic AS _OrderBasic ON I_MRPProductionDemand.SourceMRPElement = _OrderBasic.OrderID  -- association [0..1]
LEFT OUTER JOIN I_MRPTypeText AS _MRPTypeText ON MRPType = _MRPTypeText.MRPType AND _MRPTypeText.Language = $session.system_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]
LEFT OUTER JOIN I_MRPMaterial AS _MRPMaterial ON MRPPlant = _MRPMaterial.MRPPlant AND Material = _MRPMaterial.Material AND MRPArea = _MRPMaterial.MRPArea  -- association [1..1]
;