What is I_ChgMgmtActivityCube in SAP S/4HANA?

I_ChgMgmtActivityCube is a composite CDS view in SAP S/4HANA. Change Management Activity - Cube It contains 78 fields.

Which tables does I_ChgMgmtActivityCube read from?

I_ChgMgmtActivityCube reads data from: I_ChgMgmtActyWorklist.

What VDM layer is I_ChgMgmtActivityCube?

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

I_ChgMgmtActivityCube

DDL: I_CHGMGMTACTIVITYCUBE SQL: ICMACTCUBE Type: view COMPOSITE

78 Fields 1 Data Sources 3 Associations

Change Management Activity - Cube

I_ChgMgmtActivityCube is a Composite CDS View (Cube) that provides data about "Change Management Activity - Cube" in SAP S/4HANA. It reads from 1 data source (I_ChgMgmtActyWorklist) and exposes 78 fields with key field ChgMgmtActyUUID. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ChgMgmtActyWorklist	I_ChgMgmtActyWorklist	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_BusinessUserBasic	_BusinessUserBasic	`$projection.ChgMgmtActyResponsible = _BusinessUserBasic.BusinessPartner`
[1..1]	I_ChgMgmtRequestCube	_ChgMgmtRequestCube	`$projection.ChgMgmtReqUUID = _ChgMgmtRequestCube.ChgMgmtReqUUID`
[1..1]	I_Indicator	_OverdueIndicator	`$projection.ChgMgmtActyIsOverdue = _OverdueIndicator.IndicatorValue`

Annotations (16)

Name	Value	Level
EndUserText.label	Change Management Activity - Cube	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	ICMACTCUBE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	ChgMgmtActyUUID	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view

Fields (78)

Key	Field	Source Table	Source Field	Description
KEY	ChgMgmtActyUUID	I_ChgMgmtActyWorklist	ChgMgmtActyUUID
	ChgMgmtActivity		ChgMgmtActivity
	ChgMgmtActyCategory		ChgMgmtActyCategory
	_ChgMgmtActyCategory		_ChgMgmtActyCategory
	_ChgMgmtActyCategoryText		_ChgMgmtActyCategoryText
	ChgMgmtReqDescriptionText	I_ChgMgmtActyWorklist	ChgMgmtReqDescriptionText
	ChgMgmtRequest	I_ChgMgmtActyWorklist	ChgMgmtRequest
	ChgMgmtActyDescText	I_ChgMgmtActyWorklist	ChgMgmtActyDescText
	ChgMgmtActyType	I_ChgMgmtActyWorklist	ChgMgmtActyType
	_ChgMgmtActyType	I_ChgMgmtActyWorklist	_ChgMgmtActyType
	ChgMgmtDigitalSgntrStatus	I_ChgMgmtActyWorklist	ChgMgmtDigitalSgntrStatus
	_ChgMgmtDigitalSgntrSts	I_ChgMgmtActyWorklist	_ChgMgmtDigitalSgntrSts
	ChgMgmtUserStatusProfile		ChgMgmtUserStatusProfile
	_ChgMgmtUserStatusProfile		_ChgMgmtUserStatusProfile
	ChgMgmtActyStatus	I_ChgMgmtActyWorklist	ChgMgmtActyStatus
	_ChgMgmtActyStatus	I_ChgMgmtActyWorklist	_ChgMgmtActyStatus
	ChgMgmtUserStatus1	I_ChgMgmtActyWorklist	ChgMgmtUserStatus1
	_ChgMgmtUserStsPrflFldSts1Text		_ChgMgmtUserStsPrflFldSts1Text
	ChgMgmtUserStatus2	I_ChgMgmtActyWorklist	ChgMgmtUserStatus2
	_ChgMgmtUserStsPrflFldSts2Text		_ChgMgmtUserStsPrflFldSts2Text
	ChgMgmtUserStatus3	I_ChgMgmtActyWorklist	ChgMgmtUserStatus3
	_ChgMgmtUserStsPrflFldSts3Text		_ChgMgmtUserStsPrflFldSts3Text
	ChgMgmtUserStatus4	I_ChgMgmtActyWorklist	ChgMgmtUserStatus4
	_ChgMgmtUserStsPrflFldSts4Text		_ChgMgmtUserStsPrflFldSts4Text
	ChgMgmtUserStatus5	I_ChgMgmtActyWorklist	ChgMgmtUserStatus5
	_ChgMgmtUserStsPrflFldSts5Text		_ChgMgmtUserStsPrflFldSts5Text
	ChgMgmtActyResponsible	I_ChgMgmtActyWorklist	ChgMgmtActyResponsible
	_BusinessUserBasic		_BusinessUserBasic
	ChgMgmtReqUUID	I_ChgMgmtActyWorklist	ChgMgmtReqUUID
	ChgMgmtActyDueDate	I_ChgMgmtActyWorklist	ChgMgmtActyDueDate
	ChgMgmtActyDueDateTime	I_ChgMgmtActyWorklist	ChgMgmtActyDueDateTime
	ChgMgmtActyCompletionDate	I_ChgMgmtActyWorklist	ChgMgmtActyCompletionDate
	ChgMgmtReqStatus	_ChgMgmtRequestCube	ChgMgmtReqStatus
	_ChgMgmtReqStatus	_ChgMgmtRequestCube	_ChgMgmtReqStatus
	ChgMgmtReqType	_ChgMgmtRequestCube	ChgMgmtReqType	Change Request Type
	_ChgMgmtReqType	_ChgMgmtRequestCube	_ChgMgmtReqType
	ChgMgmtReqLeadingObject	_ChgMgmtRequestCube	ChgMgmtReqLeadingObject
	ChgMgmtReqLeadingObjType	_ChgMgmtRequestCube	ChgMgmtReqLeadingObjType
	_ChgMgmtReltdObjType	_ChgMgmtRequestCube	_ChgMgmtReltdObjType
	ChgMgmtReqLeadingObjName	_ChgMgmtRequestCube	ChgMgmtReqLeadingObjName
	ChgMgmtReqMainPlant	_ChgMgmtRequestCube	ChgMgmtReqMainPlant
	ChgMgmtReqMainPlantName	_ChgMgmtRequestCube	ChgMgmtReqMainPlantName
	ChgMgmtReqLeadingObjectLoc	_ChgMgmtRequestCube	ChgMgmtReqLeadingObjectLoc
	ChgMgmtReqLeadingObjectLocName	_ChgMgmtRequestCube	ChgMgmtReqLeadingObjectLocName
	Country	_ChgMgmtRequestCube	Country	Venue: Ctry/Reg
	_CountryText	_ChgMgmtRequestCube	_CountryText
	ChgMgmtReqIsEmergency	_ChgMgmtRequestCube	ChgMgmtReqIsEmergency
	ChgMgmtReqImpact	_ChgMgmtRequestCube	ChgMgmtReqImpact
	_ChgMgmtReqImpact	_ChgMgmtRequestCube	_ChgMgmtReqImpact
	ChgMgmtReqDurationCode	_ChgMgmtRequestCube	ChgMgmtReqDurationCode
	_ChgMgmtReqDuration	_ChgMgmtRequestCube	_ChgMgmtReqDuration
	ChgMgmtReqCreationDate	_ChgMgmtRequestCube	ChgMgmtReqCreationDate
	ChgMgmtReqCreationMonth	_ChgMgmtRequestCube	ChgMgmtReqCreationMonth
	ChgMgmtReqCreationYear	_ChgMgmtRequestCube	ChgMgmtReqCreationYear
	ChgMgmtReqReversalDate	_ChgMgmtRequestCube	ChgMgmtReqReversalDate
	ChgMgmtReqReversalMonth	_ChgMgmtRequestCube	ChgMgmtReqReversalMonth
	ChgMgmtReqReversalYear	_ChgMgmtRequestCube	ChgMgmtReqReversalYear
	ChgMgmtReqApprovalDate	_ChgMgmtRequestCube	ChgMgmtReqApprovalDate
	ChgMgmtReqApprovalMonth	_ChgMgmtRequestCube	ChgMgmtReqApprovalMonth
	ChgMgmtReqApprovalYear	_ChgMgmtRequestCube	ChgMgmtReqApprovalYear
	ChgMgmtReqExecStartDate	_ChgMgmtRequestCube	ChgMgmtReqExecStartDate
	ChgMgmtReqExecStartMonth	_ChgMgmtRequestCube	ChgMgmtReqExecStartMonth
	ChgMgmtReqExecStartYear	_ChgMgmtRequestCube	ChgMgmtReqExecStartYear
	ChgMgmtReqOplStartDate	_ChgMgmtRequestCube	ChgMgmtReqOplStartDate
	ChgMgmtReqOplStartMonth	_ChgMgmtRequestCube	ChgMgmtReqOplStartMonth
	ChgMgmtReqOplStartYear	_ChgMgmtRequestCube	ChgMgmtReqOplStartYear
	ChgMgmtActyDueYear	_DueDate	CalendarYear	Year
	_DueDate		_DueDate
	_ChgMgmtActyDueMonth	_DueDate	_CalendarMonth
	ChgMgmtActyDueMonth	_DueDate	CalendarMonth	Calendar Month
	NumberOfChgMgmtActivities		1	Number of Change Activities
	ChgMgmtActyAuthorizationGroup	I_ChgMgmtActyWorklist	ChgMgmtActyAuthorizationGroup
	ChgMgmtReqIsAccessRestricted	I_ChgMgmtActyWorklist	ChgMgmtReqIsAccessRestricted
	_ChgMgmtActyPersonInvolved	I_ChgMgmtActyWorklist	_ChgMgmtActyPersonInvolved
	_ChgMgmtReqMainPlant		_ChgMgmtReqMainPlant
	_ChgMgmtReqWorklist		_ChgMgmtReqWorklist
	_ChgMgmtRequestCube		_ChgMgmtRequestCube
	_OverdueIndicator		_OverdueIndicator

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_ChgMgmtActivityCube.
-- 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: ICMACTCUBE

CREATE VIEW I_ChgMgmtActivityCube AS
SELECT
  I_ChgMgmtActyWorklist.ChgMgmtActyUUID AS ChgMgmtActyUUID,
  ChgMgmtActivity,
  ChgMgmtActyCategory,
  I_ChgMgmtActyWorklist.ChgMgmtReqDescriptionText AS ChgMgmtReqDescriptionText,
  I_ChgMgmtActyWorklist.ChgMgmtRequest AS ChgMgmtRequest,
  I_ChgMgmtActyWorklist.ChgMgmtActyDescText AS ChgMgmtActyDescText,
  I_ChgMgmtActyWorklist.ChgMgmtActyType AS ChgMgmtActyType,
  I_ChgMgmtActyWorklist._ChgMgmtActyType AS _ChgMgmtActyType,
  I_ChgMgmtActyWorklist.ChgMgmtDigitalSgntrStatus AS ChgMgmtDigitalSgntrStatus,
  I_ChgMgmtActyWorklist._ChgMgmtDigitalSgntrSts AS _ChgMgmtDigitalSgntrSts,
  ChgMgmtUserStatusProfile,
  I_ChgMgmtActyWorklist.ChgMgmtActyStatus AS ChgMgmtActyStatus,
  I_ChgMgmtActyWorklist._ChgMgmtActyStatus AS _ChgMgmtActyStatus,
  I_ChgMgmtActyWorklist.ChgMgmtUserStatus1 AS ChgMgmtUserStatus1,
  I_ChgMgmtActyWorklist.ChgMgmtUserStatus2 AS ChgMgmtUserStatus2,
  I_ChgMgmtActyWorklist.ChgMgmtUserStatus3 AS ChgMgmtUserStatus3,
  I_ChgMgmtActyWorklist.ChgMgmtUserStatus4 AS ChgMgmtUserStatus4,
  I_ChgMgmtActyWorklist.ChgMgmtUserStatus5 AS ChgMgmtUserStatus5,
  I_ChgMgmtActyWorklist.ChgMgmtActyResponsible AS ChgMgmtActyResponsible,
  I_ChgMgmtActyWorklist.ChgMgmtReqUUID AS ChgMgmtReqUUID,
  I_ChgMgmtActyWorklist.ChgMgmtActyDueDate AS ChgMgmtActyDueDate,
  I_ChgMgmtActyWorklist.ChgMgmtActyDueDateTime AS ChgMgmtActyDueDateTime,
  I_ChgMgmtActyWorklist.ChgMgmtActyCompletionDate AS ChgMgmtActyCompletionDate,
  _ChgMgmtRequestCube.ChgMgmtReqStatus AS ChgMgmtReqStatus,
  _ChgMgmtRequestCube._ChgMgmtReqStatus AS _ChgMgmtReqStatus,
  _ChgMgmtRequestCube.ChgMgmtReqType AS ChgMgmtReqType,
  _ChgMgmtRequestCube._ChgMgmtReqType AS _ChgMgmtReqType,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObject AS ChgMgmtReqLeadingObject,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObjType AS ChgMgmtReqLeadingObjType,
  _ChgMgmtRequestCube._ChgMgmtReltdObjType AS _ChgMgmtReltdObjType,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObjName AS ChgMgmtReqLeadingObjName,
  _ChgMgmtRequestCube.ChgMgmtReqMainPlant AS ChgMgmtReqMainPlant,
  _ChgMgmtRequestCube.ChgMgmtReqMainPlantName AS ChgMgmtReqMainPlantName,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObjectLoc AS ChgMgmtReqLeadingObjectLoc,
  _ChgMgmtRequestCube.ChgMgmtReqLeadingObjectLocName AS ChgMgmtReqLeadingObjectLocName,
  _ChgMgmtRequestCube.Country AS Country,
  _ChgMgmtRequestCube._CountryText AS _CountryText,
  _ChgMgmtRequestCube.ChgMgmtReqIsEmergency AS ChgMgmtReqIsEmergency,
  _ChgMgmtRequestCube.ChgMgmtReqImpact AS ChgMgmtReqImpact,
  _ChgMgmtRequestCube._ChgMgmtReqImpact AS _ChgMgmtReqImpact,
  _ChgMgmtRequestCube.ChgMgmtReqDurationCode AS ChgMgmtReqDurationCode,
  _ChgMgmtRequestCube._ChgMgmtReqDuration AS _ChgMgmtReqDuration,
  _ChgMgmtRequestCube.ChgMgmtReqCreationDate AS ChgMgmtReqCreationDate,
  _ChgMgmtRequestCube.ChgMgmtReqCreationMonth AS ChgMgmtReqCreationMonth,
  _ChgMgmtRequestCube.ChgMgmtReqCreationYear AS ChgMgmtReqCreationYear,
  _ChgMgmtRequestCube.ChgMgmtReqReversalDate AS ChgMgmtReqReversalDate,
  _ChgMgmtRequestCube.ChgMgmtReqReversalMonth AS ChgMgmtReqReversalMonth,
  _ChgMgmtRequestCube.ChgMgmtReqReversalYear AS ChgMgmtReqReversalYear,
  _ChgMgmtRequestCube.ChgMgmtReqApprovalDate AS ChgMgmtReqApprovalDate,
  _ChgMgmtRequestCube.ChgMgmtReqApprovalMonth AS ChgMgmtReqApprovalMonth,
  _ChgMgmtRequestCube.ChgMgmtReqApprovalYear AS ChgMgmtReqApprovalYear,
  _ChgMgmtRequestCube.ChgMgmtReqExecStartDate AS ChgMgmtReqExecStartDate,
  _ChgMgmtRequestCube.ChgMgmtReqExecStartMonth AS ChgMgmtReqExecStartMonth,
  _ChgMgmtRequestCube.ChgMgmtReqExecStartYear AS ChgMgmtReqExecStartYear,
  _ChgMgmtRequestCube.ChgMgmtReqOplStartDate AS ChgMgmtReqOplStartDate,
  _ChgMgmtRequestCube.ChgMgmtReqOplStartMonth AS ChgMgmtReqOplStartMonth,
  _ChgMgmtRequestCube.ChgMgmtReqOplStartYear AS ChgMgmtReqOplStartYear,
  _DueDate.CalendarYear AS ChgMgmtActyDueYear,
  _DueDate._CalendarMonth AS _ChgMgmtActyDueMonth,
  _DueDate.CalendarMonth AS ChgMgmtActyDueMonth,
  1 AS NumberOfChgMgmtActivities,
  I_ChgMgmtActyWorklist.ChgMgmtActyAuthorizationGroup AS ChgMgmtActyAuthorizationGroup,
  I_ChgMgmtActyWorklist.ChgMgmtReqIsAccessRestricted AS ChgMgmtReqIsAccessRestricted,
  I_ChgMgmtActyWorklist._ChgMgmtActyPersonInvolved AS _ChgMgmtActyPersonInvolved
FROM I_ChgMgmtActyWorklist
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUserBasic ON ChgMgmtActyResponsible = _BusinessUserBasic.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtRequestCube AS _ChgMgmtRequestCube ON ChgMgmtReqUUID = _ChgMgmtRequestCube.ChgMgmtReqUUID  -- association [1..1]
LEFT OUTER JOIN I_Indicator AS _OverdueIndicator ON ChgMgmtActyIsOverdue = _OverdueIndicator.IndicatorValue  -- association [1..1]
;

Depth:

I_ChgMgmtActivityCube view

I_ChgMgmtActyWorklist view