I_RoutingActivity

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_RoutingActivity.
-- 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: IRTGACT

CREATE VIEW I_RoutingActivity AS
SELECT
  _Sequence.BillOfOperationsType AS BillOfOperationsType,
  _Sequence.BillOfOperationsGroup AS BillOfOperationsGroup,
  _Sequence.BillOfOperationsVariant AS BillOfOperationsVariant,
  _Sequence.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  _Sequence.BillOfOperationsSequence AS BillOfOperationsSequence,
  _Sequence.BOOSqncInternalVersionCounter AS BOOSqncInternalVersionCounter,
  _Operation.BOOOperationInternalID AS BOOOperationInternalID,
  _Operation.BOOOpInternalVersionCounter AS BOOOpInternalVersionCounter,
  case when _Sequence.ValidityStartDate > _Operation.ValidityStartDate then _Sequence.ValidityStartDate else _Operation.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  case when _Sequence.ValidityEndDate < _Activity.ValidityEndDate then _Sequence.ValidityEndDate when _Activity.ValidityEndDate < _Operation.ValidityEndDate then _Activity.ValidityEndDate else _Operation.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  _Operation.ChangeNumber AS ChangeNumber,
  case when _Operation.SuperiorOperationInternalID <> '00000000' then _Operation.IsDeleted else _Activity.IsDeleted end as IsDeleted AS IsDeletedendasIsDeleted,
  _Operation.Operation AS Operation,
  _Operation.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  _SuperiorOp.Operation AS SuperiorOperation,
  _Operation.WorkCenterInternalID AS WorkCenterInternalID,
  _Operation._WorkCenter.WorkCenter AS WorkCenter,
  _Operation.Plant AS Plant,
  _Operation.OperationText AS OperationText,
  _Operation.LongTextLanguageCode AS LongTextLanguageCode,
  _Operation.OperationReferenceQuantity AS OperationReferenceQuantity,
  _Operation.OperationUnit AS OperationUnit,
  _Operation.FactoryCalendar AS FactoryCalendar,
  _Operation.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  _Operation.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  _Operation.OperationStandardTextCode AS OperationStandardTextCode,
  _Operation.OperationSetupType AS OperationSetupType,
  _Operation.OperationSetupGroup AS OperationSetupGroup,
  _Operation.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  _Sequence.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _Sequence.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _Sequence.BillOfOperationsUnit AS BillOfOperationsUnit,
  _Operation._WorkCenter.StandardWorkFormulaParamGroup AS StandardWorkFormulaParamGroup,
  _Operation.CostCtrActivityType1 AS CostCtrActivityType1,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1.StandardWorkFormulaParameter AS StandardWorkFormulaParam1,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName1,
  _Operation.StandardWorkQuantity1 AS StandardWorkQuantity1,
  _Operation.StandardWorkQuantityUnit1 AS StandardWorkQuantityUnit1,
  _Operation._StandardWorkQuantityUnit1.UnitOfMeasureISOCode AS StdWrkQtyUnit1ISOCode,
  _Operation.CostCtrActivityType2 AS CostCtrActivityType2,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2.StandardWorkFormulaParameter AS StandardWorkFormulaParam2,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName2,
  _Operation.StandardWorkQuantity2 AS StandardWorkQuantity2,
  _Operation.StandardWorkQuantityUnit2 AS StandardWorkQuantityUnit2,
  _Operation._StandardWorkQuantityUnit2.UnitOfMeasureISOCode AS StdWrkQtyUnit2ISOCode,
  _Operation.CostCtrActivityType3 AS CostCtrActivityType3,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3.StandardWorkFormulaParameter AS StandardWorkFormulaParam3,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName3,
  _Operation.StandardWorkQuantity3 AS StandardWorkQuantity3,
  _Operation.StandardWorkQuantityUnit3 AS StandardWorkQuantityUnit3,
  _Operation._StandardWorkQuantityUnit3.UnitOfMeasureISOCode AS StdWrkQtyUnit3ISOCode,
  _Operation.CostCtrActivityType4 AS CostCtrActivityType4,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4.StandardWorkFormulaParameter AS StandardWorkFormulaParam4,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName4,
  _Operation.StandardWorkQuantity4 AS StandardWorkQuantity4,
  _Operation.StandardWorkQuantityUnit4 AS StandardWorkQuantityUnit4,
  _Operation._StandardWorkQuantityUnit4.UnitOfMeasureISOCode AS StdWrkQtyUnit4ISOCode,
  _Operation.CostCtrActivityType5 AS CostCtrActivityType5,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5.StandardWorkFormulaParameter AS StandardWorkFormulaParam5,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName5,
  _Operation.StandardWorkQuantity5 AS StandardWorkQuantity5,
  _Operation.StandardWorkQuantityUnit5 AS StandardWorkQuantityUnit5,
  _Operation._StandardWorkQuantityUnit5.UnitOfMeasureISOCode AS StdWrkQtyUnit5ISOCode,
  _Operation.CostCtrActivityType6 AS CostCtrActivityType6,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6.StandardWorkFormulaParameter AS StandardWorkFormulaParam6,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6._Text[1:Language = $session.system_language].StandardWorkFormulaParamName AS StandardWorkFormulaParamName6,
  _Operation.StandardWorkQuantity6 AS StandardWorkQuantity6,
  _Operation.StandardWorkQuantityUnit6 AS StandardWorkQuantityUnit6,
  _Operation._StandardWorkQuantityUnit6.UnitOfMeasureISOCode AS StdWrkQtyUnit6ISOCode,
  _LongText.PlainLongText AS PlainLongText,
  _SuperiorOp.BOOOpInternalVersionCounter AS SuperiorOperationInternalVers,
  _Operation.CreationDate AS CreationDate,
  _Operation.CreatedByUser AS CreatedByUser,
  _Operation.LastChangeDate AS LastChangeDate,
  _Operation.LastChangedByUser AS LastChangedByUser,
  _Sequence._BillOfOperationsType AS _BillOfOperationsType,
  _Sequence._BillOfOperations AS _BillOfOperations,
  _Sequence._BillOfOperationsGroup AS _BillOfOperationsGroup,
  _Sequence._BillOfOperationsSequence AS _BillOfOperationsSequence,
  _Operation._ChangeMaster AS _ChangeMaster,
  _Operation._Plant AS _Plant,
  _Operation._FactoryCalendar AS _FactoryCalendar,
  _Operation._OperationUnit AS _OperationUnit,
  _Operation._OperationStandardText AS _OperationStandardText,
  _Operation._OperationSetupType AS _OperationSetupType,
  _Operation._OperationSetupGroup AS _OperationSetupGroup,
  _Operation._OperationSetupGroupCategory AS _OperationSetupGroupCategory,
  _Operation._WorkCenter._StandardWorkFmlaParamGroup AS _StandardWorkFmlaParamGroup,
  _Operation._StandardWorkQuantityUnit1 AS _StandardWorkQuantityUnit1,
  _Operation._StandardWorkQuantityUnit2 AS _StandardWorkQuantityUnit2,
  _Operation._StandardWorkQuantityUnit3 AS _StandardWorkQuantityUnit3,
  _Operation._StandardWorkQuantityUnit4 AS _StandardWorkQuantityUnit4,
  _Operation._StandardWorkQuantityUnit5 AS _StandardWorkQuantityUnit5,
  _Operation._StandardWorkQuantityUnit6 AS _StandardWorkQuantityUnit6
FROM I_RoutingSequence AS _Sequence
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS _Activity ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillOfOperationsOpBasic AS _Operation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS _SuperiorOp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TaskListOperationLongText AS _LongText ON BillOfOperationsType = _LongText.TaskListType AND BillOfOperationsGroup = _LongText.TaskListGroup AND BOOOperationInternalID = _LongText.BOOOperationInternalID AND BOOOpInternalVersionCounter = _LongText.BOOInternalVersionCounter AND LongTextLanguageCode is not null  -- association [0..1]
;