What is I_RoutingOperation in SAP S/4HANA?

I_RoutingOperation is a composite CDS view in SAP S/4HANA. Routing Operation Details It contains 90 fields.

Which tables does I_RoutingOperation read from?

I_RoutingOperation reads data from: I_RoutingActivity.

What VDM layer is I_RoutingOperation?

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

I_RoutingOperation

DDL: I_ROUTINGOPERATION SQL: IRTGOPR Type: view_entity COMPOSITE Package: VDM_PP_MD_RTG

90 Fields 1 Data Sources 1 Associations

Routing Operation Details

I_RoutingOperation is a Composite CDS View that provides data about "Routing Operation Details" in SAP S/4HANA. It reads from 1 data source (I_RoutingActivity) and exposes 90 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BOOInternalVersionCounter, BillOfOperationsSequence. It has 1 association to related views. Part of development package VDM_PP_MD_RTG.

Data Sources (1)

Source	Alias	Join Type
I_RoutingActivity	I_RoutingActivity	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_OperationControlProfile	_ControlProfile	`$projection.OperationControlProfile = _ControlProfile.OperationControlProfile`

Annotations (9)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
ObjectModel.representativeKey	BOOOpInternalVersionCounter	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Routing Operation 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 (90)

Key	Field	Source Table	Source Field	Description
KEY	BillOfOperationsType		BillOfOperationsType	Task List Type
KEY	BillOfOperationsGroup		BillOfOperationsGroup	Group
KEY	BillOfOperationsVariant		BillOfOperationsVariant	Group Counter
KEY	BOOInternalVersionCounter		BOOInternalVersionCounter
KEY	BillOfOperationsSequence		BillOfOperationsSequence	Sequence
KEY	BOOSqncInternalVersionCounter		BOOSqncInternalVersionCounter	Counter
KEY	BOOOperationInternalID		BOOOperationInternalID	Task list node
KEY	BOOOpInternalVersionCounter		BOOOpInternalVersionCounter	Counter
	ValidityStartDate		ValidityStartDate	Validity Start Date
	ValidityEndDate		ValidityEndDate	ValidTo
	ChangeNumber		ChangeNumber	Change Number
	IsDeleted		IsDeleted	TRUE
	IsImplicitlyDeleted		IsImplicitlyDeleted
	Operation		Operation	Transaction
	WorkCenterInternalID		WorkCenterInternalID	Work Center
	WorkCenter		WorkCenter	Work Center
	Plant		Plant	Valuation Area
	OperationText		OperationText	Description
	OperationReferenceQuantity		OperationReferenceQuantity	Base Quantity
	OperationUnit		OperationUnit	Act/op UoM
	FactoryCalendar		FactoryCalendar	Factory Calendar
	OperationControlProfile		OperationControlProfile	Control Key
	OperationIsMilestone	_ControlProfile	OperationIsMilestone
	ConfirmationIsRequired	_ControlProfile	ConfirmationIsRequired
	ConfirmationIsNotPossible	_ControlProfile	ConfirmationIsNotPossible
	OperationIsScheduled	_ControlProfile	OperationIsScheduled
	CapacityRequirementsAreDtmnd	_ControlProfile	CapacityRequirementsAreDtmnd
	OpQtyToBaseQtyNmrtr		OpQtyToBaseQtyNmrtr
	OpQtyToBaseQtyDnmntr		OpQtyToBaseQtyDnmntr
	OperationStandardTextCode		OperationStandardTextCode	Std Text Key
	OperationSetupType		OperationSetupType	Setup Type Key
	OperationSetupGroup		OperationSetupGroup	Setup group key
	OperationSetupGroupCategory		OperationSetupGroupCategory	Setup group cat
	StandardWorkFormulaParamGroup		StandardWorkFormulaParamGroup
	CostCtrActivityType1		CostCtrActivityType1	Activity Type
	StandardWorkFormulaParam1		StandardWorkFormulaParam1
	StandardWorkFormulaParamName1		StandardWorkFormulaParamName1
	StandardWorkQuantity1		StandardWorkQuantity1	Standard Value
	StandardWorkQuantityUnit1		StandardWorkQuantityUnit1	Std value unit
	StdWrkQtyUnit1ISOCode		StdWrkQtyUnit1ISOCode
	CostCtrActivityType2		CostCtrActivityType2	Activity Type
	StandardWorkFormulaParam2		StandardWorkFormulaParam2
	StandardWorkFormulaParamName2		StandardWorkFormulaParamName2
	StandardWorkQuantity2		StandardWorkQuantity2	Standard Value
	StandardWorkQuantityUnit2		StandardWorkQuantityUnit2	Std value unit
	StdWrkQtyUnit2ISOCode		StdWrkQtyUnit2ISOCode
	CostCtrActivityType3		CostCtrActivityType3	Activity Type
	StandardWorkFormulaParam3		StandardWorkFormulaParam3
	StandardWorkFormulaParamName3		StandardWorkFormulaParamName3
	StandardWorkQuantity3		StandardWorkQuantity3	Standard Value
	StandardWorkQuantityUnit3		StandardWorkQuantityUnit3	Std value unit
	StdWrkQtyUnit3ISOCode		StdWrkQtyUnit3ISOCode
	CostCtrActivityType4		CostCtrActivityType4	Activity Type
	StandardWorkFormulaParam4		StandardWorkFormulaParam4
	StandardWorkFormulaParamName4		StandardWorkFormulaParamName4
	StandardWorkQuantity4		StandardWorkQuantity4	Standard Value
	StandardWorkQuantityUnit4		StandardWorkQuantityUnit4	Std value unit
	StdWrkQtyUnit4ISOCode		StdWrkQtyUnit4ISOCode
	CostCtrActivityType5		CostCtrActivityType5	Activity Type
	StandardWorkFormulaParam5		StandardWorkFormulaParam5
	StandardWorkFormulaParamName5		StandardWorkFormulaParamName5
	StandardWorkQuantity5		StandardWorkQuantity5	Standard Value
	StandardWorkQuantityUnit5		StandardWorkQuantityUnit5	Std value unit
	StdWrkQtyUnit5ISOCode		StdWrkQtyUnit5ISOCode
	CostCtrActivityType6		CostCtrActivityType6	Activity Type
	StandardWorkFormulaParam6		StandardWorkFormulaParam6
	StandardWorkFormulaParamName6		StandardWorkFormulaParamName6
	StandardWorkQuantity6		StandardWorkQuantity6	Standard Value
	StandardWorkQuantityUnit6		StandardWorkQuantityUnit6	Std value unit
	StdWrkQtyUnit6ISOCode		StdWrkQtyUnit6ISOCode
	_ControlProfile		_ControlProfile
	_BillOfOperationsType		_BillOfOperationsType
	_BillOfOperations		_BillOfOperations
	_BillOfOperationsGroup		_BillOfOperationsGroup
	_BillOfOperationsSequence		_BillOfOperationsSequence
	_ChangeMaster		_ChangeMaster
	_Plant		_Plant
	_FactoryCalendar		_FactoryCalendar
	_OperationUnit		_OperationUnit
	_OperationStandardText		_OperationStandardText
	_OperationSetupType		_OperationSetupType
	_OperationSetupGroup		_OperationSetupGroup
	_OperationSetupGroupCategory		_OperationSetupGroupCategory
	_StandardWorkFmlaParamGroup		_StandardWorkFmlaParamGroup
	_StandardWorkQuantityUnit1		_StandardWorkQuantityUnit1
	_StandardWorkQuantityUnit2		_StandardWorkQuantityUnit2
	_StandardWorkQuantityUnit3		_StandardWorkQuantityUnit3
	_StandardWorkQuantityUnit4		_StandardWorkQuantityUnit4
	_StandardWorkQuantityUnit5		_StandardWorkQuantityUnit5
	_StandardWorkQuantityUnit6		_StandardWorkQuantityUnit6

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_RoutingOperation.
-- 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: IRTGOPR

CREATE VIEW I_RoutingOperation AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BOOInternalVersionCounter,
  BillOfOperationsSequence,
  BOOSqncInternalVersionCounter,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  IsDeleted,
  IsImplicitlyDeleted,
  Operation,
  WorkCenterInternalID,
  WorkCenter,
  Plant,
  OperationText,
  OperationReferenceQuantity,
  OperationUnit,
  FactoryCalendar,
  OperationControlProfile,
  _ControlProfile.OperationIsMilestone AS OperationIsMilestone,
  _ControlProfile.ConfirmationIsRequired AS ConfirmationIsRequired,
  _ControlProfile.ConfirmationIsNotPossible AS ConfirmationIsNotPossible,
  _ControlProfile.OperationIsScheduled AS OperationIsScheduled,
  _ControlProfile.CapacityRequirementsAreDtmnd AS CapacityRequirementsAreDtmnd,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  OperationStandardTextCode,
  OperationSetupType,
  OperationSetupGroup,
  OperationSetupGroupCategory,
  StandardWorkFormulaParamGroup,
  CostCtrActivityType1,
  StandardWorkFormulaParam1,
  StandardWorkFormulaParamName1,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  StdWrkQtyUnit1ISOCode,
  CostCtrActivityType2,
  StandardWorkFormulaParam2,
  StandardWorkFormulaParamName2,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  StdWrkQtyUnit2ISOCode,
  CostCtrActivityType3,
  StandardWorkFormulaParam3,
  StandardWorkFormulaParamName3,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  StdWrkQtyUnit3ISOCode,
  CostCtrActivityType4,
  StandardWorkFormulaParam4,
  StandardWorkFormulaParamName4,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  StdWrkQtyUnit4ISOCode,
  CostCtrActivityType5,
  StandardWorkFormulaParam5,
  StandardWorkFormulaParamName5,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  StdWrkQtyUnit5ISOCode,
  CostCtrActivityType6,
  StandardWorkFormulaParam6,
  StandardWorkFormulaParamName6,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  StdWrkQtyUnit6ISOCode
FROM I_RoutingActivity
LEFT OUTER JOIN I_OperationControlProfile AS _ControlProfile ON OperationControlProfile = _ControlProfile.OperationControlProfile  -- association [1..1]
;

Depth:

I_RoutingOperation view_entity

I_RoutingActivity view