R_MaintenanceOrderOperationTP

DDL: R_MAINTENANCEORDEROPERATIONTP Type: view_entity TRANSACTIONAL
152 Fields 1 Data Sources 29 Associations

Maintenance Order Operation TP

R_MaintenanceOrderOperationTP is a Transactional CDS View that provides data about "Maintenance Order Operation TP" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOperAndSubOper) and exposes 152 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation. It has 29 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOperAndSubOper I_MaintOrderOperAndSubOper from

Associations (29)

CardinalityTargetAliasCondition
[0..1] I_WorkCenter _OperationWorkCenter _OperationWorkCenter.WorkCenterInternalID = $projection.OperationWorkCenterInternalID and _OperationWorkCenter.WorkCenterTypeCode = $projection.OperationWorkCenterTypeCode
[0..1] I_WBSElementBasicData _WBSElement _WBSElement.WBSElementInternalID = $projection.MaintOrdOpAssgdWBSElmntInt
[0..*] I_CostCenterActivityTypeText _CostCenterActivityTypeText $projection.ControllingArea = _CostCenterActivityTypeText.ControllingArea and $projection.ActivityType = _CostCenterActivityTypeText.CostCtrActivityType and _CostCenterActivityTypeText.ValidityStartDate <= $session.system_date and _CostCenterActivityTypeText.ValidityEndDate = '99991231'
[0..*] I_MaintenanceActivityTypeText _MaintenanceActivityTypeText $projection.maintenanceactivitytype = _MaintenanceActivityTypeText.MaintenanceActivityType
[0..1] I_MaintOrderOperObjectListLink _MaintOrderOpObjectListLink $projection.MaintenanceOrderRoutingNode = _MaintOrderOpObjectListLink.MaintOrderOperationCounter and $projection.MaintOrderRoutingNumber = _MaintOrderOpObjectListLink.MaintOrderRoutingNumber -- Extensions, do not expose as association:
[0..1] E_MaintenanceOrderOperation _MaintOrderOperExtension _MaintOrderOperExtension.MaintOrderRoutingNumber = $projection.MaintOrderRoutingNumber and _MaintOrderOperExtension.MaintOrderOperationCounter = $projection.MaintenanceOrderRoutingNode
[0..*] I_MaterialGroupText _MaterialGroupText $projection.MaterialGroup = _MaterialGroupText.MaterialGroup
[0..1] I_CostElement _CostElement $projection.ControllingArea = _CostElement.ControllingArea and $projection.CostElement = _CostElement.CostElement
[0..1] I_MaintenanceNotification _MaintenanceNotification _MaintenanceNotification.MaintenanceNotification = $projection.maintenancenotification
[0..*] I_OperationControlProfileText _OperationControlProfileText _OperationControlProfileText.OperationControlProfile = $projection.OperationControlKey
[0..*] I_MaintOpExecStageCodeText _MaintOpExecStageCodeText _MaintOpExecStageCodeText.MaintOperationExecStageCode = $projection.MaintOperationExecStageCode
[0..*] I_MaterialText _AssemblyText _AssemblyText.Material = $projection.Assembly
[0..*] I_EquipmentText _EquipmentText _EquipmentText.Equipment = $projection.Equipment
[0..1] I_FunctionalLocationLabel _FunctionalLocationLabel _FunctionalLocationLabel.FunctionalLocation = $projection.FunctionalLocation
[0..*] I_FunctionalLocationText _FunctionalLocationText _FunctionalLocationText.FunctionalLocation = $projection.FunctionalLocation
[0..*] I_MaintOperationSystConditionT _MaintOpSystemConditionText _MaintOpSystemConditionText.OperationSystemCondition = $projection.OperationSystemCondition
[0..*] I_WorkCenterText _WorkCenterText _WorkCenterText.WorkCenterTypeCode = $projection.OperationWorkCenterTypeCode and _WorkCenterText.WorkCenterInternalID = $projection.OperationWorkCenterInternalID
[0..*] I_OperationCalcControlText _OperationCalcControlText _OperationCalcControlText.OperationCalculationControl = $projection.OperationCalculationControl
[0..*] I_EAMProcessPhaseText _EAMProcessPhaseText _EAMProcessPhaseText.EAMProcessPhaseCode = $projection.MaintOrdOpProcessPhaseCode
[0..*] I_EAMProcessSubPhaseText _EAMProcessSubPhaseText _EAMProcessSubPhaseText.EAMProcessSubPhaseCode = $projection.MaintOrdOpProcessSubPhaseCode
[0..*] I_PurReqnOrResvnGenerationText _PurReqnOrResvnGenerationText _PurReqnOrResvnGenerationText.PurReqnOrResvnGeneration = $projection.MaintOrdOperationIsMRPRelevant
[0..*] I_MaintOrdOpDeliveryDateAdjmtT _MaintOrdOpDeliveryDateAdjmtT _MaintOrdOpDeliveryDateAdjmtT.MaintOrdOpDelivDateAdjustment = $projection.MaintOrdOpDelivDateAdjustment
[0..*] R_MaintOrderOpRelationshipTP _MaintOrderOpRelationship
[0..*] R_MaintOrderOpComponentTP _MaintOrderOpComponent
[0..*] R_MaintOrderOpComponentTP_2 _MaintOrderOpComponent_2
[0..*] R_MaintOrderOpLongTextTP _MaintOrderOpLongText
[0..*] R_MaintOrderOpPhaseControlTP _MaintOrderOpPhaseControl
[0..*] R_MaintOrderOpProdnRsceToolTP _MaintOrderOpProdnRsceTool
[0..*] R_MaintOrderOpRqmtAssgmtTP _MaintOrderOpRqmtAssgmt

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Order Operation TP view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (152)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY MaintenanceOrderOperation Suboperation
KEY MaintenanceOrderSubOperation Suboperation
MaintOrderOperationForEdit Suboperation
MaintOrderSubOperationForEdit Suboperation
MaintOrderRoutingNumber MaintOrderRoutingNumber Plan No.f.Oper.
MaintenanceOrderRoutingNode MaintOrderOperationCounter Counter
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
OperationControlKey OperationControlKey Control Key
OperationDescription OperationDescription Op. Short Text
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
OperationWorkCenterTypeCode OperationWorkCenterTypeCode
Plant Plant Valuation Area
OperationStandardTextCode OperationStandardTextCode Std Text Key
Language Language Report Text Language
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
OperationPurgInfoRecdSearchTxt OperationPurgInfoRecdSearchTxt Sort Term
OperationSupplier OperationSupplier Supplier
OpExternalProcessingPrice OpExternalProcessingPrice Price
OpExternalProcessingPriceUnit OpExternalProcessingPriceUnit Price unit
CostElement CostElement G/L Account
OpExternalProcessingCurrency OpExternalProcessingCurrency Currency
OperationPurchasingInfoRecord OperationPurchasingInfoRecord Info Record
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
MaterialGroup MaterialGroup Product Group
OpPurchaseOutlineAgreement OpPurchaseOutlineAgreement Agreement
OpPurchaseOutlineAgreementItem OpPurchaseOutlineAgreementItem Agreement Item
OperationRequisitionerName OperationRequisitionerName Requisitioner
OperationTrackingNumber OperationTrackingNumber Tracking Number
NumberOfCapacities NumberOfCapacities Number
OperationWorkPercent OperationWorkPercent Percent
OperationCalculationControl OperationCalculationControl Calculation key
ActivityType CostCtrActivityType Activity Type
OperationSystemCondition OperationSystemCondition SystemCondition
OperationGoodsRecipientName OperationGoodsRecipientName Recipient
OperationUnloadingPointName OperationUnloadingPointName Unloading Point
OperationPersonResponsible OperationPersonResponsible Personnel no.
EAMPlannedDeliveryDurnInDays EAMPlannedDeliveryDurnInDays Pl. Deliv. Time
MaintOrderOperationDuration MaintOrderOperationDuration Normal duration
MaintOrdOperationDurationUnit MaintOrdOperationDurationUnit Norm.duratn un.
OpBscStartDateConstraintType OpBscStartDateConstraintType StartConstraint
OpBscEndDateConstraintType OpBscEndDateConstraintType Fin. constraint
MaintOrdOperationWorkDuration MaintOrdOperationWorkDuration Work
MaintOrdOpWorkDurationUnit MaintOrdOpWorkDurationUnit Unit for work
MaintOrdOperationExecutionRate MaintOrdOperationExecutionRate Execution Fact.
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
clientNULLendasOpErlstSchedldExecStrtDte
clientNULLendasOpErlstSchedldExecStrtTme
clientNULLendasOpErlstSchedldExecEndDte
clientNULLendasOpErlstSchedldExecEndTme
clientNULLendasOpLtstSchedldExecStrtDte
clientNULLendasOpLtstSchedldExecStrtTme
clientNULLendasOpLtstSchedldExecEndDte
clientNULLendasOpLtstSchedldExecEndTme
clientNULLendasOpActualExecutionEndDate
clientNULLendasOpActualExecutionEndTime
clientNULLendasActyConfFcstdEndDate
clientNULLendasActyConfFcstdEndTime
ActualWorkQuantity ActualWorkQuantity Actual work
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
CostingSheet CostingSheet Costing Sheet
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
FunctionalArea FunctionalArea Sendr Fctl Area
MaintOrdOperationIsMRPRelevant MaintOrdOperationIsMRPRelevant Res./Purc. req.
MaintControllingObjectClass MaintControllingObjectClass Object Class
WrkCtrIntCapRqmtsDistr WrkCtrIntCapRqmtsDistr Int. dist. key
MaintOrdOperationOverheadCode MaintOrdOperationOverheadCode Overhead key
MaintOrderOperationQuantity MaintOrderOperationQuantity Operation Qty
MaintOrdOperationQuantityUnit MaintOrdOperationQuantityUnit Act/op UoM
Assembly Assembly Pegged Reqmt
MaintOperationExecStageCode MaintOperationExecStageCode Execution Stage
MaintOrdOpAssgdWBSElmntInt MaintOrdOpAssgdWBSElmntInt WBS Internal ID
WBSElement
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
MaintOrderOperationInternalID MaintOrderOperationInternalID Object number
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
MaintOrdOpProcessPhaseCode MaintOrdOpProcessPhaseCode Process Phase
MaintOrdOpProcessSubPhaseCode MaintOrdOpProcessSubPhaseCode Process Subphase
AllMaintOrdCompCmtdQtsAreKept AllMaintOrdCompCmtdQtsAreKept Keep Committed Qties
MaintOrderConfirmation MaintOrderConfirmation Confirmation
MaintOrderConfCntrValue MaintOrderConfCntrValue Counter
MaintOrdOpHasNoRemainingWork MaintOrdOpHasNoRemainingWork No Remain. Work
MaintOrdOpHasLeanServices MaintOrdOpHasLeanServices operation has srv
MaintenanceNotification
ExtProcgOperationHasSubcontrg ExtProcgOperationHasSubcontrg Subcontracting
MaintOrdOpDelivDateAdjustment MaintOrdOpDelivDateAdjustment Align Date
TaskListType TaskListType Task List Type
TaskListGroup TaskListGroup Group
TaskListGroupCounter TaskListGroupCounter Group Counter
TaskListSequence TaskListSequence Sequence
TaskListOperationInternalId TaskListOperationInternalId Node
MaintOperationalChecklistType MaintOperationalChecklistType Checklist Type
_MaintOrderOpRelationship _MaintOrderOpRelationship
_MaintOrderOpComponent _MaintOrderOpComponent
_MaintOrderOpComponent_2 _MaintOrderOpComponent_2
_MaintOrderOpRqmtAssgmt _MaintOrderOpRqmtAssgmt
_MaintenanceOrder _MaintenanceOrder
_OpExternalProcessingCurrency _OpExternalProcessingCurrency
_OperationPlanningValues _OperationPlanningValues
_OperationControlKey _OperationControlKey
_OperationSystemCondition _OperationSystemCondition
_Plant _Plant
_OperationCalculationControl _OperationCalculationControl
_Assembly _Assembly
_Language _Language
_Supplier _Supplier
_PersonResponsible _PersonResponsible
_FunctionalLocation _FunctionalLocation
_Equipment _Equipment
_MaintOrderProdnRsceTool _MaintOrderProdnRsceTool
_PMContactEmployee _PMContactEmployee
_MaintOperationExecStageCode _MaintOperationExecStageCode
_OperationWorkCenter _OperationWorkCenter
_StatusObjectActiveStatus _StatusObjectActiveStatus
_MaintOrderOpLongText _MaintOrderOpLongText
_MaintOrderOpPhaseControl _MaintOrderOpPhaseControl
_MaintOrderOpProdnRsceTool _MaintOrderOpProdnRsceTool
_MaintenanceActivityTypeText _MaintenanceActivityTypeText
_CostCenterActivityTypeText _CostCenterActivityTypeText
_PersonWorkAgreement _PersonWorkAgreement
_WorkAssignment _WorkAssignment
_MaintOrderOpObjectListLink _MaintOrderOpObjectListLink
_EAMProcessPhase _EAMProcessPhase
_EAMProcessSubPhase _EAMProcessSubPhase
_MaintenanceNotification _MaintenanceNotification
_MaterialGroupText _MaterialGroupText
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_PurReqnOrResvnGeneration _PurReqnOrResvnGeneration
_CostElement _CostElement
_MaintOrdOpDeliveryDateAdjmt _MaintOrdOpDeliveryDateAdjmt
_OperationControlProfileText _OperationControlProfileText
_MaintOpExecStageCodeText _MaintOpExecStageCodeText
_AssemblyText _AssemblyText
_EquipmentText _EquipmentText
_FunctionalLocationLabel _FunctionalLocationLabel
_FunctionalLocationText _FunctionalLocationText
_MaintOpSystemConditionText _MaintOpSystemConditionText
_WorkCenterText _WorkCenterText
_OperationCalcControlText _OperationCalcControlText
_EAMProcessPhaseText _EAMProcessPhaseText
_EAMProcessSubPhaseText _EAMProcessSubPhaseText
_PurReqnOrResvnGenerationText _PurReqnOrResvnGenerationText
_MaintOrdOpDeliveryDateAdjmtT _MaintOrdOpDeliveryDateAdjmtT
ControllingArea _MaintenanceOrder ControllingArea Controlling Area
MaintenanceObjectListItem _MaintOrderOperObjectListLink MaintenanceObjectListItem Object counters
MaintenanceActivityType _MaintOrdOpAdditionalData MaintenanceActivityType MaintActivType
WorkCenter _OperationWorkCenter WorkCenter Work Center

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 R_MaintenanceOrderOperationTP.
-- 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.

CREATE VIEW R_MaintenanceOrderOperationTP AS
SELECT
  MaintenanceOrder,
  cast( MaintenanceOrderOperation as maintenanceorderoperation preserving type ) AS MaintenanceOrderOperation,
  cast( MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) AS MaintenanceOrderSubOperation,
  cast( MaintenanceOrderOperation as maintenanceorderoperation preserving type ) AS MaintOrderOperationForEdit,
  cast( MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) AS MaintOrderSubOperationForEdit,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter AS MaintenanceOrderRoutingNode,
  SuperiorOperationInternalID,
  OperationControlKey,
  OperationDescription,
  OperationWorkCenterInternalID,
  OperationWorkCenterTypeCode,
  Plant,
  OperationStandardTextCode,
  Language,
  NumberOfTimeTickets,
  OperationPurgInfoRecdSearchTxt,
  OperationSupplier,
  OpExternalProcessingPrice,
  OpExternalProcessingPriceUnit,
  CostElement,
  OpExternalProcessingCurrency,
  OperationPurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingGroup,
  MaterialGroup,
  OpPurchaseOutlineAgreement,
  OpPurchaseOutlineAgreementItem,
  OperationRequisitionerName,
  OperationTrackingNumber,
  NumberOfCapacities,
  OperationWorkPercent,
  OperationCalculationControl,
  CostCtrActivityType AS ActivityType,
  OperationSystemCondition,
  OperationGoodsRecipientName,
  OperationUnloadingPointName,
  OperationPersonResponsible,
  EAMPlannedDeliveryDurnInDays,
  MaintOrderOperationDuration,
  MaintOrdOperationDurationUnit,
  OpBscStartDateConstraintType,
  OpBscEndDateConstraintType,
  MaintOrdOperationWorkDuration,
  MaintOrdOpWorkDurationUnit,
  MaintOrdOperationExecutionRate,
  Equipment,
  FunctionalLocation,
  case when OpErlstSchedldExecStrtTme = '240000' and OpErlstSchedldExecStrtDte is not initial then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( OpErlstSchedldExecStrtDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(OpErlstSchedldExecStrtDte, OpErlstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpErlstSchedldExecStrtDte AS clientNULLendasOpErlstSchedldExecStrtDte,
  case when OpErlstSchedldExecStrtTme = '240000' and OpErlstSchedldExecStrtDte is not initial then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( OpErlstSchedldExecStrtDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(OpErlstSchedldExecStrtDte, OpErlstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpErlstSchedldExecStrtTme AS clientNULLendasOpErlstSchedldExecStrtTme,
  case when OpErlstSchedldExecEndTme = '240000' and OpErlstSchedldExecEndDte is not initial then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( OpErlstSchedldExecEndDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(OpErlstSchedldExecEndDte, OpErlstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpErlstSchedldExecEndDte AS clientNULLendasOpErlstSchedldExecEndDte,
  case when OpErlstSchedldExecEndTme = '240000' and OpErlstSchedldExecEndDte is not initial then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( OpErlstSchedldExecEndDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(OpErlstSchedldExecEndDte, OpErlstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpErlstSchedldExecEndTme AS clientNULLendasOpErlstSchedldExecEndTme,
  case when OpLtstSchedldExecStrtTme = '240000' and OpLtstSchedldExecStrtDte is not initial then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( OpLtstSchedldExecStrtDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(OpLtstSchedldExecStrtDte, OpLtstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpLtstSchedldExecStrtDte AS clientNULLendasOpLtstSchedldExecStrtDte,
  case when OpLtstSchedldExecStrtTme = '240000' and OpLtstSchedldExecStrtDte is not initial then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( OpLtstSchedldExecStrtDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(OpLtstSchedldExecStrtDte, OpLtstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpLtstSchedldExecStrtTme AS clientNULLendasOpLtstSchedldExecStrtTme,
  case when OpLtstSchedldExecEndTme = '240000' and OpLtstSchedldExecEndDte is not initial then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( OpLtstSchedldExecEndDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(OpLtstSchedldExecEndDte, OpLtstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpLtstSchedldExecEndDte AS clientNULLendasOpLtstSchedldExecEndDte,
  case when OpLtstSchedldExecEndTme = '240000' and OpLtstSchedldExecEndDte is not initial then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( OpLtstSchedldExecEndDte, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(OpLtstSchedldExecEndDte, OpLtstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpLtstSchedldExecEndTme AS clientNULLendasOpLtstSchedldExecEndTme,
  case when OpActualExecutionEndTime = '240000' and OpActualExecutionEndDate is not initial then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( OpActualExecutionEndDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(OpActualExecutionEndDate, OpActualExecutionEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpActualExecutionEndDate AS clientNULLendasOpActualExecutionEndDate,
  case when OpActualExecutionEndTime = '240000' and OpActualExecutionEndDate is not initial then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( OpActualExecutionEndDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(OpActualExecutionEndDate, OpActualExecutionEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as OpActualExecutionEndTime AS clientNULLendasOpActualExecutionEndTime,
  case when ActyConfFcstdEndTime = '240000' and ActyConfFcstdEndDate is not initial then tstmp_to_dats( dats_tims_to_tstmp(dats_add_days( ActyConfFcstdEndDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_dats( dats_tims_to_tstmp(ActyConfFcstdEndDate, ActyConfFcstdEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as ActyConfFcstdEndDate AS clientNULLendasActyConfFcstdEndDate,
  case when ActyConfFcstdEndTime = '240000' and ActyConfFcstdEndDate is not initial then tstmp_to_tims( dats_tims_to_tstmp(dats_add_days( ActyConfFcstdEndDate, 1, 'NULL'), cast( '000000' as abap.tims ), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) else tstmp_to_tims( dats_tims_to_tstmp(ActyConfFcstdEndDate, ActyConfFcstdEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'UTC', $session.client, 'NULL' ) end as ActyConfFcstdEndTime AS clientNULLendasActyConfFcstdEndTime,
  ActualWorkQuantity,
  BusinessArea,
  ProfitCenter,
  CostingSheet,
  TaxJurisdiction,
  FunctionalArea,
  MaintOrdOperationIsMRPRelevant,
  MaintControllingObjectClass,
  WrkCtrIntCapRqmtsDistr,
  MaintOrdOperationOverheadCode,
  MaintOrderOperationQuantity,
  MaintOrdOperationQuantityUnit,
  Assembly,
  MaintOperationExecStageCode,
  MaintOrdOpAssgdWBSElmntInt,
  cast ( _WBSElement.WBSElement as vdm_ps_posid ) AS WBSElement,
  IsMarkedForDeletion,
  MaintOrderOperationInternalID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  AllMaintOrdCompCmtdQtsAreKept,
  MaintOrderConfirmation,
  MaintOrderConfCntrValue,
  MaintOrdOpHasNoRemainingWork,
  MaintOrdOpHasLeanServices,
  _MaintOrderOpObjectListLink._MaintenanceItemObject.MaintenanceNotification AS MaintenanceNotification,
  ExtProcgOperationHasSubcontrg,
  MaintOrdOpDelivDateAdjustment,
  TaskListType,
  TaskListGroup,
  TaskListGroupCounter,
  TaskListSequence,
  TaskListOperationInternalId,
  MaintOperationalChecklistType,
  _MaintenanceOrder.ControllingArea AS ControllingArea,
  _MaintOrderOperObjectListLink.MaintenanceObjectListItem AS MaintenanceObjectListItem,
  _MaintOrdOpAdditionalData.MaintenanceActivityType AS MaintenanceActivityType,
  _OperationWorkCenter.WorkCenter AS WorkCenter
FROM I_MaintOrderOperAndSubOper
LEFT OUTER JOIN I_WorkCenter AS _OperationWorkCenter ON _OperationWorkCenter.WorkCenterInternalID = OperationWorkCenterInternalID AND _OperationWorkCenter.WorkCenterTypeCode = OperationWorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = MaintOrdOpAssgdWBSElmntInt  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON ControllingArea = _CostCenterActivityTypeText.ControllingArea AND ActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND _CostCenterActivityTypeText.ValidityStartDate <= $session.system_date AND _CostCenterActivityTypeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceActivityTypeText AS _MaintenanceActivityTypeText ON maintenanceactivitytype = _MaintenanceActivityTypeText.MaintenanceActivityType  -- association [0..*]
LEFT OUTER JOIN I_MaintOrderOperObjectListLink AS _MaintOrderOpObjectListLink ON MaintenanceOrderRoutingNode = _MaintOrderOpObjectListLink.MaintOrderOperationCounter AND MaintOrderRoutingNumber = _MaintOrderOpObjectListLink.MaintOrderRoutingNumber  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrderOperation AS _MaintOrderOperExtension ON _MaintOrderOperExtension.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _MaintOrderOperExtension.MaintOrderOperationCounter = MaintenanceOrderRoutingNode  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ControllingArea = _CostElement.ControllingArea AND CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceNotification AS _MaintenanceNotification ON _MaintenanceNotification.MaintenanceNotification = maintenancenotification  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfileText AS _OperationControlProfileText ON _OperationControlProfileText.OperationControlProfile = OperationControlKey  -- association [0..*]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _AssemblyText ON _AssemblyText.Material = Assembly  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON _EquipmentText.Equipment = Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON _FunctionalLocationText.FunctionalLocation = FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_MaintOperationSystConditionT AS _MaintOpSystemConditionText ON _MaintOpSystemConditionText.OperationSystemCondition = OperationSystemCondition  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON _WorkCenterText.WorkCenterTypeCode = OperationWorkCenterTypeCode AND _WorkCenterText.WorkCenterInternalID = OperationWorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN I_OperationCalcControlText AS _OperationCalcControlText ON _OperationCalcControlText.OperationCalculationControl = OperationCalculationControl  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessPhaseText AS _EAMProcessPhaseText ON _EAMProcessPhaseText.EAMProcessPhaseCode = MaintOrdOpProcessPhaseCode  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessSubPhaseText AS _EAMProcessSubPhaseText ON _EAMProcessSubPhaseText.EAMProcessSubPhaseCode = MaintOrdOpProcessSubPhaseCode  -- association [0..*]
LEFT OUTER JOIN I_PurReqnOrResvnGenerationText AS _PurReqnOrResvnGenerationText ON _PurReqnOrResvnGenerationText.PurReqnOrResvnGeneration = MaintOrdOperationIsMRPRelevant  -- association [0..*]
LEFT OUTER JOIN I_MaintOrdOpDeliveryDateAdjmtT AS _MaintOrdOpDeliveryDateAdjmtT ON _MaintOrdOpDeliveryDateAdjmtT.MaintOrdOpDelivDateAdjustment = MaintOrdOpDelivDateAdjustment  -- association [0..*]
LEFT OUTER JOIN R_MaintOrderOpRelationshipTP AS _MaintOrderOpRelationship ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintOrderOpComponentTP AS _MaintOrderOpComponent ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintOrderOpComponentTP_2 AS _MaintOrderOpComponent_2 ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintOrderOpLongTextTP AS _MaintOrderOpLongText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintOrderOpPhaseControlTP AS _MaintOrderOpPhaseControl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintOrderOpProdnRsceToolTP AS _MaintOrderOpProdnRsceTool ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MaintOrderOpRqmtAssgmtTP AS _MaintOrderOpRqmtAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More