C_MaintOrderTP

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_MaintOrderTP.
-- 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: CMAINTORDTP

CREATE VIEW C_MaintOrderTP AS
SELECT
  _MaintOrderTP.MaintenanceOrder AS MaintenanceOrder,
  _MaintOrderTP.MaintenanceOrderForEdit AS MaintenanceOrderForEdit,
  _MaintOrderTP.TechnicalObject AS TechnicalObject,
  _MaintOrderTP.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _MaintOrderTP.MaintPriorityType AS MaintPriorityType,
  _MaintOrderTP.MaintPriority AS MaintPriority,
  _MaintOrderTP.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  _MaintOrderTP.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _MaintOrderTP.MaintenanceNotification AS MaintenanceNotification,
  _MaintOrderTP.Equipment AS Equipment,
  _MaintOrderTP.FunctionalLocation AS FunctionalLocation,
  _MaintOrderTP.MaintenanceItem AS MaintenanceItem,
  _MaintOrderTP.Assembly AS Assembly,
  _MaintOrderTP.SerialNumber AS SerialNumber,
  _MaintOrderTP.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintOrderTP.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintOrderTP.OperationSystemCondition AS OperationSystemCondition,
  _MaintOrderTP.MaintenanceRevision AS MaintenanceRevision,
  _MaintOrderTP.MaintenancePlan AS MaintenancePlan,
  _MaintOrderTP.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _MaintOrderTP.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintOrderTP.MaintenanceOrderCategory AS MaintenanceOrderCategory,
  _MaintOrderTP.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintOrderTP.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  _MaintOrderTP.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  _MaintOrderTP.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _MaintOrderTP.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _MaintOrderTP.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _MaintOrderTP.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  _MaintOrderTP.AuthorizationGroup AS AuthorizationGroup,
  _MaintOrderTP.MaintenancePlant AS MaintenancePlant,
  _MaintOrderTP.ControllingArea AS ControllingArea,
  _MaintOrderTP.MaintenanceActivityType AS MaintenanceActivityType,
  _MaintOrderTP.ResponsibleCostCenter AS ResponsibleCostCenter,
  _MaintOrderTP.MaintOrderSourceApplication AS MaintOrderSourceApplication,
  _MaintOrderTP.MaintOrdPersonResponsible AS MaintOrdPersonResponsible,
  _MaintOrderTP.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  _MaintOrderTP._EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS EAMProcessPhaseCodeDesc,
  _MaintOrderTP.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  _MaintOrderTP._EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS EAMProcessSubPhaseCodeDesc,
  _WorkCenter.WorkCenter AS WorkCenter,
  cast( '' as herst ) AS AssetManufacturerName,
  cast( '' as eams_tec_obj_des ) AS TechnicalObjectDescription,
  _MaintOrderTP.CreatedByUser AS CreatedByUser,
  _PMContactCardUser.FullName AS FullName,
  _MaintOrderTP.CreationDate AS CreationDate,
  _MaintOrderTP._Equipment AS _Equipment,
  _MaintOrderTP._LocationAccountAssignment AS _LocationAccountAssignment,
  _MaintOrderTP._MaintenanceNotification AS _MaintenanceNotification,
  _MaintOrderTP._MaintenanceOrderPhase AS _MaintenanceOrderPhase,
  _MaintOrderTP._MaintenancePlan AS _MaintenancePlan,
  _MaintOrderTP._MaintenancePriority AS _MaintenancePriority,
  _MaintOrderTP._MaintenancePriorityType AS _MaintenancePriorityType,
  _MaintOrderTP._Order AS _Order,
  _MaintOrderTP._OperationSystemCondition AS _OperationSystemCondition,
  _MaintOrderTP._TechnicalObject AS _TechnicalObject,
  _MaintOrderTP._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  _MaintOrderTP._MaintenanceActivityType AS _MaintenanceActivityType,
  _MaintOrderTP._Assembly AS _Assembly,
  _MaintOrderTP._MaintenanceOrderCategory AS _MaintenanceOrderCategory,
  _MaintOrderTP._MaintenanceOrderType AS _MaintenanceOrderType,
  _MaintOrderTP._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
  _MaintOrderTP._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  _MaintOrderTP._MaintenanceRevision AS _MaintenanceRevision,
  _MaintOrderTP._StatusObject AS _StatusObject,
  _MaintOrderTP._StatusObjectStatus AS _StatusObjectStatus,
  _MaintOrderTP._MaintOrdPersonResponsible AS _MaintOrdPersonResponsible,
  _MaintOrderTP.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintOrderTP.WorkCenterTypeCode AS WorkCenterTypeCode,
  _MaintOrderTP._EAMProcessPhase AS _EAMProcessPhase,
  _MaintOrderTP._EAMProcessSubPhase AS _EAMProcessSubPhase
FROM I_MaintOrderTP AS _MaintOrderTP
LEFT OUTER JOIN C_MaintOrderOperationTP AS _MaintOrderOperationTP ON MaintenanceOrder = _MaintOrderOperationTP.MaintenanceOrder  -- association [0..*]
LEFT OUTER JOIN I_MaintOrderPlantDefaults AS _PlanningPlantDefaults ON MaintenancePlanningPlant = _PlanningPlantDefaults.Plant  -- association [0..1]
LEFT OUTER JOIN C_MaintenanceJobWorkItem AS _MaintenanceJobWorkItem ON MaintenanceOrder = _MaintenanceJobWorkItem.MaintenanceOrder  -- association [0..*]
LEFT OUTER JOIN I_GenericPriorityText AS _PriorityText ON _PriorityText.GenericPriorityType = MaintPriorityType AND _PriorityText.PriorityCode = MaintPriority  -- association [0..*]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode  -- association [0..*]
LEFT OUTER JOIN I_OrderTypeText AS _OrderTypeText ON _OrderTypeText.OrderType = MaintenanceOrderType  -- association [0..*]
LEFT OUTER JOIN I_PMContactCardUser AS _PMContactCardUser ON _PMContactCardUser.UserID = CreatedByUser  -- association [0..1]
;