C_MRPMaintenanceOrderCard

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_MRPMaintenanceOrderCard.
-- 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.
-- Parameters: P_SourceMRPElementItem : delps

CREATE VIEW C_MRPMaintenanceOrderCard AS
SELECT
  C_MRPMaintenanceOrderComponent.Reservation AS Reservation,
  C_MRPMaintenanceOrderComponent.ReservationItem AS ReservationItem,
  C_MRPMaintenanceOrderComponent.RecordType AS RecordType,
  C_MRPMaintenanceOrderComponent.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  C_MRPMaintenanceOrderComponent.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  C_MRPMaintenanceOrderComponent.MaintenanceWorkCenter AS MaintenanceWorkCenter,
  C_MRPMaintenanceOrderComponent.MaintenanceWorkCenterText AS MaintenanceWorkCenterText,
  C_MRPMaintenanceOrderComponent.RequirementDate AS RequirementDate,
  C_MRPMaintenanceOrderComponent.BaseUnit AS BaseUnit,
  C_MRPMaintenanceOrderComponent.Material AS Material,
  C_MRPMaintenanceOrderComponent.OrderedQuantity AS OrderedQuantity,
  C_MRPMaintenanceOrderComponent.WithdrawnQuantity AS WithdrawnQuantity,
  C_MRPMaintenanceOrderComponent.OpenQuantity AS OpenQuantity,
  C_MRPMaintenanceOrderComponent.MaintenanceOrder AS MaintenanceOrder,
  C_MRPMaintenanceOrderComponent.OrderType AS OrderType,
  C_MRPMaintenanceOrderComponent.OrderTypeName AS OrderTypeName,
  C_MRPMaintenanceOrderComponent.OrderStatusText AS OrderStatusText,
  C_MRPMaintenanceOrderComponent.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  C_MRPMaintenanceOrderComponent.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  C_MRPMaintenanceOrderComponent.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenancePlanningPlant.PlantName AS PlantName,
  C_MRPMaintenanceOrderComponent.ActivityType AS MaintenanceActivityType,
  C_MRPMaintenanceOrderComponent.MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  C_MRPMaintenanceOrderComponent.MaintenanceNotification AS MaintenanceNotification,
  _MaintenanceNotification.NotificationText AS NotificationText,
  C_MRPMaintenanceOrderComponent.MaintenanceRevision AS MaintenanceRevision,
  _MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceRevisionDesc,
  C_MRPMaintenanceOrderComponent.PriorityCode AS PriorityCode,
  cast ( case when maintenanceplannergroup is initial then 'X' else '' end as boolean preserving type ) AS UICT_PlannerGroup,
  cast ( case when maintenanceworkcenter is initial then 'X' else '' end as boolean preserving type ) AS UICT_WorkCenter,
  cast ( case when requirementdate is initial then 'X' else '' end as boolean preserving type ) AS UICT_RequirementDate,
  cast ( case when orderedquantity is initial then 'X' else '' end as boolean preserving type ) AS UICT_OrderQuantity,
  cast ( case when withdrawnquantity is initial then 'X' else '' end as boolean preserving type ) AS UICT_WithdrawnQuantity,
  cast ( case when openquantity is initial then 'X' else '' end as boolean preserving type ) AS UICT_OpenQuantity,
  cast ( case when ordertype is initial then 'X' else '' end as boolean preserving type ) AS UICT_OrderType,
  cast ( case when orderstatustext is initial then 'X' else '' end as boolean preserving type ) AS UICT_OrderStatus,
  cast ( case when maintordbasicstartdate is initial then 'X' else '' end as boolean preserving type ) AS UICT_BasicStartDate,
  cast ( case when maintordbasicenddate is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaintOrdBasicEndDate,
  cast ( case when maintenanceplanningplant is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaintenancePlanningPlant,
  cast ( case when maintenancenotification is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaintenanceNotification,
  cast ( case when maintenancerevision is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaintenanceRevision,
  cast ( case when MaintenanceActivityType is initial then 'X' else '' end as boolean preserving type ) AS UICT_MaintenanceActivityType,
  cast ( case when prioritycode is initial then 'X' else '' end as boolean preserving type ) AS UICT_PriorityCode,
  cast( concat( _MRPElementCategoryText.MRPElementCategoryShortName, concat( '-', ltrim ( maintenanceorder, '0' ) ) ) as char30 ) AS MRPAffectedOrder,
  _Reservation.Supplier AS Supplier
FROM C_MRPMaintenanceOrderComponent
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceRevision AS _MaintenanceRevision ON _MaintenanceRevision.MaintenanceRevision = MaintenanceRevision AND _MaintenanceRevision.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON MaintenanceNotification = _MaintenanceNotification.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _MRPElementCategoryText ON _MRPElementCategoryText.MRPElementCategory = 'IH' AND _MRPElementCategoryText.Language = $session.system_language  -- association [0..1]
;