C_MDGovOpenWrkflwProdQry

DDL: C_MDGOVOPENWRKFLWPRODQRY SQL: CWFTSKOPENPRQRY Type: view CONSUMPTION
47 Fields 1 Data Sources 1 Fiori Apps

Analytics on Open WI for Products

C_MDGovOpenWrkflwProdQry is a Consumption CDS View that provides data about "Analytics on Open WI for Products" in SAP S/4HANA. It reads from 1 data source (I_MDGovChgReqWrkflwTskOpenCube) and exposes 47 fields with key fields WorkflowTaskInternalID, WorkflowOrglObjectType, WorkflowOrglObject. It is used in 1 Fiori application: Monitor Open Work Items from Change Requests for Products.

Data Sources (1)

SourceAliasJoin Type
I_MDGovChgReqWrkflwTskOpenCube I_MDGovChgReqWrkflwTskOpenCube from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CWFTSKOPENPRQRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Analytics.query true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
OData.publish true view
EndUserText.label Analytics on Open WI for Products view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fiori Apps (1)

App IDApp NameTypeDescription
F4751 Monitor Open Work Items from Change Requests for Products Transactional The overview page provides the master data specialist with an immediate status information about the open work items from change requests for Products and the ability to drill into the details for further analysis

Monitor Open Work Items from Change Requests for Products

Business Role: Master Data Specialist - Product Data

The Monitor Open Work Items from Change Request feature enables analytics end-users to analyze the Number of Work Items for open work items from change requests. Highlights of this feature include: You can drill-down by change request information, for example, Change Request Type, Change Request Status, Reason, Reject Reason, and Priority. You can drill-down by work item information, for example, Workflow Task, and Administration Data. You can display the dimensions by Intervals defined in customizing for Processing Hour, Processing Days, and Processing Workdays. Each SAP-delivered domain (Business Partner, Product and Financial Master Data) has own app in its central governance business catalog. You can display the details of a change request and its work items and navigate further to change request applications. These apps provide the following drilldown views: By Change Request Steps By Work item Status By Responsibility By Processing Hours By Processing Workdays

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID Work Item ID
KEY WorkflowOrglObjectType WorkflowOrglObjectType
KEY WorkflowOrglObject WorkflowOrglObject
WorkflowTaskStatus WorkflowTaskStatus
CreationDate MDGovChgReqWrkflwTskCrtnDte
CreationDateTime WrkflwTskCreationUTCDateTime
MDGovChgReqWrkflwTskCrtnYear MDGovChgReqWrkflwTskCrtnYear
MDGovChgReqWrkflwTskCrtnMonth MDGovChgReqWrkflwTskCrtnMonth
MDGovChgReqWrkflwTskCrtnWeek MDGovChgReqWrkflwTskCrtnWeek
MDGovChgReqWrkflwTskCrtnTme MDGovChgReqWrkflwTskCrtnTme
MDGovChgReqWrkflwTskCompltnTme MDGovChgReqWrkflwTskCompltnTme
MDGovChgReqWrkflwTskCompltnDte MDGovChgReqWrkflwTskCompltnDte
TopLevelWorkflowTask TopLevelWorkflowTask
WorkflowTaskCurrentUser WorkflowTaskCurrentUser
WorkflowTaskCreatedByUser WorkflowTaskCreatedByUser
WorkflowTaskDefinition WorkflowTaskDefinition Workflow Task
MDGovChgReqStep MDGovChgReqStep
MDGovWrkflwTskProcgDaysIntvl MDGovWrkflwTskProcgDaysIntvl
MDGovWrkflwTskProcgHrsIntvl MDGovWrkflwTskProcgHrsIntvl
MDGovWrkflwTskWrkDaysIntvl MDGovWrkflwTskWrkDaysIntvl
MDGovChangeRequest MDGovChangeRequest
MDGovChgReqDescription MDGovChgReqDescription
MDGovChgReqStatus MDGovChgReqStatus
MDGovChgReqType MDGovChgReqType
MDGovDataModel MDGovDataModel
MDGovChgReqPriority MDGovChgReqPriority
MDGovChgReqReason MDGovChgReqReason
MDGovChgReqRejectionReason MDGovChgReqRejectionReason
MDGovChgReqCreationDateTime MDGovChgReqCreationDateTime
CreatedByUser MDGovChgReqCreatedByUser
MDGovChgReqChangeDateTime MDGovChgReqChangeDateTime
MDGovChgReqChangedByUser MDGovChgReqChangedByUser
MDGovChgReqReleaseDateTime MDGovChgReqReleaseDateTime
MDGovChgReqReleasedByUser MDGovChgReqReleasedByUser
MDGovChgReqDataIsActivated MDGovChgReqDataIsActivated
MDGovChgReqDueDate MDGovChgReqDueDate
MDGovChgReqCreationDate MDGovChgReqCreationDate
MDGovChgReqCreationYear MDGovChgReqCreationYear
MDGovChgReqCreationMonth MDGovChgReqCreationMonth
MDGovChgReqCreationWeek MDGovChgReqCreationWeek
MDGovChgReqIsOverdue MDGovChgReqIsOverdue
MDGovChgReqIsOpen MDGovChgReqIsOpen
MDGovBusinessActivity MDGovBusinessActivity
MDChgProcessWorkflowTemplate MDChgProcessWorkflowTemplate
MDGovChgReqTypeIsParallel MDGovChgReqTypeIsParallel
BusinessObjectType BusinessObjectType Object Type
MDGovChgReqNmbrOfWrkflwTsks 0 Number of Work Items

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_MDGovOpenWrkflwProdQry.
-- 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: CWFTSKOPENPRQRY

CREATE VIEW C_MDGovOpenWrkflwProdQry AS
SELECT
  WorkflowTaskInternalID,
  WorkflowOrglObjectType,
  WorkflowOrglObject,
  WorkflowTaskStatus,
  MDGovChgReqWrkflwTskCrtnDte AS CreationDate,
  WrkflwTskCreationUTCDateTime AS CreationDateTime,
  MDGovChgReqWrkflwTskCrtnYear,
  MDGovChgReqWrkflwTskCrtnMonth,
  MDGovChgReqWrkflwTskCrtnWeek,
  MDGovChgReqWrkflwTskCrtnTme,
  MDGovChgReqWrkflwTskCompltnTme,
  MDGovChgReqWrkflwTskCompltnDte,
  TopLevelWorkflowTask,
  WorkflowTaskCurrentUser,
  WorkflowTaskCreatedByUser,
  WorkflowTaskDefinition,
  MDGovChgReqStep,
  MDGovWrkflwTskProcgDaysIntvl,
  MDGovWrkflwTskProcgHrsIntvl,
  MDGovWrkflwTskWrkDaysIntvl,
  MDGovChangeRequest,
  MDGovChgReqDescription,
  MDGovChgReqStatus,
  MDGovChgReqType,
  MDGovDataModel,
  MDGovChgReqPriority,
  MDGovChgReqReason,
  MDGovChgReqRejectionReason,
  MDGovChgReqCreationDateTime,
  MDGovChgReqCreatedByUser AS CreatedByUser,
  MDGovChgReqChangeDateTime,
  MDGovChgReqChangedByUser,
  MDGovChgReqReleaseDateTime,
  MDGovChgReqReleasedByUser,
  MDGovChgReqDataIsActivated,
  MDGovChgReqDueDate,
  MDGovChgReqCreationDate,
  MDGovChgReqCreationYear,
  MDGovChgReqCreationMonth,
  MDGovChgReqCreationWeek,
  MDGovChgReqIsOverdue,
  MDGovChgReqIsOpen,
  MDGovBusinessActivity,
  MDChgProcessWorkflowTemplate,
  MDGovChgReqTypeIsParallel,
  BusinessObjectType,
  0 AS MDGovChgReqNmbrOfWrkflwTsks
FROM I_MDGovChgReqWrkflwTskOpenCube
;

Learn More