C_ManageProductionOrder

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 C_ManageProductionOrder.
-- 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 C_ManageProductionOrder AS
SELECT
  cast(ManageOrdersTP.ManufacturingOrder as aufnr preserving type) AS ManufacturingOrder,
  ManageOrdersTP._MRPPlant.PlantName AS MRPPlantName,
  ManageOrdersTP._MRPArea.MRPAreaText AS MRPAreaText,
  ManageOrdersTP._MRPController.MRPControllerName AS MRPControllerName,
  ManageOrdersTP._ProductPlant.SerialNumberProfile AS SerialNumberProfile,
  ManageOrdersTP._Plant.PlantName AS ProductionPlantName,
  cast( ManageOrdersTP._Plant._OrganizationAddress[AddressRepresentationCode = ''].AddressTimeZone as co_plant_timezone ) AS PlantTimeZone,
  ManageOrdersTP._ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  case when _latestOp.LatestOperation is null then _firstOp.FirstOperationText else _latestOp.LatestOperationText end as OperationText AS LatestOperationTextendasOperationText,
  case when _latestOp.LatestOperation is null then _firstOp.FirstOperDet else _latestOp.LatestOperDet end as MfgOrderOperationText AS LatestOperDetendasMfgOrderOperationText,
  cast(ManageOrdersTP.ProdnProcgIsFlexible as mpe_procg_flexibility_ind preserving type) AS ProdnProcgIsFlexible,
  _ProdnProcgFlexibilityIndTxt[1: Language=$session.system_language].ProdnProcgFlexibilityIndName AS ProdnProcgFlexibilityIndName,
  _ExtendedQualityCheckIndTxt[1: Language=$session.system_language].ExtdQualityCheckIndName AS ExtdQualityCheckIndName,
  _SalesDocumentBasic._SoldToParty.Customer AS Customer,
  _SalesDocumentBasic._SoldToParty.CustomerName AS CustomerName,
  _SalesDocumentBasic._SoldToParty.AuthorizationGroup AS AuthorizationGroup,
  case when ManageOrdersTP._InspectionLot.InspectionLotOrigin = '03' or ManageOrdersTP._InspectionLot.InspectionLotOrigin = '04' then ManageOrdersTP.InspectionLot else ' ' end as InspectionLot AS InspectionLotelseendasInspectionLot,
  cast( ' ' as /plmb/cr_id ) AS ChangeRecord,
  cast( ' ' as abap.char( 255 ) ) AS NetChangeAnalysisPath,
  cast( ' ' as mpe_cima_exec_sts_type ) AS ImpactedActyExecSts,
  cast( ' ' as mpe_cima_exec_sts_text_type ) AS ImpactedActyExecStsDesc,
  cast( ' ' as boole_d preserving type ) AS ExecStsRequired,
  cast( ' ' as mpe_cima_impct_cat_val ) AS ImpactOnWorkInProgress,
  cast( ' ' as mpe_cima_impct_cat_val_desc ) AS ImpctOnWrkInPrgrsDesc,
  ManageOrdersTP._BasicSchedulingType._Text[1: Language = $session.system_language].SchedulingTypeName AS SchedulingTypeName,
  cast( case when ManageOrdersTP.OrderIsDeleted = 'X' then '12' when ManageOrdersTP.OrderIsClosed = 'X' then '11' when ManageOrdersTP.OrderIsTechnicallyCompleted = 'X' then '10' when ManageOrdersTP.OrderIsLocked = 'X' then '09' when ManageOrdersTP.OrderIsDelivered = 'X' then '08' when ManageOrdersTP.OrderIsPartiallyDelivered = 'X' then '07' when ManageOrdersTP.OrderIsConfirmed = 'X' then '06' when ManageOrdersTP.OrderIsPartiallyConfirmed = 'X' then '05' when ManageOrdersTP.MfgOrderIsToBeDeleted = 'X' then '04' when ManageOrdersTP.OrderIsReleased = 'X' then '03' when ManageOrdersTP.OrderIsPartiallyReleased = 'X' then '02' when ManageOrdersTP.OrderIsCreated = 'X' then '01' end as abap.numc(2)) as OrderStatusInternalID AS numc2asOrderStatusInternalID,
  cast( dats_tims_to_tstmp( '00000000', cast('000000' as tims), 'NULL', $session.client, 'NULL') as timestamp preserving type ) AS MfgOrderActualStartDateTime,
  cast( dats_tims_to_tstmp( '00000000', cast('000000' as tims), 'NULL', $session.client, 'NULL') as timestamp preserving type ) AS MfgOrderPlannedStartDateTime,
  cast( dats_tims_to_tstmp( '00000000', cast('000000' as tims), 'NULL', $session.client, 'NULL') as timestamp preserving type ) AS MfgOrderPlannedEndDateTime,
  cast( dats_tims_to_tstmp( '00000000', cast('000000' as tims), 'NULL', $session.client, 'NULL') as timestamp preserving type ) AS MfgOrderScheduledStartDateTime,
  cast( dats_tims_to_tstmp( '00000000', cast('000000' as tims), 'NULL', $session.client, 'NULL') as timestamp preserving type ) AS MfgOrderScheduledEndDateTime,
  cast( dats_tims_to_tstmp( '00000000', cast('000000' as tims), 'NULL', $session.client, 'NULL') as timestamp preserving type ) AS MfgOrderConfirmedEndDateTime,
  cast(case when _latestOp.LatestOperation is null then _firstOp.OperationUnit else _latestOp.OperationUnit end as meinh ) as OperationUnit AS OperationUnitendasmeinhasOperationUnit,
  cast (ManageOrdersTP.MfgOrderPlannedTotalQty - ManageOrdersTP.MfgOrderPlannedScrapQty - ManageOrdersTP.ActualDeliveredQuantity - ManageOrdersTP.ExpectedDeviationQuantity as openquan) AS OrderOpenQuantity,
  ManageOrdersTP._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  cast ( case when ManageOrdersTP.OrderIsConfirmed = 'X' then MissingQty.OrderYieldDeviationQty else 0.000 end as abap.quan(13,3) ) AS OrderYieldDeviationQty,
  cast(case when ManageOrdersTP.OrderIsConfirmed = 'X' and MissingQty.OrderYieldDeviationQty < 0 then ( - 1 * MissingQty.OrderYieldDeviationQty ) else 0 end as abap.quan(13,3) ) as OrderMissingQuantity AS quan133asOrderMissingQuantity,
  case when ManageOrdersTP.MfgOrderPlannedTotalQty = 0 then 0 when ManageOrdersTP.OrderIsConfirmed = 'X' and MissingQty.OrderYieldDeviationQty < 0 then cast ( ( cast( -100 * MissingQty.OrderYieldDeviationQty as abap.fltp ) ) / cast( ManageOrdersTP.MfgOrderPlannedTotalQty as abap.fltp ) as abap.fltp ) else 0.0 end as MissingQuantityInPercent AS 0endasMissingQuantityInPercent,
  case when not( ManageOrdersTP.OrderIsPartiallyConfirmed = 'X' or (ManageOrdersTP.OrderIsReleased = 'X' and ManageOrdersTP.OrderIsConfirmed = '') ) then 0 when ManageOrdersTP.OrderIsPartiallyConfirmed = ' ' and ManageOrdersTP.OrderIsReleased = 'X' and ManageOrdersTP.OrderIsConfirmed = '' then case when ManageOrdersTP.CurrentStartDelayInSeconds <= 0 then 0 else cast(ManageOrdersTP.CurrentStartDelayInSeconds as abap.fltp) / 60.00 end else case when ManageOrdersTP.ConfirmedStartDelayInSeconds <= 0 then 0 else cast(ManageOrdersTP.ConfirmedStartDelayInSeconds as abap.fltp) / 60.00 end end as ExecutionStartLatenessInMins AS 00endendasExecutionStartLatenessInMins,
  case when not ( ManageOrdersTP.OrderIsConfirmed = 'X' or (ManageOrdersTP.OrderIsPartiallyConfirmed = 'X' and ManageOrdersTP.OrderIsConfirmed = '') ) then 0 when ManageOrdersTP.OrderIsConfirmed = ' ' and ManageOrdersTP.OrderIsPartiallyConfirmed = 'X' and ManageOrdersTP.OrderIsConfirmed = '' then case when ManageOrdersTP.CurrentEndDelayInSeconds <= 0 then 0 else cast(ManageOrdersTP.CurrentEndDelayInSeconds as abap.fltp) / 60.00 end else case when ManageOrdersTP.ConfirmedEndDelayInSeconds <= 0 then 0 else cast(ManageOrdersTP.ConfirmedEndDelayInSeconds as abap.fltp) / 60.00 end end as ExecutionEndLatenessInMinutes AS 00endendasExecutionEndLatenessInMinutes,
  cast( case when _S4SoftwareComponent.ABAPSoftwareComponentVersion is null then ' ' else 'X' end as boolean preserving type ) AS IsCloudSystem,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  cast('' as abap.sstring( 256 )) AS EffctyTypeCnctntdParamDesc,
  ManageOrdersTP._MfgOrderType._Text[1: Language=$session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  _BillOfOperations._BillOfOperationsVersionType.BOOVersionChangeRecordIsRqd AS BOOVersionChangeRecordIsRqd,
  cast( case when _ProdnRsceTool.ManufacturingOrder is null then '' else 'X' end as mpe_has_prt ) AS OpHasAssgdProdnRsceTools,
  _UserStatus(im_clnt: $session.client).UserStatusText AS UserStatusText,
  _UserStatus(im_clnt: $session.client).StatusProfile AS StatusProfile,
  case when _GoodsMovFlag.OrderID is null then '' else 'X' end AS OrderHasFailedGoodsMovements,
  DefectSitns.SitnNumberOfInstances AS SitnNumberOfInstances,
  DefectSitns.SitnNmbrOfInstceInHierarchy AS SitnNmbrOfInstceInHierarchy,
  ManageOrdersTP.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ManageOrdersTP.ManufacturingOrderType AS ManufacturingOrderType,
  ManageOrdersTP.ManufacturingOrderText AS ManufacturingOrderText,
  ManageOrdersTP.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  ManageOrdersTP.Reservation AS Reservation,
  ManageOrdersTP.ReferenceOrder AS ReferenceOrder,
  ManageOrdersTP.MRPPlant AS MRPPlant,
  ManageOrdersTP.MRPArea AS MRPArea,
  ManageOrdersTP.MRPController AS MRPController,
  ManageOrdersTP.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  ManageOrdersTP.ControllingArea AS ControllingArea,
  ManageOrdersTP.ProfitCenter AS ProfitCenter,
  ManageOrdersTP.CostCenter AS CostCenter,
  ManageOrdersTP.ResponsibleCostCenter AS ResponsibleCostCenter,
  ManageOrdersTP.CostElement AS CostElement,
  ManageOrdersTP.GLAccount AS GLAccount,
  ManageOrdersTP.FunctionalArea AS FunctionalArea,
  ManageOrdersTP.ProductionPlant AS ProductionPlant,
  ManageOrdersTP.ProductionSupervisor AS ProductionSupervisor,
  ManageOrdersTP.SalesDocument AS SalesDocument,
  ManageOrdersTP.SalesDocumentItem AS SalesDocumentItem,
  ManageOrdersTP.WBSElement AS WBSElement,
  ManageOrdersTP.WBSDescription AS WBSDescription,
  ManageOrdersTP.ProductionVersion AS ProductionVersion,
  ManageOrdersTP.ProductionVersionText AS ProductionVersionText,
  ManageOrdersTP.ProductionLine AS ProductionLine,
  ManageOrdersTP.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  ManageOrdersTP.ExtdQualityCheckIsRequired AS ExtdQualityCheckIsRequired,
  ManageOrdersTP.MfgOrderSuperiorMfgOrder AS MfgOrderSuperiorMfgOrder,
  ManageOrdersTP.BasicSchedulingType AS BasicSchedulingType,
  ManageOrdersTP.MfgOrderSplitStatus AS MfgOrderSplitStatus,
  ManageOrdersTP.OrderIsCreated AS OrderIsCreated,
  ManageOrdersTP.OrderIsReleased AS OrderIsReleased,
  ManageOrdersTP.OrderIsPrinted AS OrderIsPrinted,
  ManageOrdersTP.OrderIsConfirmed AS OrderIsConfirmed,
  ManageOrdersTP.OrderIsPartiallyConfirmed AS OrderIsPartiallyConfirmed,
  ManageOrdersTP.OrderIsDelivered AS OrderIsDelivered,
  ManageOrdersTP.OrderIsDeleted AS OrderIsDeleted,
  ManageOrdersTP.OrderIsPreCosted AS OrderIsPreCosted,
  ManageOrdersTP.SettlementRuleIsCreated AS SettlementRuleIsCreated,
  ManageOrdersTP.OrderIsPartiallyReleased AS OrderIsPartiallyReleased,
  ManageOrdersTP.OrderIsTechnicallyCompleted AS OrderIsTechnicallyCompleted,
  ManageOrdersTP.OrderIsClosed AS OrderIsClosed,
  ManageOrdersTP.OrderIsPartiallyDelivered AS OrderIsPartiallyDelivered,
  ManageOrdersTP.OrderIsLocked AS OrderIsLocked,
  ManageOrdersTP.SettlementRuleIsCrtedManually AS SettlementRuleIsCrtedManually,
  ManageOrdersTP.OrderIsScheduled AS OrderIsScheduled,
  ManageOrdersTP.OrderIsShopFloorOrder AS OrderIsShopFloorOrder,
  ManageOrdersTP.OrderHasGeneratedOperations AS OrderHasGeneratedOperations,
  ManageOrdersTP.OrderIsToBeHandledInBatches AS OrderIsToBeHandledInBatches,
  ManageOrdersTP.MaterialAvailyIsNotChecked AS MaterialAvailyIsNotChecked,
  ManageOrdersTP.MfgOrderIsToBeDeleted AS MfgOrderIsToBeDeleted,
  ManageOrdersTP.OrderInCollvOrdersIsReleased AS OrderInCollvOrdersIsReleased,
  ManageOrdersTP.BillOfOperationsType AS BillOfOperationsType,
  ManageOrdersTP.BillOfOperationsGroup AS BillOfOperationsGroup,
  ManageOrdersTP.BillOfOperationsVariant AS BillOfOperationsVariant,
  ManageOrdersTP.BillOfOperationsVersion AS BillOfOperationsVersion,
  ManageOrdersTP.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  ManageOrdersTP.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  ManageOrdersTP.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  ManageOrdersTP.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  ManageOrdersTP.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  ManageOrdersTP.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  ManageOrdersTP.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  ManageOrdersTP.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  ManageOrdersTP.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  ManageOrdersTP.MfgOrderCreationDate AS MfgOrderCreationDate,
  ManageOrdersTP.MfgOrderCreationTime AS MfgOrderCreationTime,
  ManageOrdersTP.LastChangeDate AS LastChangeDate,
  ManageOrdersTP.LastChangeTime AS LastChangeTime,
  ManageOrdersTP.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  ManageOrdersTP.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  ManageOrdersTP.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  ManageOrdersTP.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  ManageOrdersTP.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  ManageOrdersTP.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  ManageOrdersTP.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  ManageOrdersTP.MfgOrderTotalCommitmentDate AS MfgOrderTotalCommitmentDate,
  ManageOrdersTP.ProductionUnit AS ProductionUnit,
  ManageOrdersTP.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  ManageOrdersTP.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  ManageOrdersTP.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  ManageOrdersTP.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  ManageOrdersTP.MfgOrderPlannedYieldQty AS MfgOrderPlannedYieldQty,
  ManageOrdersTP.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  ManageOrdersTP.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  ManageOrdersTP.Material AS Material,
  ManageOrdersTP.NumberOfSerialNumbers AS NumberOfSerialNumbers,
  ManageOrdersTP.ChangeToScheduledDatesIsMade AS ChangeToScheduledDatesIsMade,
  ManageOrdersTP.ProductConfiguration AS ProductConfiguration,
  ManageOrdersTP.EffectivityParameterVariant AS EffectivityParameterVariant,
  ManageOrdersTP.Batch AS Batch,
  ManageOrdersTP.ProdUnivHierarchy AS ProdUnivHierarchy,
  ManageOrdersTP.ProdUnivHierarchyNode AS ProdUnivHierarchyNode,
  ManageOrdersTP.ObjectInternalID AS ManufacturingObject,
  ManageOrdersTP.CreatedByUser AS CreatedByUser,
  ManageOrdersTP._Material AS _Material,
  ManageOrdersTP._ProductionUnit AS _ProductionUnit,
  ManageOrdersTP._BasicSchedulingType AS _BasicSchedulingType,
  ManageOrdersTP._Plant AS _Plant,
  ManageOrdersTP._Batch AS _Batch,
  ManageOrdersTP.EngineProcessingMode AS EngineProcessingMode,
  _HierNodeText.ProductHierarchyNodeText AS ProductHierarchyNodeText,
  _HierText.ProductHierarchyText AS ProductHierarchyText,
  _latestOp.OpLtstConfirmedScrapQty AS OpLtstConfirmedScrapQty,
  _ManufacturingFeatureStatus.ManufacturingFeature AS ManufacturingFeature,
  _ManufacturingFeatureStatus.ManufacturingFeatureIsActive AS ManufacturingFeatureIsActive,
  _ManufacturingFeatureStatus.MfgFeatureIsActiveInAnyPlant AS MfgFeatureIsActiveInAnyPlant,
  _OrderLongText.PlainLongText AS OrderLongText,
  _QualityIssue.InspHasRejectedCharc AS InspHasRejectedCharc,
  _QualityIssue.InspHasRejectedInspSubset AS InspHasRejectedInspSubset,
  _QualityIssue.InspHasRejectedInspLot AS InspHasRejectedInspLot
FROM I_ManageOrdersTP AS ManageOrdersTP
LEFT OUTER JOIN P_Mfgordcompmissaggr AS _compnts ON ManufacturingOrder = _compnts.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_Ordlatestoper AS _latestOp ON ManufacturingOrder = _latestOp.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_OrdFirstOper AS _firstOp ON ManufacturingOrder = _firstOp.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_Orderqtyissue AS MissingQty ON ManufacturingOrder = MissingQty.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderBasicFilter AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderBasicFilter AS _OrderVH ON ManufacturingOrder = _OrderVH.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocumentBasic ON SalesDocument = _SalesDocumentBasic.SalesDocument  -- association [0..1]
LEFT OUTER JOIN P_MPEInspIssuesByProdnOrder AS _QualityIssue ON ManufacturingOrder = _QualityIssue.ManufacturingOrder AND OrderInternalBillOfOperations = _QualityIssue.OrderInternalBillOfOperations  -- association [0..1]
LEFT OUTER JOIN I_ABAPSoftwareComponent AS _S4SoftwareComponent ON _S4SoftwareComponent.ABAPSoftwareComponent = 'SAPSCORE'  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingFeatureStatus AS _ManufacturingFeatureStatus ON ProductionPlant = _ManufacturingFeatureStatus.Plant AND _ManufacturingFeatureStatus.ManufacturingFeature = 'EPO'  -- association [0..1]
LEFT OUTER JOIN I_ProdnProcgFlexibilityIndTxt AS _ProdnProcgFlexibilityIndTxt ON ProdnProcgIsFlexible = _ProdnProcgFlexibilityIndTxt.ProdnProcgIsFlexible  -- association [0..*]
LEFT OUTER JOIN I_ExtendedQualityCheckIndTxt AS _ExtendedQualityCheckIndTxt ON ExtdQualityCheckIsRequired = _ExtendedQualityCheckIndTxt.ExtdQualityCheckIsRequired  -- association [0..*]
LEFT OUTER JOIN C_ChFiExProdnOrdConfign AS _ChFiExProdnOrdConfign ON ManufacturingOrder = _ChFiExProdnOrdConfign.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderLongText AS _OrderLongText ON ManufacturingOrder = _OrderLongText.OrderID  -- association [0..1]
LEFT OUTER JOIN P_MfgOrdNrOfDefectSitns AS DefectSitns ON DefectSitns.ProductionOrder = ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderHoldCount AS MfgOrderNmbrOfOrderHolds ON MfgOrderNmbrOfOrderHolds.ManufacturingOrder = ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderOperActyHoldCount AS MfgOrderNmbrOfOpActyHolds ON MfgOrderNmbrOfOpActyHolds.ManufacturingOrder = ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderSFIHoldCount AS MfgOrderNmbrOfSFIHolds ON MfgOrderNmbrOfSFIHolds.ManufacturingOrder = ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderOperHoldCount AS MfgOrderNmbrOfOpHolds ON MfgOrderNmbrOfOpHolds.ManufacturingOrder = ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderWrkCtrHoldCount AS MfgOrderNmbrOfWrkCtrHolds ON MfgOrderNmbrOfWrkCtrHolds.ManufacturingOrder = ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyNormalNodeT AS _HierNodeText ON ProdUnivHierarchyNode = _HierNodeText.ProductHierarchyNode AND _HierNodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProdUniversalHierarchyText AS _HierText ON ProdUnivHierarchy = _HierText.ProductHierarchy AND _HierText.ProdHierarchyValidityEndDate >= $session.user_date AND _HierText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_MFGOrderPRTAssignment AS _ProdnRsceTool ON ManufacturingOrder = _ProdnRsceTool.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_Order_UserStatuses AS _UserStatus ON ManufacturingOrder = _UserStatus.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_PRODORFDGOODSMOV AS _GoodsMovFlag ON ManufacturingOrder = _GoodsMovFlag.OrderID  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsVersion AS _BillOfOperationsVersion ON _BillOfOperationsVersion.BillOfOperationsType = BillOfOperationsType AND _BillOfOperationsVersion.BillOfOperationsGroup = BillOfOperationsGroup AND _BillOfOperationsVersion.BillOfOperationsVariant = BillOfOperationsVariant AND _BillOfOperationsVersion.BillOfOperationsVersion = BillOfOperationsVersion  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [0..1]
;