MDG_ANLY_S_CR_DATASOURCE SAP (Change Request Process Analytics Extract Structure) Structure details
Description: Change Request Process Analytics Extract Structure
Related tables to MDG_ANLY_S_CR_DATASOURCE
Access table MDG_ANLY_S_CR_DATASOURCE
Structure field list including key, data, relationships and ABAP select examples
MDG_ANLY_S_CR_DATASOURCE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change Request Process Analytics Extract Structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MDG_ANLY_S_CR_DATASOURCE TYPE MDG_ANLY_S_CR_DATASOURCE.
The MDG_ANLY_S_CR_DATASOURCE table consists of various fields, each holding specific information or linking keys about Change Request Process Analytics Extract Structure data available in SAP. These include CREATED_YEAR (CR Created Year), CREATED_QUARTER (CR Created Quarter), CREATED_MONTH (Created Month), CREATED_WEEK (CR Created Week).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP MDG_ANLY_S_CR_DATASOURCE structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| USMD_PRIORITY | Priority | USMD_PRIORITY | NUMC | 2 | Assigned to domain | USMD_PRIORITY | |||
| CREATED_YEAR | CR Created Year | MDG_ANLY_YEAR | NUMC | 4 | |||||
| CREATED_QUARTER | CR Created Quarter | MDG_ANLY_QUARTER | NUMC | 6 | |||||
| CREATED_MONTH | Created Month | MDG_ANLY_CREATED_MONTH | NUMC | 6 | |||||
| CREATED_WEEK | CR Created Week | MDG_ANLY_WEEK | NUMC | 6 | |||||
| CREATED_DATE | Change Request Creation Date | MDG_CR_CREATED_AT | DATS | 8 | DATUM | ||||
| USMD_MODEL | Data Model | USMD_MODEL | CHAR | 2 | Assigned to domain | USMD_MODEL | |||
| USMD_CREQ_TYPE | Type of Change Request | USMD_CREQUEST_TYPE | CHAR | 8 | USMD_CREQUEST_TYPE | ||||
| USMD_CREQUEST | Change Request | USMD_CREQUEST | NUMC | 12 | ALPHA | USMD_CREQUEST | |||
| DD_VIOLATED | Check Whether the CR Violated the Due Date | MDG_ANLY_DD_VIOLATED | INT4 | 10 | MDG_ANLY_FLAG | ||||
| DD_ON_TIME | Check Whether the Change Request with Due Date is On Time | MDG_ANLY_DD_ON_TIME | INT4 | 10 | MDG_ANLY_FLAG | ||||
| SLA_VIOLATED | Check Whether the CR has Violated the SLA | MDG_ANLY_SLA_VIOLATED | INT4 | 10 | MDG_ANLY_FLAG | ||||
| SLA_ON_TIME | Check Whether the CR With SLA Is On Time | MDG_ANLY_SLA_ON_TIME | INT4 | 10 | MDG_ANLY_FLAG | ||||
| OTHERS | SLA or Due Date is not Maintained | MDG_ANLY_OTHER_CR | INT4 | 10 | |||||
| CR_PRO_TIME | Processing Time | MDG_CR_PROCESSING_TIME | DEC | 21(7) | |||||
| TOTAL_ON_TIME | Check Whether the CR is On Time | MDG_ANLY_OTHERS_ON_TIME | INT4 | 10 | MDG_ANLY_FLAG | ||||
| IN_PROCESS | Check Whether the Status of the CR is In Process | MDG_ANLY_CR_INPROCESS | INT4 | 10 | MDG_ANLY_FLAG | ||||
| REJECTED | Check Whether the Status of CR is Rejected | MDG_ANLY_CR_REJECTED | INT4 | 10 | MDG_ANLY_FLAG | ||||
| APPROVED | Check Whether the Status of the Change Request is Approved | MDG_ANLY_CR_APPROVED | INT4 | 10 | MDG_ANLY_FLAG | ||||
| SLA_IN_DAYS | SLA In Days | MDG_ANLY_SLA_IN_DAYS | DEC | 10(2) | |||||
| USMD_REASON_REJ | Reason for Rejection | USMD_REASON_REJ | CHAR | 2 | Assigned to domain | USMD_REASON_REJ |
| Key field | Non-key field |
How do I retrieve data from SAP structure MDG_ANLY_S_CR_DATASOURCE using ABAP code?
As MDG_ANLY_S_CR_DATASOURCE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MDG_ANLY_S_CR_DATASOURCE as there is no data to select.How to access SAP table MDG_ANLY_S_CR_DATASOURCE
Within an ECC or HANA version of SAP you can also view further information about MDG_ANLY_S_CR_DATASOURCE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects