R_ProductionRoutingSubopTP_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_ProductionRoutingSubopTP_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_ProductionRoutingSubopTP_2 AS
SELECT
  SubOP.BillOfOperationsGroup AS ProductionRoutingGroup,
  SubOP.BillOfOperationsVariant AS ProductionRouting,
  SubOP.BillOfOperationsSequence AS ProductionRoutingSequence,
  SubOP.BOOOperationInternalID AS ProductionRoutingOpIntID,
  SubOP.BOOOpInternalVersionCounter AS ProdnRtgSubOpIntVersion,
  SubOP.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  SubOP.Operation AS Operation,
  SubOP.OperationText AS OperationText,
  SubOP.LongTextLanguageCode AS LongTextLanguageCode,
  SubOP.WorkCenterTypeCode AS WorkCenterTypeCode,
  SubOP.WorkCenterInternalID AS WorkCenterInternalID,
  SubOP.Plant AS Plant,
  SubOP.OperationControlProfile AS OperationControlProfile,
  SubOP.OperationStandardTextCode AS OperationStandardTextCode,
  SubOP.OperationReferenceQuantity AS OperationReferenceQuantity,
  SubOP.OperationUnit AS OperationUnit,
  SubOP.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  SubOP.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  SubOP.StandardWorkQuantity1 AS StandardWorkQuantity1,
  SubOP.StandardWorkQuantityUnit1 AS StandardWorkQuantityUnit1,
  SubOP.CostCtrActivityType1 AS CostCtrActivityType1,
  SubOP.StandardWorkQuantity2 AS StandardWorkQuantity2,
  SubOP.StandardWorkQuantityUnit2 AS StandardWorkQuantityUnit2,
  SubOP.CostCtrActivityType2 AS CostCtrActivityType2,
  SubOP.StandardWorkQuantity3 AS StandardWorkQuantity3,
  SubOP.StandardWorkQuantityUnit3 AS StandardWorkQuantityUnit3,
  SubOP.CostCtrActivityType3 AS CostCtrActivityType3,
  SubOP.StandardWorkQuantity4 AS StandardWorkQuantity4,
  SubOP.StandardWorkQuantityUnit4 AS StandardWorkQuantityUnit4,
  SubOP.CostCtrActivityType4 AS CostCtrActivityType4,
  SubOP.StandardWorkQuantity5 AS StandardWorkQuantity5,
  SubOP.StandardWorkQuantityUnit5 AS StandardWorkQuantityUnit5,
  SubOP.CostCtrActivityType5 AS CostCtrActivityType5,
  SubOP.StandardWorkQuantity6 AS StandardWorkQuantity6,
  SubOP.StandardWorkQuantityUnit6 AS StandardWorkQuantityUnit6,
  SubOP.CostCtrActivityType6 AS CostCtrActivityType6,
  SubOP.NumberOfTimeTickets AS NumberOfTimeTickets,
  SubOP.EmployeeWageType AS EmployeeWageType,
  SubOP.EmployeeWageGroup AS EmployeeWageGroup,
  SubOP.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  SubOP.NumberOfEmployees AS NumberOfEmployees,
  SubOP.OperationCostingRelevancyType AS OperationCostingRelevancyType,
  SubOP.BusinessProcess AS BusinessProcess,
  cast( SubOP.OpIsExtlyProcdWithSubcontrg as pph_frdlb) AS OpIsExtlyProcdWithSubcontrg,
  SubOP.InspectionLotType AS InspectionLotType,
  SubOP.PurchasingInfoRecord AS PurchasingInfoRecord,
  SubOP.PurchasingOrganization AS PurchasingOrganization,
  SubOP.PurchaseContract AS PurchaseContract,
  SubOP.PurchaseContractItem AS PurchaseContractItem,
  SubOP.PurchasingInfoRecdAddlGrpgName AS PurchasingInfoRecdAddlGrpgName,
  SubOP.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  SubOP.MaterialGroup AS MaterialGroup,
  SubOP.PurchasingGroup AS PurchasingGroup,
  SubOP.Supplier AS Supplier,
  SubOP.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  SubOP.CostElement AS CostElement,
  SubOP.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  SubOP.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  SubOP.CreationDate AS CreationDate,
  SubOP.CreatedByUser AS CreatedByUser,
  SubOP.LastChangeDate AS LastChangeDate,
  SubOP.LastChangedByUser AS LastChangedByUser,
  SubOP.ValidityStartDate AS ValidityStartDate,
  SubOP.ValidityEndDate AS ValidityEndDate,
  SubOP.ChangeNumber AS ChangeNumber,
  SubOP.OperationSetupType AS OperationSetupType,
  SubOP.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  SubOP.OperationSetupGroup AS OperationSetupGroup,
  SubOP.CapacityCategoryCode AS CapacityCategoryCode,
  SubOP.OperationScrapPercent AS OperationScrapPercent,
  _NonSqncTP.ChangedDateTime AS ChangedDateTime,
  _LongText.PlainLongText AS PlainLongText,
  SubOP._Supplier AS _Supplier,
  SubOP._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  _WorkCenter.WorkCenter AS WorkCenter
FROM I_ProductionRoutingSubOp AS SubOP
INNER JOIN I_ProdnRtgSubordOpToOperation AS OprSubOpr ON /* join condition not captured in parsed metadata */
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 ProdnRtgSubOpIntVersion = _LongText.BOOInternalVersionCounter AND LongTextLanguageCode is not null AND _LongText.TaskListType = 'N'  -- association [0..1]
LEFT OUTER JOIN E_ProductionRoutingOperation AS _Extension ON ProductionRoutingGroup = _Extension.ProductionRoutingGroup AND ProductionRoutingOpIntID = _Extension.ProductionRoutingOpIntID AND ProdnRtgSubOpIntVersion = _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]
;