I_MaintOrderOperTechObj

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 I_MaintOrderOperTechObj.
-- 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: IMTORDOPRTECOBJ

CREATE VIEW I_MaintOrderOperTechObj AS
SELECT
  I_MaintenanceOrderOperation.MaintenanceOrder AS MaintenanceOrder,
  I_MaintenanceOrderOperation.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  _MaintenanceOrder._Order.ControllingArea AS ControllingArea,
  I_MaintenanceOrderOperation.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  I_MaintenanceOrderOperation.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  I_MaintenanceOrderOperation.OperationControlKey AS OperationControlKey,
  I_MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  I_MaintenanceOrderOperation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  I_MaintenanceOrderOperation.Equipment AS Equipment,
  I_MaintenanceOrderOperation.FunctionalLocation AS FunctionalLocation,
  I_MaintenanceOrderOperation.Plant AS Plant,
  I_MaintenanceOrderOperation.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  I_MaintenanceOrderOperation.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  I_MaintenanceOrderOperation.OperationPurgInfoRecdSearchTxt AS OperationPurgInfoRecdSearchTxt,
  I_MaintenanceOrderOperation.OperationRequisitionerName AS OperationRequisitionerName,
  I_MaintenanceOrderOperation.OperationGoodsRecipientName AS OperationGoodsRecipientName,
  I_MaintenanceOrderOperation.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  I_MaintenanceOrderOperation.OpExternalProcessingPriceUnit AS OpExternalProcessingPriceUnit,
  I_MaintenanceOrderOperation.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  I_MaintenanceOrderOperation.OperationTrackingNumber AS OperationTrackingNumber,
  I_MaintenanceOrderOperation.OperationPurchasingInfoRecord AS OperationPurchasingInfoRecord,
  I_MaintenanceOrderOperation.OperationUnloadingPointName AS OperationUnloadingPointName,
  I_MaintenanceOrderOperation.OpPurchaseOutlineAgreement AS OpPurchaseOutlineAgreement,
  I_MaintenanceOrderOperation.OpPurchaseOutlineAgreementItem AS OpPurchaseOutlineAgreementItem,
  I_MaintenanceOrderOperation.OperationSupplier AS OperationSupplier,
  I_MaintenanceOrderOperation.OperationPersonResponsible AS OperationPersonResponsible,
  I_MaintenanceOrderOperation.Assembly AS Assembly,
  I_MaintenanceOrderOperation.OperationSystemCondition AS OperationSystemCondition,
  I_MaintenanceOrderOperation.CostCtrActivityType AS CostCtrActivityType,
  I_MaintenanceOrderOperation.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  I_MaintenanceOrderOperation.OperationCalculationControl AS OperationCalculationControl,
  I_MaintenanceOrderOperation.OperationWorkPercent AS OperationWorkPercent,
  I_MaintenanceOrderOperation.CapacityRequirement AS CapacityRequirement,
  I_MaintenanceOrderOperation.CapacityRequirementItem AS CapacityRequirementItem,
  I_MaintenanceOrderOperation.PurchaseRequisition AS PurchaseRequisition,
  I_MaintenanceOrderOperation.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_MaintenanceOrderOperation.NumberOfCapacities AS NumberOfCapacities,
  I_MaintenanceOrderOperation.MaterialGroup AS MaterialGroup,
  I_MaintenanceOrderOperation.CostElement AS CostElement,
  I_MaintenanceOrderOperation.PurchasingGroup AS PurchasingGroup,
  I_MaintenanceOrderOperation.PurchasingOrganization AS PurchasingOrganization,
  I_MaintenanceOrderOperation.Language AS Language,
  I_MaintenanceOrderOperation.OperationHasLongText AS OperationHasLongText,
  I_MaintenanceOrderOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  I_MaintenanceOrderOperation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  I_MaintenanceOrderOperation.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  I_MaintenanceOrderOperation.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  I_MaintenanceOrderOperation.MaintenanceJobVerification AS MaintenanceJobVerification,
  I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  I_MaintenanceOrderOperation._OperationPlanningValues.OperationDuration AS OperationDuration,
  I_MaintenanceOrderOperation._OperationPlanningValues.OperationDurationUnit AS OperationDurationUnit,
  I_MaintenanceOrderOperation._OperationPlanningValues._PlannedWorkUnitOfMeasure AS _PlannedWorkUnitOfMeasure,
  cast( I_MaintenanceOrderOperation._OperationPlanningValues.ConfirmationTotalQuantity as eams_total_actual_work ) AS ConfirmationTotalQuantity,
  I_MaintenanceOrderOperation._WorkCenter.WorkCenter AS OperationWorkCenter,
  _ObjectOverallStatus.EAMOverallObjectStatusProfile AS EAMOverallObjectStatusProfile,
  _ObjectOverallStatus.EAMOverallObjectStatus AS EAMOverallObjectStatus,
  case when _StatusObjectStatus[1: StatusCode = 'I0013'].StatusCode is not null and _StatusObjectStatus[1: StatusCode = 'I0013'].StatusIsInactive <> 'X' then 'X' else '' end as IsDeleted AS StatusIsInactiveXthenXelseendasIsDeleted,
  I_MaintenanceOrderOperation._OperationControlKey AS _OperationControlKey,
  I_MaintenanceOrderOperation._OperationPlanningValues AS _OperationPlanningValues,
  I_MaintenanceOrderOperation._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  I_MaintenanceOrderOperation._OperationSystemCondition AS _OperationSystemCondition,
  I_MaintenanceOrderOperation._Plant AS _Plant,
  I_MaintenanceOrderOperation._StatusObject AS _StatusObject,
  I_MaintenanceOrderOperation._WorkCenter AS _WorkCenter,
  I_MaintenanceOrderOperation._OperationCalculationControl AS _OperationCalculationControl,
  I_MaintenanceOrderOperation._Assembly AS _Assembly,
  I_MaintenanceOrderOperation._Language AS _Language,
  I_MaintenanceOrderOperation._OperationHasLongText AS _OperationHasLongText,
  I_MaintenanceOrderOperation._Supplier AS _Supplier,
  I_MaintenanceOrderOperation._PersonResponsible AS _PersonResponsible,
  I_MaintenanceOrderOperation._MaintOperationExecStageCode AS _MaintOperationExecStageCode,
  _ObjectOverallStatus._OverallStatus AS _OverallStatus,
  _OperationPlanningValues._DurationUnitOfMeasure AS _DurationUnitOfMeasure
FROM I_MaintenanceOrderOperation
LEFT OUTER JOIN I_MaintOrderTechObj AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_MaintOrderOperComp AS _MaintenanceOperationComponent ON MaintenanceOrder = _MaintenanceOperationComponent.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOperationComponent.MaintenanceOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_MaintOrderSubOperTechObj AS _MaintenanceSubOperation ON MaintenanceOrder = _MaintenanceSubOperation.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceSubOperation.MaintenanceOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON TechnicalObject = _TechnicalObject.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObject.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON TechObjIsEquipOrFuncnlLoc = _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _ActivityType ON ControllingArea = _ActivityType.ControllingArea AND CostCtrActivityType = _ActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ControllingArea = _CostElement.ControllingArea AND CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_EAMObjectOverallStatus AS _ObjectOverallStatus ON MaintOrderOperationInternalID = _ObjectOverallStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_MaintOrderOperObjectListLink AS _MaintOrderOperObjectListLink ON MaintOrderOperationCounter = _MaintOrderOperObjectListLink.MaintOrderOperationCounter AND MaintOrderRoutingNumber = _MaintOrderOperObjectListLink.MaintOrderRoutingNumber  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON MaintOrderOperationInternalID = _StatusObjectStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_Indicator AS _IsDeleted ON IsDeleted = _IsDeleted.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsFinallyConfirmed ON IsFinallyConfirmed = _IsFinallyConfirmed.IndicatorValue  -- association [0..1]
;