I_MfgOrderOperation

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_MfgOrderOperation.
-- 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: IPPMFGORDOPER

CREATE VIEW I_MfgOrderOperation AS
SELECT
  cast(afvg.OrderInternalID as pph_aufpl preserving type) AS OrderInternalBillOfOperations,
  cast(afvg.OrderOperationInternalID as operationinternalid preserving type) AS OrderIntBillOfOperationsItem,
  cast(aufv.ManufacturingOrder as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(afvg.Sequence as manufacturingordersequence preserving type) AS ManufacturingOrderSequence,
  afvc.Operation AS MfgOrderOperationOrSubOp,
  cast(aufv.ManufacturingOrderCategory as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(aufv.ManufacturingOrderType as manufacturingordertype preserving type) AS ManufacturingOrderType,
  cast(aufv.ProductionSupervisor as pph_fevor preserving type) AS ProductionSupervisor,
  cast(aufv.MRPController as pph_dispo preserving type) AS MRPController,
  cast(aufv.ResponsiblePlannerGroup as vagrp preserving type) AS ResponsiblePlannerGroup,
  cast(aufv.ProductConfiguration as product_configuration preserving type) AS ProductConfiguration,
  aufv.InspectionLot AS InspectionLot,
  aufv.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  cast(afvg.OperationText as mfgorderoperationtext preserving type) AS MfgOrderOperationText,
  afvg.Language AS Language,
  cast(afvg.StandardTextInternalID as pph_ktsch preserving type) AS OperationStandardTextCode,
  afvg.OperationIsToBeDeleted AS OperationIsToBeDeleted,
  afvg.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  afvp.Operation AS MfgOrderPhaseSuperiorOperation,
  cast(afvg.NumberOfCapacities as pph_anzkap preserving type) AS NumberOfCapacities,
  afvg.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  afvg.OperationImportance AS OperationImportance,
  cast(afvg.Plant as pwwrk preserving type) AS ProductionPlant,
  cast(afvg.WorkCenterInternalID as pph_arbid preserving type) AS WorkCenterInternalID,
  afvg.WorkCenterTypeCode AS WorkCenterTypeCode,
  cast(afvg.WorkCenterTypeCode_2 as vdm_arbty preserving type) AS WorkCenterTypeCode_2,
  cast(afvg.OperationControlProfile as pph_steus preserving type) AS OperationControlProfile,
  afvg.ControlRecipeDestination AS ControlRecipeDestination,
  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 ManufacturingObject,
  afvg.OperationTrackingNumber AS OperationTrackingNumber,
  cast(afvg.BillOfOperationsType as billofoperationstype preserving type) AS BillOfOperationsType,
  afvg.BillOfOperationsGroup AS BillOfOperationsGroup,
  afvg.BillOfOperationsVariant AS BillOfOperationsVariant,
  afvg.BillOfOperationsSequence AS BillOfOperationsSequence,
  afvg.BOOOperationInternalID AS BOOOperationInternalID,
  afvg.BillOfOperationsVersion AS BillOfOperationsVersion,
  cast(afvg.BillOfMaterialCategory as pph_stlty preserving type) AS BillOfMaterialCategory,
  afvg.BillOfMaterialInternalID 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.PurgInfoRecdDataIsFixed AS PurgInfoRecdDataIsFixed,
  cast(afvg.PurchasingInfoRecordCategory as pph_esokz preserving type) AS PurchasingInfoRecordCategory,
  afvg.OpExternalProcessingPriceUnit AS OpExternalProcessingPriceUnit,
  afvg.Supplier AS Supplier,
  cast(afvg.GoodsRecipientName as pph_wempf preserving type) AS GoodsRecipientName,
  afvg.UnloadingPointName AS UnloadingPointName,
  afvg.Currency AS OpExternalProcessingCurrency,
  afvg.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  afvg.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  afvg.CompanyCode AS CompanyCode,
  afvg.BusinessArea AS BusinessArea,
  aufv.ControllingArea AS ControllingArea,
  afvg.ProfitCenter AS ProfitCenter,
  afvg.RequestingCostCenter AS RequestingCostCenter,
  afvg.CostElement AS CostElement,
  afvg.CostingVariant AS CostingVariant,
  afvg.CostingSheet AS CostingSheet,
  afvg.CostEstimate AS CostEstimate,
  afvg.ControllingObjectCurrency AS ControllingObjectCurrency,
  afvg.ControllingObjectClass AS ControllingObjectClass,
  afvg.FunctionalArea AS FunctionalArea,
  afvg.TaxJurisdiction AS TaxJurisdiction,
  cast(afvg.EmployeeWageType as pph_loart preserving type) AS EmployeeWageType,
  cast(afvg.EmployeeWageGroup as pph_logrp preserving type) AS EmployeeWageGroup,
  cast(afvg.EmployeeSuitability as pph_qualf preserving type) AS EmployeeSuitability,
  afvg.NumberOfTimeTickets AS NumberOfTimeTickets,
  cast(afvg.Personnel as pph_pernr preserving type) AS Personnel,
  cast(afvg.NumberOfEmployees as pph_anzms preserving type) AS NumberOfEmployees,
  cast(afvg.OperationSetupGroupCategory as pph_rfgrp preserving type) AS OperationSetupGroupCategory,
  cast(afvg.OperationSetupGroup as pph_rfsch preserving type) AS OperationSetupGroup,
  cast(afvg.OperationSetupType as pph_rasch preserving type) AS OperationSetupType,
  afvg.OperationOverlappingIsRequired AS OperationOverlappingIsRequired,
  afvg.OperationOverlappingIsPossible AS OperationOverlappingIsPossible,
  afvg.OperationsIsAlwaysOverlapping AS OperationsIsAlwaysOverlapping,
  afvg.OperationSplitIsRequired AS OperationSplitIsRequired,
  afvg.MaximumNumberOfSplits AS MaximumNumberOfSplits,
  cast(afvg.LeadTimeReductionStrategy as pph_rstra preserving type) AS LeadTimeReductionStrategy,
  afvg.OpSchedldReductionLevel AS OpSchedldReductionLevel,
  cast(afvg.OpErlstSchedldExecStrtDte as pph_fsavd preserving type) AS OpErlstSchedldExecStrtDte,
  cast(afvg.OpErlstSchedldExecStrtTme as pph_fsavz preserving type) AS OpErlstSchedldExecStrtTme,
  cast(afvg.OpErlstSchedldProcgStrtDte as pph_fssbd preserving type) AS OpErlstSchedldProcgStrtDte,
  cast(afvg.OpErlstSchedldProcgStrtTme as pph_fssbz preserving type) AS OpErlstSchedldProcgStrtTme,
  cast(afvg.OpErlstSchedldTrdwnStrtDte as pph_fssad preserving type) AS OpErlstSchedldTrdwnStrtDte,
  cast(afvg.OpErlstSchedldTrdwnStrtTme as pph_fssaz preserving type) AS OpErlstSchedldTrdwnStrtTme,
  cast(afvg.OpErlstSchedldExecEndDte as pph_fsedd preserving type) AS OpErlstSchedldExecEndDte,
  cast(afvg.OpErlstSchedldExecEndTme as pph_fsedz preserving type) AS OpErlstSchedldExecEndTme,
  cast(afvg.OpLtstSchedldExecStrtDte as pph_ssavd preserving type) AS OpLtstSchedldExecStrtDte,
  cast(afvg.OpLtstSchedldExecStrtTme as pph_ssavz preserving type) AS OpLtstSchedldExecStrtTme,
  cast(afvg.OpLtstSchedldProcgStrtDte as pph_sssbd preserving type) AS OpLtstSchedldProcgStrtDte,
  cast(afvg.OpLtstSchedldProcgStrtTme as pph_sssbz preserving type) AS OpLtstSchedldProcgStrtTme,
  cast(afvg.OpLtstSchedldTrdwnStrtDte as pph_sssad preserving type) AS OpLtstSchedldTrdwnStrtDte,
  cast(afvg.OpLtstSchedldTrdwnStrtTme as pph_sssaz preserving type) AS OpLtstSchedldTrdwnStrtTme,
  cast(afvg.OpLtstSchedldExecEndDte as pph_ssedd preserving type) AS OpLtstSchedldExecEndDte,
  cast(afvg.OpLtstSchedldExecEndTme as pph_ssedz preserving type) AS OpLtstSchedldExecEndTme,
  cast(afvg.OperationConfirmedStartDate as pph_isavd preserving type) AS OperationConfirmedStartDate,
  cast(afvg.OperationConfirmedEndDate as pph_ieavd preserving type) AS OperationConfirmedEndDate,
  cast(afvg.OpActualExecutionStartDate as vdm_isdd preserving type) AS OpActualExecutionStartDate,
  cast(afvg.OpActualExecutionStartTime as vdm_isdz preserving type) AS OpActualExecutionStartTime,
  cast(afvg.OpActualSetupEndDate as vdm_ierd preserving type) AS OpActualSetupEndDate,
  cast(afvg.OpActualSetupEndTime as vdm_ierz preserving type) AS OpActualSetupEndTime,
  cast(afvg.OpActualProcessingStartDate as vdm_isbd preserving type) AS OpActualProcessingStartDate,
  cast(afvg.OpActualProcessingStartTime as vdm_isbz preserving type) AS OpActualProcessingStartTime,
  cast(afvg.OpActualProcessingEndDate as vdm_iebd preserving type) AS OpActualProcessingEndDate,
  cast(afvg.OpActualProcessingEndTime as vdm_iebz preserving type) AS OpActualProcessingEndTime,
  cast(afvg.OpActualTeardownStartDate as vdm_isad preserving type) AS OpActualTeardownStartDate,
  cast(afvg.OpActualTeardownStartTme as vdm_isaz preserving type) AS OpActualTeardownStartTme,
  cast(afvg.OpActualExecutionEndDate as vdm_iedd preserving type) AS OpActualExecutionEndDate,
  cast(afvg.OpActualExecutionEndTime as vdm_iedz preserving type) AS OpActualExecutionEndTime,
  cast(afvg.SchedldFcstdEarliestStartDate as pph_fpavd preserving type) AS SchedldFcstdEarliestStartDate,
  cast(afvg.SchedldFcstdEarliestStartTime as pph_fpavz preserving type) AS SchedldFcstdEarliestStartTime,
  cast(afvg.SchedldFcstdEarliestEndDate as pph_fpedd preserving type) AS SchedldFcstdEarliestEndDate,
  cast(afvg.SchedldFcstdEarliestEndTime as pph_fpedz preserving type) AS SchedldFcstdEarliestEndTime,
  cast(afvg.LatestSchedldFcstdStartDate as pph_spavd preserving type) AS LatestSchedldFcstdStartDate,
  cast(afvg.SchedldFcstdLatestStartTime as pph_spavz preserving type) AS SchedldFcstdLatestStartTime,
  cast(afvg.LatestSchedldFcstdEndDate as pph_spedd preserving type) AS LatestSchedldFcstdEndDate,
  cast(afvg.SchedldFcstdLatestEndTime as pph_spedz preserving type) AS SchedldFcstdLatestEndTime,
  afvg.EarliestScheduledWaitStartDate AS EarliestScheduledWaitStartDate,
  afvg.EarliestScheduledWaitStartTime AS EarliestScheduledWaitStartTime,
  afvg.EarliestScheduledWaitEndDate AS EarliestScheduledWaitEndDate,
  afvg.EarliestScheduledWaitEndTime AS EarliestScheduledWaitEndTime,
  afvg.LatestScheduledWaitStartDate AS LatestScheduledWaitStartDate,
  afvg.LatestScheduledWaitStartTime AS LatestScheduledWaitStartTime,
  afvg.LatestScheduledWaitEndDate AS LatestScheduledWaitEndDate,
  afvg.LatestScheduledWaitEndTime AS LatestScheduledWaitEndTime,
  afvg.BreakDurationUnit AS BreakDurationUnit,
  afvg.PlannedBreakDuration AS PlannedBreakDuration,
  afvg.ConfirmedBreakDuration AS ConfirmedBreakDuration,
  cast(afvg.OverlapMinimumDurationUnit as pph_dzeimu preserving type) AS OverlapMinimumDurationUnit,
  afvg.OverlapMinimumDuration AS OverlapMinimumDuration,
  afvg.MaximumWaitDurationUnit AS MaximumWaitDurationUnit,
  afvg.MaximumWaitDuration AS MaximumWaitDuration,
  afvg.MinimumWaitDurationUnit AS MinimumWaitDurationUnit,
  afvg.MinimumWaitDuration AS MinimumWaitDuration,
  afvg.StandardMoveDurationUnit AS StandardMoveDurationUnit,
  afvg.StandardMoveDuration AS StandardMoveDuration,
  afvg.StandardQueueDurationUnit AS StandardQueueDurationUnit,
  afvg.StandardQueueDuration AS StandardQueueDuration,
  afvg.MinimumQueueDurationUnit AS MinimumQueueDurationUnit,
  afvg.MinimumQueueDuration AS MinimumQueueDuration,
  afvg.MinimumMoveDurationUnit AS MinimumMoveDurationUnit,
  afvg.MinimumMoveDuration AS MinimumMoveDuration,
  afvg.OperationStandardDuration AS OperationStandardDuration,
  afvg.OperationStandardDurationUnit AS OperationStandardDurationUnit,
  afvg.MinimumDuration AS MinimumDuration,
  afvg.MinimumDurationUnit AS MinimumDurationUnit,
  afvg.MinimumProcessingDuration AS MinimumProcessingDuration,
  afvg.MinimumProcessingDurationUnit AS MinimumProcessingDurationUnit,
  afvg.ScheduledMoveDuration AS ScheduledMoveDuration,
  afvg.ScheduledMoveDurationUnit AS ScheduledMoveDurationUnit,
  afvg.ScheduledQueueDuration AS ScheduledQueueDuration,
  afvg.ScheduledQueueDurationUnit AS ScheduledQueueDurationUnit,
  afvg.ScheduledWaitDuration AS ScheduledWaitDuration,
  afvg.ScheduledWaitDurationUnit AS ScheduledWaitDurationUnit,
  cast(afvg.PlannedDeliveryDuration as pph_plifz preserving type) AS PlannedDeliveryDuration,
  afvg.OpPlannedSetupDurn AS OpPlannedSetupDurn,
  afvg.OpPlannedSetupDurnUnit AS OpPlannedSetupDurnUnit,
  afvg.OpPlannedProcessingDurn AS OpPlannedProcessingDurn,
  cast(afvg.OpPlannedProcessingDurnUnit as pph_beaze preserving type) AS OpPlannedProcessingDurnUnit,
  afvg.OpPlannedTeardownDurn AS OpPlannedTeardownDurn,
  afvg.OpPlannedTeardownDurnUnit AS OpPlannedTeardownDurnUnit,
  afvg.FcstdStandardDurationUnit AS FcstdStandardDurationUnit,
  afvg.StartDateOffsetReferenceCode AS StartDateOffsetReferenceCode,
  afvg.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  afvg.StartDateOffsetDuration AS StartDateOffsetDuration,
  afvg.EndDateOffsetReferenceCode AS EndDateOffsetReferenceCode,
  afvg.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  afvg.EndDateOffsetDuration AS EndDateOffsetDuration,
  cast(afvg.OperationUnit as operationunit preserving type) AS OperationUnit,
  afvg.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  afvg.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  afvg.OperationScrapPercent AS OperationScrapPercent,
  afvg.OperationReferenceQuantity AS OperationReferenceQuantity,
  afvg.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  afvg.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  (afvg.OpPlannedTotalQuantity - afvg.OpPlannedScrapQuantity) AS OpPlannedYieldQuantity,
  afvg.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  afvg.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  afvg.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
  cast(aufv.ProductionUnit as productionunit preserving type) AS ProductionUnit,
  afvg.OpTotConfdYieldQtyInOrdQtyUnit AS OpTotConfdYieldQtyInOrdQtyUnit,
  afvg.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
  afvg.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
  afvg.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  afvg.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
  afvg.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
  afvg.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  afvg.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
  afvg.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
  afvg.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  afvg.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
  afvg.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
  afvg.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  afvg.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
  afvg.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
  afvg.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  afvg.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
  afvg.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
  afvg.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  cast(afvg.WorkCenterStandardWorkQtyUnit1 as pph_vge01 preserving type) AS WorkCenterStandardWorkQtyUnit1,
  afvg.WorkCenterStandardWorkQty1 AS WorkCenterStandardWorkQty1,
  afvg.CostCtrActivityType1 AS CostCtrActivityType1,
  cast(afvg.WorkCenterStandardWorkQtyUnit2 as pph_vge02 preserving type) AS WorkCenterStandardWorkQtyUnit2,
  afvg.WorkCenterStandardWorkQty2 AS WorkCenterStandardWorkQty2,
  afvg.CostCtrActivityType2 AS CostCtrActivityType2,
  cast(afvg.WorkCenterStandardWorkQtyUnit3 as pph_vge03 preserving type) AS WorkCenterStandardWorkQtyUnit3,
  afvg.WorkCenterStandardWorkQty3 AS WorkCenterStandardWorkQty3,
  afvg.CostCtrActivityType3 AS CostCtrActivityType3,
  cast(afvg.WorkCenterStandardWorkQtyUnit4 as pph_vge04 preserving type) AS WorkCenterStandardWorkQtyUnit4,
  afvg.WorkCenterStandardWorkQty4 AS WorkCenterStandardWorkQty4,
  afvg.CostCtrActivityType4 AS CostCtrActivityType4,
  cast(afvg.WorkCenterStandardWorkQtyUnit5 as pph_vge05 preserving type) AS WorkCenterStandardWorkQtyUnit5,
  afvg.WorkCenterStandardWorkQty5 AS WorkCenterStandardWorkQty5,
  afvg.CostCtrActivityType5 AS CostCtrActivityType5,
  cast(afvg.WorkCenterStandardWorkQtyUnit6 as pph_vge06 preserving type) AS WorkCenterStandardWorkQtyUnit6,
  afvg.WorkCenterStandardWorkQty6 AS WorkCenterStandardWorkQty6,
  afvg.CostCtrActivityType6 AS CostCtrActivityType6,
  afvg.BusinessProcess AS BusinessProcess,
  afvg.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  afvg.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  afvg.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
  afvg.BusinessProcRemainingQtyUnit AS BusinessProcRemainingQtyUnit,
  cast(afvg.BusinessProcessRemainingQty as pph_oprz1 preserving type) AS BusinessProcessRemainingQty,
  afvg.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  afvg.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  afvg.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  afvg.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  afvg.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  afvg.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  afvg.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  afvg.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  afvg.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  afvg.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  afvg.FreeDefinedAmount1 AS FreeDefinedAmount1,
  afvg.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  afvg.FreeDefinedAmount2 AS FreeDefinedAmount2,
  afvg.FreeDefinedDate1 AS FreeDefinedDate1,
  afvg.FreeDefinedDate2 AS FreeDefinedDate2,
  afvg.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  afvg.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  afvg._LongText AS _LongText
FROM I_OrderOperation AS afvg
INNER JOIN I_MfgOrderBasic AS aufv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _SuperiorOperation ON OrderInternalBillOfOperations = _SuperiorOperation.OrderInternalID AND SuperiorOperationInternalID = _SuperiorOperation.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_OperationStandardText AS _OperationStandardTextCode ON OperationStandardTextCode = _OperationStandardTextCode.OperationStandardTextCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.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_MRPController AS _MRPController ON ProductionPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_ResponsiblePlannerGroup AS _ResponsiblePlannerGroup ON ProductionPlant = _ResponsiblePlannerGroup.Plant AND ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType_2 ON WorkCenterTypeCode_2 = _WorkCenterType_2.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter_2 ON WorkCenterTypeCode_2 = _WorkCenter_2.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter_2.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_BillOfOperations AS _BillOfOperationsVariant ON BillOfOperationsType = _BillOfOperationsVariant.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsVariant.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsVariant.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsSequence 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_ControlRecipeDestination AS _ControlRecipeDestination ON ProductionPlant = _ControlRecipeDestination.Plant AND ControlRecipeDestination = _ControlRecipeDestination.ControlRecipeDestination  -- 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_PurchaseOrderAPI01 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- 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_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON ProductionPlant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
LEFT OUTER JOIN I_EmployeeWageGroup AS _EmployeeWageGroup ON ProductionPlant = _EmployeeWageGroup.Plant AND EmployeeWageGroup = _EmployeeWageGroup.EmployeeWageGroup  -- association [0..1]
LEFT OUTER JOIN I_EmployeeSuitability AS _EmployeeSuitability ON ProductionPlant = _EmployeeSuitability.Plant AND EmployeeSuitability = _EmployeeSuitability.EmployeeSuitability  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employee ON Personnel = _Employee.EmploymentInternalID  -- association [0..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_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_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_OperationSetupGroupCategory AS _OperationSetupGroupCategory ON ProductionPlant = _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 ProductionPlant = _OperationSetupGroup.Plant  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupType AS _OperationSetupType ON OperationSetupType = _OperationSetupType.OperationSetupType AND ProductionPlant = _OperationSetupType.Plant  -- association [0..1]
LEFT OUTER JOIN I_LeadTimeReductionStrategy AS _LeadTimeReductionStrategy ON LeadTimeReductionStrategy = _LeadTimeReductionStrategy.LeadTimeReductionStrategy AND ProductionPlant = _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_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _OpExternalProcessingCurrency ON OpExternalProcessingCurrency = _OpExternalProcessingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _SetupOpActyNtwkInstance ON SetupOpActyNtwkInstance = _SetupOpActyNtwkInstance.OpActyNtwkInstance  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _ProduceOpActyNtwkInstance ON ProduceOpActyNtwkInstance = _ProduceOpActyNtwkInstance.OpActyNtwkInstance  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _TeardownOpActyNtwkInstance ON TeardownOpActyNtwkInstance = _TeardownOpActyNtwkInstance.OpActyNtwkInstance  -- association [0..1]
;