I_ProductionRoutingVersion

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_ProductionRoutingVersion.
-- 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_ProductionRoutingVersion AS
SELECT
  ProdnRtgVersion.BillOfOperationsType AS BillOfOperationsType,
  ProdnRtgVersion.BillOfOperationsGroup AS BillOfOperationsGroup,
  ProdnRtgVersion.BillOfOperationsVariant AS BillOfOperationsVariant,
  ProdnRtgVersion.BillOfOperationsVersion AS BillOfOperationsVersion,
  BillOfOperationChangeState.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  BillOfOperationChangeState.IsDeleted AS IsDeleted,
  BillOfOperationChangeState.WorkCenterTypeCode AS WorkCenterTypeCode,
  BillOfOperationChangeState.WorkCenterInternalID AS WorkCenterInternalID,
  BillOfOperations.BillOfOperationsVersionType AS BillOfOperationsVersionType,
  BillOfOperations.BillOfOperationsSubtype AS BillOfOperationsSubtype,
  BillOfOperations.BillOfOperationsVariantDesc AS BillOfOperationsVariantDesc,
  BillOfOperations.RoutingIsReworkRouting AS RoutingIsReworkRouting,
  BillOfOperations.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  BillOfOperations.BillOfOperationIsExecutedInMES AS BillOfOperationIsExecutedInMES,
  BillOfOperations.BillOfOperationsIsTrnsfdToERP AS BillOfOperationsIsTrnsfdToERP,
  BillOfOperations.ShopFloorRtgTemplateCategory AS ShopFloorRtgTemplateCategory,
  BillOfOperations.ShopFloorRoutingTemplateType AS ShopFloorRoutingTemplateType,
  BillOfOperations.ShopFloorRtgTemplateSubType AS ShopFloorRtgTemplateSubType,
  BillOfOperations.ShopFloorRoutingTemplateOwner AS ShopFloorRoutingTemplateOwner,
  VersionedBillOfOperations.RoutingIsProductReworkRouting AS RoutingIsProductReworkRouting,
  cast(BillOfOperationChangeState.Plant as pwwrk preserving type) AS Plant,
  BillOfOperationChangeState.BillOfOperationsUsage AS BillOfOperationsUsage,
  BillOfOperationChangeState.BillOfOperationsStatus AS BillOfOperationsStatus,
  BillOfOperationChangeState.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  BillOfOperationChangeState._WorkCenter.WorkCenter AS WorkCenter,
  BillOfOperationChangeState.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  BillOfOperationChangeState.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  cast(BillOfOperationChangeState.BillOfOperationsUnit as mpe_rtg_unit preserving type) AS BillOfOperationsUnit,
  BillOfOperationChangeState.ReplacedBillOfOperations AS ReplacedBillOfOperations,
  BillOfOperationChangeState.IsMarkedForDeletion AS IsMarkedForDeletion,
  BillOfOperationChangeState.InspectionPartialLot AS InspectionPartialLot,
  BillOfOperationChangeState.SmplDrawingProcedure AS SmplDrawingProcedure,
  BillOfOperationChangeState.SmplDrawingProcedureVersion AS SmplDrawingProcedureVersion,
  BillOfOperationChangeState.InspectionLotDynamicLevel AS InspectionLotDynamicLevel,
  BillOfOperationChangeState.InspLotDynamicRule AS InspLotDynamicRule,
  BillOfOperationChangeState.MaintenanceStrategy AS MaintenanceStrategy,
  ProdnRtgVersion.CreatedByUser AS CreatedByUser,
  ProdnRtgVersion.LastChangeDateTime AS LastChangeDateTime,
  ProdnRtgVersion.LastChangedByUser AS LastChangedByUser,
  BillOfOperationChangeState.ChangeNumber AS ChangeNumber,
  BillOfOperationChangeState.ValidityEndDate AS ValidityEndDate,
  BillOfOperationChangeState.LastUsageDate AS LastUsageDate,
  BillOfOperationChangeState.NumberOfUsages AS NumberOfUsages,
  ProdnRtgVersion.BillOfOperationsVersionStatus AS BillOfOperationsVersionStatus,
  ProdnRtgVersion.IsLatestBOOVersion AS IsLatestBOOVersion,
  ProdnRtgVersion.NumberOfBOOVersionSuccessors AS NumberOfBOOVersionSuccessors,
  ProdnRtgVersion.BillOfOperationsRefType AS BillOfOperationsRefType,
  ProdnRtgVersion.BillOfOperationsRefGroup AS BillOfOperationsRefGroup,
  ProdnRtgVersion.BillOfOperationsRefVariant AS BillOfOperationsRefVariant,
  ProdnRtgVersion.BOOReferenceVersion AS BOOReferenceVersion,
  ProdnRtgVersion.OrderID AS OrderID,
  BillOfOperationChangeState._BillOfOperationsStatus AS _BillOfOperationsStatus,
  BillOfOperationChangeState._BillOfOperationsUnit AS _BillOfOperationsUnit,
  BillOfOperationChangeState._BillOfOperationsUsage AS _BillOfOperationsUsage,
  BillOfOperationChangeState._ChangeMaster AS _ChangeMaster,
  BillOfOperationChangeState._InspExtNumbering AS _InspExtNumbering,
  BillOfOperationChangeState._InspLotDynamicRule AS _InspLotDynamicRule,
  BillOfOperationChangeState._InspPartialLotAssignment AS _InspPartialLotAssignment,
  BillOfOperationChangeState._InspSubsetFieldCombination AS _InspSubsetFieldCombination,
  BillOfOperationChangeState._InspectionLotDynamicLevel AS _InspectionLotDynamicLevel,
  BillOfOperationChangeState._MaintenanceStrategy AS _MaintenanceStrategy,
  BillOfOperationChangeState._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  BillOfOperationChangeState._SampleDrawingProcedure AS _SampleDrawingProcedure,
  BillOfOperationChangeState._SmplDrwgProcedureVersion AS _SmplDrwgProcedureVersion,
  BillOfOperationChangeState._WorkCenter AS _WorkCenter,
  BillOfOperationChangeState._WorkCenterType AS _WorkCenterType,
  ProdnRtgVersion._BOOVersionStatus AS _BOOVersionStatus,
  ProdnRtgVersion._BillOfOperations AS _BillOfOperations,
  ProdnRtgVersion._BillOfOperationsGroup AS _BillOfOperationsGroup,
  ProdnRtgVersion._BillOfOperationsType AS _BillOfOperationsType,
  ProdnRtgVersion._CreatedByUser AS _CreatedByUser,
  ProdnRtgVersion._LastChangedByUser AS _LastChangedByUser,
  BillOfOperations._BillOfOperationsVersionType AS _BillOfOperationsVersionType
FROM I_BillOfOperationsVersion AS ProdnRtgVersion
INNER JOIN I_BillOfOperationsChangeState AS BillOfOperationChangeState ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfOperations AS BillOfOperations ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON WorkCenter = _WorkCenterBySemanticKey.WorkCenter AND Plant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionRoutingVersion AS _ProdnRtgReferenceVersion ON BillOfOperationsType = _ProdnRtgReferenceVersion.BillOfOperationsType AND BillOfOperationsGroup = _ProdnRtgReferenceVersion.BillOfOperationsGroup AND BillOfOperationsVariant = _ProdnRtgReferenceVersion.BillOfOperationsVariant AND BOOReferenceVersion = _ProdnRtgReferenceVersion.BillOfOperationsVersion  -- association [0..1]
;