I_ChgMgmtActyOverviewCube

DDL: I_CHGMGMTACTYOVERVIEWCUBE SQL: ICMACTOVWCUBE Type: view COMPOSITE
48 Fields 1 Data Sources 4 Associations

Change Management Activity Overview - Cube

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

Data Sources (1)

SourceAliasJoin Type
I_ChgMgmtActivityCube I_ChgMgmtActivityCube from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_BusinessUserBasic _BusinessUserBasicResponsible $projection.ChgMgmtActyResponsible = _BusinessUserBasicResponsible.BusinessPartner
[0..1] I_ChgMgmtAssignedIndicatorText _ChgMgmtAssignedIndicatorText $projection.ChgMgmtActyRespIsAssigned = _ChgMgmtAssignedIndicatorText.IndicatorValue and _ChgMgmtAssignedIndicatorText.Language = $session.system_language
[0..1] I_Indicatortext _IndicatorText $projection.ChgMgmtReqIsEmergency = _IndicatorText.IndicatorValue and _IndicatorText.Language = $session.system_language
[0..1] I_Country _Country $projection.Country = _Country.Country

Annotations (16)

NameValueLevelField
EndUserText.label Change Management Activity Overview - Cube view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ICMACTOVWCUBE 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 (48)

KeyFieldSource TableSource FieldDescription
KEY ChgMgmtActyUUID ChgMgmtActyUUID
ChgMgmtActivity ChgMgmtActivity
ChgMgmtActyCategory ChgMgmtActyCategory
ChgMgmtActyCategoryText
ChgMgmtActyDescText ChgMgmtActyDescText
ChgMgmtActyType ChgMgmtActyType
ChgMgmtActyTypeText
_ChgMgmtActyType _ChgMgmtActyType
ChgMgmtActyStatus ChgMgmtActyStatus
ChgMgmtActyStatusText
ChgMgmtActyResponsible ChgMgmtActyResponsible
_BusinessUserBasicResponsible _BusinessUserBasicResponsible
ChgMgmtActyRespIsAssigned ChgMgmtActyRespIsAssigned
ChgMgmtActyRespAssignedText _ChgMgmtAssignedIndicatorText IndicatorText
ChgMgmtActyDueDate ChgMgmtActyDueDate
ChgMgmtActyDueDateCriticality ChgMgmtActyDueDateCriticality
ChgMgmtActyDueDateTime ChgMgmtActyDueDateTime
ChgMgmtActyCompletionDate ChgMgmtActyCompletionDate
ChgMgmtActyIsOverdue ChgMgmtActyIsOverdue
IndicatorText
NumberOfChgMgmtActivities 1 Change Activities
ChgMgmtReqDescriptionText ChgMgmtReqDescriptionText
ChgMgmtRequest ChgMgmtRequest
Country Country Venue: Ctry/Reg
CountryName
ChgMgmtReqMainPlant ChgMgmtReqMainPlant
ChgMgmtReqMainPlantName ChgMgmtReqMainPlantName
ChgMgmtReqLeadingObjectLoc ChgMgmtReqLeadingObjectLoc
ChgMgmtReqLeadingObjectLocName ChgMgmtReqLeadingObjectLocName
ChgMgmtReqUUID ChgMgmtReqUUID
ChgMgmtReqStatus ChgMgmtReqStatus
ChgMgmtReqStatusText
ChgMgmtReqType ChgMgmtReqType Change Request Type
ChgMgmtReqTypeText
ChgMgmtReqLeadingObjType ChgMgmtReqLeadingObjType
ChgMgmtReltdObjTypeText
ChgMgmtReqImpact ChgMgmtReqImpact
ChgMgmtReqImpactText
ChgMgmtReqDurationCode ChgMgmtReqDurationCode
ChgMgmtReqDurationText
ChgMgmtReqIsEmergency ChgMgmtReqIsEmergency
ChgMgmtReqEmergencyText _IndicatorText IndicatorText
ChgMgmtActyAuthorizationGroup ChgMgmtActyAuthorizationGroup
ChgMgmtReqIsAccessRestricted ChgMgmtReqIsAccessRestricted
_ChgMgmtReqMainPlant _ChgMgmtReqMainPlant
_Country _Country
_ChgMgmtReqWorklist _ChgMgmtReqWorklist
_ChgMgmtActyPersonInvolved _ChgMgmtActyPersonInvolved

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_ChgMgmtActyOverviewCube.
-- 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: ICMACTOVWCUBE

CREATE VIEW I_ChgMgmtActyOverviewCube AS
SELECT
  ChgMgmtActyUUID,
  ChgMgmtActivity,
  ChgMgmtActyCategory,
  _ChgMgmtActyCategory._Text[1: Language = $session.system_language].ChgMgmtActyCategoryText AS ChgMgmtActyCategoryText,
  ChgMgmtActyDescText,
  ChgMgmtActyType,
  _ChgMgmtActyType._Text[1: Language = $session.system_language].ChgMgmtActyTypeText AS ChgMgmtActyTypeText,
  ChgMgmtActyStatus,
  _ChgMgmtActyStatus._Text[1: Language = $session.system_language].ChgMgmtActyStatusText AS ChgMgmtActyStatusText,
  ChgMgmtActyResponsible,
  ChgMgmtActyRespIsAssigned,
  _ChgMgmtAssignedIndicatorText.IndicatorText AS ChgMgmtActyRespAssignedText,
  ChgMgmtActyDueDate,
  ChgMgmtActyDueDateCriticality,
  ChgMgmtActyDueDateTime,
  ChgMgmtActyCompletionDate,
  ChgMgmtActyIsOverdue,
  _OverdueIndicator._IndicatorText[1: Language = $session.system_language].IndicatorText AS IndicatorText,
  1 AS NumberOfChgMgmtActivities,
  ChgMgmtReqDescriptionText,
  ChgMgmtRequest,
  Country,
  _CountryText[1:Language = $session.system_language].CountryName AS CountryName,
  ChgMgmtReqMainPlant,
  ChgMgmtReqMainPlantName,
  ChgMgmtReqLeadingObjectLoc,
  ChgMgmtReqLeadingObjectLocName,
  ChgMgmtReqUUID,
  ChgMgmtReqStatus,
  _ChgMgmtReqStatus._Text[1:Language = $session.system_language].ChgMgmtReqStatusText AS ChgMgmtReqStatusText,
  ChgMgmtReqType,
  _ChgMgmtReqType._Text[1:Language = $session.system_language].ChgMgmtReqTypeText AS ChgMgmtReqTypeText,
  ChgMgmtReqLeadingObjType,
  _ChgMgmtReltdObjType._Text[1:Language = $session.system_language].ChgMgmtReltdObjTypeText AS ChgMgmtReltdObjTypeText,
  ChgMgmtReqImpact,
  _ChgMgmtReqImpact._Text[1:Language = $session.system_language].ChgMgmtReqImpactText AS ChgMgmtReqImpactText,
  ChgMgmtReqDurationCode,
  _ChgMgmtReqDuration._Text[1:Language = $session.system_language].ChgMgmtReqDurationText AS ChgMgmtReqDurationText,
  ChgMgmtReqIsEmergency,
  _IndicatorText.IndicatorText AS ChgMgmtReqEmergencyText,
  ChgMgmtActyAuthorizationGroup,
  ChgMgmtReqIsAccessRestricted
FROM I_ChgMgmtActivityCube
LEFT OUTER JOIN I_BusinessUserBasic AS _BusinessUserBasicResponsible ON ChgMgmtActyResponsible = _BusinessUserBasicResponsible.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ChgMgmtAssignedIndicatorText AS _ChgMgmtAssignedIndicatorText ON ChgMgmtActyRespIsAssigned = _ChgMgmtAssignedIndicatorText.IndicatorValue AND _ChgMgmtAssignedIndicatorText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Indicatortext AS _IndicatorText ON ChgMgmtReqIsEmergency = _IndicatorText.IndicatorValue AND _IndicatorText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
;

Learn More