SAP ABAP Table MDG_ANLY_S_CR_DATASOURCE (Change Request Process Analytics Extract Structure)

Hierarchy

☛ MDG_FND (Software Component) MDG Foundation
   ⤷ CA-MDG-ANR (Application Component) Analytics and Reporting
     ⤷ MDG_ANALYTICS_UI (Package) MDG_ANALYTICS_UI

Basic Data

Table Category	INTTAB	Structure
Structure	MDG_ANLY_S_CR_DATASOURCE	Table Relationship Diagram
Short Description	Change Request Process Analytics Extract Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	USMD_PRIORITY	☐	USMD_PRIORITY	USMD_PRIORITY	NUMC	2	0	Priority	*
2	CREATED_YEAR	☐	MDG_ANLY_YEAR		NUMC	4	0	CR Created Year
3	CREATED_QUARTER	☐	MDG_ANLY_QUARTER		NUMC	6	0	CR Created Quarter
4	CREATED_MONTH	☐	MDG_ANLY_CREATED_MONTH		NUMC	6	0	Created Month
5	CREATED_WEEK	☐	MDG_ANLY_WEEK		NUMC	6	0	CR Created Week
6	CREATED_DATE	☐	MDG_CR_CREATED_AT	DATUM	DATS	8	0	Change Request Creation Date
7	USMD_MODEL	☐	USMD_MODEL	USMD_MODEL	CHAR	2	0	Data Model	*
8	USMD_CREQ_TYPE	☐	USMD_CREQUEST_TYPE	USMD_CREQUEST_TYPE	CHAR	8	0	Type of Change Request
9	USMD_CREQUEST	☐	USMD_CREQUEST	USMD_CREQUEST	NUMC	12	0	Change Request
10	DD_VIOLATED	☐	MDG_ANLY_DD_VIOLATED	MDG_ANLY_FLAG	INT4	10	0	Check Whether the CR Violated the Due Date
11	DD_ON_TIME	☐	MDG_ANLY_DD_ON_TIME	MDG_ANLY_FLAG	INT4	10	0	Check Whether the Change Request with Due Date is On Time
12	SLA_VIOLATED	☐	MDG_ANLY_SLA_VIOLATED	MDG_ANLY_FLAG	INT4	10	0	Check Whether the CR has Violated the SLA
13	SLA_ON_TIME	☐	MDG_ANLY_SLA_ON_TIME	MDG_ANLY_FLAG	INT4	10	0	Check Whether the CR With SLA Is On Time
14	OTHERS	☐	MDG_ANLY_OTHER_CR		INT4	10	0	SLA or Due Date is not Maintained
15	CR_PRO_TIME	☐	MDG_CR_PROCESSING_TIME		DEC	21	7	Processing Time
16	TOTAL_ON_TIME	☐	MDG_ANLY_OTHERS_ON_TIME	MDG_ANLY_FLAG	INT4	10	0	Check Whether the CR is On Time
17	IN_PROCESS	☐	MDG_ANLY_CR_INPROCESS	MDG_ANLY_FLAG	INT4	10	0	Check Whether the Status of the CR is In Process
18	REJECTED	☐	MDG_ANLY_CR_REJECTED	MDG_ANLY_FLAG	INT4	10	0	Check Whether the Status of CR is Rejected
19	APPROVED	☐	MDG_ANLY_CR_APPROVED	MDG_ANLY_FLAG	INT4	10	0	Check Whether the Status of the Change Request is Approved
20	SLA_IN_DAYS	☐	MDG_ANLY_SLA_IN_DAYS		DEC	10	2	SLA In Days
21	USMD_REASON_REJ	☐	USMD_REASON_REJ	USMD_REASON_REJ	CHAR	2	0	Reason for Rejection	*

History

Last changed by/on	SAP	20130604
SAP Release Created in	703