What is I_ChgMgmtRequestCube in SAP S/4HANA?

I_ChgMgmtRequestCube is a composite CDS view in SAP S/4HANA. Change Management Request Cube It contains 85 fields.

Which tables does I_ChgMgmtRequestCube read from?

I_ChgMgmtRequestCube reads data from: I_ChgMgmtReqWorklist.

What VDM layer is I_ChgMgmtRequestCube?

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

I_ChgMgmtRequestCube

DDL: I_CHGMGMTREQUESTCUBE SQL: ICMREQCUBE Type: view COMPOSITE

85 Fields 1 Data Sources 6 Associations

Change Management Request Cube

I_ChgMgmtRequestCube is a Composite CDS View (Cube) that provides data about "Change Management Request Cube" in SAP S/4HANA. It reads from 1 data source (I_ChgMgmtReqWorklist) and exposes 85 fields with key field ChgMgmtReqUUID. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ChgMgmtReqWorklist	I_ChgMgmtReqWorklist	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..*]	I_Indicatortext	_ChgMgmtReqEmergencyIndText	`I_ChgMgmtReqWorklist.ChgMgmtReqIsEmergency = _ChgMgmtReqEmergencyIndText.IndicatorValue`
[0..*]	I_ChgMgmtUserStsPrflFldSts1Txt	_ChgMgmtUserStsPrflFldSts1Text	`$projection.ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts1Text.ChgMgmtUserStatusProfile and $projection.ChgMgmtUserStatus1 = _ChgMgmtUserStsPrflFldSts1Text.ChgMgmtUserStatus`
[0..*]	I_ChgMgmtUserStsPrflFldSts2Txt	_ChgMgmtUserStsPrflFldSts2Text	`$projection.ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts2Text.ChgMgmtUserStatusProfile and $projection.ChgMgmtUserStatus2 = _ChgMgmtUserStsPrflFldSts2Text.ChgMgmtUserStatus`
[0..*]	I_ChgMgmtUserStsPrflFldSts3Txt	_ChgMgmtUserStsPrflFldSts3Text	`$projection.ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts3Text.ChgMgmtUserStatusProfile and $projection.ChgMgmtUserStatus3 = _ChgMgmtUserStsPrflFldSts3Text.ChgMgmtUserStatus`
[0..*]	I_ChgMgmtUserStsPrflFldSts4Txt	_ChgMgmtUserStsPrflFldSts4Text	`$projection.ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts4Text.ChgMgmtUserStatusProfile and $projection.ChgMgmtUserStatus4 = _ChgMgmtUserStsPrflFldSts4Text.ChgMgmtUserStatus`
[0..*]	I_ChgMgmtUserStsPrflFldSts5Txt	_ChgMgmtUserStsPrflFldSts5Text	`$projection.ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts5Text.ChgMgmtUserStatusProfile and $projection.ChgMgmtUserStatus5 = _ChgMgmtUserStsPrflFldSts5Text.ChgMgmtUserStatus`

Annotations (16)

Name	Value	Level
EndUserText.label	Change Management Request Cube	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	ICMREQCUBE	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	ChgMgmtReqUUID	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 (85)

Key	Field	Source Table	Source Field	Description
KEY	ChgMgmtReqUUID	I_ChgMgmtReqWorklist	ChgMgmtReqUUID
	ChgMgmtReqDescriptionText	I_ChgMgmtReqWorklist	ChgMgmtReqDescriptionText
	ChgMgmtRequest	I_ChgMgmtReqWorklist	ChgMgmtRequest
	ChgMgmtReqType	I_ChgMgmtReqWorklist	ChgMgmtReqType	Change Request Type
	_ChgMgmtReqType	I_ChgMgmtReqWorklist	_ChgMgmtReqType
	ChgMgmtDigitalSgntrStatus	I_ChgMgmtReqWorklist	ChgMgmtDigitalSgntrStatus
	_ChgMgmtDigitalSgntrSts	I_ChgMgmtReqWorklist	_ChgMgmtDigitalSgntrSts
	ChgMgmtReqStatus	I_ChgMgmtReqWorklist	ChgMgmtReqStatus
	_ChgMgmtReqStatus	I_ChgMgmtReqWorklist	_ChgMgmtReqStatus
	ChgMgmtReqCombinedStatus		ChgMgmtReqCombinedStatus
	_ChgMgmtReqCombinedStatus		_ChgMgmtReqCombinedStatus
	ChgMgmtUserStatus1	I_ChgMgmtReqWorklist	ChgMgmtUserStatus1
	_ChgMgmtUserStsPrflFldSts1Text		_ChgMgmtUserStsPrflFldSts1Text
	ChgMgmtUserStatusProfile		ChgMgmtUserStatusProfile
	_ChgMgmtUserStatusProfile		_ChgMgmtUserStatusProfile
	ChgMgmtUserStatus2	I_ChgMgmtReqWorklist	ChgMgmtUserStatus2
	_ChgMgmtUserStsPrflFldSts2Text		_ChgMgmtUserStsPrflFldSts2Text
	ChgMgmtUserStatus3	I_ChgMgmtReqWorklist	ChgMgmtUserStatus3
	_ChgMgmtUserStsPrflFldSts3Text		_ChgMgmtUserStsPrflFldSts3Text
	ChgMgmtUserStatus4	I_ChgMgmtReqWorklist	ChgMgmtUserStatus4
	_ChgMgmtUserStsPrflFldSts4Text		_ChgMgmtUserStsPrflFldSts4Text
	ChgMgmtUserStatus5	I_ChgMgmtReqWorklist	ChgMgmtUserStatus5
	_ChgMgmtUserStsPrflFldSts5Text		_ChgMgmtUserStsPrflFldSts5Text
	ChgMgmtReqLeadingObjType	I_ChgMgmtReqWorklist	ChgMgmtReqLeadingObjType
	_ChgMgmtReqLeadingObjTypeText	I_ChgMgmtReqWorklist	_ChgMgmtReqLeadingObjTypeText
	_ChgMgmtReltdObjType		_ChgMgmtReltdObjType
	ChgMgmtReqLeadingObject	I_ChgMgmtReqWorklist	ChgMgmtReqLeadingObject
	ChgMgmtReqLeadingObjName	I_ChgMgmtReqWorklist	ChgMgmtReqLeadingObjName
	ChgMgmtReqLeadingObjectLoc	I_ChgMgmtReqWorklist	ChgMgmtReqLeadingObjectLoc
	ChgMgmtReqLeadingObjectLocName	I_ChgMgmtReqWorklist	ChgMgmtReqLeadingObjectLocName
	ChgMgmtReqMainPlant	I_ChgMgmtReqWorklist	ChgMgmtReqMainPlant
	ChgMgmtReqMainPlantUUID	I_ChgMgmtReqWorklist	ChgMgmtReqMainPlantUUID
	_ChgMgmtReqMainPlantText	I_ChgMgmtReqWorklist	_ChgMgmtReqMainPlantText
	ChgMgmtReqMainPlantName
	Country	I_ChgMgmtReqWorklist	Country	Venue: Ctry/Reg
	_CountryText	I_ChgMgmtReqWorklist	_CountryText
	ChgMgmtReqEnteredByBP	I_ChgMgmtReqWorklist	ChgMgmtReqEnteredByBP
	_ChgMgmtReqEnteredByBP	I_ChgMgmtReqWorklist	_ChgMgmtReqEnteredByBP
	ChgMgmtReqEnteredByUser	I_ChgMgmtReqWorklist	ChgMgmtReqEnteredByUser	User Name
	_EnteredBy	I_ChgMgmtReqWorklist	_EnteredBy
	ChgMgmtReqReportedByBP	I_ChgMgmtReqWorklist	ChgMgmtReqReportedByBP
	_ChgMgmtReqReportedByBP	I_ChgMgmtReqWorklist	_ChgMgmtReqReportedByBP
	_ChgMgmtReqReporter	I_ChgMgmtReqWorklist	_ChgMgmtReqReporter
	ChgMgmtReqIsEmergency	I_ChgMgmtReqWorklist	ChgMgmtReqIsEmergency
	_ChgMgmtReqEmergencyIndText		_ChgMgmtReqEmergencyIndText
	ChgMgmtReqDurationCode	I_ChgMgmtReqWorklist	ChgMgmtReqDurationCode
	_ChgMgmtReqDuration	I_ChgMgmtReqWorklist	_ChgMgmtReqDuration
	_ChgMgmtReqDurationText	I_ChgMgmtReqWorklist	_ChgMgmtReqDurationText
	ChgMgmtReqImpact	I_ChgMgmtReqWorklist	ChgMgmtReqImpact
	_ChgMgmtReqImpact	I_ChgMgmtReqWorklist	_ChgMgmtReqImpact
	_ChgMgmtReqImpactText	I_ChgMgmtReqWorklist	_ChgMgmtReqImpactText
	ChgMgmtReqReversalDate	I_ChgMgmtReqWorklist	ChgMgmtReqReversalDate
	ChgMgmtReqApprovalDate	I_ChgMgmtReqWorklist	ChgMgmtReqApprovalDate
	ChgMgmtReqExecStartDate	I_ChgMgmtReqWorklist	ChgMgmtReqExecStartDate
	ChgMgmtReqOplStartDate	I_ChgMgmtReqWorklist	ChgMgmtReqOplStartDate
	ChgMgmtReqCreationDate	I_ChgMgmtReqWorklist	ChgMgmtReqCreationDate
	ChgMgmtReqReportedDate	I_ChgMgmtReqWorklist	ChgMgmtReqReportedDate
	ChgMgmtReqCreationYear
	_CreationDate		_CreationDate
	_ChgMgmtReqCreationMonth	_CreationDate	_CalendarMonth
	ChgMgmtReqCreationMonth	_CreationDate	CalendarMonth	Calendar Month
	ChgMgmtReqReversalYear	_ReversalDate	CalendarYear	Year
	_ReversalDate		_ReversalDate
	_ChgMgmtReqReversalMonth	_ReversalDate	_CalendarMonth
	ChgMgmtReqReversalMonth	_ReversalDate	CalendarMonth	Calendar Month
	ChgMgmtReqApprovalYear	_ApprovalDate	CalendarYear	Year
	_ApprovalDate		_ApprovalDate
	_ChgMgmtReqApprovalMonth	_ApprovalDate	_CalendarMonth
	ChgMgmtReqApprovalMonth	_ApprovalDate	CalendarMonth	Calendar Month
	ChgMgmtReqExecStartYear	_ExecStartDate	CalendarYear	Year
	_ExecStartDate		_ExecStartDate
	_ChgMgmtReqExecStartMonth	_ExecStartDate	_CalendarMonth
	ChgMgmtReqExecStartMonth	_ExecStartDate	CalendarMonth	Calendar Month
	ChgMgmtReqOplStartYear	_OplStartDate	CalendarYear	Year
	_OplStartDate		_OplStartDate
	_ChgMgmtReqOplStartMonth	_OplStartDate	_CalendarMonth
	ChgMgmtReqOplStartMonth	_OplStartDate	CalendarMonth	Calendar Month
	NumberOfChgMgmtRequests		1	Number of Change Requests
	ChgMgmtReqStatusCriticality	I_ChgMgmtReqWorklist	ChgMgmtReqStatusCriticality
	ChgMgmtReqIsAccessRestricted	I_ChgMgmtReqWorklist	ChgMgmtReqIsAccessRestricted
	ChgMgmtReqAuthorizationGroup	I_ChgMgmtReqWorklist	ChgMgmtReqAuthorizationGroup
	_ChgMgmtReqLeadingObject	I_ChgMgmtReqWorklist	_ChgMgmtReqLeadingObject
	_ChgMgmtReqMainPlant	I_ChgMgmtReqWorklist	_ChgMgmtReqMainPlant
	_ChgMgmtActivity	I_ChgMgmtReqWorklist	_ChgMgmtActivity
	_ChgMgmtReqPersonInvolved	I_ChgMgmtReqWorklist	_ChgMgmtReqPersonInvolved

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_ChgMgmtRequestCube.
-- 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: ICMREQCUBE

CREATE VIEW I_ChgMgmtRequestCube AS
SELECT
  I_ChgMgmtReqWorklist.ChgMgmtReqUUID AS ChgMgmtReqUUID,
  I_ChgMgmtReqWorklist.ChgMgmtReqDescriptionText AS ChgMgmtReqDescriptionText,
  I_ChgMgmtReqWorklist.ChgMgmtRequest AS ChgMgmtRequest,
  I_ChgMgmtReqWorklist.ChgMgmtReqType AS ChgMgmtReqType,
  I_ChgMgmtReqWorklist._ChgMgmtReqType AS _ChgMgmtReqType,
  I_ChgMgmtReqWorklist.ChgMgmtDigitalSgntrStatus AS ChgMgmtDigitalSgntrStatus,
  I_ChgMgmtReqWorklist._ChgMgmtDigitalSgntrSts AS _ChgMgmtDigitalSgntrSts,
  I_ChgMgmtReqWorklist.ChgMgmtReqStatus AS ChgMgmtReqStatus,
  I_ChgMgmtReqWorklist._ChgMgmtReqStatus AS _ChgMgmtReqStatus,
  ChgMgmtReqCombinedStatus,
  I_ChgMgmtReqWorklist.ChgMgmtUserStatus1 AS ChgMgmtUserStatus1,
  ChgMgmtUserStatusProfile,
  I_ChgMgmtReqWorklist.ChgMgmtUserStatus2 AS ChgMgmtUserStatus2,
  I_ChgMgmtReqWorklist.ChgMgmtUserStatus3 AS ChgMgmtUserStatus3,
  I_ChgMgmtReqWorklist.ChgMgmtUserStatus4 AS ChgMgmtUserStatus4,
  I_ChgMgmtReqWorklist.ChgMgmtUserStatus5 AS ChgMgmtUserStatus5,
  I_ChgMgmtReqWorklist.ChgMgmtReqLeadingObjType AS ChgMgmtReqLeadingObjType,
  I_ChgMgmtReqWorklist._ChgMgmtReqLeadingObjTypeText AS _ChgMgmtReqLeadingObjTypeText,
  I_ChgMgmtReqWorklist.ChgMgmtReqLeadingObject AS ChgMgmtReqLeadingObject,
  I_ChgMgmtReqWorklist.ChgMgmtReqLeadingObjName AS ChgMgmtReqLeadingObjName,
  I_ChgMgmtReqWorklist.ChgMgmtReqLeadingObjectLoc AS ChgMgmtReqLeadingObjectLoc,
  I_ChgMgmtReqWorklist.ChgMgmtReqLeadingObjectLocName AS ChgMgmtReqLeadingObjectLocName,
  I_ChgMgmtReqWorklist.ChgMgmtReqMainPlant AS ChgMgmtReqMainPlant,
  I_ChgMgmtReqWorklist.ChgMgmtReqMainPlantUUID AS ChgMgmtReqMainPlantUUID,
  I_ChgMgmtReqWorklist._ChgMgmtReqMainPlantText AS _ChgMgmtReqMainPlantText,
  coalesce(I_ChgMgmtReqWorklist._ChgMgmtReqMainPlantText[1: ChgMgmtReqReltdObjUUID = I_ChgMgmtReqWorklist.ChgMgmtReqMainPlantUUID ].ChgMgmtReqReltdObjName, 'Not assigned') AS ChgMgmtReqMainPlantName,
  I_ChgMgmtReqWorklist.Country AS Country,
  I_ChgMgmtReqWorklist._CountryText AS _CountryText,
  I_ChgMgmtReqWorklist.ChgMgmtReqEnteredByBP AS ChgMgmtReqEnteredByBP,
  I_ChgMgmtReqWorklist._ChgMgmtReqEnteredByBP AS _ChgMgmtReqEnteredByBP,
  I_ChgMgmtReqWorklist.ChgMgmtReqEnteredByUser AS ChgMgmtReqEnteredByUser,
  I_ChgMgmtReqWorklist._EnteredBy AS _EnteredBy,
  I_ChgMgmtReqWorklist.ChgMgmtReqReportedByBP AS ChgMgmtReqReportedByBP,
  I_ChgMgmtReqWorklist._ChgMgmtReqReportedByBP AS _ChgMgmtReqReportedByBP,
  I_ChgMgmtReqWorklist._ChgMgmtReqReporter AS _ChgMgmtReqReporter,
  I_ChgMgmtReqWorklist.ChgMgmtReqIsEmergency AS ChgMgmtReqIsEmergency,
  I_ChgMgmtReqWorklist.ChgMgmtReqDurationCode AS ChgMgmtReqDurationCode,
  I_ChgMgmtReqWorklist._ChgMgmtReqDuration AS _ChgMgmtReqDuration,
  I_ChgMgmtReqWorklist._ChgMgmtReqDurationText AS _ChgMgmtReqDurationText,
  I_ChgMgmtReqWorklist.ChgMgmtReqImpact AS ChgMgmtReqImpact,
  I_ChgMgmtReqWorklist._ChgMgmtReqImpact AS _ChgMgmtReqImpact,
  I_ChgMgmtReqWorklist._ChgMgmtReqImpactText AS _ChgMgmtReqImpactText,
  I_ChgMgmtReqWorklist.ChgMgmtReqReversalDate AS ChgMgmtReqReversalDate,
  I_ChgMgmtReqWorklist.ChgMgmtReqApprovalDate AS ChgMgmtReqApprovalDate,
  I_ChgMgmtReqWorklist.ChgMgmtReqExecStartDate AS ChgMgmtReqExecStartDate,
  I_ChgMgmtReqWorklist.ChgMgmtReqOplStartDate AS ChgMgmtReqOplStartDate,
  I_ChgMgmtReqWorklist.ChgMgmtReqCreationDate AS ChgMgmtReqCreationDate,
  I_ChgMgmtReqWorklist.ChgMgmtReqReportedDate AS ChgMgmtReqReportedDate,
  I_ChgMgmtReqWorklist._CreationDate.CalendarYear AS ChgMgmtReqCreationYear,
  _CreationDate._CalendarMonth AS _ChgMgmtReqCreationMonth,
  _CreationDate.CalendarMonth AS ChgMgmtReqCreationMonth,
  _ReversalDate.CalendarYear AS ChgMgmtReqReversalYear,
  _ReversalDate._CalendarMonth AS _ChgMgmtReqReversalMonth,
  _ReversalDate.CalendarMonth AS ChgMgmtReqReversalMonth,
  _ApprovalDate.CalendarYear AS ChgMgmtReqApprovalYear,
  _ApprovalDate._CalendarMonth AS _ChgMgmtReqApprovalMonth,
  _ApprovalDate.CalendarMonth AS ChgMgmtReqApprovalMonth,
  _ExecStartDate.CalendarYear AS ChgMgmtReqExecStartYear,
  _ExecStartDate._CalendarMonth AS _ChgMgmtReqExecStartMonth,
  _ExecStartDate.CalendarMonth AS ChgMgmtReqExecStartMonth,
  _OplStartDate.CalendarYear AS ChgMgmtReqOplStartYear,
  _OplStartDate._CalendarMonth AS _ChgMgmtReqOplStartMonth,
  _OplStartDate.CalendarMonth AS ChgMgmtReqOplStartMonth,
  1 AS NumberOfChgMgmtRequests,
  I_ChgMgmtReqWorklist.ChgMgmtReqStatusCriticality AS ChgMgmtReqStatusCriticality,
  I_ChgMgmtReqWorklist.ChgMgmtReqIsAccessRestricted AS ChgMgmtReqIsAccessRestricted,
  I_ChgMgmtReqWorklist.ChgMgmtReqAuthorizationGroup AS ChgMgmtReqAuthorizationGroup,
  I_ChgMgmtReqWorklist._ChgMgmtReqLeadingObject AS _ChgMgmtReqLeadingObject,
  I_ChgMgmtReqWorklist._ChgMgmtReqMainPlant AS _ChgMgmtReqMainPlant,
  I_ChgMgmtReqWorklist._ChgMgmtActivity AS _ChgMgmtActivity,
  I_ChgMgmtReqWorklist._ChgMgmtReqPersonInvolved AS _ChgMgmtReqPersonInvolved
FROM I_ChgMgmtReqWorklist
LEFT OUTER JOIN I_Indicatortext AS _ChgMgmtReqEmergencyIndText ON I_ChgMgmtReqWorklist.ChgMgmtReqIsEmergency = _ChgMgmtReqEmergencyIndText.IndicatorValue  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts1Txt AS _ChgMgmtUserStsPrflFldSts1Text ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts1Text.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus1 = _ChgMgmtUserStsPrflFldSts1Text.ChgMgmtUserStatus  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts2Txt AS _ChgMgmtUserStsPrflFldSts2Text ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts2Text.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus2 = _ChgMgmtUserStsPrflFldSts2Text.ChgMgmtUserStatus  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts3Txt AS _ChgMgmtUserStsPrflFldSts3Text ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts3Text.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus3 = _ChgMgmtUserStsPrflFldSts3Text.ChgMgmtUserStatus  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts4Txt AS _ChgMgmtUserStsPrflFldSts4Text ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts4Text.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus4 = _ChgMgmtUserStsPrflFldSts4Text.ChgMgmtUserStatus  -- association [0..*]
LEFT OUTER JOIN I_ChgMgmtUserStsPrflFldSts5Txt AS _ChgMgmtUserStsPrflFldSts5Text ON ChgMgmtUserStatusProfile = _ChgMgmtUserStsPrflFldSts5Text.ChgMgmtUserStatusProfile AND ChgMgmtUserStatus5 = _ChgMgmtUserStsPrflFldSts5Text.ChgMgmtUserStatus  -- association [0..*]
;

Depth:

I_ChgMgmtRequestCube view

I_ChgMgmtReqWorklist view