C_MRPMaintenanceOrderComponent

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_MRPMaintenanceOrderComponent.
-- 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: CMRPMAINTORDCOMP

CREATE VIEW C_MRPMaintenanceOrderComponent AS
SELECT
  Reservation,
  ReservationItem,
  ReservationType AS RecordType,
  'AR' AS RequirementType,
  Material,
  _Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
  Plant AS MRPPlant,
  RequirementDate,
  BaseUnit,
  _MaintenanceOrderOperation.PurchasingGroup AS PurchasingGroup,
  _ProductPlant.ProcurementType AS MaterialProcurementCategory,
  _ProductPlant.SpecialProcurementType AS MaterialProcurementType,
  MaintenanceOrder AS ManufacturingOrder,
  _MaintenanceOrder.MaintenanceOrderCategory AS OrderCategory,
  _MaintenanceOrder.MaintenanceOrderType AS OrderType,
  _MaintenanceOrder._MaintenanceOrderType._Text[1: Language = $session.system_language ].OrderTypeName AS OrderTypeName,
  _MaintenanceOrder.MaintPriority AS PriorityCode,
  RequirementQuantityInBaseUnit AS OrderedQuantity,
  QuantityWithdrawnInBaseUnit AS WithdrawnQuantity,
  RequirementQuantityInBaseUnit - QuantityWithdrawnInBaseUnit AS OpenQuantity,
  0 AS CommittedQuantity,
  _MaintenanceOrderOperation._OperationPlanningValues.ConfirmationTotalQuantity AS OrderPlannedTotalQty,
  0 AS OrderPlannedScrapQty,
  0 AS ExpectedDeviationQuantity,
  0 AS GoodsReceiptQty,
  _MaintenanceOrder.MaintOrdBasicStartDate AS PlannedStartDate,
  _MaintenanceOrder.MaintOrdBasicEndDate AS OrderPlannedEndDate,
  _MaintenanceOrder.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  _MaintenanceOrder.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionStartDate AS ActualStartDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpActualExecutionEndDate AS ActualEndDate,
  '00000000' AS ActualReleasedDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtDte AS ScheduledBasicStartDate,
  _MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndDte AS ScheduledBasicEndDate,
  '00000000' AS ScheduledReleaseDate,
  '' AS TopLevelOrder,
  '' AS TopLevelOrderMaterial,
  0 AS MaterialGoodsReceiptDuration,
  0 AS MaterialPlannedDeliveryDurn,
  0 AS MaterialPlannedProductionDurn,
  0 AS MaterialReplenishmentLeadDurn,
  '' AS SalesOrder,
  '000000' AS SalesOrderItem,
  '' AS SalesOrderType,
  '' AS SalesOrderItemMaterial,
  '' AS Customer,
  '00000000' AS WBSElementInternalID,
  '' AS WBSElement,
  '' AS WBSDescription,
  '00000000' AS ResponsiblePerson,
  '' AS ResponsiblePersonName,
  '00000000' AS ProjectInternalID,
  '' AS ProjectDescription,
  '' AS Project,
  _ProductSupplyPlanning.TotalReplenishmentLeadTime AS TotalReplenishmentLeadDuration,
  _ProductSupplyPlanning.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  _ProductSupplyPlanning.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _ProductSupplyPlanning.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _ProductSupplyPlanning.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  _ProductSupplyPlanning.RoundingProfile AS RoundingProfile,
  _MaintenanceOrder.MaintPriority AS MaintPriorityType,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  _MaintenanceOrder.MaintenancePlan AS MaintenancePlan,
  _MaintenanceOrder.MaintenanceNotification AS MaintenanceNotification,
  _MaintenanceOrder._MainWorkCenter.WorkCenter AS MaintenanceWorkCenter,
  _MaintenanceOrder._MainWorkCenter._Text[1: Language = $session.system_language ].WorkCenterText AS MaintenanceWorkCenterText,
  _MaintenanceOrder._MainWorkCenter.Plant AS MaintenanceWorkCenterPlant,
  _MaintenanceOrder.MaintenanceActivityType AS ActivityType,
  _MaintenanceOrder._MaintenanceActivityType._Text[1: Language = $session.system_language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  _MaintenanceOrder._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  case when _MaintenanceOrder._Order.ActualEndDate <> '00000000' then _StatusTextFin.StatusName else case when _MaintenanceOrder._Order.ActualStartDate <> '00000000' then _StatusTextProg.StatusName else case when _MaintenanceOrder._Order.ActualReleasedDate <> '00000000' then _StatusTextRel.StatusName else _StatusTextCrea.StatusName end end end as OrderStatusText AS StatusNameendendendasOrderStatusText,
  MaintenanceOrder,
  MaintenanceOrderOperation,
  MaintenanceOrderComponent,
  ComponentDescription,
  StorageLocation,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  MaintOrderComponentInternalID,
  MaintComponentItemCategory,
  MaterialGroup,
  IsDeleted,
  PurchaseRequisition,
  PurchaseRequisitionItem
FROM I_MaintenanceOrderComponent_2
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]
LEFT OUTER JOIN I_StatusCodeText AS _StatusTextRel ON _StatusTextRel.StatusCode = 'I0002' AND _StatusTextRel.Language = $session.system_language AND _StatusTextRel.StatusProfile = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusCodeText AS _StatusTextCrea ON _StatusTextCrea.StatusCode = 'I0001' AND _StatusTextCrea.Language = $session.system_language AND _StatusTextCrea.StatusProfile = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusCodeText AS _StatusTextFin ON _StatusTextFin.StatusCode = 'I1712' AND _StatusTextFin.Language = $session.system_language AND _StatusTextFin.StatusProfile = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusCodeText AS _StatusTextProg ON _StatusTextProg.StatusCode = 'IDGL2' AND _StatusTextProg.Language = $session.system_language AND _StatusTextProg.StatusProfile = ''  -- association [0..1]
;