C_ChgMgmtActyOverviewQuery

DDL: C_CHGMGMTACTYOVERVIEWQUERY SQL: CMOCACTOVWQ Type: view CONSUMPTION
42 Fields 1 Data Sources 1 Fiori Apps

Change Activities Overview - Query

C_ChgMgmtActyOverviewQuery is a Consumption CDS View that provides data about "Change Activities Overview - Query" in SAP S/4HANA. It reads from 1 data source (I_ChgMgmtActyOverviewCube) and exposes 42 fields with key field ChgMgmtActyUUID. It is used in 1 Fiori application: Change Activities Dashboard.

Data Sources (1)

SourceAliasJoin Type
I_ChgMgmtActyOverviewCube I_ChgMgmtActyOverviewCube from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMOCACTOVWQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Change Activities Overview - Query view
Analytics.query true view
VDM.viewType #CONSUMPTION view
OData.publish true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fiori Apps (1)

App IDApp NameTypeDescription
F5761 Change Activities Dashboard Analytical

Change Activities Dashboard

Business Role: Change Management Coordinator

With this feature you can get an overview of the existing change activities in the new Change Activities Dashboard app. You can use dynamic filters with chart visualizations to analyze change activities by various criteria, such as type, status, overdue status, and whether a main responsible person is assigned.

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY ChgMgmtActyUUID ChgMgmtActyUUID
ChgMgmtActivity ChgMgmtActivity
ChgMgmtActyCategory ChgMgmtActyCategory
ChgMgmtActyCategoryText ChgMgmtActyCategoryText
ChgMgmtActyDescText ChgMgmtActyDescText
ChgMgmtRequest ChgMgmtRequest
ChgMgmtReqDescriptionText ChgMgmtReqDescriptionText
ChgMgmtActyType ChgMgmtActyType
ChgMgmtActyTypeText ChgMgmtActyTypeText
ChgMgmtActyIsOverdue ChgMgmtActyIsOverdue
Country Country Venue: Ctry/Reg
CountryName CountryName Country
ChgMgmtReqMainPlant ChgMgmtReqMainPlant
ChgMgmtReqMainPlantName ChgMgmtReqMainPlantName
ChgMgmtReqLeadingObjectLoc ChgMgmtReqLeadingObjectLoc
ChgMgmtReqLeadingObjectLocName ChgMgmtReqLeadingObjectLocName
IndicatorText IndicatorText
ChgMgmtActyDueDate ChgMgmtActyDueDate
ChgMgmtActyCompletionDate ChgMgmtActyCompletionDate
ChgMgmtActyDueDateCriticality ChgMgmtActyDueDateCriticality
ChgMgmtActyStatus ChgMgmtActyStatus
ChgMgmtActyStatusText ChgMgmtActyStatusText
ChgMgmtActyResponsible ChgMgmtActyResponsible
ChgMgmtActyRespIsAssigned ChgMgmtActyRespIsAssigned Main Responsible Assigned
ChgMgmtActyRespAssignedText ChgMgmtActyRespAssignedText
NumberOfChgMgmtActivities NumberOfChgMgmtActivities
ChgMgmtReqStatus ChgMgmtReqStatus Change Request Status
ChgMgmtReqStatusText ChgMgmtReqStatusText Change Request Status
ChgMgmtReqType ChgMgmtReqType Change Request Type
ChgMgmtReqTypeText ChgMgmtReqTypeText Change Request Type
ChgMgmtReqLeadingObjType ChgMgmtReqLeadingObjType Change Request Leading Object Type
ChgMgmtReltdObjTypeText ChgMgmtReltdObjTypeText Change Request Leading Object Type
ChgMgmtReqImpact ChgMgmtReqImpact Change Request Impact
ChgMgmtReqImpactText ChgMgmtReqImpactText Change Request Impact
ChgMgmtReqDurationCode ChgMgmtReqDurationCode Change Request Duration
ChgMgmtReqDurationText ChgMgmtReqDurationText Change Request Duration
ChgMgmtReqIsEmergency ChgMgmtReqIsEmergency Change Request Emergency
ChgMgmtReqEmergencyText ChgMgmtReqEmergencyText Change Request Emergency
_Country _Country
_ChgMgmtReqWorklist _ChgMgmtReqWorklist
_ChgMgmtActyPersonInvolved _ChgMgmtActyPersonInvolved
ChgMgmtReqIsAccessRestricted ChgMgmtReqIsAccessRestricted

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_ChgMgmtActyOverviewQuery.
-- 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: CMOCACTOVWQ

CREATE VIEW C_ChgMgmtActyOverviewQuery AS
SELECT
  ChgMgmtActyUUID,
  ChgMgmtActivity,
  ChgMgmtActyCategory,
  ChgMgmtActyCategoryText,
  ChgMgmtActyDescText,
  ChgMgmtRequest,
  ChgMgmtReqDescriptionText,
  ChgMgmtActyType,
  ChgMgmtActyTypeText,
  ChgMgmtActyIsOverdue,
  Country,
  CountryName,
  ChgMgmtReqMainPlant,
  ChgMgmtReqMainPlantName,
  ChgMgmtReqLeadingObjectLoc,
  ChgMgmtReqLeadingObjectLocName,
  IndicatorText,
  ChgMgmtActyDueDate,
  ChgMgmtActyCompletionDate,
  ChgMgmtActyDueDateCriticality,
  ChgMgmtActyStatus,
  ChgMgmtActyStatusText,
  ChgMgmtActyResponsible,
  ChgMgmtActyRespIsAssigned,
  ChgMgmtActyRespAssignedText,
  NumberOfChgMgmtActivities,
  ChgMgmtReqStatus,
  ChgMgmtReqStatusText,
  ChgMgmtReqType,
  ChgMgmtReqTypeText,
  ChgMgmtReqLeadingObjType,
  ChgMgmtReltdObjTypeText,
  ChgMgmtReqImpact,
  ChgMgmtReqImpactText,
  ChgMgmtReqDurationCode,
  ChgMgmtReqDurationText,
  ChgMgmtReqIsEmergency,
  ChgMgmtReqEmergencyText,
  ChgMgmtReqIsAccessRestricted
FROM I_ChgMgmtActyOverviewCube
;

Learn More