I_ProductionOrderOperation_2

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_ProductionOrderOperation_2.
-- 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 I_ProductionOrderOperation_2 AS
SELECT
  cast(afvg.OrderInternalID as pph_aufpl preserving type) AS OrderInternalID,
  cast(afvg.OrderOperationInternalID as operationinternalid preserving type) AS OrderOperationInternalID,
  cast(aufv.ManufacturingOrder as vdm_manufacturingorder preserving type) AS ProductionOrder,
  cast(afvg.Sequence as vdm_prodnordersequence preserving type) AS ProductionOrderSequence,
  cast(afvg.Operation_2 as vdm_prodnorderoperation preserving type) AS ProductionOrderOperation,
  cast(aufv.ManufacturingOrderType as vdm_prodnordertype preserving type) AS ProductionOrderType,
  cast(aufv.ProductionSupervisor as pph_fevor preserving type) AS ProductionSupervisor,
  cast(aufv.MRPController as pph_dispo preserving type) AS MRPController,
  afvg.OperationText AS ProductionOrderOperationText,
  cast(afvg.StandardTextInternalID as pph_ktsch preserving type) AS OperationStandardTextCode,
  afvg.Language AS LongTextLanguage,
  afvg.OperationIsToBeDeleted AS OperationIsToBeDeleted,
  cast(afvg.NumberOfCapacities as pph_anzkap preserving type) AS NumberOfCapacities,
  afvg.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  afvg.Plant AS Plant,
  cast(afvg.WorkCenterInternalID as pph_arbid preserving type) AS WorkCenterInternalID,
  cast(afvg.WorkCenterTypeCode_2 as vdm_arbty preserving type) AS WorkCenterType,
  cast(afvg.OperationControlProfile as pph_steus preserving type) AS OperationControlProfile,
  afvg.OperationConfirmation AS OperationConfirmation,
  cast(afvg.NumberOfOperationConfirmations as pph_noofconf preserving type) AS NumberOfOperationConfirmations,
  cast(afvg.FactoryCalendar as cr_wfcid preserving type) AS FactoryCalendar,
  afvg.CapacityRequirement AS CapacityRequirement,
  cast(afvg.CapacityRequirementItem as pph_bedzl preserving type) AS CapacityRequirementItem,
  afvg.ChangeNumber AS ChangeNumber,
  cast(afvg.ObjectInternalID as pph_objnr preserving type) AS ObjectInternalID,
  afvg.OperationTrackingNumber AS OperationTrackingNumber,
  afvg.NumberOfTimeTickets AS NumberOfTimeTickets,
  cast(afvg.NumberOfEmployees as pph_anzms preserving type) AS NumberOfEmployees,
  cast(afvg.BillOfOperationsType as billofoperationstype preserving type) AS BillOfOperationsType,
  afvg.BillOfOperationsGroup AS BillOfOperationsGroup,
  afvg.BillOfOperationsVariant AS BillOfOperationsVariant,
  cast(afvg.BillOfOperationsSequence as boosequence preserving type) AS BillOfOperationsSequence,
  afvg.BOOOperationInternalID AS BOOOperationInternalID,
  afvg.BillOfOperationsVersion AS BillOfOperationsVersion,
  cast(afvg.BillOfMaterialCategory as pph_stlty preserving type) AS BillOfMaterialCategory,
  afvg.BillOfMaterialInternalID_2 AS BillOfMaterialInternalID,
  cast(afvg.BillOfMaterialItemNodeNumber as pph_stlkn preserving type) AS BillOfMaterialItemNodeNumber,
  afvg.BOMItemNodeCount AS BOMItemNodeCount,
  afvg.ExtProcgOperationHasSubcontrg AS ExtProcgOperationHasSubcontrg,
  cast(afvg.PurchasingOrganization as pph_ekorg preserving type) AS PurchasingOrganization,
  afvg.PurchasingGroup AS PurchasingGroup,
  afvg.PurchaseRequisition AS PurchaseRequisition,
  cast(afvg.PurchaseRequisitionItem as pph_bnfpo preserving type) AS PurchaseRequisitionItem,
  cast(afvg.PurchasingDocument as pph_konnr preserving type) AS PurchaseOutlineAgreement,
  cast(afvg.PurchasingDocumentItem as pph_ktpnr preserving type) AS PurchaseOutlineAgreementItem,
  afvg.PurgInfoRecNonStockItmSortTerm AS PurgInfoRecNonStockItmSortTerm,
  cast(afvg.PurchasingInfoRecord as pph_infnr preserving type) AS PurchasingInfoRecord,
  cast(afvg.PurgInfoRecdDataIsFixed as vdm_kzfix preserving type) AS PurgInfoRecdDataIsFixed,
  cast(afvg.PurchasingInfoRecordCategory as pph_esokz preserving type) AS PurchasingInfoRecordCategory,
  afvg.Supplier AS Supplier,
  cast(afvg.PlannedDeliveryDuration as pph_plifz preserving type) AS PurchaseRequisitionPlndDlvDurn,
  cast(afvg.GoodsRecipientName as pph_wempf preserving type) AS GoodsRecipientName,
  afvg.UnloadingPointName AS UnloadingPointName,
  afvg.MaterialGroup AS MaterialGroup,
  afvg.InspectionLotType AS InspectionLotType,
  afvg.Currency AS OpExternalProcessingCurrency,
  afvg.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  afvg.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  afvg.CompanyCode AS CompanyCode,
  afvg.BusinessArea AS BusinessArea,
  aufv.ControllingArea AS ControllingArea
FROM I_OrderOperation AS afvg
INNER JOIN I_MfgOrderBasic AS aufv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionOrderInternalID AS _ProductionOrderInternal ON OrderInternalID = _ProductionOrderInternal.ProductionOrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrderType AS _ProductionOrderType ON ProductionOrderType = _ProductionOrderType.ProductionOrderType  -- association [1..1]
LEFT OUTER JOIN I_OperationStandardText AS _OperationStandardTextCode ON OperationStandardTextCode = _OperationStandardTextCode.OperationStandardTextCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductionUnit ON ProductionUnit = _ProductionUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationUnit ON OperationUnit = _OperationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON Plant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterType = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterType = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperationsVariant ON BillOfOperationsType = _BillOfOperationsVariant.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsVariant.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsVariant.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [0..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOOperationInternalID ON BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup AND BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_CapacityRequirement AS _CapacityRequirement ON CapacityRequirement = _CapacityRequirement.CapacityRequirement  -- association [0..1]
LEFT OUTER JOIN I_CapacityRequirementItem AS _CapacityRequirementItem ON CapacityRequirement = _CapacityRequirementItem.CapacityRequirement AND CapacityRequirementItem = _CapacityRequirementItem.CapacityRequirementItem  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationGroup AS _OperationConfirmation ON OperationConfirmation = _OperationConfirmation.ConfirmationGroup  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContractAPI01 AS _PurchaseContract ON PurchaseOutlineAgreement = _PurchaseContract.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContractItemAPI01 AS _PurchaseContractItem ON PurchaseOutlineAgreement = _PurchaseContractItem.PurchaseContract AND PurchaseOutlineAgreementItem = _PurchaseContractItem.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_SchedgagrmthdrApi01 AS _SchedulingAgreement ON PurchaseOutlineAgreement = _SchedulingAgreement .SchedulingAgreement  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtItmApi01 AS _SchedulingAgreementItem ON PurchaseOutlineAgreement = _SchedulingAgreementItem.SchedulingAgreement AND PurchaseOutlineAgreementItem = _SchedulingAgreementItem.SchedulingAgreementItem  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisition AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemAPI01 AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecordApi01 AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _RequestingCostCenter ON ControllingArea = _RequestingCostCenter.ControllingArea AND RequestingCostCenter = _RequestingCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ControllingArea = _CostElement.ControllingArea AND CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _CostingVariant ON CostingVariant = _CostingVariant.CostingVariant  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingObjectCurrency ON ControllingObjectCurrency = _ControllingObjectCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _OpExternalProcessingCurrency ON OpExternalProcessingCurrency = _OpExternalProcessingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BusinessProcessEntryUnit ON BusinessProcessEntryUnit = _BusinessProcessEntryUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmedWorkQuantityUnit1 ON WorkQuantityUnit1 = _ConfirmedWorkQuantityUnit1.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmedWorkQuantityUnit2 ON WorkQuantityUnit2 = _ConfirmedWorkQuantityUnit2.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmedWorkQuantityUnit3 ON WorkQuantityUnit3 = _ConfirmedWorkQuantityUnit3.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmedWorkQuantityUnit4 ON WorkQuantityUnit4 = _ConfirmedWorkQuantityUnit4.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmedWorkQuantityUnit5 ON WorkQuantityUnit5 = _ConfirmedWorkQuantityUnit5.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmedWorkQuantityUnit6 ON WorkQuantityUnit6 = _ConfirmedWorkQuantityUnit6.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit1 ON WorkCenterStandardWorkQtyUnit1 = _StdWorkQuantityUnit1.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit2 ON WorkCenterStandardWorkQtyUnit2 = _StdWorkQuantityUnit2.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit3 ON WorkCenterStandardWorkQtyUnit3 = _StdWorkQuantityUnit3.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit4 ON WorkCenterStandardWorkQtyUnit4 = _StdWorkQuantityUnit4.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit5 ON WorkCenterStandardWorkQtyUnit5 = _StdWorkQuantityUnit5.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit6 ON WorkCenterStandardWorkQtyUnit6 = _StdWorkQuantityUnit6.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupGroupCategory AS _OperationSetupGroupCategory ON Plant = _OperationSetupGroupCategory.Plant AND OperationSetupGroupCategory = _OperationSetupGroupCategory.OperationSetupGroupCategory  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupGroup AS _OperationSetupGroup ON OperationSetupGroup = _OperationSetupGroup.OperationSetupGroup AND OperationSetupGroupCategory = _OperationSetupGroup.OperationSetupGroupCategory AND Plant = _OperationSetupGroup.Plant  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupType AS _OperationSetupType ON OperationSetupType = _OperationSetupType.OperationSetupType AND Plant = _OperationSetupType.Plant  -- association [0..1]
LEFT OUTER JOIN I_LeadTimeReductionStrategy AS _LeadTimeReductionStrategy ON LeadTimeReductionStrategy = _LeadTimeReductionStrategy.LeadTimeReductionStrategy AND Plant = _LeadTimeReductionStrategy.Plant  -- association [0..1]
LEFT OUTER JOIN I_OperationDateOffsetRefCode AS _StartDateOffsetReferenceCode ON StartDateOffsetReferenceCode = _StartDateOffsetReferenceCode.OperationDateOffsetRefCode  -- association [0..1]
LEFT OUTER JOIN I_OperationDateOffsetRefCode AS _EndDateOffsetReferenceCode ON EndDateOffsetReferenceCode = _EndDateOffsetReferenceCode.OperationDateOffsetRefCode  -- association [0..1]
LEFT OUTER JOIN I_StandardWorkFmlaParamGroup AS _StandardWorkFmlaParamGroup ON StandardWorkFormulaParamGroup = _StandardWorkFmlaParamGroup.StandardWorkFormulaParamGroup  -- association [0..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguage = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN E_OrderOperation AS _Extension ON OrderInternalID = _Extension.OrderInternalID AND OrderOperationInternalID = _Extension.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderHeader ON ProductionOrder = _ProductionOrderHeader.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantText ON Plant = _PlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderText ON ProductionOrder = _ProductionOrderText.ProductionOrder  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID AND WorkCenterType = _WorkCenterText.WorkCenterTypeCode  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObjectText ON ObjectInternalID = _StatusObjectText.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_ProductionOrderComponent AS _ProductionOrderComponent ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductionOrderTriggerPoint AS _ProductionOrderTriggerPoint ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProductionOrderPRT AS _ProductionOrderPRT ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProdnOrderOperationCapacity AS _ProdnOrderOperationCapacity ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProdnOrderOperationLongText AS _LongText ON /* condition not available in parsed metadata */  -- association [0..*]
;