C_MaintenanceJobWorkItem

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_MaintenanceJobWorkItem.
-- 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: CMAINTJOBWRKITM

CREATE VIEW C_MaintenanceJobWorkItem AS
SELECT
  cast(_Operation.MaintenanceOrderOperation as maintenanceorderoperation preserving type) AS MaintenanceOrderOperation,
  cast( _Operation.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) AS MaintenanceOrderSubOperation,
  MaintOrdOpProcessSubPhaseCode,
  _Operation._OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _Operation._OperationPlanningValues.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  dats_tims_to_tstmp( _Operation._OperationPlanningValues.OpErlstSchedldExecStrtDte, _Operation._OperationPlanningValues.OpErlstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as OpErlstSchedldExecStrtDteTme AS clientNULLasOpErlstSchedldExecStrtDteTme,
  _Operation._OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _Operation._OperationPlanningValues.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  dats_tims_to_tstmp( _Operation._OperationPlanningValues.OpErlstSchedldExecEndDte, _Operation._OperationPlanningValues.OpErlstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as OpErlstSchedldExecEndDteTme AS clientNULLasOpErlstSchedldExecEndDteTme,
  _Operation._OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _Operation._OperationPlanningValues.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  dats_tims_to_tstmp( _Operation._OperationPlanningValues.OpLtstSchedldExecStrtDte, _Operation._OperationPlanningValues.OpLtstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as OpLtstSchedldExecStrtDteTme AS clientNULLasOpLtstSchedldExecStrtDteTme,
  _Operation._OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _Operation._OperationPlanningValues.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  dats_tims_to_tstmp( _Operation._OperationPlanningValues.OpLtstSchedldExecEndDte, _Operation._OperationPlanningValues.OpLtstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as OpLtstSchedldExecEndDteTme AS clientNULLasOpLtstSchedldExecEndDteTme,
  _Operation._OperationPlanningValues.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  _OperationPlanningValues.ForecastedWorkQty - _OperationPlanningValues.ConfirmationTotalQuantity AS RemainingWorkQuantity,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  _Order._MaintenanceNotification.NotificationText AS NotificationText,
  cast( '' as xfeld ) AS UserIsPersonResponsible,
  _Operation._OperationControlKey.ConfirmationIsNotPossible AS ConfirmationIsNotPossible,
  _Operation._OperationControlKey.OperationIsProcessedInternally AS OperationIsProcessedInternally,
  _Operation._WorkCenter.WorkCenter AS OperationWorkCenter,
  _Operation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _Operation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  cast( case when _Order._StatusObjectStatus[ StatusCode = 'I3350' and StatusIsInactive = '' ].StatusObject is not null then 'F2023' else '' end as pm_source_appl) AS MaintOrderSourceApplication,
  cast( '' as eams_ui_myself_myteam ) AS MaintenanceJobSelection,
  _Operation._MaintenanceOrder._MaintenancePriority.MaintPriorityColorCode AS MaintPriorityColorCode,
  _Operation._MaintenanceOrder._MaintenancePriority.MaintPriority AS MaintPriority,
  _Operation._MaintenanceOrder._MaintenancePriority._Text [1:Language=$session.system_language].MaintPriorityDesc AS MaintPriorityDesc,
  _Order._MaintenanceNotification.MaintPriorityType AS MaintPriorityType,
  _Order._MaintenanceNotification._PMNotificationPriorityType._Text[1:Language=$session.system_language].MaintPriorityTypeDesc AS MaintPriorityTypeDesc,
  cast( 'X' as xfeld ) AS IsActiveEntity,
  cast( hextobin('00000000000000000000000000000000') as sysuuid_x ) AS DraftUUID,
  _Order._TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  _Order._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  _Order._FunctionalLocation._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  _Operation.MaintenanceOrder AS MaintenanceOrder,
  _Operation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  _Operation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _Operation.CapacityRequirement AS CapacityRequirement,
  _Operation.OperationDescription AS OperationDescription,
  _Operation.OperationPersonResponsible AS OperationPersonResponsible,
  _Operation.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _Operation.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  _Operation.Plant AS Plant,
  _Operation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  _Operation._MaintenanceOrder AS _MaintenanceOrder,
  _Operation._WorkCenter AS _WorkCenter,
  _Operation._PersonResponsible AS _PersonResponsible,
  _OperationPlanningValues._PlannedWorkUnitOfMeasure AS _PlannedWorkUnitOfMeasure,
  _Order.MaintenanceOrderType AS MaintenanceOrderType,
  _Order.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  _Order.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  _Order.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _Order.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _Order.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _Order.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  _Order.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _Order.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  _Order.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _Order.MaintenanceNotification AS MaintenanceNotification,
  _Order.TechnicalObject AS TechnicalObject,
  _Order.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _Order.Equipment AS Equipment,
  _Order._StatusObjectStatus AS _StatusObjectStatus,
  _Order._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  _PersonWorkAgreement.PersonFullName AS OperationPersonRespName
FROM I_MaintOrderOperAndSubOper AS _Operation
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _IsDeletedStatus ON _IsDeletedStatus.StatusCode = 'I0013' AND _IsDeletedStatus.StatusObject = _Operation.MaintOrderOperationInternalID AND _IsDeletedStatus.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTechObj AS _Order ON _Order.MaintenanceOrder = _Operation.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN C_Malfunctionreport AS _MalfunctionReport ON _MalfunctionReport.MaintenanceNotification = maintenancenotification  -- association [1..1]
LEFT OUTER JOIN I_PMContactCardEmployee AS _OperationPersonResponsible ON OperationPersonResponsible = _OperationPersonResponsible.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceJobSelection AS _MaintenanceJobSelection ON _MaintenanceJobSelection.MaintenanceJobSelection = MaintenanceJobSelection  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON _WorkCenterText.WorkCenterInternalID = OperationWorkCenterInternalID AND _WorkCenterText.WorkCenterTypeCode = 'A'  -- association [0..*]
LEFT OUTER JOIN C_PMWorkCenterVH AS _WorkCenterVH ON OperationWorkCenter = _WorkCenterVH.WorkCenter AND Plant = _WorkCenterVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectForEditVH AS _TechnicalObjectVH ON _TechnicalObjectVH.TechnicalObject = technicalobject AND _TechnicalObjectVH.TechObjIsEquipOrFuncnlLoc = techobjisequiporfuncnlloc AND _TechnicalObjectVH.TechnicalObjectLabel = technicalobjectlabel  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderQuickVw AS _MaintOrderQuickView ON MaintenanceOrder = _MaintOrderQuickView.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN C_ObjPgMaintOrderConfirmation AS _OrderConfirmation ON _OrderConfirmation.MaintenanceOrder = MaintenanceOrder AND _OrderConfirmation.MaintenanceOrderOperation = MaintenanceOrderOperation AND _OrderConfirmation.MaintenanceOrderSubOperation = MaintenanceOrderSubOperation  -- association [0..*]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocT ON _TechObjIsEquipOrFuncnlLocT.TechObjIsEquipOrFuncnlLoc = techobjisequiporfuncnlloc  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessPhase AS _EAMProcessPhase ON MaintOrdOpProcessPhaseCode = _EAMProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _EAMProcessSubPhase ON MaintOrdOpProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _MaintOrderOpIsInProcess ON _MaintOrderOpIsInProcess.IndicatorValue = MaintOrderOperationIsInProcess  -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..*]
LEFT OUTER JOIN C_MaintOrderTypeVH AS _MaintOrderTypeVH ON _MaintOrderTypeVH.MaintenanceOrderType = maintenanceordertype  -- association [0..1]
LEFT OUTER JOIN C_MaintOrdOperationQuickVw AS _QuickView ON _QuickView.MaintenanceOrder = MaintenanceOrder AND _QuickView.MaintenanceOrderOperation = MaintenanceOrderOperation AND _QuickView.MaintenanceOrderSubOperation = MaintenanceOrderSubOperation  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _OpStatusObjectStatus ON MaintOrderOperationInternalID = _OpStatusObjectStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _IsFinallyConfirmed ON IsFinallyConfirmed = _IsFinallyConfirmed.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON OperationPersonResponsible = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
;