C_ChgMgmtActivityDueDateQ

DDL: C_CHGMGMTACTIVITYDUEDATEQ SQL: CCMACTDUEDQRY Type: view CONSUMPTION
41 Fields 1 Data Sources 1 Fiori Apps

Change Management Activity Due Date Query

C_ChgMgmtActivityDueDateQ is a Consumption CDS View that provides data about "Change Management Activity Due Date Query" in SAP S/4HANA. It reads from 1 data source (I_ChgMgmtActivityCube) and exposes 41 fields with key field ChgMgmtActyUUID. It is used in 1 Fiori application: Change Requests and Activities - Detailed Analysis.

Data Sources (1)

SourceAliasJoin Type
I_ChgMgmtActivityCube I_ChgMgmtActivityCube from

Annotations (12)

NameValueLevelField
EndUserText.label Change Management Activity Due Date Query view
Analytics.query true view
OData.publish true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CCMACTDUEDQRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fiori Apps (1)

App IDApp NameTypeDescription
F5469 Change Requests and Activities - Detailed Analysis Analytical With this app, you can analyze change requests and activities. You can add several analysis steps to create an analysis path. With this analysis path, you can evaluate data you need for information and reporting purposes.

Change Requests and Activities - Detailed Analysis

Business Role: Change Management Coordinator

With this feature, you can analyze change requests and activities using the Change Requests and Activities - Detailed Analysis (F5469) app. You can view graphical representations of change request and activities grouped by various criteria. You can add several analysis steps to create an analysis path. With this analysis path, you can evaluate the data you need for information and reporting purposes.

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ChgMgmtActyUUID ChgMgmtActyUUID
ChgMgmtReqType ChgMgmtReqType Change Request Type
ChgMgmtActyType ChgMgmtActyType
ChgMgmtDigitalSgntrStatus ChgMgmtDigitalSgntrStatus
ChgMgmtActyStatus ChgMgmtActyStatus
ChgMgmtUserStatus1 ChgMgmtUserStatus1
ChgMgmtUserStatus2 ChgMgmtUserStatus2
ChgMgmtUserStatus3 ChgMgmtUserStatus3
ChgMgmtUserStatus4 ChgMgmtUserStatus4
ChgMgmtUserStatus5 ChgMgmtUserStatus5
ChgMgmtActyDueDate ChgMgmtActyDueDate
ChgMgmtActyDueYear ChgMgmtActyDueYear Year
ChgMgmtActyDueMonth ChgMgmtActyDueMonth Calendar Month
ChgMgmtActyResponsible ChgMgmtActyResponsible
ChgMgmtActyIsOverdue ChgMgmtActyIsOverdue
NumberOfChgMgmtActivities NumberOfChgMgmtActivities Number of Change Activities
ChgMgmtReqStatus ChgMgmtReqStatus
ChgMgmtReqLeadingObject ChgMgmtReqLeadingObject
ChgMgmtReqLeadingObjType ChgMgmtReqLeadingObjType
ChgMgmtReqLeadingObjName ChgMgmtReqLeadingObjName
ChgMgmtReqMainPlant ChgMgmtReqMainPlant
ChgMgmtReqMainPlantName ChgMgmtReqMainPlantName
Country Country Venue: Ctry/Reg
ChgMgmtReqIsEmergency ChgMgmtReqIsEmergency
ChgMgmtReqImpact ChgMgmtReqImpact
ChgMgmtReqDurationCode ChgMgmtReqDurationCode
ChgMgmtReqCreationDate ChgMgmtReqCreationDate
ChgMgmtReqCreationMonth ChgMgmtReqCreationMonth
ChgMgmtReqCreationYear ChgMgmtReqCreationYear
ChgMgmtReqReversalDate ChgMgmtReqReversalDate
ChgMgmtReqReversalMonth ChgMgmtReqReversalMonth
ChgMgmtReqReversalYear ChgMgmtReqReversalYear
ChgMgmtReqApprovalDate ChgMgmtReqApprovalDate
ChgMgmtReqApprovalMonth ChgMgmtReqApprovalMonth
ChgMgmtReqApprovalYear ChgMgmtReqApprovalYear
ChgMgmtReqExecStartDate ChgMgmtReqExecStartDate
ChgMgmtReqExecStartMonth ChgMgmtReqExecStartMonth
ChgMgmtReqExecStartYear ChgMgmtReqExecStartYear
ChgMgmtReqOplStartDate ChgMgmtReqOplStartDate
ChgMgmtReqOplStartMonth ChgMgmtReqOplStartMonth
ChgMgmtReqOplStartYear ChgMgmtReqOplStartYear

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_ChgMgmtActivityDueDateQ.
-- 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: CCMACTDUEDQRY

CREATE VIEW C_ChgMgmtActivityDueDateQ AS
SELECT
  ChgMgmtActyUUID,
  ChgMgmtReqType,
  ChgMgmtActyType,
  ChgMgmtDigitalSgntrStatus,
  ChgMgmtActyStatus,
  ChgMgmtUserStatus1,
  ChgMgmtUserStatus2,
  ChgMgmtUserStatus3,
  ChgMgmtUserStatus4,
  ChgMgmtUserStatus5,
  ChgMgmtActyDueDate,
  ChgMgmtActyDueYear,
  ChgMgmtActyDueMonth,
  ChgMgmtActyResponsible,
  ChgMgmtActyIsOverdue,
  NumberOfChgMgmtActivities,
  ChgMgmtReqStatus,
  ChgMgmtReqLeadingObject,
  ChgMgmtReqLeadingObjType,
  ChgMgmtReqLeadingObjName,
  ChgMgmtReqMainPlant,
  ChgMgmtReqMainPlantName,
  Country,
  ChgMgmtReqIsEmergency,
  ChgMgmtReqImpact,
  ChgMgmtReqDurationCode,
  ChgMgmtReqCreationDate,
  ChgMgmtReqCreationMonth,
  ChgMgmtReqCreationYear,
  ChgMgmtReqReversalDate,
  ChgMgmtReqReversalMonth,
  ChgMgmtReqReversalYear,
  ChgMgmtReqApprovalDate,
  ChgMgmtReqApprovalMonth,
  ChgMgmtReqApprovalYear,
  ChgMgmtReqExecStartDate,
  ChgMgmtReqExecStartMonth,
  ChgMgmtReqExecStartYear,
  ChgMgmtReqOplStartDate,
  ChgMgmtReqOplStartMonth,
  ChgMgmtReqOplStartYear
FROM I_ChgMgmtActivityCube
;

Learn More