I_MRPOrderComponent

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_MRPOrderComponent.
-- 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: IMRPORDERCOMP

CREATE VIEW I_MRPOrderComponent AS
SELECT
  I_MRPManufacturingComponent.Reservation AS Reservation,
  I_MRPManufacturingComponent.ReservationItem AS ReservationItem,
  I_MRPManufacturingComponent.RecordType AS RecordType,
  I_MRPManufacturingComponent.RequirementType AS RequirementType,
  I_MRPManufacturingComponent.Material AS Material,
  I_MRPManufacturingComponent.MaterialName AS MaterialName,
  I_MRPManufacturingComponent.MRPPlant AS MRPPlant,
  I_MRPManufacturingComponent.SupplyingPlant AS SupplyingPlant,
  I_MRPManufacturingComponent.RequirementDate AS RequirementDate,
  I_MRPManufacturingComponent.BaseUnit AS BaseUnit,
  I_MRPManufacturingComponent.Supplier AS Supplier,
  I_MRPManufacturingComponent.PurchasingGroup AS PurchasingGroup,
  I_MRPManufacturingComponent.MaterialProcurementCategory AS MaterialProcurementCategory,
  I_MRPManufacturingComponent.MaterialProcurementType AS MaterialProcurementType,
  I_MRPManufacturingComponent.ManufacturingOrder AS ManufacturingOrder,
  I_MRPManufacturingComponent.ManufacturingOrderCategory AS OrderCategory,
  I_MRPManufacturingComponent.ManufacturingOrderType AS OrderType,
  _MfgOrderTypeText[1: Language = $session.system_language ].ManufacturingOrderTypeName AS OrderTypeName,
  I_MRPManufacturingComponent.ManufacturingOrderImportance AS PriorityCode,
  I_MRPManufacturingComponent.PlannedOrder AS PlannedOrder,
  I_MRPManufacturingComponent.ProductionPlant AS ProductionPlant,
  I_MRPManufacturingComponent.MRPController AS MRPController,
  I_MRPManufacturingComponent.MRPControllerName AS MRPControllerName,
  I_MRPManufacturingComponent.MRPControllerPhoneNumber AS MRPControllerPhoneNumber,
  I_MRPManufacturingComponent.EmailAddress AS EmailAddress,
  I_MRPManufacturingComponent.ProductionSupervisor AS ProductionSupervisor,
  I_MRPManufacturingComponent.ProductionVersion AS ProductionVersion,
  I_MRPManufacturingComponent.ProductionVersionText AS ProductionVersionText,
  I_MRPManufacturingComponent.ProductionLine AS ProductionLine,
  I_MRPManufacturingComponent.InventorySpecialStockType AS InventorySpecialStockType,
  I_MRPManufacturingComponent.OrderedQuantity AS OrderedQuantity,
  I_MRPManufacturingComponent.WithdrawnQuantity AS WithdrawnQuantity,
  I_MRPManufacturingComponent.OpenQuantity AS OpenQuantity,
  I_MRPManufacturingComponent.CommittedQuantity AS CommittedQuantity,
  I_MRPManufacturingComponent.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  I_MRPManufacturingComponent.OrderPlannedScrapQty AS OrderPlannedScrapQty,
  I_MRPManufacturingComponent.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  I_MRPManufacturingComponent.GoodsReceiptQty AS GoodsReceiptQty,
  I_MRPManufacturingComponent.PlannedStartDate AS PlannedStartDate,
  I_MRPManufacturingComponent.OrderPlannedEndDate AS OrderPlannedEndDate,
  I_MRPManufacturingComponent.ActualStartDate AS ActualStartDate,
  I_MRPManufacturingComponent.ActualEndDate AS ActualEndDate,
  I_MRPManufacturingComponent.ActualReleasedDate AS ActualReleasedDate,
  I_MRPManufacturingComponent.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  I_MRPManufacturingComponent.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  I_MRPManufacturingComponent.ScheduledReleaseDate AS ScheduledReleaseDate,
  I_MRPManufacturingComponent.TopLevelOrder AS TopLevelOrder,
  I_MRPManufacturingComponent.TopLevelOrderMaterial AS TopLevelOrderMaterial,
  I_MRPManufacturingComponent.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  I_MRPManufacturingComponent.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  I_MRPManufacturingComponent.MaterialPlannedProductionDurn AS MaterialPlannedProductionDurn,
  I_MRPManufacturingComponent.MaterialReplenishmentLeadDurn AS MaterialReplenishmentLeadDurn,
  I_MRPManufacturingComponent.SalesOrder AS SalesOrder,
  I_MRPManufacturingComponent.SalesOrderItem AS SalesOrderItem,
  I_MRPManufacturingComponent.SalesOrderType AS SalesOrderType,
  I_MRPManufacturingComponent.SalesOrderItemMaterial AS SalesOrderItemMaterial,
  I_MRPManufacturingComponent.Customer AS Customer,
  I_MRPManufacturingComponent.WBSElementInternalID AS WBSElementInternalID,
  I_MRPManufacturingComponent.WBSElement AS WBSElement,
  I_MRPManufacturingComponent.WBSDescription AS WBSDescription,
  I_MRPManufacturingComponent.ProjectInternalID AS ProjectInternalID,
  I_MRPManufacturingComponent.ProjectDescription AS ProjectDescription,
  I_MRPManufacturingComponent.Project AS Project,
  I_MRPManufacturingComponent.TotalReplenishmentLeadDuration AS TotalReplenishmentLeadDuration,
  I_MRPManufacturingComponent.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  I_MRPManufacturingComponent.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  I_MRPManufacturingComponent.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  I_MRPManufacturingComponent.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  I_MRPManufacturingComponent.RoundingProfile AS RoundingProfile,
  '' AS MaintPriorityType,
  '0000' AS MaintenancePlanningPlant,
  '' AS MaintenancePlannerGroup,
  '' AS MaintenanceRevision,
  '' AS MaintenancePlan,
  '' AS MaintenanceNotification,
  '' AS MaintenanceWorkCenter,
  '0000' AS MaintenanceWorkCenterPlant,
  '' AS ActivityType,
  '00000000' AS ResponsiblePerson,
  '' AS ResponsiblePersonName,
  I_MaintenanceOrderComponent_2._MaintenanceOrder._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName
FROM I_MRPManufacturingComponent
LEFT OUTER JOIN I_MfgOrderTypeText AS _MfgOrderTypeText ON OrderType = _MfgOrderTypeText.ManufacturingOrderType  -- association [0..*]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND MRPPlant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND MRPPlant = _ProductSupplyPlanning.Plant  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MaintenanceOrderComponent_2
;