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,
  cast( _ProjectRespPersn.PersonWorkAgreement as ps_s4_vernr preserving type ) AS ResponsiblePerson,
  _ProjectRespPersn._WorkforcePerson.PersonFullName AS ResponsiblePersonName,
  cast( _ProjectRespPersn.PersonWorkAgreement as ps_s4_vernr preserving type ) AS ProjectResponsiblePerson,
  _ProjectRespPersn._WorkforcePerson.PersonFullName AS ProjectResponsiblePersonName,
  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,
  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_EntProjectResponsiblePerson AS _ProjectRespPersn ON WBSElementInternalID = _ProjectRespPersn.WBSElementInternalID AND _ProjectRespPersn.WBSElementInternalID is not initial  -- 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
;