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,
  afvg.CostElement AS CostElement,
  afvg.CostingVariant AS CostingVariant,
  afvg.CostingSheet AS CostingSheet,
  afvg.CostEstimate AS CostEstimate,
  afvg.ControllingObjectCurrency AS ControllingObjectCurrency,
  cast(afvg.ControllingObjectClass as pph_scope preserving type) AS ControllingObjectClass,
  afvg.FunctionalArea AS FunctionalArea,
  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.OverlapMinimumTransferQty AS OverlapMinimumTransferQty,
  afvg.MaximumNumberOfSplits AS MaximumNumberOfSplits,
  afvg.ActualNumberOfSplits AS ActualNumberOfSplits,
  afvg.MinProcessingDurnPerSplitUnit AS MinProcessingDurnPerSplitUnit,
  afvg.MinProcessingDurationPerSplit AS MinProcessingDurationPerSplit,
  cast(afvg.LeadTimeReductionStrategy as pph_rstra preserving type) AS LeadTimeReductionStrategy,
  afvg.OpSchedldReductionLevel AS OpSchedldReductionLevel,
  cast(afvg.OpErlstSchedldExecStrtDte as vdm_fsavd preserving type) AS OpErlstSchedldExecStrtDte,
  cast(afvg.OpErlstSchedldExecStrtTme as vdm_fsavz preserving type) AS OpErlstSchedldExecStrtTme,
  cast(afvg.OpErlstSchedldProcgStrtDte as vdm_fssbd preserving type) AS OpErlstSchedldProcgStrtDte,
  cast(afvg.OpErlstSchedldProcgStrtTme as vdm_fssbz preserving type) AS OpErlstSchedldProcgStrtTme,
  cast(afvg.OpErlstSchedldTrdwnStrtDte as vdm_fssad preserving type) AS OpErlstSchedldTrdwnStrtDte,
  cast(afvg.OpErlstSchedldTrdwnStrtTme as vdm_fssaz preserving type) AS OpErlstSchedldTrdwnStrtTme,
  cast(afvg.OpErlstSchedldExecEndDte as vdm_fsedd preserving type) AS OpErlstSchedldExecEndDte,
  cast(afvg.OpErlstSchedldExecEndTme as vdm_fsedz preserving type) AS OpErlstSchedldExecEndTme,
  cast(afvg.OpLtstSchedldExecStrtDte as vdm_ssavd preserving type) AS OpLtstSchedldExecStrtDte,
  cast(afvg.OpLtstSchedldExecStrtTme as vdm_ssavz preserving type) AS OpLtstSchedldExecStrtTme,
  cast(afvg.OpLtstSchedldProcgStrtDte as vdm_sssbd preserving type) AS OpLtstSchedldProcgStrtDte,
  cast(afvg.OpLtstSchedldProcgStrtTme as vdm_sssbz preserving type) AS OpLtstSchedldProcgStrtTme,
  cast(afvg.OpLtstSchedldTrdwnStrtDte as vdm_sssad preserving type) AS OpLtstSchedldTrdwnStrtDte,
  cast(afvg.OpLtstSchedldTrdwnStrtTme as vdm_sssaz preserving type) AS OpLtstSchedldTrdwnStrtTme,
  cast(afvg.OpLtstSchedldExecEndDte as vdm_ssedd preserving type) AS OpLtstSchedldExecEndDte,
  cast(afvg.OpLtstSchedldExecEndTme as vdm_ssedz preserving type) AS OpLtstSchedldExecEndTme,
  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,
  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,
  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,
  cast(afvg.MinimumDuration as vdm_daumin preserving type) AS MinimumDuration,
  cast(afvg.MinimumDurationUnit as vdm_daumine preserving type) 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,
  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.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  afvg.StartDateOffsetDuration AS StartDateOffsetDuration,
  afvg.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  afvg.EndDateOffsetDuration AS EndDateOffsetDuration,
  afvg.StandardWorkFormulaParamGroup AS StandardWorkFormulaParamGroup,
  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,
  cast((afvg.OpPlannedTotalQuantity - afvg.OpPlannedScrapQuantity) as vdm_gmeng) 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,
  cast(afvg.OpWorkQuantityUnit1 as vdm_ile01 preserving type) AS WorkQuantityUnit1,
  cast(afvg.OpConfirmedWorkQuantity1 as vdm_ism01 preserving type) AS ConfirmedWorkQuantity1,
  cast(afvg.NoFurtherOpWorkQuantity1IsExpd as vdm_lek01 preserving type) AS NoFurtherOpWorkQuantity1IsExpd,
  cast(afvg.OpWorkQuantityUnit2 as vdm_ile02 preserving type) AS WorkQuantityUnit2,
  cast(afvg.OpConfirmedWorkQuantity2 as vdm_ism02 preserving type) AS ConfirmedWorkQuantity2,
  cast(afvg.NoFurtherOpWorkQuantity2IsExpd as vdm_lek02 preserving type) AS NoFurtherOpWorkQuantity2IsExpd,
  cast(afvg.OpWorkQuantityUnit3 as vdm_ile03 preserving type) AS WorkQuantityUnit3,
  cast(afvg.OpConfirmedWorkQuantity3 as vdm_ism03 preserving type) AS ConfirmedWorkQuantity3,
  cast(afvg.NoFurtherOpWorkQuantity3IsExpd as vdm_lek03 preserving type) AS NoFurtherOpWorkQuantity3IsExpd,
  cast(afvg.OpWorkQuantityUnit4 as vdm_ile04 preserving type) AS WorkQuantityUnit4,
  cast(afvg.OpConfirmedWorkQuantity4 as vdm_ism04 preserving type) AS ConfirmedWorkQuantity4,
  cast(afvg.NoFurtherOpWorkQuantity4IsExpd as vdm_lek04 preserving type) AS NoFurtherOpWorkQuantity4IsExpd,
  cast(afvg.OpWorkQuantityUnit5 as vdm_ile05 preserving type) AS WorkQuantityUnit5,
  cast(afvg.OpConfirmedWorkQuantity5 as vdm_ism05 preserving type) AS ConfirmedWorkQuantity5,
  cast(afvg.NoFurtherOpWorkQuantity5IsExpd as vdm_lek05 preserving type) AS NoFurtherOpWorkQuantity5IsExpd,
  cast(afvg.OpWorkQuantityUnit6 as vdm_ile06 preserving type) AS WorkQuantityUnit6,
  cast(afvg.OpConfirmedWorkQuantity6 as vdm_ism06 preserving type) AS ConfirmedWorkQuantity6,
  cast(afvg.NoFurtherOpWorkQuantity6IsExpd as vdm_lek06 preserving type) AS NoFurtherOpWorkQuantity6IsExpd,
  cast(afvg.WorkCenterStandardWorkQtyUnit1 as pph_vge01 preserving type) AS WorkCenterStandardWorkQtyUnit1,
  cast(afvg.WorkCenterStandardWorkQty1 as vdm_vgw01 preserving type) AS WorkCenterStandardWorkQty1,
  cast(afvg.CostCtrActivityType1 as vdm_lar01 preserving type) AS CostCtrActivityType1,
  cast(afvg.WorkCenterStandardWorkQtyUnit2 as pph_vge02 preserving type) AS WorkCenterStandardWorkQtyUnit2,
  cast(afvg.WorkCenterStandardWorkQty2 as vdm_vgw02 preserving type) AS WorkCenterStandardWorkQty2,
  cast(afvg.CostCtrActivityType2 as vdm_lar02 preserving type) AS CostCtrActivityType2,
  cast(afvg.WorkCenterStandardWorkQtyUnit3 as pph_vge03 preserving type) AS WorkCenterStandardWorkQtyUnit3,
  cast(afvg.WorkCenterStandardWorkQty3 as vdm_vgw03 preserving type) AS WorkCenterStandardWorkQty3,
  cast(afvg.CostCtrActivityType3 as vdm_lar03 preserving type) AS CostCtrActivityType3,
  cast(afvg.WorkCenterStandardWorkQtyUnit4 as pph_vge04 preserving type) AS WorkCenterStandardWorkQtyUnit4,
  cast(afvg.WorkCenterStandardWorkQty4 as vdm_vgw04 preserving type) AS WorkCenterStandardWorkQty4,
  cast(afvg.CostCtrActivityType4 as vdm_lar04 preserving type) AS CostCtrActivityType4,
  cast(afvg.WorkCenterStandardWorkQtyUnit5 as pph_vge05 preserving type) AS WorkCenterStandardWorkQtyUnit5,
  cast(afvg.WorkCenterStandardWorkQty5 as vdm_vgw05 preserving type) AS WorkCenterStandardWorkQty5,
  cast(afvg.CostCtrActivityType5 as vdm_lar05 preserving type) AS CostCtrActivityType5,
  cast(afvg.WorkCenterStandardWorkQtyUnit6 as pph_vge06 preserving type) AS WorkCenterStandardWorkQtyUnit6,
  cast(afvg.WorkCenterStandardWorkQty6 as vdm_vgw06 preserving type) AS WorkCenterStandardWorkQty6,
  cast(afvg.CostCtrActivityType6 as vdm_lar06 preserving type) AS CostCtrActivityType6,
  afvg.StandardWorkQtyDetnType AS StandardWorkQtyDetnType,
  afvg.StandardWorkQtyDetnYear AS StandardWorkQtyDetnYear,
  afvg.StandardWorkQuantityReference AS StandardWorkQuantityReference,
  afvg.StandardWorkQuantityCalcBasis AS StandardWorkQuantityCalcBasis,
  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
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..*]
;