C_ObjPgMaintOrderConfirmation

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_ObjPgMaintOrderConfirmation.
-- 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: COPMAINTORDCONF

CREATE VIEW C_ObjPgMaintOrderConfirmation AS
SELECT
  _MaintenanceOrder._Equipment._EquipmentText[Language = $session.system_language].EquipmentName AS EquipmentName,
  _MaintenanceOrder._FunctionalLocation._FunctionalLocationText[Language = $session.system_language].FunctionalLocationName AS FunctionalLocationName,
  cast('' as eams_person_responsible_name ) AS CreatedByUserDescription,
  cast('' as eams_person_responsible_name ) AS LastChangedByUserDescription,
  _MaintenanceOrder._Order._OrderType._Text[1:Language = $session.system_language].OrderTypeName AS MaintenanceOrderTypeName,
  _MaintenanceOrder._MaintenanceOrderPhase._Text[1:Language = $session.system_language].MaintenanceProcessingPhaseDesc AS MaintenanceProcessingPhaseDesc,
  _MaintOrderOperation._WorkCenter.WorkCenter AS PlannedWorkCenter,
  _MaintOrderOperation._WorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS PlannedWorkCenterDesc,
  _MaintOrderOperation._WorkCenter.WorkCenterInternalID AS PlannedWorkCenterInternalID,
  _MaintenanceOrderConfirmation._ActualWorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterDesc,
  _MaintOrderOperation._Plant.PlantName AS PlannedPlantName,
  _MaintenanceOrderConfirmation._Plant.PlantName AS PlantName,
  _MaintenanceOrder._MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  _MaintenanceOrder._MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  MaintOrdOpWrkExecStartDateTime,
  MaintOrdOpWrkExecEndDateTime,
  MaintOrdOpFcstdEndDateTime,
  _MaintenanceOrderConfirmation._VarianceReason._Text[1:Language = $session.system_language].VarianceReasonName AS VarianceReasonName,
  cast('' as eams_person_responsible_name) AS OperationPersonRespName,
  _MaintenanceOrder._TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  _MaintenanceOrder._TechnicalObject._TechnicalObjectText[1:Language=$session.system_language].TechnicalObjectDescription AS TechnicalObjectDescription,
  _MaintenanceOrder._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  _MaintOrderOperation._TechnicalObject.TechnicalObjectLabel AS OperationTechnicalObjectLabel,
  _MaintOrderOperation._TechnicalObject._TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS OperationTechnicalObjectDesc,
  _MaintOrderOperation._TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS OperationTechObjIsEquipDesc,
  _MaintOrderOperation._OperationPlanningValues.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  cast ( 0 as co_idauv) AS ActualDurationCalc,
  cast ('' as maueh) AS ActualDurationCalcUnit,
  _MaintOrderOperation._OperationPlanningValues.OpActualExecutionStartDate AS ActualStartDate,
  _MaintOrderOperation._OperationPlanningValues.OpActualExecutionStartTime AS ActualStartTime,
  _MaintOrderOperation._OperationPlanningValues.OpActualExecutionEndDate AS ActualEndDate,
  _MaintOrderOperation._OperationPlanningValues.OpActualExecutionEndTime AS ActualEndTime,
  dats_tims_to_tstmp( _MaintOrderOperation._OperationPlanningValues.OpActualExecutionEndDate, _MaintOrderOperation._OperationPlanningValues.OpActualExecutionEndTime, AddressTimeZone, $session.client, 'NULL' ) as OpActualExecutionEndDateTime AS clientNULLasOpActualExecutionEndDateTime,
  _MaintenanceOrder._TechnicalObject.TechnicalObject AS TechnicalObject,
  _MaintenanceOrder._TechnicalObject._FunctionalLocationLabel._FuncLocationLabelSearch[FunctionalLocLabelIsActive = 'X'].FunctionalLocationLabelName AS FunctionalLocationLabelName,
  concat( '/sap/opu/odata/sap/EAM_OBJPG_ORDERCONFIRMATION_SRV/', concat( concat( concat( 'MaintOrderConfirmationTypeImageSet(MaintOrderConf=''', MaintOrderConf ), ''', '), concat( concat( 'MaintOrderConfCntrValue=''', MaintOrderConfCntrValue), ''')/$value'))) AS MaintOrderConfThumbnailURL,
  _MaintenanceOrderConfirmation.MaintOrderConf AS MaintOrderConf,
  _MaintenanceOrderConfirmation.MaintOrderConfCntrValue AS MaintOrderConfCntrValue,
  _MaintenanceOrderConfirmation.MaintOrderConfForEdit AS MaintOrderConfForEdit,
  _MaintenanceOrderConfirmation.MaintOrderConfCntrValueForEdit AS MaintOrderConfCntrValueForEdit,
  _MaintenanceOrderConfirmation.PostingDate AS PostingDate,
  _MaintenanceOrderConfirmation.EnteredByUser AS EnteredByUser,
  _MaintenanceOrderConfirmation.LastChangedByUser AS LastChangedByUser,
  _MaintenanceOrderConfirmation.MaintenanceOrder AS MaintenanceOrder,
  _MaintenanceOrderConfirmation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  _MaintenanceOrderConfirmation.ConfirmationText AS ConfirmationText,
  _MaintenanceOrderConfirmation.IsFinalConfirmation AS IsFinalConfirmation,
  _MaintenanceOrderConfirmation.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  _MaintenanceOrderConfirmation.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  _MaintenanceOrderConfirmation.WorkCenterInternalID AS WorkCenterInternalID,
  _MaintenanceOrderConfirmation.Plant AS Plant,
  _MaintenanceOrderConfirmation.PlantTimeZone AS PlantTimeZone,
  _MaintenanceOrderConfirmation.AddressTimeZone AS AddressTimeZone,
  _MaintenanceOrderConfirmation.ActivityType AS ActivityType,
  _MaintenanceOrderConfirmation.OperationConfirmedStartDate AS OperationConfirmedStartDate,
  _MaintenanceOrderConfirmation.OperationConfirmedStartTime AS OperationConfirmedStartTime,
  _MaintenanceOrderConfirmation.OperationConfirmedEndDate AS OperationConfirmedEndDate,
  _MaintenanceOrderConfirmation.OperationConfirmedEndTime AS OperationConfirmedEndTime,
  _MaintenanceOrderConfirmation.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  _MaintenanceOrderConfirmation.ActyConfFcstdEndTime AS ActyConfFcstdEndTime,
  _MaintenanceOrderConfirmation.ActualWorkQuantity AS ActualWorkQuantity,
  _MaintenanceOrderConfirmation.ActualWorkQuantityUnit AS ActualWorkQuantityUnit,
  _MaintenanceOrderConfirmation.ActualDuration AS ActualDuration,
  _MaintenanceOrderConfirmation.ActualDurationUnit AS ActualDurationUnit,
  _MaintenanceOrderConfirmation.RemainingWorkQuantity AS RemainingWorkQuantity,
  _MaintenanceOrderConfirmation.RemainingWorkQuantityUnit AS RemainingWorkQuantityUnit,
  _MaintenanceOrderConfirmation.VarianceReasonCode AS VarianceReasonCode,
  _MaintenanceOrderConfirmation.PersonnelNumber AS OperationPersonResponsible,
  _MaintenanceOrderConfirmation.EmployeeWageType AS EmployeeWageType,
  _MaintenanceOrderConfirmation.AccountingIndicatorCode AS AccountingIndicatorCode,
  _MaintenanceOrderConfirmation.NoFurtherWorkQuantityIsExpd AS NoFurtherWorkQuantityIsExpd,
  _MaintenanceOrderConfirmation.OpenReservationsIsCleared AS OpenReservationsIsCleared,
  _MaintenanceOrderConfirmation.IsReversed AS IsReversed,
  _MaintenanceOrderConfirmation.IsReversal AS IsReversal,
  _MaintenanceOrderConfirmation.FactoryCalendar AS FactoryCalendar,
  _MaintenanceOrderConfirmation.Language AS Language,
  _MaintenanceOrderConfirmation.LongTextExists AS LongTextExists,
  _MaintenanceOrderConfirmation._IsReversed AS _IsReversed,
  _MaintenanceOrderConfirmation._IsReversal AS _IsReversal,
  _MaintenanceOrderConfirmation._IsFinalConfirmation AS _IsFinalConfirmation,
  _MaintenanceOrderConfirmation._OpenReservationsIsCleared AS _OpenReservationsIsCleared,
  _MaintenanceOrderConfirmation._NoFurtherWorkQuantityIsExpd AS _NoFurtherWorkQuantityIsExpd,
  _MaintenanceOrderConfirmation._LongTextExists AS _LongTextExists,
  _MaintenanceOrderConfirmation._VarianceReason AS _VarianceReason,
  _MaintenanceOrderConfirmation._PersonnelName AS _PersonnelName,
  _MaintenanceOrderConfirmation._EnteredByUser AS _EnteredByUser,
  _ActualWorkCenter.WorkCenter AS WorkCenter,
  _MaintenanceOrder.Equipment AS Equipment,
  _MaintenanceOrder.FunctionalLocation AS FunctionalLocation,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceOrder.MaintenanceProcessingPhase AS MaintenanceProcessingPhase,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _MaintenanceOrder._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
  _MaintenanceOrder._MaintenanceOrderPhase AS _MaintenanceOrderPhase,
  _MaintenanceOrder._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  _MaintOrderOperation.MaintenanceOrderOperation AS MaintenanceOrdOpForSearch,
  _MaintOrderOperation.OperationDescription AS OperationDescription,
  _MaintOrderOperation.Plant AS PlannedPlant,
  _MaintOrderOperation.TechObjIsEquipOrFuncnlLoc AS MaintOrdOpTechObjType,
  _MaintOrderOperation.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _MaintOrderOperation.OperationPlannedWork AS OperationPlannedWork,
  _MaintOrderOperation.TechnicalObject AS MaintOperationTechnicalObject
FROM I_MaintenanceOrderConfTP AS _MaintenanceOrderConfirmation
LEFT OUTER JOIN C_ObjPgMaintOrderConfWthDesc AS _ObjPgMaintOrderConfWthDesc ON _ObjPgMaintOrderConfWthDesc.MaintOrderConf = MaintOrderConf AND _ObjPgMaintOrderConfWthDesc.MaintOrderConfCntrValue = MaintOrderConfCntrValue  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderTechObj AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN P_ObjPgMaintOrderAndOperation AS _MaintOrderOperation ON _MaintOrderOperation.MaintenanceOrder = MaintenanceOrder AND _MaintOrderOperation.MaintenanceOrderOperation = MaintenanceOrderOperation AND _MaintOrderOperation.MaintenanceOrderSubOperation = MaintenanceOrderSubOperation  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderConfirmation AS _MaintOrderConfVH ON MaintOrderConf = _MaintOrderConfVH.MaintOrderConf AND MaintOrderConfCntrValue = _MaintOrderConfVH.MaintOrderConfCntrValue  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _PlannedWorkCenterVH ON _PlannedWorkCenterVH.Plant = PlannedPlant AND _PlannedWorkCenterVH.WorkCenter = PlannedWorkCenter  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterVH ON _WorkCenterVH.Plant = Plant AND _WorkCenterVH.WorkCenter = WorkCenter  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _TechnicalObjectLabelVH ON _TechnicalObjectLabelVH.TechnicalObjectLabel = technicalobjectlabel AND _TechnicalObjectLabelVH.TechObjIsEquipOrFuncnlLoc = techobjisequiporfuncnlloc AND _TechnicalObjectLabelVH.TechnicalObject = technicalobject  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _OperationTechObjLabelVH ON _OperationTechObjLabelVH.TechnicalObjectLabel = OperationTechnicalObjectLabel AND _OperationTechObjLabelVH.TechObjIsEquipOrFuncnlLoc = MaintOrdOpTechObjType AND _OperationTechObjLabelVH.TechnicalObject = MaintOperationTechnicalObject  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderTypeVH AS _MaintOrderTypeVH ON _MaintOrderTypeVH.MaintenanceOrderType = maintenanceordertype  -- association [0..1]
LEFT OUTER JOIN C_MaintenanceOrderPhaseVH AS _MaintenanceOrderPhaseVH ON _MaintenanceOrderPhaseVH.MaintenanceProcessingPhase = maintenanceprocessingphase  -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _TechnicalObjQuickVw ON _TechnicalObjQuickVw.TechnicalObject = technicalobject AND _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = techobjisequiporfuncnlloc AND _TechnicalObjQuickVw.TechnicalObjectLabel = technicalobjectlabel  -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _OpTechnicalObjQuickVw ON _OpTechnicalObjQuickVw.TechnicalObject = MaintOperationTechnicalObject AND _OpTechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = MaintOrdOpTechObjType AND _OpTechnicalObjQuickVw.TechnicalObjectLabel = OperationTechnicalObjectLabel  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _OperationTechObjIsEquip ON _OperationTechObjIsEquip.TechObjIsEquipOrFuncnlLoc = MaintOrdOpTechObjType  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderQuickVw AS _MaintenanceOrderQuickView ON _MaintenanceOrderQuickView.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN C_StsObjActiveStatusCodeText AS _ActiveSystemStatus ON _ActiveSystemStatus.StatusObject = MaintOrderOperationInternalID AND _ActiveSystemStatus.IsUserStatus = ''  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _SystemStatus ON _SystemStatus.StatusObject = MaintOrderOperationInternalID AND _SystemStatus.IsUserStatus = ' '  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _UserStatusWthoutStsNmbr ON _UserStatusWthoutStsNmbr.StatusObject = MaintOrderOperationInternalID AND _UserStatusWthoutStsNmbr.StatusSequenceNumber = '00' AND _UserStatusWthoutStsNmbr.IsUserStatus = 'X'  -- association [0..*]
LEFT OUTER JOIN C_MaintObjUserStatusWthStsNmbr AS _UserStatusWithStatusNumber ON _UserStatusWithStatusNumber.StatusObject = MaintOrderOperationInternalID AND _UserStatusWithStatusNumber.StatusSequenceNumber != '00' AND _UserStatusWithStatusNumber.IsUserStatus = 'X'  -- association [0..1]
;