I_MaintenanceOrderSubOperation

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_MaintenanceOrderSubOperation.
-- 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: IMAINTORDSOP

CREATE VIEW I_MaintenanceOrderSubOperation AS
SELECT
  afko.aufnr AS MaintenanceOrder,
  afvc_superior.vornr AS MaintenanceOrderOperation,
  afvc.vornr AS MaintenanceOrderSubOperation,
  afvc.aufpl AS MaintOrderRoutingNumber,
  afvc.aplzl AS MaintOrderOperationCounter,
  afvc.sumnr AS SuperiorOrderIntBillOfOpItem,
  afvc.steus AS OperationControlKey,
  afvc.ltxa1 AS OperationDescription,
  afvc.equnr AS Equipment,
  afvc.tplnr AS FunctionalLocation,
  afvc.werks AS Plant,
  'A' AS OperationWorkCenterTypeCode,
  afvc.arbid AS OperationWorkCenterInternalID,
  afvc.pernr AS OperationPersonResponsible,
  afvc.anzzl AS NumberOfCapacities,
  afvc.sortl AS OperationPurgInfoRecdSearchTxt,
  afvc.afnam AS OperationRequisitionerName,
  afvc.wempf AS OperationGoodsRecipientName,
  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.bedzl AS CapacityRequirementItem,
  afvc.banfn AS PurchaseRequisition,
  afvc.objnr AS MaintOrderOperationInternalID,
  afvc.bnfpo AS PurchaseRequisitionItem,
  afvc.matkl AS MaterialGroup,
  afvc.sakto AS CostElement,
  afvc.frdlb AS ExtProcgOperationHasSubcontrg,
  afvc.ekorg AS PurchasingOrganization,
  afvc.ekgrp AS PurchasingGroup,
  e.g. activity type afvc.rueck as MaintOrderConfirmation AS rueckasMaintOrderConfirmation,
  afvc.rmzhl AS MaintOrderConfCntrValue,
  afvc.maintordopprocessphasecode AS MaintOrdOpProcessPhaseCode,
  afvc.maintordopprocesssubphasecode AS MaintOrdOpProcessSubPhaseCode,
  cast( afvc.maintopexecutionphasecode as eam_premainpost_cds preserving type ) AS MaintOperationExecStageCode,
  cast(afvc.txtsp as spras) AS Language,
  afvc.cl_type AS MaintOperationalChecklistType,
  afvc.maintenancejobverification AS MaintenanceJobVerification
FROM afvc
INNER JOIN afvc AS afvc_superior ON /* join condition not captured in parsed metadata */
INNER JOIN afko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintOrderOperPlanningValues AS _OperationPlanningValues ON MaintOrderRoutingNumber = _OperationPlanningValues.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _OperationPlanningValues.MaintOrderOperationCounter  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderComponent_2 AS _MaintenanceOrderComponent ON MaintenanceOrder = _MaintenanceOrderComponent.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOrderComponent.MaintenanceOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON OperationWorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND OperationWorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode  -- association [0..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_OperationControlProfile AS _OperationControlKey ON OperationControlKey = _OperationControlKey.OperationControlProfile  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationSystCondition AS _OperationSystemCondition ON OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- 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_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _OperationHasLongText ON OperationHasLongText = _OperationHasLongText.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON OperationSupplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonResponsible ON OperationPersonResponsible = _PersonResponsible.PersonWorkAgreement  -- 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_PMContactCardEmployee AS _PMContactEmployee ON OperationPersonResponsible = _PMContactEmployee.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _WorkAssignment ON OperationPersonResponsible = _WorkAssignment.WorkAssignment  -- association [0..1]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOperationExecStageCode ON MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode  -- association [1..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]
;