I_RoutingSequence

DDL: I_ROUTINGSEQUENCE SQL: IRTGSEQUENCE Type: view BASIC
32 Fields 2 Data Sources

Routing Sequence Details

I_RoutingSequence is a Basic CDS View that provides data about "Routing Sequence Details" in SAP S/4HANA. It reads from 2 data sources (I_RoutingHeader, I_MfgBOOSequenceChangeState) and exposes 32 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BOOInternalVersionCounter, BillOfOperationsSequence.

Data Sources (2)

SourceAliasJoin Type
I_RoutingHeader _Header inner
I_MfgBOOSequenceChangeState _Sequence from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IRTGSEQUENCE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey BOOSqncInternalVersionCounter view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Routing Sequence Details view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType I_MfgBOOSequenceChangeState BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_MfgBOOSequenceChangeState BillOfOperationsGroup Group
KEY BillOfOperationsVariant I_MfgBOOSequenceChangeState BillOfOperationsVariant Group Counter
KEY BOOInternalVersionCounter I_RoutingHeader BOOInternalVersionCounter
KEY BillOfOperationsSequence I_MfgBOOSequenceChangeState BillOfOperationsSequence Sequence
KEY BOOSqncInternalVersionCounter I_MfgBOOSequenceChangeState BOOSqncInternalVersionCounter Counter
IsDeleted I_MfgBOOSequenceChangeState IsDeleted TRUE
IsImplicitlyDeleted I_MfgBOOSequenceChangeState IsImplicitlyDeleted
ChangeNumber I_MfgBOOSequenceChangeState ChangeNumber Change Number
ValidityStartDateendasValidityStartDate
ValidityEndDateendasValidityEndDate
SequenceCategory I_MfgBOOSequenceChangeState SequenceCategory
BillOfOperationsRefSequence I_MfgBOOSequenceChangeState BillOfOperationsRefSequence
BOOSqncBranchOpInternalID I_MfgBOOSequenceChangeState BOOSqncBranchOpInternalID
BOOSqncReturnOpInternalID I_MfgBOOSequenceChangeState BOOSqncReturnOpInternalID
MinimumLotSizeQuantity I_MfgBOOSequenceChangeState MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity I_MfgBOOSequenceChangeState MaximumLotSizeQuantity Max. Lot Size
BillOfOperationsUnit I_RoutingHeader BillOfOperationsUnit
SequenceText I_MfgBOOSequenceChangeState SequenceText
CreationDate I_MfgBOOSequenceChangeState CreationDate Time Stamp
CreatedByUser I_MfgBOOSequenceChangeState CreatedByUser User Name
LastChangeDate I_MfgBOOSequenceChangeState LastChangeDate Time Stamp
LastChangedByUser I_MfgBOOSequenceChangeState LastChangedByUser User Name
_BillOfOperations I_MfgBOOSequenceChangeState _BillOfOperations
_BillOfOperationsGroup I_MfgBOOSequenceChangeState _BillOfOperationsGroup
_BillOfOperationsRefSequence I_MfgBOOSequenceChangeState _BillOfOperationsRefSequence
_BillOfOperationsSequence I_MfgBOOSequenceChangeState _BillOfOperationsSequence
_BillOfOperationsType I_MfgBOOSequenceChangeState _BillOfOperationsType
_BOOOperationsBranchOperation I_MfgBOOSequenceChangeState _BOOOperationsBranchOperation
_BOOOperationsReturnOperation I_MfgBOOSequenceChangeState _BOOOperationsReturnOperation
_ChangeMaster I_MfgBOOSequenceChangeState _ChangeMaster
_SequenceCategory I_MfgBOOSequenceChangeState _SequenceCategory

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_RoutingSequence.
-- 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: IRTGSEQUENCE

CREATE VIEW I_RoutingSequence AS
SELECT
  _Sequence.BillOfOperationsType AS BillOfOperationsType,
  _Sequence.BillOfOperationsGroup AS BillOfOperationsGroup,
  _Sequence.BillOfOperationsVariant AS BillOfOperationsVariant,
  _Header.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  _Sequence.BillOfOperationsSequence AS BillOfOperationsSequence,
  _Sequence.BOOSqncInternalVersionCounter AS BOOSqncInternalVersionCounter,
  _Sequence.IsDeleted AS IsDeleted,
  _Sequence.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  _Sequence.ChangeNumber AS ChangeNumber,
  case when _Header.ValidityStartDate > _Sequence.ValidityStartDate then _Header.ValidityStartDate else _Sequence.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  case when _Header.ValidityEndDate < _Sequence.ValidityEndDate then _Header.ValidityEndDate else _Sequence.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  _Sequence.SequenceCategory AS SequenceCategory,
  _Sequence.BillOfOperationsRefSequence AS BillOfOperationsRefSequence,
  _Sequence.BOOSqncBranchOpInternalID AS BOOSqncBranchOpInternalID,
  _Sequence.BOOSqncReturnOpInternalID AS BOOSqncReturnOpInternalID,
  _Sequence.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _Sequence.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _Header.BillOfOperationsUnit AS BillOfOperationsUnit,
  _Sequence.SequenceText AS SequenceText,
  _Sequence.CreationDate AS CreationDate,
  _Sequence.CreatedByUser AS CreatedByUser,
  _Sequence.LastChangeDate AS LastChangeDate,
  _Sequence.LastChangedByUser AS LastChangedByUser,
  _Sequence._BillOfOperations AS _BillOfOperations,
  _Sequence._BillOfOperationsGroup AS _BillOfOperationsGroup,
  _Sequence._BillOfOperationsRefSequence AS _BillOfOperationsRefSequence,
  _Sequence._BillOfOperationsSequence AS _BillOfOperationsSequence,
  _Sequence._BillOfOperationsType AS _BillOfOperationsType,
  _Sequence._BOOOperationsBranchOperation AS _BOOOperationsBranchOperation,
  _Sequence._BOOOperationsReturnOperation AS _BOOOperationsReturnOperation,
  _Sequence._ChangeMaster AS _ChangeMaster,
  _Sequence._SequenceCategory AS _SequenceCategory
FROM I_MfgBOOSequenceChangeState AS _Sequence
INNER JOIN I_RoutingHeader AS _Header ON /* join condition not captured in parsed metadata */
;

Learn More