I_MaintOrderOperAndSubOper

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_MaintOrderOperAndSubOper.
-- 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: IMTORDOPSOPR

CREATE VIEW I_MaintOrderOperAndSubOper AS
SELECT
  afko.aufnr AS MaintenanceOrder,
  coalesce( afvc_superior.vornr, afvc.vornr ) AS MaintenanceOrderOperation,
  cast( afvc.vornr as maintenanceorderoperation preserving type ) AS MaintOrderOperationForEdit,
  afvc.aufpl AS MaintOrderRoutingNumber,
  afvc.aplzl AS MaintOrderOperationCounter,
  afvc.sumnr AS SuperiorOperationInternalID,
  afvc.objnr AS MaintOrderOperationInternalID,
  afvc.steus AS OperationControlKey,
  afvc.ltxa1 AS OperationDescription,
  afvc.ktsch AS OperationStandardTextCode,
  afvc.loanz AS NumberOfTimeTickets,
  afvc.pernr AS OperationPersonResponsible,
  afvc.werks AS Plant,
  afvc.arbid AS OperationWorkCenterInternalID,
  'A' AS OperationWorkCenterTypeCode,
  afvc.anzzl AS NumberOfCapacities,
  afvc.rueck AS MaintOrderConfirmation,
  afvc.equnr AS Equipment,
  cast ( afvc.tplnr as vdm_eam_tplnr ) AS FunctionalLocation,
  afvc.sortl AS OperationPurgInfoRecdSearchTxt,
  afvc.afnam AS OperationRequisitionerName,
  afvc.wempf AS OperationGoodsRecipientName,
  afvv.bmsch AS OperationQuantity,
  afvv.meinh AS OperationQuantityUnit,
  afvc.larnt AS ActivityType,
  afvc.preis AS OpExternalProcessingPrice,
  afvc.peinh AS OpExternalProcessingPriceUnit,
  afvc.waers AS OpExternalProcessingCurrency,
  afvc.bednr AS OperationTrackingNumber,
  afvc.infnr AS OperationPurchasingInfoRecord,
  afvc.ablad AS OperationUnloadingPointName,
  cast (afvc.ebeln as konnr) AS OpPurchaseOutlineAgreement,
  cast (afvc.ebelp as ktpnr) AS OpPurchaseOutlineAgreementItem,
  afvc.lifnr AS OperationSupplier,
  afvc.istru AS Assembly,
  afvc.anlzu AS OperationSystemCondition,
  afvc.larnt AS CostCtrActivityType,
  afvc.anfkokrs AS ReqgCostCenterControllingArea,
  afvc.indet AS OperationCalculationControl,
  afvc.prznt AS OperationWorkPercent,
  afvc.bedid AS CapacityRequirement,
  afvc.banfn AS PurchaseRequisition,
  afvc.bnfpo AS PurchaseRequisitionItem,
  afvc.matkl AS MaterialGroup,
  afvc.sakto AS CostElement,
  afvc.ekorg AS PurchasingOrganization,
  afvc.ekgrp AS PurchasingGroup,
  cast(afvc.txtsp as spras preserving type) AS Language,
  cast(case when afvc.txtsp = '' then '' else 'X' end as xfeld) AS OperationHasLongText,
  afvv.plifz AS EAMPlannedDeliveryDurnInDays,
  afvv.dauno AS MaintOrderOperationDuration,
  afvv.daune AS MaintOrdOperationDurationUnit,
  afvv.einsa AS OpBscStartDateConstraintType,
  afvv.einse AS OpBscEndDateConstraintType,
  afvv.arbei AS MaintOrdOperationWorkDuration,
  afvv.arbeh AS MaintOrdOpWorkDurationUnit,
  afvv.ntanf AS ConstraintDateForBscStartDate,
  afvv.ntanz AS ConstraintTimeForBscStartTime,
  afvv.ntend AS ConstraintDateForBscFinishDate,
  afvv.ntenz AS ConstraintTimeForBscFinishTime,
  afvv.aufkt AS MaintOrdOperationExecutionRate,
  afvc.gsber AS BusinessArea,
  cast( afvc.projn as ps_s4_pspnr preserving type ) AS MaintOrdOpAssgdWBSElmntInt,
  afvc.prctr AS ProfitCenter,
  afvc.kalsm AS CostingSheet,
  afvc.txjcd AS TaxJurisdiction,
  afvc.func_area AS FunctionalArea,
  afvc.fldlogsdelivisheldonshore AS FldLogsDelivHdrIsHeldOnShore,
  afvc.fordn AS MaintOrdOpFrameWorkOrder,
  afvc.fordp AS MaintOrdOpFrameWorkOrderItem,
  afvc.frdlb AS ExtProcgOperationHasSubcontrg,
  afvc.loart AS EmployeeWageType,
  afvc.logrp AS EmployeeWageGroup,
  afvc.qualf AS EmployeeSuitability,
  cast( afvc.scope as ps_s4_scope_cv preserving type ) AS MaintControllingObjectClass,
  afvc.vertl AS WrkCtrIntCapRqmtsDistr,
  afvc.zschl AS MaintOrdOperationOverheadCode,
  afvv.mgvrg AS MaintOrderOperationQuantity,
  afvv.meinh AS MaintOrdOperationQuantityUnit,
  cast( afvc.maintopexecutionphasecode as eam_premainpost_cds preserving type ) AS MaintOperationExecStageCode,
  afvc.mlstn AS OperationMilestoneUsageCode,
  afvc.rmzhl AS MaintOrderConfCntrValue,
  aufk.kokrs AS ControllingArea,
  afvc.loekz AS IsMarkedForDeletion,
  afvv.fsavd AS OpErlstSchedldExecStrtDte,
  afvv.fsavz AS OpErlstSchedldExecStrtTme,
  afvv.fsedd AS OpErlstSchedldExecEndDte,
  afvv.fsedz AS OpErlstSchedldExecEndTme,
  afvv.ssavd AS OpLtstSchedldExecStrtDte,
  afvv.ssavz AS OpLtstSchedldExecStrtTme,
  afvv.ssedd AS OpLtstSchedldExecEndDte,
  afvv.ssedz AS OpLtstSchedldExecEndTme,
  afvv.isdd AS OpActualExecutionStartDate,
  afvv.isdz AS OpActualExecutionStartTime,
  afvv.iedd AS OpActualExecutionEndDate,
  afvv.iedz AS OpActualExecutionEndTime,
  afvv.pedd AS ActyConfFcstdEndDate,
  afvv.pedz AS ActyConfFcstdEndTime,
  afvv.ismnw AS ActualWorkQuantity,
  cast(afvc.sched_end as cc4_delvry_date_adj_oper preserving type) AS MaintOrdOpDelivDateAdjustment,
  afvc.maintordopprocessphasecode AS MaintOrdOpProcessPhaseCode,
  afvc.maintordopprocesssubphasecode AS MaintOrdOpProcessSubPhaseCode,
  afvc.allmaintordcompcmtdqtsarekept AS AllMaintOrdCompCmtdQtsAreKept,
  afvc.leknw AS MaintOrdOpHasNoRemainingWork,
  afvc.maintordophasleanservices AS MaintOrdOpHasLeanServices,
  afvc.plnty AS TaskListType,
  afvc.plnnr AS TaskListGroup,
  afvc.plnal AS TaskListGroupCounter
FROM afvc
INNER JOIN afko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintOrdOpAdditionalData AS _MaintOrdOpAdditionalData ON MaintOrderRoutingNumber = _MaintOrdOpAdditionalData.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _MaintOrdOpAdditionalData.MaintenanceOrderRoutingNode  -- association [1..1]
LEFT OUTER JOIN I_MaintOrderOperPlanningValues AS _OperationPlanningValues ON MaintOrderRoutingNumber = _OperationPlanningValues.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _OperationPlanningValues.MaintOrderOperationCounter  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = OperationWorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = OperationWorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlKey ON _OperationControlKey.OperationControlProfile = OperationControlKey  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderBasic AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _StatusObjectActiveStatus ON _StatusObjectActiveStatus.StatusObject = MaintOrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_OrderProdnResourceTool AS _MaintOrderProdnRsceTool ON _MaintOrderProdnRsceTool.OrderInternalBillOfOperations = MaintOrderRoutingNumber AND _MaintOrderProdnRsceTool.OrderIntBillOfOperationsItem = MaintOrderOperationCounter  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceOrderComponent_2 AS _MaintOrderComponent ON _MaintOrderComponent.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _MaintOrderComponent.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..*]
LEFT OUTER JOIN I_MaintOrderOperObjectListLink AS _MaintOrderOperObjectListLink ON MaintOrderOperationCounter = _MaintOrderOperObjectListLink.MaintOrderOperationCounter AND MaintOrderRoutingNumber = _MaintOrderOperObjectListLink.MaintOrderRoutingNumber  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _PersonResponsible ON OperationPersonResponsible = _PersonResponsible.PersonExternalID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON OperationSupplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOperationExecStageCode ON MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _OpExternalProcessingCurrency ON OpExternalProcessingCurrency = _OpExternalProcessingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON MaintOrderOperationInternalID = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _OperationSystemCondition ON OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_OperationCalculationControl AS _OperationCalculationControl ON OperationCalculationControl = _OperationCalculationControl.OperationCalculationControl  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _OperationHasLongText ON OperationHasLongText = _OperationHasLongText.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderConfirmation AS _MaintenanceOrderConf ON MaintOrderConfirmation = _MaintenanceOrderConf.MaintOrderConf AND MaintOrderConfCntrValue = _MaintenanceOrderConf.MaintOrderConfCntrValue  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON ControllingArea = _CostCenterActivityTypeText.ControllingArea AND CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_PMContactCardEmployee AS _PMContactEmployee ON OperationPersonResponsible = _PMContactEmployee.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON OperationPersonResponsible = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _WorkAssignment ON OperationPersonResponsible = _WorkAssignment.WorkAssignment  -- association [0..1]
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_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurReqnOrResvnGeneration AS _PurReqnOrResvnGeneration ON MaintOrdOperationIsMRPRelevant = _PurReqnOrResvnGeneration.PurReqnOrResvnGeneration  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdOpDeliveryDateAdjmt AS _MaintOrdOpDeliveryDateAdjmt ON MaintOrdOpDelivDateAdjustment = _MaintOrdOpDeliveryDateAdjmt.MaintOrdOpDelivDateAdjustment  -- association [0..1]
;