P_ProcOrderOperationDurn

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 P_ProcOrderOperationDurn.
-- 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: PPOROPDURN

CREATE VIEW P_ProcOrderOperationDurn AS
SELECT
  cast(afvg.OrderInternalID as pph_aufpl preserving type) AS MfgOrderInternalID,
  cast(afvg.OrderOperationInternalID as operationinternalid preserving type) AS OrderOperationInternalID,
  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,
  _MfgOrderType._Text[1: Language=$session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  cast(aufv.ProductionPlant as pwwrk preserving type) AS ProductionPlant,
  _ProductionPlant.PlantName AS ProductionPlantName,
  cast( _ProductionPlant._OrganizationAddress[AddressRepresentationCode = ''].AddressTimeZone as co_plant_timezone ) AS PlantTimeZone,
  cast(aufv.ProductionSupervisor as pph_fevor preserving type) AS ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  cast(aufv.MRPController as pph_dispo preserving type) AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  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,
  cast(afvp.Operation as vdm_supop preserving type) AS MfgOrderPhaseSuperiorOperation,
  afvp.OperationText AS SuperiorOperationText,
  cast(afvg.NumberOfCapacities as pph_anzkap preserving type) AS NumberOfCapacities,
  afvg.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  afvg.OperationImportance AS OperationImportance,
  afvg.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  afvg.Plant AS Plant,
  cast(afvg.WorkCenterInternalID as pph_arbid preserving type) AS WorkCenterInternalID,
  cast(afvg.WorkCenterTypeCode as pph_arbty preserving type) AS WorkCenterTypeCode,
  cast(afvg.OperationControlProfile as pph_steus preserving type) AS OperationControlProfile,
  _OperationControlProfile._Text[1: Language=$session.system_language].OperationControlProfileName AS OperationControlProfileName,
  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 ObjectInternalID,
  afvg.OperationTrackingNumber AS OperationTrackingNumber,
  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 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,
  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.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.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,
  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.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,
  afvg.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  afvg.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  afvg.OpActualSetupEndDate AS OpActualSetupEndDate,
  afvg.OpActualSetupEndTime AS OpActualSetupEndTime,
  afvg.OpActualProcessingStartDate AS OpActualProcessingStartDate,
  afvg.OpActualProcessingStartTime AS OpActualProcessingStartTime,
  afvg.OpActualProcessingEndDate AS OpActualProcessingEndDate,
  afvg.OpActualProcessingEndTime AS OpActualProcessingEndTime,
  afvg.OpActualTeardownStartDate AS OpActualTeardownStartDate,
  afvg.OpActualTeardownStartTme AS OpActualTeardownStartTme,
  afvg.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  afvg.OpActualExecutionEndTime 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.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.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 OpWorkQuantityUnit1,
  cast(afvg.OpConfirmedWorkQuantity1 as vdm_ism01 preserving type) AS OpConfirmedWorkQuantity1,
  afvg.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  cast(afvg.OpWorkQuantityUnit2 as vdm_ile02 preserving type) AS OpWorkQuantityUnit2,
  cast(afvg.OpConfirmedWorkQuantity2 as vdm_ism02 preserving type) AS OpConfirmedWorkQuantity2,
  afvg.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  cast(afvg.OpWorkQuantityUnit3 as vdm_ile03 preserving type) AS OpWorkQuantityUnit3,
  cast(afvg.OpConfirmedWorkQuantity3 as vdm_ism03 preserving type) AS OpConfirmedWorkQuantity3,
  afvg.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  cast(afvg.OpWorkQuantityUnit4 as vdm_ile04 preserving type) AS OpWorkQuantityUnit4,
  cast(afvg.OpConfirmedWorkQuantity4 as vdm_ism04 preserving type) AS OpConfirmedWorkQuantity4,
  afvg.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  cast(afvg.OpWorkQuantityUnit5 as vdm_ile05 preserving type) AS OpWorkQuantityUnit5,
  cast(afvg.OpConfirmedWorkQuantity5 as vdm_ism05 preserving type) AS OpConfirmedWorkQuantity5,
  afvg.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  cast(afvg.OpWorkQuantityUnit6 as vdm_ile06 preserving type) AS OpWorkQuantityUnit6,
  cast(afvg.OpConfirmedWorkQuantity6 as vdm_ism06 preserving type) AS OpConfirmedWorkQuantity6,
  afvg.NoFurtherOpWorkQuantity6IsExpd 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.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,
  _OperationControlProfile.ConfirmationIsNotPossible AS ConfirmationIsNotPossible,
  _OperationConfirmation.ConfirmationGroup AS ConfirmationGroup,
  afvg.OrderIntBillOfOpItemOfPhase AS OrderIntBillOfOpItemOfPhase,
  _ManufacturingOrder.Material AS Material,
  aufv.ObjectInternalID AS OrdObjectInternalID,
  cast(_WorkCenter.WorkCenter as pph_arbpl preserving type) AS WorkCenter,
  _WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  _WorkCenter.CapacityInternalID AS CapacityInternalID
FROM I_OrderOperation AS afvg
INNER JOIN P_ProcOrdAORListDistinct AS _AORList ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrderBasic AS aufv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON MfgOrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- 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 MfgOrderInternalID = _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 _Plant ON Plant = _Plant.Plant  -- association [1..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_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_ResponsiblePlannerGroup AS _ResponsiblePlannerGroup ON Plant = _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 AND WorkCenterTypeCode = 'A'  -- 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_ControlRecipeDestination AS _ControlRecipeDestination ON Plant = _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_PurchaseRequisition_Api01 AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemAPI01 AS _PurchaseRequisitionItem2 ON PurchaseRequisition = _PurchaseRequisitionItem2.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem2.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 Plant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
LEFT OUTER JOIN I_EmployeeWageGroup AS _EmployeeWageGroup ON Plant = _EmployeeWageGroup.Plant AND EmployeeWageGroup = _EmployeeWageGroup.EmployeeWageGroup  -- association [0..1]
LEFT OUTER JOIN I_EmployeeSuitability AS _EmployeeSuitability ON Plant = _EmployeeSuitability.Plant AND EmployeeSuitability = _EmployeeSuitability.EmployeeSuitability  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _Employee ON Personnel = _Employee.PersonWorkAgreement  -- 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_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_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 _Language ON Language = _Language.Language  -- 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]
LEFT OUTER JOIN I_UnitOfMeasure AS _FreeDefinedQuantity1Unit ON FreeDefinedQuantity1Unit = _FreeDefinedQuantity1Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _FreeDefinedQuantity2Unit ON FreeDefinedQuantity2Unit = _FreeDefinedQuantity2Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedAmount1Currency ON FreeDefinedAmount1Currency = _FreeDefinedAmount1Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedAmount2Currency ON FreeDefinedAmount2Currency = _FreeDefinedAmount2Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.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_MfgOrderOperationComponent AS _MfgOrderOpComponent ON ManufacturingOrder = _MfgOrderOpComponent.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOpComponent.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOpComponent.ManufacturingOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderOperationPRT AS _MfgOrderOperationPRT ON ManufacturingOrder = _MfgOrderOperationPRT.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperationPRT.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOperationPRT.ManufacturingOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderOperationTrggrPoint AS _MfgOrderOpTriggerPoint ON ManufacturingOrder = _MfgOrderOpTriggerPoint.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOpTriggerPoint.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOpTriggerPoint.ManufacturingOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecord ON ManufacturingOrder = _MfgOrderOpDocInfoRecord.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOpDocInfoRecord.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOpDocInfoRecord.ManufacturingOrderOperation  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderOperationConf AS _MfgOrderOperationConf ON ManufacturingOrder = _MfgOrderOperationConf.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperationConf.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOperationConf.ManufacturingOrderOperation  -- association [0..*]
LEFT OUTER JOIN E_OrderOperation AS _Extension ON MfgOrderInternalID = _Extension.OrderInternalID AND OrderOperationInternalID = _Extension.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
;