What is C_MDChgProcessActivatedProcess in SAP S/4HANA?

C_MDChgProcessActivatedProcess is a consumption CDS view in SAP S/4HANA. Activated processes It contains 11 fields.

What VDM layer is C_MDChgProcessActivatedProcess?

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

C_MDChgProcessActivatedProcess

DDL: C_MDCHGPROCESSACTIVATEDPROCESS Type: view_entity CONSUMPTION

11 Fields 2 Associations 1 OData Services

Activated processes

C_MDChgProcessActivatedProcess is a Consumption CDS View that provides data about "Activated processes" in SAP S/4HANA. It has 2 associations to related views. It is exposed through 1 OData service (MASTERDATACHANGEPROCESSSD).

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_MDChangeProcGoalT	_ProcessGoalText	`_ProcessGoalText.MDChgProcessGoal = $projection.MDChgProcessGoal and _ProcessGoalText.Language = $session.system_language`
[0..1]	I_MasterDataChangeProcessUser	_ProcessUser	`_ProcessUser.MDChgProcessRequestor = $projection.MDChgProcessRequestor and _ProcessUser.MDChgProcessSrceObjectTypeCode = $projection.MDChgProcessSrceObjectTypeCode`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Activated processes	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view

OData Services (1)

Service	Binding	Version	Contract	Release
MASTERDATACHANGEPROCESSSD	MASTERDATACHANGEPROCESSSB	V2	C1	NOT_RELEASED

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	MDChgProcessSrceObjectTypeCode		MDChgProcessSrceObjectTypeCode	Bus. Obj. Type
KEY	MasterDataChangeProcess		MasterDataChangeProcess	Process ID
	MDChgProcessDescription		MDChgProcessDescription	Process Description
	MDChgProcessTypeID		MDChgProcessTypeID	Process Template
	MDChgProcessGoal		MDChgProcessGoal	Process Goal
	MDChgProcessRequestor		MDChgProcessRequestor	Process Requestor
	MDChgProcessIsErased		MDChgProcessIsErased	Process Erased
	MDChgProcessGoalName	_ProcessGoalText	MDChgProcessGoalName
	CreatedByUserNameendasCreatedByUserName
	_ProcessGoalText		_ProcessGoalText
	_ProcessUser		_ProcessUser

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_MDChgProcessActivatedProcess.
-- 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.

CREATE VIEW C_MDChgProcessActivatedProcess AS
SELECT
  MDChgProcessSrceObjectTypeCode,
  MasterDataChangeProcess,
  MDChgProcessDescription,
  MDChgProcessTypeID,
  MDChgProcessGoal,
  MDChgProcessRequestor,
  MDChgProcessIsErased,
  _ProcessGoalText.MDChgProcessGoalName AS MDChgProcessGoalName,
  case when _ProcessUser.CreatedByUserName is null then MDChgProcessRequestor else _ProcessUser.CreatedByUserName end as CreatedByUserName AS CreatedByUserNameendasCreatedByUserName
LEFT OUTER JOIN I_MDChangeProcGoalT AS _ProcessGoalText ON _ProcessGoalText.MDChgProcessGoal = MDChgProcessGoal AND _ProcessGoalText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterDataChangeProcessUser AS _ProcessUser ON _ProcessUser.MDChgProcessRequestor = MDChgProcessRequestor AND _ProcessUser.MDChgProcessSrceObjectTypeCode = MDChgProcessSrceObjectTypeCode  -- association [0..1]
;

Depth:

C_MDChgProcessActivatedProcess view_entity