I_MaintOrderSubOperTechObj

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_MaintOrderSubOperTechObj.
-- 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: IMTORDSOPTECOBJ

CREATE VIEW I_MaintOrderSubOperTechObj AS
SELECT
  I_MaintenanceOrderSubOperation.MaintenanceOrder AS MaintenanceOrder,
  I_MaintenanceOrderSubOperation.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  I_MaintenanceOrderSubOperation.MaintenanceOrderSubOperation AS MaintenanceOrderSubOperation,
  _MaintenanceOrder._Order.ControllingArea AS ControllingArea,
  I_MaintenanceOrderSubOperation.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  I_MaintenanceOrderSubOperation.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  I_MaintenanceOrderSubOperation.OperationControlKey AS OperationControlKey,
  I_MaintenanceOrderSubOperation.OperationDescription AS OperationDescription,
  I_MaintenanceOrderSubOperation.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  I_MaintenanceOrderSubOperation.Equipment AS Equipment,
  I_MaintenanceOrderSubOperation.FunctionalLocation AS FunctionalLocation,
  I_MaintenanceOrderSubOperation.Plant AS Plant,
  I_MaintenanceOrderSubOperation.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  I_MaintenanceOrderSubOperation.OperationWorkCenterTypeCode AS OperationWorkCenterTypeCode,
  I_MaintenanceOrderSubOperation.OperationPurgInfoRecdSearchTxt AS OperationPurgInfoRecdSearchTxt,
  I_MaintenanceOrderSubOperation.OperationRequisitionerName AS OperationRequisitionerName,
  I_MaintenanceOrderSubOperation.OperationGoodsRecipientName AS OperationGoodsRecipientName,
  I_MaintenanceOrderSubOperation.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  I_MaintenanceOrderSubOperation.OpExternalProcessingPriceUnit AS OpExternalProcessingPriceUnit,
  I_MaintenanceOrderSubOperation.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  I_MaintenanceOrderSubOperation.OperationTrackingNumber AS OperationTrackingNumber,
  I_MaintenanceOrderSubOperation.OperationPurchasingInfoRecord AS OperationPurchasingInfoRecord,
  I_MaintenanceOrderSubOperation.OperationUnloadingPointName AS OperationUnloadingPointName,
  I_MaintenanceOrderSubOperation.OpPurchaseOutlineAgreement AS OpPurchaseOutlineAgreement,
  I_MaintenanceOrderSubOperation.OpPurchaseOutlineAgreementItem AS OpPurchaseOutlineAgreementItem,
  I_MaintenanceOrderSubOperation.OperationSupplier AS OperationSupplier,
  I_MaintenanceOrderSubOperation.OperationPersonResponsible AS OperationPersonResponsible,
  I_MaintenanceOrderSubOperation.Assembly AS Assembly,
  I_MaintenanceOrderSubOperation.OperationSystemCondition AS OperationSystemCondition,
  I_MaintenanceOrderSubOperation.CostCtrActivityType AS CostCtrActivityType,
  I_MaintenanceOrderSubOperation.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  I_MaintenanceOrderSubOperation.OperationCalculationControl AS OperationCalculationControl,
  I_MaintenanceOrderSubOperation.OperationWorkPercent AS OperationWorkPercent,
  I_MaintenanceOrderSubOperation.CapacityRequirement AS CapacityRequirement,
  I_MaintenanceOrderSubOperation.CapacityRequirementItem AS CapacityRequirementItem,
  I_MaintenanceOrderSubOperation.PurchaseRequisition AS PurchaseRequisition,
  I_MaintenanceOrderSubOperation.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_MaintenanceOrderSubOperation.NumberOfCapacities AS NumberOfCapacities,
  I_MaintenanceOrderSubOperation.CostElement AS CostElement,
  I_MaintenanceOrderSubOperation.MaterialGroup AS MaterialGroup,
  I_MaintenanceOrderSubOperation.PurchasingGroup AS PurchasingGroup,
  I_MaintenanceOrderSubOperation.PurchasingOrganization AS PurchasingOrganization,
  I_MaintenanceOrderSubOperation.Language AS Language,
  I_MaintenanceOrderSubOperation.OperationHasLongText AS OperationHasLongText,
  I_MaintenanceOrderSubOperation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  I_MaintenanceOrderSubOperation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  I_MaintenanceOrderSubOperation.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  I_MaintenanceOrderSubOperation.MaintOperationalChecklistType AS MaintOperationalChecklistType,
  I_MaintenanceOrderSubOperation.MaintenanceJobVerification AS MaintenanceJobVerification,
  I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationDuration AS OperationDuration,
  I_MaintenanceOrderSubOperation._OperationPlanningValues.OperationDurationUnit AS OperationDurationUnit,
  I_MaintenanceOrderSubOperation._OperationPlanningValues._PlannedWorkUnitOfMeasure AS _PlannedWorkUnitOfMeasure,
  I_MaintenanceOrderSubOperation._WorkCenter.WorkCenter AS OperationWorkCenter,
  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_MaintenanceOrderSubOperation._OperationControlKey AS _OperationControlKey,
  I_MaintenanceOrderSubOperation._OperationPlanningValues AS _OperationPlanningValues,
  I_MaintenanceOrderSubOperation._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  I_MaintenanceOrderSubOperation._OperationSystemCondition AS _OperationSystemCondition,
  I_MaintenanceOrderSubOperation._Plant AS _Plant,
  I_MaintenanceOrderSubOperation._StatusObject AS _StatusObject,
  I_MaintenanceOrderSubOperation._WorkCenter AS _WorkCenter,
  I_MaintenanceOrderSubOperation._OperationCalculationControl AS _OperationCalculationControl,
  I_MaintenanceOrderSubOperation._Assembly AS _Assembly,
  I_MaintenanceOrderSubOperation._Language AS _Language,
  I_MaintenanceOrderSubOperation._OperationHasLongText AS _OperationHasLongText,
  I_MaintenanceOrderSubOperation._Supplier AS _Supplier,
  I_MaintenanceOrderSubOperation._PersonResponsible AS _PersonResponsible,
  I_MaintenanceOrderSubOperation._MaintOperationExecStageCode AS _MaintOperationExecStageCode,
  I_MaintenanceOrderSubOperation._EAMProcessPhase AS _EAMProcessPhase,
  I_MaintenanceOrderSubOperation._EAMProcessSubPhase AS _EAMProcessSubPhase
FROM I_MaintenanceOrderSubOperation
LEFT OUTER JOIN I_MaintOrderTechObj AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_MaintOrderOperTechObj AS _MaintenanceOrderOperation ON MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MaintOrderOperComp AS _MaintenanceOperationComponent ON MaintenanceOrder = _MaintenanceOperationComponent.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOperationComponent.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_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]
;