C_MaintOrdCompPurReqItem

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_MaintOrdCompPurReqItem.
-- 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: CMTORDPURREQI

CREATE VIEW C_MaintOrdCompPurReqItem AS
SELECT
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaintenanceOrder,
  MaintenanceOrderDesc,
  MaintenanceOrderType,
  MaintOrderRoutingNumber,
  MaintenanceOrderOperation,
  OperationDescription,
  MaintOrderOperationCounter,
  cast( ' ' as abap.char(4) ) AS MaintenanceOrderSubOperation,
  Reservation,
  ReservationItem,
  ReferenceDate,
  MaintOrdBasicStartDate,
  OpErlstSchedldExecStrtDte,
  RequirementDate,
  MaintPriority,
  MaintPriorityType,
  _GenericPriority.GenericPriorityColorCode AS MaintPriorityColorCode,
  _GenericPriorityText.GenericPriorityDesc AS MaintPriorityDesc,
  MaintenanceRevision,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  MaintenancePlant,
  MainWorkCenter,
  MainWorkCenterPlant,
  _MaintenanceOrder.WorkCenterTypeCode AS WorkCenterTypeCode,
  PurchaseOrder,
  cast( PurchaseOrderItem as vdm_purchaseorderitem preserving type ) AS PurchaseOrderItem,
  Material,
  PurchasingGroup,
  PurchaseRequisitionItemText AS MaterialName,
  concat( '/sap/opu/odata/sap/EAM_ORDER_MONITOR/' , concat( concat( 'MaterialThumbnail(''', _PurchaseRequisitionItem.Material ), ''')/$value') ) AS MaterialThumbnailURL,
  PurReqnReleaseStatus,
  RequestedQuantity,
  BaseUnit,
  PurchaseRequisitionPrice,
  PurReqnItemCurrency,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  PreferredSupplier,
  _PreferredSupplier.SupplierName AS PreferredSupplierName,
  cast( MaintOrdProcmtMlstnDateTime as maintordprocmtactivityduedate preserving type ) AS MaintOrdProcmtMlstnDateTime,
  cast( hextobin('00000000000000000000000000000000') as maintplanningbucketuuid ) AS MaintPlanningBucketUUID,
  PlantSection,
  WorkCenterInternalID,
  Equipment,
  FunctionalLocation,
  MaintObjectLocAcctAssgmtNmbr,
  OperationIsProcessedExternally
FROM I_MaintOrdCompPurRequisitionC
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTP AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrderVH ON _MaintenanceOrderVH.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN C_PMWorkCenterVH AS _PMWorkCenterVH ON _PMWorkCenterVH.WorkCenter = MainWorkCenter AND _PMWorkCenterVH.Plant = MainWorkCenterPlant  -- association [0..1]
LEFT OUTER JOIN C_MaintenancePlannerGroupVH AS _MaintenancePlannerGroupVH ON _MaintenancePlannerGroupVH.MaintenancePlannerGroup = MaintenancePlannerGroup AND _MaintenancePlannerGroupVH.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN C_PurchaseDocumentStatusVH AS _PurReqStatusVH ON _PurReqStatusVH.PurReqnReleaseStatus = PurReqnReleaseStatus AND _PurReqStatusVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PMNotificationPriority AS _MaintenancePriorityVH ON _MaintenancePriorityVH.MaintPriorityType = MaintPriorityType AND _MaintenancePriorityVH.MaintPriority = MaintPriority  -- association [0..1]
LEFT OUTER JOIN I_GenericPriority AS _GenericPriority ON _GenericPriority.GenericPriorityType = MaintPriorityType AND _GenericPriority.PriorityCode = MaintPriority  -- association [0..1]
LEFT OUTER JOIN I_GenericPriorityText AS _GenericPriorityText ON _GenericPriorityText.GenericPriorityType = MaintPriorityType AND _GenericPriorityText.PriorityCode = MaintPriority AND _GenericPriorityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SuplrContactCard AS _SupplierContactCard ON _SupplierContactCard.ContactCardID = Supplier  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchaseGroupVH ON _PurchaseGroupVH.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PreferredSupplier ON PreferredSupplier = _PreferredSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaintPlanningBucketVH AS _PlanningBucket ON MaintPlanningBucketUUID = MaintPlanningBucketUUID  -- association [0..1]
LEFT OUTER JOIN I_MaintProcurementMilestoneTxt AS _ProcurementMilestoneText ON MaintProcurementMilestone = _ProcurementMilestoneText.MaintProcurementMilestone  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant  -- association [0..1]
;