R_ProdnRoutingOperationTP_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 R_ProdnRoutingOperationTP_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 R_ProdnRoutingOperationTP_2 AS
SELECT
  operation.BillOfOperationsGroup AS ProductionRoutingGroup,
  operation.BillOfOperationsVariant AS ProductionRouting,
  operation.BillOfOperationsSequence AS ProductionRoutingSequence,
  operation.BOOOperationInternalID AS ProductionRoutingOpIntID,
  operation.BOOOpInternalVersionCounter AS ProductionRoutingOpIntVersion,
  cast(operation.Operation as pph_vornr preserving type) AS Operation,
  operation.CreationDate AS CreationDate,
  operation.CreatedByUser AS CreatedByUser,
  operation.LastChangeDate AS LastChangeDate,
  operation.LastChangedByUser AS LastChangedByUser,
  operation.ChangeNumber AS ChangeNumber,
  operation.ValidityStartDate AS ValidityStartDate,
  operation.ValidityEndDate AS ValidityEndDate,
  operation.IsDeleted AS IsDeleted,
  operation.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  operation.OperationText AS OperationText,
  operation.LongTextLanguageCode AS LongTextLanguageCode,
  operation.Plant AS Plant,
  operation.OperationControlProfile AS OperationControlProfile,
  operation.OperationStandardTextCode AS OperationStandardTextCode,
  operation.WorkCenterTypeCode AS WorkCenterTypeCode,
  operation.WorkCenterInternalID AS WorkCenterInternalID,
  operation.CapacityCategoryCode AS CapacityCategoryCode,
  operation.CostElement AS CostElement,
  operation.OperationCostingRelevancyType AS OperationCostingRelevancyType,
  operation.NumberOfTimeTickets AS NumberOfTimeTickets,
  operation.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  operation.EmployeeWageGroup AS EmployeeWageGroup,
  operation.EmployeeWageType AS EmployeeWageType,
  operation.EmployeeSuitability AS EmployeeSuitability,
  operation.NumberOfEmployees AS NumberOfEmployees,
  operation.BillOfOperationsRefType AS BillOfOperationsRefType,
  operation.BillOfOperationsRefGroup AS BillOfOperationsRefGroup,
  operation.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  operation.LineSegmentTakt AS LineSegmentTakt,
  operation.OperationStdWorkQtyGrpgCat AS OperationStdWorkQtyGrpgCat,
  operation.OrderHasNoSubOperations AS OrderHasNoSubOperations,
  operation.OperationSetupType AS OperationSetupType,
  operation.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  operation.OperationSetupGroup AS OperationSetupGroup,
  operation.BOOOperationIsPhase AS BOOOperationIsPhase,
  operation.BOOPhaseSuperiorOpInternalID AS BOOPhaseSuperiorOpInternalID,
  operation.ControlRecipeDestination AS ControlRecipeDestination,
  cast( operation.OpIsExtlyProcdWithSubcontrg as pph_frdlb) AS OpIsExtlyProcdWithSubcontrg,
  operation.PurchasingInfoRecord AS PurchasingInfoRecord,
  operation.PurchasingOrganization AS PurchasingOrganization,
  operation.PurchaseContract AS PurchaseContract,
  operation.PurchaseContractItem AS PurchaseContractItem,
  operation.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  operation.MaterialGroup AS MaterialGroup,
  operation.PurchasingGroup AS PurchasingGroup,
  operation.Supplier AS Supplier,
  operation.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  operation.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  operation.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  operation.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  operation.InspectionLotType AS InspectionLotType,
  operation.InspResultRecordingView AS InspResultRecordingView,
  operation.InspSbstCompletionConfirmation AS InspSbstCompletionConfirmation,
  operation.InspSbstHasNoTimeOrQuantity AS InspSbstHasNoTimeOrQuantity,
  operation.OperationReferenceQuantity AS OperationReferenceQuantity,
  operation.OperationUnit AS OperationUnit,
  operation.OperationScrapPercent AS OperationScrapPercent,
  operation.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  operation.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  operation.StandardWorkQuantity1 AS StandardWorkQuantity1,
  operation.StandardWorkQuantityUnit1 AS StandardWorkQuantityUnit1,
  operation.CostCtrActivityType1 AS CostCtrActivityType1,
  operation.PerfEfficiencyRatioCode1 AS PerfEfficiencyRatioCode1,
  operation.StandardWorkQuantity2 AS StandardWorkQuantity2,
  operation.StandardWorkQuantityUnit2 AS StandardWorkQuantityUnit2,
  operation.CostCtrActivityType2 AS CostCtrActivityType2,
  operation.PerfEfficiencyRatioCode2 AS PerfEfficiencyRatioCode2,
  operation.StandardWorkQuantity3 AS StandardWorkQuantity3,
  operation.StandardWorkQuantityUnit3 AS StandardWorkQuantityUnit3,
  operation.CostCtrActivityType3 AS CostCtrActivityType3,
  operation.PerfEfficiencyRatioCode3 AS PerfEfficiencyRatioCode3,
  operation.StandardWorkQuantity4 AS StandardWorkQuantity4,
  operation.StandardWorkQuantityUnit4 AS StandardWorkQuantityUnit4,
  operation.CostCtrActivityType4 AS CostCtrActivityType4,
  operation.PerfEfficiencyRatioCode4 AS PerfEfficiencyRatioCode4,
  operation.StandardWorkQuantity5 AS StandardWorkQuantity5,
  operation.StandardWorkQuantityUnit5 AS StandardWorkQuantityUnit5,
  operation.CostCtrActivityType5 AS CostCtrActivityType5,
  operation.PerfEfficiencyRatioCode5 AS PerfEfficiencyRatioCode5,
  operation.StandardWorkQuantity6 AS StandardWorkQuantity6,
  operation.StandardWorkQuantityUnit6 AS StandardWorkQuantityUnit6,
  operation.CostCtrActivityType6 AS CostCtrActivityType6,
  operation.PerfEfficiencyRatioCode6 AS PerfEfficiencyRatioCode6,
  operation.BusinessProcess AS BusinessProcess,
  operation.LeadTimeReductionStrategy AS LeadTimeReductionStrategy,
  operation.TeardownAndWaitIsParallel AS TeardownAndWaitIsParallel,
  operation.BillOfOperationsBreakDuration AS BillOfOperationsBreakDuration,
  operation.BreakDurationUnit AS BreakDurationUnit,
  operation.MaximumWaitDuration AS MaximumWaitDuration,
  operation.MaximumWaitDurationUnit AS MaximumWaitDurationUnit,
  operation.MinimumWaitDuration AS MinimumWaitDuration,
  operation.MinimumWaitDurationUnit AS MinimumWaitDurationUnit,
  operation.StandardQueueDuration AS StandardQueueDuration,
  operation.StandardQueueDurationUnit AS StandardQueueDurationUnit,
  operation.MinimumQueueDuration AS MinimumQueueDuration,
  operation.MinimumQueueDurationUnit AS MinimumQueueDurationUnit,
  operation.StandardMoveDuration AS StandardMoveDuration,
  operation.StandardMoveDurationUnit AS StandardMoveDurationUnit,
  operation.MinimumMoveDuration AS MinimumMoveDuration,
  operation.MinimumMoveDurationUnit AS MinimumMoveDurationUnit,
  operation.OperationSplitIsRequired AS OperationSplitIsRequired,
  operation.MaximumNumberOfSplits AS MaximumNumberOfSplits,
  operation.MinProcessingDurationPerSplit AS MinProcessingDurationPerSplit,
  operation.MinProcessingDurnPerSplitUnit AS MinProcessingDurnPerSplitUnit,
  operation.OperationOverlappingIsRequired AS OperationOverlappingIsRequired,
  operation.OperationOverlappingIsPossible AS OperationOverlappingIsPossible,
  operation.OperationsIsAlwaysOverlapping AS OperationsIsAlwaysOverlapping,
  operation.OperationHasNoOverlapping AS OperationHasNoOverlapping,
  operation.OverlapMinimumDuration AS OverlapMinimumDuration,
  operation.OverlapMinimumDurationUnit AS OverlapMinimumDurationUnit,
  operation.OverlapMinimumTransferQty AS OverlapMinimumTransferQty,
  operation.OverlapMinimumTransferQtyUnit AS OverlapMinimumTransferQtyUnit,
  operation.FactoryCalendar AS FactoryCalendar,
  _NonSqncTP.ChangedDateTime AS ChangedDateTime,
  _LongText.PlainLongText AS PlainLongText,
  _WorkCenter.WorkCenter AS WorkCenter,
  operation._Supplier AS _Supplier,
  operation._SupplierCompanyByPlant AS _SupplierCompanyByPlant
FROM I_ProductionRoutingOperation AS operation
INNER JOIN I_ProdnRtgOperationToSequence AS operationseq ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ProductionRoutingSubopTP_2 AS _SubOp ON ProductionRoutingGroup = _SubOp.ProductionRoutingGroup AND ProductionRouting = _SubOp.ProductionRouting AND ProductionRoutingOpIntID = _SubOp.SuperiorOperationInternalID AND ProductionRoutingSequence = _SubOp.ProductionRoutingSequence AND ValidityEndDate >= _SubOp.ValidityStartDate AND ValidityStartDate <= _SubOp.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN R_ProdnRoutingOpCompAllocTP_2 AS _OpCompAlloc ON ProductionRoutingGroup = _OpCompAlloc.ProductionRoutingGroup AND ProductionRouting = _OpCompAlloc.ProductionRouting AND ProductionRoutingOpIntID = _OpCompAlloc.ProductionRoutingOpIntID AND ProductionRoutingSequence = _OpCompAlloc.ProductionRoutingSequence AND ValidityEndDate >= _OpCompAlloc.ValidityStartDate AND ValidityStartDate <= _OpCompAlloc.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN R_ProductionRoutingHeaderTP_2 AS _Header ON ProductionRoutingGroup = _Header.ProductionRoutingGroup AND ProductionRouting = _Header.ProductionRouting AND ValidityEndDate >= _Header.ValidityStartDate AND ValidityStartDate <= _Header.ValidityEndDate  -- association [1..*]
LEFT OUTER JOIN I_TaskListOperationLongText AS _LongText ON ProductionRoutingGroup = _LongText.TaskListGroup AND ProductionRoutingOpIntID = _LongText.BOOOperationInternalID AND ProductionRoutingOpIntVersion = _LongText.BOOInternalVersionCounter AND LongTextLanguageCode is not null AND _LongText.TaskListType = 'N'  -- association [0..1]
LEFT OUTER JOIN R_ProdnRtgOpMiscPRTAssgmtTP_2 AS _OpMiscPRTAssgmt ON ProductionRoutingGroup = _OpMiscPRTAssgmt.ProductionRoutingGroup AND ProductionRouting = _OpMiscPRTAssgmt.ProductionRouting AND ProductionRoutingOpIntID = _OpMiscPRTAssgmt.ProductionRoutingOpIntID AND ProductionRoutingSequence = _OpMiscPRTAssgmt.ProductionRoutingSequence AND ValidityEndDate >= _OpMiscPRTAssgmt.ValidityStartDate AND ValidityStartDate <= _OpMiscPRTAssgmt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN R_ProdnRtgOpDocPRTAssgmtTP_2 AS _OpDocPRTAssgmt ON ProductionRoutingGroup = _OpDocPRTAssgmt.ProductionRoutingGroup AND ProductionRouting = _OpDocPRTAssgmt.ProductionRouting AND ProductionRoutingOpIntID = _OpDocPRTAssgmt.ProductionRoutingOpIntID AND ProductionRoutingSequence = _OpDocPRTAssgmt.ProductionRoutingSequence AND ValidityEndDate >= _OpDocPRTAssgmt.ValidityStartDate AND ValidityStartDate <= _OpDocPRTAssgmt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN R_ProdnRtgOpMatlPRTAssgmtTP_2 AS _OpMatlPRTAssgmt ON ProductionRoutingGroup = _OpMatlPRTAssgmt.ProductionRoutingGroup AND ProductionRouting = _OpMatlPRTAssgmt.ProductionRouting AND ProductionRoutingOpIntID = _OpMatlPRTAssgmt.ProductionRoutingOpIntID AND ProductionRoutingSequence = _OpMatlPRTAssgmt.ProductionRoutingSequence AND ValidityEndDate >= _OpMatlPRTAssgmt.ValidityStartDate AND ValidityStartDate <= _OpMatlPRTAssgmt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN R_ProdnRtgOpEquipPRTAssgmtTP_2 AS _OpEquipPRTAssgmt ON ProductionRoutingGroup = _OpEquipPRTAssgmt.ProductionRoutingGroup AND ProductionRouting = _OpEquipPRTAssgmt.ProductionRouting AND ProductionRoutingOpIntID = _OpEquipPRTAssgmt.ProductionRoutingOpIntID AND ProductionRoutingSequence = _OpEquipPRTAssgmt.ProductionRoutingSequence AND ValidityEndDate >= _OpEquipPRTAssgmt.ValidityStartDate AND ValidityStartDate <= _OpEquipPRTAssgmt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN R_ProdnRtgInspCharcsAssgmtTP_2 AS _OpInspCharcsAssgmt ON ProductionRoutingGroup = _OpInspCharcsAssgmt.ProductionRoutingGroup AND ProductionRouting = _OpInspCharcsAssgmt.ProductionRouting AND ProductionRoutingOpIntID = _OpInspCharcsAssgmt.ProductionRoutingOpIntID AND ProductionRoutingSequence = _OpInspCharcsAssgmt.ProductionRoutingSequence AND ValidityEndDate >= _OpInspCharcsAssgmt.ValidityStartDate AND ValidityStartDate <= _OpInspCharcsAssgmt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN E_ProductionRoutingOperation AS _Extension ON ProductionRoutingGroup = _Extension.ProductionRoutingGroup AND ProductionRoutingOpIntID = _Extension.ProductionRoutingOpIntID AND ProductionRoutingOpIntVersion = _Extension.ProductionRoutingOpIntVersion AND _Extension.BillOfOperationsType = 'N'  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
;