What is C_ChgImpactPlngRoutingDets in SAP S/4HANA?

C_ChgImpactPlngRoutingDets is a consumption CDS view in SAP S/4HANA. Planning Routing Details It contains 36 fields.

Which tables does C_ChgImpactPlngRoutingDets read from?

C_ChgImpactPlngRoutingDets reads data from: I_BillOfOperationsChangeState.

What VDM layer is C_ChgImpactPlngRoutingDets?

C_ChgImpactPlngRoutingDets is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ChgImpactPlngRoutingDets

DDL: C_CHGIMPACTPLNGROUTINGDETS SQL: CCHGIMPCTPLR Type: view CONSUMPTION Package: MPE_PLAN_CIMA

36 Fields 1 Data Sources 6 Associations

Planning Routing Details

C_ChgImpactPlngRoutingDets is a Consumption CDS View that provides data about "Planning Routing Details" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperationsChangeState) and exposes 36 fields with key fields BillOfOperationsGroup, BillOfOperationsType, BillOfOperationsVariant, BOOInternalVersionCounter. It has 6 associations to related views. Part of development package MPE_PLAN_CIMA.

Data Sources (1)

Source	Alias	Join Type
I_BillOfOperationsChangeState	ChgImpactPlngRoutingDets	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..*]	I_BillOfOperationsTypeText	_BillOfOperationsTypeText	`$projection.BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType`
[1..1]	I_BillOfOperationsUsageText	_BillOfOperationsUsageText	`$projection.BillOfOperationsUsage = _BillOfOperationsUsageText.BillOfOperationsUsage and _BillOfOperationsUsageText.Language = $session.system_language`
[0..1]	I_BillOfOperationsStatusText	_BillOfOperationsStatusText	`$projection.BillOfOperationsStatus = _BillOfOperationsStatusText.BillOfOperationsStatus and _BillOfOperationsStatusText.Language = $session.system_language`
[0..*]	C_ChgImpactPlngRoutingMBOM	_ChgImpactPlngRoutingMBOM	`$projection.BillOfOperationsGroup = _ChgImpactPlngRoutingMBOM.BillOfOperationsGroup and $projection.BillOfOperationsType = _ChgImpactPlngRoutingMBOM.BillOfOperationsType and $projection.BillOfOperationsVariant = _ChgImpactPlngRoutingMBOM.BillOfOperationsVariant`
[0..*]	C_ChgImpactPlngRoutingOp	_ChgImpactPlngRoutingOP	`$projection.BillOfOperationsGroup = _ChgImpactPlngRoutingOP.BillOfOperationsGroup and $projection.BillOfOperationsType = _ChgImpactPlngRoutingOP.BillOfOperationsType and $projection.BillOfOperationsVariant = _ChgImpactPlngRoutingOP.BillOfOperationsVariant`
[0..*]	I_BillOfOperationsOpBasic	_BillOfOperationsOpBasic	`$projection.BillOfOperationsGroup = _BillOfOperationsOpBasic.BillOfOperationsGroup and $projection.BillOfOperationsType = _BillOfOperationsOpBasic.BillOfOperationsType`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CCHGIMPCTPLR	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Planning Routing Details	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
UI.headerInfo.title.value	BillOfOperationsGroup	view

Fields (36)

Key	Field	Source Table	Source Field	Description
KEY	BillOfOperationsGroup	I_BillOfOperationsChangeState	BillOfOperationsGroup	Group
KEY	BillOfOperationsType	I_BillOfOperationsChangeState	BillOfOperationsType	Task List Type
KEY	BillOfOperationsVariant	I_BillOfOperationsChangeState	BillOfOperationsVariant	Group Counter
KEY	BOOInternalVersionCounter	I_BillOfOperationsChangeState	BOOInternalVersionCounter	Sort pos.
	BillOfOperationsDesc	I_BillOfOperationsChangeState	BillOfOperationsDesc
	ChangeNumber	I_BillOfOperationsChangeState	ChangeNumber	Change Number
	BillOfOperationsUsage	I_BillOfOperationsChangeState	BillOfOperationsUsage	Work Center Category
	BillOfOperationsStatus	I_BillOfOperationsChangeState	BillOfOperationsStatus	Vehicle Status
	BillOfOperationsStatusDesc	_BillOfOperationsStatusText	BillOfOperationsStatusDesc
	ProductionPlant	I_BillOfOperationsChangeState	Plant	Valuation Area
	MinimumLotSizeQuantity	I_BillOfOperationsChangeState	MinimumLotSizeQuantity	Min. Lot Size
	MaximumLotSizeQuantity	I_BillOfOperationsChangeState	MaximumLotSizeQuantity	Max. Lot Size
	ResponsiblePlannerGroup	I_BillOfOperationsChangeState	ResponsiblePlannerGroup	Prodn Supervisor
	WorkCenterTypeCode	I_BillOfOperationsChangeState	WorkCenterTypeCode	Object Type
	EffectivityType	I_BillOfOperationsChangeState	EffectivityType
	ValidityStartDate	I_BillOfOperationsChangeState	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_BillOfOperationsChangeState	ValidityEndDate	ValidTo
	BillOfOperationsUnit	I_BillOfOperationsChangeState	BillOfOperationsUnit	Unit
	CreationDate	I_BillOfOperationsChangeState	CreationDate	Time Stamp
	CreatedByUser	I_BillOfOperationsChangeState	CreatedByUser	User Name
	LastChangeDate	I_BillOfOperationsChangeState	LastChangeDate	Time Stamp
	LastChangedByUser	I_BillOfOperationsChangeState	LastChangedByUser	User Name
	LastUsageDate	I_BillOfOperationsChangeState	LastUsageDate	Store Until
	NumberOfUsages	I_BillOfOperationsChangeState	NumberOfUsages	No. of Periods
	BillOfOperationsTypeName
	BillOfOperationsUsageDesc
	_ChgImpactPlngRoutingMBOM		_ChgImpactPlngRoutingMBOM
	_ChgImpactPlngRoutingOP		_ChgImpactPlngRoutingOP
	_BillOfOperationsOpBasic		_BillOfOperationsOpBasic
	_BillOfOperations		_BillOfOperations
	_BillOfOperationsGroup		_BillOfOperationsGroup
	_BillOfOperationsStatus		_BillOfOperationsStatus
	_BillOfOperationsType		_BillOfOperationsType
	_BillOfOperationsTypeText		_BillOfOperationsTypeText
	_BillOfOperationsStatusText		_BillOfOperationsStatusText
	_BillOfOperationsUsageText		_BillOfOperationsUsageText

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 C_ChgImpactPlngRoutingDets.
-- 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: CCHGIMPCTPLR

CREATE VIEW C_ChgImpactPlngRoutingDets AS
SELECT
  ChgImpactPlngRoutingDets.BillOfOperationsGroup AS BillOfOperationsGroup,
  ChgImpactPlngRoutingDets.BillOfOperationsType AS BillOfOperationsType,
  ChgImpactPlngRoutingDets.BillOfOperationsVariant AS BillOfOperationsVariant,
  ChgImpactPlngRoutingDets.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  ChgImpactPlngRoutingDets.BillOfOperationsDesc AS BillOfOperationsDesc,
  ChgImpactPlngRoutingDets.ChangeNumber AS ChangeNumber,
  ChgImpactPlngRoutingDets.BillOfOperationsUsage AS BillOfOperationsUsage,
  ChgImpactPlngRoutingDets.BillOfOperationsStatus AS BillOfOperationsStatus,
  _BillOfOperationsStatusText.BillOfOperationsStatusDesc AS BillOfOperationsStatusDesc,
  ChgImpactPlngRoutingDets.Plant AS ProductionPlant,
  ChgImpactPlngRoutingDets.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  ChgImpactPlngRoutingDets.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  ChgImpactPlngRoutingDets.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  ChgImpactPlngRoutingDets.WorkCenterTypeCode AS WorkCenterTypeCode,
  ChgImpactPlngRoutingDets.EffectivityType AS EffectivityType,
  ChgImpactPlngRoutingDets.ValidityStartDate AS ValidityStartDate,
  ChgImpactPlngRoutingDets.ValidityEndDate AS ValidityEndDate,
  ChgImpactPlngRoutingDets.BillOfOperationsUnit AS BillOfOperationsUnit,
  ChgImpactPlngRoutingDets.CreationDate AS CreationDate,
  ChgImpactPlngRoutingDets.CreatedByUser AS CreatedByUser,
  ChgImpactPlngRoutingDets.LastChangeDate AS LastChangeDate,
  ChgImpactPlngRoutingDets.LastChangedByUser AS LastChangedByUser,
  ChgImpactPlngRoutingDets.LastUsageDate AS LastUsageDate,
  ChgImpactPlngRoutingDets.NumberOfUsages AS NumberOfUsages,
  _BillOfOperationsTypeText[1:Language = $session.system_language].BillOfOperationsTypeName AS BillOfOperationsTypeName,
  _BillOfOperationsUsageText[1:Language = $session.system_language].BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc
FROM I_BillOfOperationsChangeState AS ChgImpactPlngRoutingDets
LEFT OUTER JOIN I_BillOfOperationsTypeText AS _BillOfOperationsTypeText ON BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType  -- association [0..*]
LEFT OUTER JOIN I_BillOfOperationsUsageText AS _BillOfOperationsUsageText ON BillOfOperationsUsage = _BillOfOperationsUsageText.BillOfOperationsUsage AND _BillOfOperationsUsageText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsStatusText AS _BillOfOperationsStatusText ON BillOfOperationsStatus = _BillOfOperationsStatusText.BillOfOperationsStatus AND _BillOfOperationsStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ChgImpactPlngRoutingMBOM AS _ChgImpactPlngRoutingMBOM ON BillOfOperationsGroup = _ChgImpactPlngRoutingMBOM.BillOfOperationsGroup AND BillOfOperationsType = _ChgImpactPlngRoutingMBOM.BillOfOperationsType AND BillOfOperationsVariant = _ChgImpactPlngRoutingMBOM.BillOfOperationsVariant  -- association [0..*]
LEFT OUTER JOIN C_ChgImpactPlngRoutingOp AS _ChgImpactPlngRoutingOP ON BillOfOperationsGroup = _ChgImpactPlngRoutingOP.BillOfOperationsGroup AND BillOfOperationsType = _ChgImpactPlngRoutingOP.BillOfOperationsType AND BillOfOperationsVariant = _ChgImpactPlngRoutingOP.BillOfOperationsVariant  -- association [0..*]
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS _BillOfOperationsOpBasic ON BillOfOperationsGroup = _BillOfOperationsOpBasic.BillOfOperationsGroup AND BillOfOperationsType = _BillOfOperationsOpBasic.BillOfOperationsType  -- association [0..*]
;

Depth:

C_ChgImpactPlngRoutingDets view

I_BillOfOperationsChangeState view