I_ChgMgmtActivityCube
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 | Field |
|---|---|---|---|
| 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]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA