I_RoutingComponentAlloc
Routing Component Allocation details
I_RoutingComponentAlloc is a Composite CDS View that provides data about "Routing Component Allocation details" in SAP S/4HANA. It reads from 3 data sources (I_MaterialBOM, I_BOOOpBOMItemChangeState, I_RoutingMaterialAssignment) and exposes 52 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID. It has 3 associations to related views. Part of development package VDM_PP_MD_RTG.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| I_MaterialBOM | _BOM | inner |
| I_BOOOpBOMItemChangeState | _CompAlloc | from |
| I_RoutingMaterialAssignment | _MatlAssgmt | inner |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_RoutingActivity | _Activity | $projection.BillOfOperationsType = _Activity.BillOfOperationsType and $projection.BillOfOperationsGroup = _Activity.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _Activity.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _Activity.BillOfOperationsSequence and $projection.BOOOperationInternalID = _Activity.BOOOperationInternalID and $projection.ValidityStartDate <= _Activity.ValidityEndDate and $projection.ValidityEndDate >= _Activity.ValidityStartDate and _Activity.IsDeleted <> 'X' |
| [0..1] | I_BillOfMaterialItem | _BOMItem | $projection.BillOfMaterialCategory = _BOMItem.BillOfMaterialCategory and $projection.BillOfMaterial = _BOMItem.BillOfMaterial and $projection.BillOfMaterialVariant = _BOMItem.BillOfMaterialVariant and $projection.BillOfMaterialItemNodeNumber = _BOMItem.BillOfMaterialItemNodeNumber |
| [0..1] | I_ProductionVersion | _ProdnVers | $projection.Material = _ProdnVers.Material and $projection.Plant = _ProdnVers.Plant and $projection.BillOfOperationsType = _ProdnVers.BillOfOperationsType and $projection.BillOfOperationsGroup = _ProdnVers.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _ProdnVers.BillOfOperationsVariant and $projection.BillOfMaterialVariant = _ProdnVers.BillOfMaterialVariant and $projection.BillOfMaterialVariantUsage = _ProdnVers.BillOfMaterialVariantUsage and _ProdnVers.ValidityEndDate >= $session.system_date |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.representativeKey | BOOOpBOMItemIntVersCounter | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Routing Component Allocation details | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| Metadata.allowExtensions | true | view | |
| AccessControl.personalData.blocking | #REQUIRED | view |
Fields (52)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillOfOperationsType | I_BOOOpBOMItemChangeState | BillOfOperationsType | |
| KEY | BillOfOperationsGroup | I_BOOOpBOMItemChangeState | BillOfOperationsGroup | |
| KEY | BillOfOperationsVariant | I_BOOOpBOMItemChangeState | BillOfOperationsVariant | |
| KEY | BillOfOperationsSequence | I_BOOOpBOMItemChangeState | BillOfOperationsSequence | |
| KEY | BOOOperationInternalID | I_BOOOpBOMItemChangeState | BOOOperationInternalID | |
| KEY | BOOOpBOMItemInternalID | I_BOOOpBOMItemChangeState | BOOOpBOMItemInternalID | |
| KEY | BOOOpBOMItemIntVersCounter | I_BOOOpBOMItemChangeState | BOOOpBOMItemIntVersCounter | |
| KEY | ProductionVersion | _ProdnVers | ProductionVersion | |
| BillOfOperationsVersion | I_BOOOpBOMItemChangeState | BillOfOperationsVersion | ||
| ValidityStartDate | I_BOOOpBOMItemChangeState | ValidityStartDate | ||
| ValidityEndDate | I_BOOOpBOMItemChangeState | ValidityEndDate | ||
| CreationDate | I_BOOOpBOMItemChangeState | CreationDate | ||
| CreatedByUser | I_BOOOpBOMItemChangeState | CreatedByUser | ||
| LastChangeDate | I_BOOOpBOMItemChangeState | LastChangeDate | ||
| LastChangedByUser | I_BOOOpBOMItemChangeState | LastChangedByUser | ||
| IsDeleted | I_BOOOpBOMItemChangeState | IsDeleted | ||
| IsImplicitlyDeleted | I_BOOOpBOMItemChangeState | IsImplicitlyDeleted | ||
| ChangeNumber | I_BOOOpBOMItemChangeState | ChangeNumber | ||
| Operation | _Activity | Operation | ||
| SuperiorOperationInternalID | _Activity | SuperiorOperationInternalID | ||
| SuperiorOperation | _Activity | SuperiorOperation | ||
| Material | I_RoutingMaterialAssignment | Material | ||
| Plant | I_RoutingMaterialAssignment | Plant | ||
| BillOfMaterialCategory | I_BOOOpBOMItemChangeState | BillOfMaterialCategory | ||
| BillOfMaterial | I_BOOOpBOMItemChangeState | BillOfMaterial | ||
| BillOfMaterialVariant | I_BOOOpBOMItemChangeState | BillOfMaterialVariant | ||
| BillOfMaterialVariantUsage | I_MaterialBOM | BillOfMaterialVariantUsage | ||
| BillOfMaterialItemNodeNumber | I_BOOOpBOMItemChangeState | BillOfMaterialItemNodeNumber | ||
| BillOfMaterialItemCategory | _BOMItem | BillOfMaterialItemCategory | ||
| BillOfMaterialItemNumber | _BOMItem | BillOfMaterialItemNumber | ||
| BillOfMaterialComponent | _BOMItem | BillOfMaterialComponent | ||
| BillOfMaterialItemQuantity | _BOMItem | BillOfMaterialItemQuantity | ||
| BillOfMaterialItemUnit | _BOMItem | BillOfMaterialItemUnit | ||
| MatlCompIsMarkedForBackflush | I_BOOOpBOMItemChangeState | MatlCompIsMarkedForBackflush | ||
| ResvnIsMRPRlvtOrPurReqnIsCrted | I_BOOOpBOMItemChangeState | ResvnIsMRPRlvtOrPurReqnIsCrted | ||
| _BillOfMaterialItem | I_BOOOpBOMItemChangeState | _BillOfMaterialItem | ||
| _BillOfOperations | I_BOOOpBOMItemChangeState | _BillOfOperations | ||
| _BillOfOperationsGroup | I_BOOOpBOMItemChangeState | _BillOfOperationsGroup | ||
| _BillOfOperationsOperation | I_BOOOpBOMItemChangeState | _BillOfOperationsOperation | ||
| _BillOfOperationsSequence | I_BOOOpBOMItemChangeState | _BillOfOperationsSequence | ||
| _BillOfOperationsType | I_BOOOpBOMItemChangeState | _BillOfOperationsType | ||
| _BOOOpBOMItemInternalID | I_BOOOpBOMItemChangeState | _BOOOpBOMItemInternalID | ||
| _BOOOperationInternalID | I_BOOOpBOMItemChangeState | _BOOOperationInternalID | ||
| _ChangeMaster | I_BOOOpBOMItemChangeState | _ChangeMaster | ||
| _Material | I_RoutingMaterialAssignment | _Material | ||
| _Plant | I_RoutingMaterialAssignment | _Plant | ||
| _BillOfMaterialVariantUsage | I_MaterialBOM | _BillOfMaterialVariantUsage | ||
| _BOMItemCategory | _BOMItem | _BOMItemCategory | ||
| _UnitOfMeasure | _BOMItem | _UnitOfMeasure | ||
| _Activity | _Activity | |||
| _BOMItem | _BOMItem | |||
| _ProdnVers | _ProdnVers |
//@AbapCatalog.sqlViewName: 'IRTGCOMPALC'
//@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
//@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BOOOpBOMItemIntVersCounter'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Routing Component Allocation details'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #XXL, dataClass: #MASTER }
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #REQUIRED
//define view I_RoutingComponentAlloc
define view entity I_RoutingComponentAlloc
as select from I_BOOOpBOMItemChangeState as _CompAlloc
inner join I_MaterialBOM as _BOM on _CompAlloc.BillOfMaterialCategory = _BOM.BillOfMaterialCategory
and _CompAlloc.BillOfMaterial = _BOM.BillOfMaterial
and _CompAlloc.BillOfMaterialVariant = _BOM.BillOfMaterialVariant
inner join I_RoutingMaterialAssignment as _MatlAssgmt on _CompAlloc.BillOfOperationsType = _MatlAssgmt.BillOfOperationsType
and _CompAlloc.BillOfOperationsGroup = _MatlAssgmt.BillOfOperationsGroup
and _CompAlloc.BillOfOperationsVariant = _MatlAssgmt.BillOfOperationsVariant
and _BOM.Material = _MatlAssgmt.Material
and _BOM.Plant = _MatlAssgmt.Plant
// and _MatlAssgmt.ValidityStartDate <= $session.system_date
and _MatlAssgmt.ValidityEndDate >= $session.system_date
association [0..1] to I_RoutingActivity as _Activity on $projection.BillOfOperationsType = _Activity.BillOfOperationsType
and $projection.BillOfOperationsGroup = _Activity.BillOfOperationsGroup
and $projection.BillOfOperationsVariant = _Activity.BillOfOperationsVariant
and $projection.BillOfOperationsSequence = _Activity.BillOfOperationsSequence
and $projection.BOOOperationInternalID = _Activity.BOOOperationInternalID
// and _Activity.ValidityStartDate <= $session.system_date
// and _Activity.ValidityEndDate >= $session.system_date
and $projection.ValidityStartDate <= _Activity.ValidityEndDate
and $projection.ValidityEndDate >= _Activity.ValidityStartDate
and _Activity.IsDeleted <> 'X'
association [0..1] to I_BillOfMaterialItem as _BOMItem on $projection.BillOfMaterialCategory = _BOMItem.BillOfMaterialCategory
and $projection.BillOfMaterial = _BOMItem.BillOfMaterial
and $projection.BillOfMaterialVariant = _BOMItem.BillOfMaterialVariant
and $projection.BillOfMaterialItemNodeNumber = _BOMItem.BillOfMaterialItemNodeNumber
association [0..1] to I_ProductionVersion as _ProdnVers on $projection.Material = _ProdnVers.Material
and $projection.Plant = _ProdnVers.Plant
and $projection.BillOfOperationsType = _ProdnVers.BillOfOperationsType
and $projection.BillOfOperationsGroup = _ProdnVers.BillOfOperationsGroup
and $projection.BillOfOperationsVariant = _ProdnVers.BillOfOperationsVariant
and $projection.BillOfMaterialVariant = _ProdnVers.BillOfMaterialVariant
and $projection.BillOfMaterialVariantUsage = _ProdnVers.BillOfMaterialVariantUsage
// and _ProdnVers.ValidityStartDate <= $session.system_date
and _ProdnVers.ValidityEndDate >= $session.system_date
{
key _CompAlloc.BillOfOperationsType,
key _CompAlloc.BillOfOperationsGroup,
key _CompAlloc.BillOfOperationsVariant,
key _CompAlloc.BillOfOperationsSequence,
key _CompAlloc.BOOOperationInternalID,
key _CompAlloc.BOOOpBOMItemInternalID,
key _CompAlloc.BOOOpBOMItemIntVersCounter,
key _ProdnVers.ProductionVersion,
_CompAlloc.BillOfOperationsVersion,
_CompAlloc.ValidityStartDate,
_CompAlloc.ValidityEndDate,
_CompAlloc.CreationDate,
_CompAlloc.CreatedByUser,
_CompAlloc.LastChangeDate,
_CompAlloc.LastChangedByUser,
_CompAlloc.IsDeleted,
_CompAlloc.IsImplicitlyDeleted,
_CompAlloc.ChangeNumber,
_Activity.Operation,
_Activity.SuperiorOperationInternalID,
_Activity.SuperiorOperation,
_MatlAssgmt.Material,
_MatlAssgmt.Plant,
_CompAlloc.BillOfMaterialCategory,
_CompAlloc.BillOfMaterial,
_CompAlloc.BillOfMaterialVariant,
_BOM.BillOfMaterialVariantUsage,
_CompAlloc.BillOfMaterialItemNodeNumber,
_BOMItem.BillOfMaterialItemCategory,
_BOMItem.BillOfMaterialItemNumber,
_BOMItem.BillOfMaterialComponent,
_BOMItem.BillOfMaterialItemQuantity,
_BOMItem.BillOfMaterialItemUnit,
_CompAlloc.MatlCompIsMarkedForBackflush,
_CompAlloc.ResvnIsMRPRlvtOrPurReqnIsCrted,
// Associations
_CompAlloc._BillOfMaterialItem,
_CompAlloc._BillOfOperations,
_CompAlloc._BillOfOperationsGroup,
_CompAlloc._BillOfOperationsOperation,
_CompAlloc._BillOfOperationsSequence,
_CompAlloc._BillOfOperationsType,
_CompAlloc._BOOOpBOMItemInternalID,
_CompAlloc._BOOOperationInternalID,
_CompAlloc._ChangeMaster,
_MatlAssgmt._Material,
_MatlAssgmt._Plant,
_BOM._BillOfMaterialVariantUsage,
_BOMItem._BOMItemCategory,
_BOMItem._UnitOfMeasure,
_Activity,
_BOMItem,
_ProdnVers
}
where
_CompAlloc.BillOfOperationsType = 'N'
and _CompAlloc.ValidityEndDate > _CompAlloc.ValidityStartDate
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA