I_ProductionRoutingOperation

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_ProductionRoutingOperation.
-- 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: IPRODNRTGOPR

CREATE VIEW I_ProductionRoutingOperation AS
SELECT
  _Op.BillOfOperationsType AS BillOfOperationsType,
  _Op.BillOfOperationsGroup AS BillOfOperationsGroup,
  _Op.BillOfOperationsVariant AS BillOfOperationsVariant,
  _Op.BOOOperationInternalID AS BOOOperationInternalID,
  _Op.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  _Op.BillOfOperationsSequence AS BillOfOperationsSequence,
  _Op.BOOSqncOpAssgmtIntVersionCntr AS BOOSqncOpAssgmtIntVersionCntr,
  OperationExternalID,
  cast(Operation as pph_vornr preserving type) AS Operation,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ChangeNumber,
  ValidityStartDate,
  ValidityEndDate,
  IsDeleted,
  IsImplicitlyDeleted,
  OperationText,
  LongTextLanguageCode,
  Plant,
  OperationControlProfile,
  OperationStandardTextCode,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  CapacityCategoryCode,
  CostElement,
  OperationCostingRelevancyType,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  EmployeeSuitability,
  NumberOfEmployees,
  BillOfOperationsRefType,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  LineSegmentTakt,
  OperationStdWorkQtyGrpgCat,
  OrderHasNoSubOperations,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  BOOOperationIsPhase,
  BOOPhaseSuperiorOpInternalID,
  ControlRecipeDestination,
  OpIsExtlyProcdWithSubcontrg,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingCurrency,
  OpExternalProcessingPrice,
  InspectionLotType,
  InspResultRecordingView,
  InspSbstCompletionConfirmation,
  InspSbstHasNoTimeOrQuantity,
  OperationReferenceQuantity,
  OperationUnit,
  OperationScrapPercent,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  StandardWorkFormulaParam1,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  PerfEfficiencyRatioCode1,
  StandardWorkFormulaParam2,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  PerfEfficiencyRatioCode2,
  StandardWorkFormulaParam3,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  PerfEfficiencyRatioCode3,
  StandardWorkFormulaParam4,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  PerfEfficiencyRatioCode4,
  StandardWorkFormulaParam5,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  PerfEfficiencyRatioCode5,
  StandardWorkFormulaParam6,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  PerfEfficiencyRatioCode6,
  BusinessProcess,
  LeadTimeReductionStrategy,
  TeardownAndWaitIsParallel,
  BillOfOperationsBreakDuration,
  BreakDurationUnit,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  OperationSplitIsRequired,
  MaximumNumberOfSplits,
  MinProcessingDurationPerSplit,
  MinProcessingDurnPerSplitUnit,
  OperationOverlappingIsRequired,
  OperationOverlappingIsPossible,
  OperationsIsAlwaysOverlapping,
  OperationHasNoOverlapping,
  OverlapMinimumDuration,
  OverlapMinimumDurationUnit,
  OverlapMinimumTransferQty,
  OverlapMinimumTransferQtyUnit,
  _Op.FactoryCalendar AS FactoryCalendar,
  _Op._BillOfOperations AS _BillOfOperations,
  _Op._SupplierCompanyByPlant AS _SupplierCompanyByPlant
FROM I_MfgBOOOperationChangeState AS _Op
LEFT OUTER JOIN I_RoutingHeader AS _Header ON BillOfOperationsType = _Header.BillOfOperationsType AND BillOfOperationsGroup = _Header.BillOfOperationsGroup AND BillOfOperationsVariant = _Header.BillOfOperationsVariant AND ValidityStartDate <= _Header.ValidityEndDate AND ValidityEndDate >= _Header.ValidityStartDate AND _Header.IsDeleted <> 'X' AND _Header.IsImplicitlyDeleted <> 'X'  -- association [1..*]
LEFT OUTER JOIN I_MfgBOOOperationChangeState AS _SupOp ON BillOfOperationsType = _SupOp.BillOfOperationsType AND BillOfOperationsGroup = _SupOp.BillOfOperationsGroup AND BOOPhaseSuperiorOpInternalID = _SupOp.BOOOperationInternalID AND ValidityStartDate <= _SupOp.ValidityEndDate AND ValidityEndDate >= _SupOp.ValidityStartDate AND BOOOperationIsPhase = 'X' AND _SupOp.IsDeleted <> 'X' AND _SupOp.IsImplicitlyDeleted <> 'X'  -- association [1..*]
;