What is I_RoutingComponentAlloc in SAP S/4HANA?

I_RoutingComponentAlloc is a composite CDS view in SAP S/4HANA. Routing Component Allocation details It contains 52 fields.

Which tables does I_RoutingComponentAlloc read from?

I_RoutingComponentAlloc reads data from: I_MaterialBOM, I_BOOOpBOMItemChangeState, I_RoutingMaterialAssignment.

What VDM layer is I_RoutingComponentAlloc?

I_RoutingComponentAlloc is classified as a Composite view that combines data from multiple basic views.

I_RoutingComponentAlloc

DDL: I_ROUTINGCOMPONENTALLOC SQL: IRTGCOMPALC Type: view_entity COMPOSITE Package: VDM_PP_MD_RTG

52 Fields 3 Data Sources 3 Associations

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
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	Task List Type
KEY	BillOfOperationsGroup	I_BOOOpBOMItemChangeState	BillOfOperationsGroup	Group
KEY	BillOfOperationsVariant	I_BOOOpBOMItemChangeState	BillOfOperationsVariant	Group Counter
KEY	BillOfOperationsSequence	I_BOOOpBOMItemChangeState	BillOfOperationsSequence	Sequence
KEY	BOOOperationInternalID	I_BOOOpBOMItemChangeState	BOOOperationInternalID	Task list node
KEY	BOOOpBOMItemInternalID	I_BOOOpBOMItemChangeState	BOOOpBOMItemInternalID	Allocation no.
KEY	BOOOpBOMItemIntVersCounter	I_BOOOpBOMItemChangeState	BOOOpBOMItemIntVersCounter	Sort pos.
KEY	ProductionVersion	_ProdnVers	ProductionVersion	Version ID
	BillOfOperationsVersion	I_BOOOpBOMItemChangeState	BillOfOperationsVersion	Routing Version
	ValidityStartDate	I_BOOOpBOMItemChangeState	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_BOOOpBOMItemChangeState	ValidityEndDate	ValidTo
	CreationDate	I_BOOOpBOMItemChangeState	CreationDate	Time Stamp
	CreatedByUser	I_BOOOpBOMItemChangeState	CreatedByUser	User Name
	LastChangeDate	I_BOOOpBOMItemChangeState	LastChangeDate	Time Stamp
	LastChangedByUser	I_BOOOpBOMItemChangeState	LastChangedByUser	User Name
	IsDeleted	I_BOOOpBOMItemChangeState	IsDeleted	TRUE
	IsImplicitlyDeleted	I_BOOOpBOMItemChangeState	IsImplicitlyDeleted	Deletion Ind.
	ChangeNumber	I_BOOOpBOMItemChangeState	ChangeNumber	Change Number
	Operation	_Activity	Operation	Transaction
	SuperiorOperationInternalID	_Activity	SuperiorOperationInternalID	Sup. Op. Node
	SuperiorOperation	_Activity	SuperiorOperation
	Material	I_RoutingMaterialAssignment	Material	Vehicle Model
	Plant	I_RoutingMaterialAssignment	Plant	Valuation Area
	BillOfMaterialCategory	I_BOOOpBOMItemChangeState	BillOfMaterialCategory	BOM category
	BillOfMaterial	I_BOOOpBOMItemChangeState	BillOfMaterial	BOM
	BillOfMaterialVariant	I_BOOOpBOMItemChangeState	BillOfMaterialVariant	AlternativeBOM
	BillOfMaterialVariantUsage	I_MaterialBOM	BillOfMaterialVariantUsage	Usage
	BillOfMaterialItemNodeNumber	I_BOOOpBOMItemChangeState	BillOfMaterialItemNodeNumber	Item node
	BillOfMaterialItemCategory	_BOMItem	BillOfMaterialItemCategory	Item Category
	BillOfMaterialItemNumber	_BOMItem	BillOfMaterialItemNumber	Item
	BillOfMaterialComponent	_BOMItem	BillOfMaterialComponent	Component
	BillOfMaterialItemQuantity	_BOMItem	BillOfMaterialItemQuantity	Quantity
	BillOfMaterialItemUnit	_BOMItem	BillOfMaterialItemUnit	Component UoM
	MatlCompIsMarkedForBackflush	I_BOOOpBOMItemChangeState	MatlCompIsMarkedForBackflush	Backflush
	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

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_RoutingComponentAlloc.
-- 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: IRTGCOMPALC

CREATE VIEW I_RoutingComponentAlloc AS
SELECT
  _CompAlloc.BillOfOperationsType AS BillOfOperationsType,
  _CompAlloc.BillOfOperationsGroup AS BillOfOperationsGroup,
  _CompAlloc.BillOfOperationsVariant AS BillOfOperationsVariant,
  _CompAlloc.BillOfOperationsSequence AS BillOfOperationsSequence,
  _CompAlloc.BOOOperationInternalID AS BOOOperationInternalID,
  _CompAlloc.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  _CompAlloc.BOOOpBOMItemIntVersCounter AS BOOOpBOMItemIntVersCounter,
  _ProdnVers.ProductionVersion AS ProductionVersion,
  _CompAlloc.BillOfOperationsVersion AS BillOfOperationsVersion,
  _CompAlloc.ValidityStartDate AS ValidityStartDate,
  _CompAlloc.ValidityEndDate AS ValidityEndDate,
  _CompAlloc.CreationDate AS CreationDate,
  _CompAlloc.CreatedByUser AS CreatedByUser,
  _CompAlloc.LastChangeDate AS LastChangeDate,
  _CompAlloc.LastChangedByUser AS LastChangedByUser,
  _CompAlloc.IsDeleted AS IsDeleted,
  _CompAlloc.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  _CompAlloc.ChangeNumber AS ChangeNumber,
  _Activity.Operation AS Operation,
  _Activity.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  _Activity.SuperiorOperation AS SuperiorOperation,
  _MatlAssgmt.Material AS Material,
  _MatlAssgmt.Plant AS Plant,
  _CompAlloc.BillOfMaterialCategory AS BillOfMaterialCategory,
  _CompAlloc.BillOfMaterial AS BillOfMaterial,
  _CompAlloc.BillOfMaterialVariant AS BillOfMaterialVariant,
  _BOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _CompAlloc.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  _BOMItem.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  _BOMItem.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  _BOMItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  _BOMItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  _BOMItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  _CompAlloc.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  _CompAlloc.ResvnIsMRPRlvtOrPurReqnIsCrted AS ResvnIsMRPRlvtOrPurReqnIsCrted,
  _CompAlloc._BillOfMaterialItem AS _BillOfMaterialItem,
  _CompAlloc._BillOfOperations AS _BillOfOperations,
  _CompAlloc._BillOfOperationsGroup AS _BillOfOperationsGroup,
  _CompAlloc._BillOfOperationsOperation AS _BillOfOperationsOperation,
  _CompAlloc._BillOfOperationsSequence AS _BillOfOperationsSequence,
  _CompAlloc._BillOfOperationsType AS _BillOfOperationsType,
  _CompAlloc._BOOOpBOMItemInternalID AS _BOOOpBOMItemInternalID,
  _CompAlloc._BOOOperationInternalID AS _BOOOperationInternalID,
  _CompAlloc._ChangeMaster AS _ChangeMaster,
  _MatlAssgmt._Material AS _Material,
  _MatlAssgmt._Plant AS _Plant,
  _BOM._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  _BOMItem._BOMItemCategory AS _BOMItemCategory,
  _BOMItem._UnitOfMeasure AS _UnitOfMeasure
FROM I_BOOOpBOMItemChangeState AS _CompAlloc
INNER JOIN I_MaterialBOM AS _BOM ON /* join condition not captured in parsed metadata */
INNER JOIN I_RoutingMaterialAssignment AS _MatlAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RoutingActivity AS _Activity ON BillOfOperationsType = _Activity.BillOfOperationsType AND BillOfOperationsGroup = _Activity.BillOfOperationsGroup AND BillOfOperationsVariant = _Activity.BillOfOperationsVariant AND BillOfOperationsSequence = _Activity.BillOfOperationsSequence AND BOOOperationInternalID = _Activity.BOOOperationInternalID AND ValidityStartDate <= _Activity.ValidityEndDate AND ValidityEndDate >= _Activity.ValidityStartDate AND _Activity.IsDeleted <> 'X'  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItem AS _BOMItem ON BillOfMaterialCategory = _BOMItem.BillOfMaterialCategory AND BillOfMaterial = _BOMItem.BillOfMaterial AND BillOfMaterialVariant = _BOMItem.BillOfMaterialVariant AND BillOfMaterialItemNodeNumber = _BOMItem.BillOfMaterialItemNodeNumber  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProdnVers ON Material = _ProdnVers.Material AND Plant = _ProdnVers.Plant AND BillOfOperationsType = _ProdnVers.BillOfOperationsType AND BillOfOperationsGroup = _ProdnVers.BillOfOperationsGroup AND BillOfOperationsVariant = _ProdnVers.BillOfOperationsVariant AND BillOfMaterialVariant = _ProdnVers.BillOfMaterialVariant AND BillOfMaterialVariantUsage = _ProdnVers.BillOfMaterialVariantUsage AND _ProdnVers.ValidityEndDate >= $session.system_date  -- association [0..1]
;

Depth:

I_RoutingComponentAlloc view_entity