This query provides you with an overview of requests for change in service. The query contains a full set of all characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Requests for Change
.
For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.
This query is based on the InfoProvider /CRMBW/SVO_C01.
Note
For the categorization of requests for change in service, there is a maximum of 5 schemas available, with 10 categories each. In the Request for Change Query
, only eight of these categories are taken into account as standard (see Free Characteristics
). If you want to evaluate other categories within reports that are based on this query, you need to extend the query with the corresponding categories.
To use this query, you must activate the business function SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB
).
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Report Area | /CRMBW/REPORTA | Request for Change (REQUESTFORCHANGE) |
Characteristic | Application Server | /CRMBW/APPLS | Application server (/CRMBW/V_APPLS) |
Characteristic | Logical System | /CRMBW/LOGSYS | Source system (/CRMBW/V_LOGSY) |
Characteristic | Selection ID | /CRMBW/SELID | Selection ID (/CRMBW/V_SELID) |
Characteristic | User Name | /CRMBW/UNAME | Current User (/CRMBW/V_UNAME) |
Object Type | Name | Technical Name |
---|---|---|
Characteristic | Subject Category 1 | /CRMBW/CATL11 |
Characteristic | Reason Category 1 | /CRMBW/CATL12 |
Characteristic | Subject Category 2 | /CRMBW/CATL21 |
Characteristic | Reason Category 2 | /CRMBW/CATL22 |
Characteristic | Subject Category 3 | /CRMBW/CATL31 |
Characteristic | Reason Category 3 | /CRMBW/CATL32 |
Characteristic | Subject Category 4 | /CRMBW/CATL41 |
Characteristic | Reason Category 4 | /CRMBW/CATL42 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Request for Change | /CRMBW/SRV_ORD | |
Characteristic | Request for Change ID | /CRMBW/SVORDID | |
Characteristic | Installed Base | /CRMBW/IBASE | |
Characteristic | Installed Base: Component (Instance) | /CRMBW/INSTANC | |
Characteristic | Currency | /CRMBW/CURNCY | |
Characteristic | Day (Posting Date) | 0CALDAY | |
Characteristic | Week (Posting Date) | 0CALWEEK | |
Characteristic | Month (Posting Date) | 0CALMONTH | |
Characteristic | Quarter (Posting Date) | 0CALQUARTER | |
Characteristic | Year (Posting Date) | 0CALYEAR | |
Characteristic | Posting Date | /CRMBW/POSTING | |
Characteristic | Sales Organization | /CRMBW/SLS_ORG | |
Characteristic | Responsible Sales Org. Unit | /CRMBW/SLS_RES | |
Characteristic | Distribution Channel | /CRMBW/DIS_CHA | |
Characteristic | Service Organization | /CRMBW/SRV_ORG | |
Characteristic | Responsible Service Org. Unit | /CRMBW/SRV_RES | |
Characteristic | Service Team | /CRMBW/SRV_TM | |
Characteristic | Employee Responsible | /CRMBW/PERSON | |
Characteristic | Transaction Type | /CRMBW/PROCESS | |
Characteristic | Priority | /CRMBW/PRIORIT | |
Characteristic | Sold-To Party | /CRMBW/SLO_STP | |
Characteristic | Country | /CRMBW/COUNTRY | |
Characteristic | Region | /CRMBW/REGION | |
Characteristic | Object/Product ID | /CRMBW/PRODUCT | |
Characteristic | Object/Product | /CRMBW/GUID_OB | |
Characteristic | Status | /CRMBW/SVO_STC | |
Characteristic | Change Category | /CRMBW/CHG_CAT | |
Characteristic | Recommended Priority | /CRMBW/REC_PRI | |
Characteristic | Impact | /CRMBW/IMPACT | |
Characteristic | Urgency | /CRMBW/URGENCY | |
Characteristic | Risk | /CRMBW/RISK | |
Characteristic | Escalation Level | /CRMBW/ESCALAT | |
Characteristic | Company Code | /CRMBW/ICBD_CC | |
Characteristic | Logical System | /CRMBW/ICBD_LS | |
Characteristic | Activity Category | /CRMBW/ACT_CAT | |
Characteristic | Service Contract ID | /CRMBW/SRVCONT | |
Characteristic | Category ID | /CRMBW/CAT_ID | |
Characteristic | Coherent Cat. - Aspect ID | /CRMBW/ASPID |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Gross Value of Requests for Change (Document Currency) | /CRMBW/GV_H_DC | — |
Key Figure | Gross Value of Requests for Change | /CRMBW/GV_SVOH | — |
Key Figure | Number of Requests for Change with Status: Waiting for Approval | /CRMBW/RFC_WITH_AW_APP | — |
Key Figure | No. of Rejected Requests for Change | /CRMBW/NO_REJ_RFC | — |
Key Figure | Number of Closed Requests for Change | /CRMBW/NUCLORFC | — |
Key Figure | No. of Requests for Change | /CRMBW/NO_RFC | — |
Key Figure | No. of Open Requests for Change | CRMBW_NOORFC | — |
Key Figure | Percentage of Open Requests for Change | CRMBW_POORFC | Number of open requests for change / number of requests for change * 100 |
Key Figure | No. of Approved Requests for Change | CRMBW_NOARFC | — |
Key Figure | Percentage of Approved Requests for Change | CRMBW_POARFC | No. of approved requests for change / (number of requests for change with status: Waiting for Approval plus no. of rejected requests for change) |
Key Figure | 0-7 Days | CRMBW_NORFC07 | Number of closed requests for change / number of requests for change * 100 |
Key Figure | Closure Rate | CRMBW_CRRFC | — |
Key Figure | Average Work Duration | CRMBW_RFCAWD | Work duration (/CRMBW/W_DURA) / number of requests for change |
Key Figure | Average Total Duration | CRMBW_RFCATD | Total duration (/CRMBW/TW_DURA) / number of requests for change |
Key Figure | Total Duration | /CRMBW/TW_DURA | — |
Key Figure | Work Duration | /CRMBW/W_DURA | — |
Key Figure | Number of Requests for Change Within Requested End | CRMBW_NORFCWRE | — |
Key Figure | Percentage of Requests for Change Within Requested End | CRMBW_PORFCWRE | Number of requests for change within requested end / number of requests for change |
Key Figure | Number of Requests for Change Outside Requested End | CRMBW_NORFCORE | — |
Key Figure | Percentage of Requests for Change Outside Requested End | CRMBW_PORFCORE | Number of requests for change outside requested end / number of requests for change |
Key Figure | No. of Escalated Requests for Change (Escalation Level 1) | CRMBW_NOERFCL1 | — |
Key Figure | No. of Escalated Requests for Change (Escalation Level 2) | CRMBW_NOERFCL2 | — |
Key Figure | No. of Requests for Change Outside Reaction Time | CRMBW_NORFCORT | — |
Key Figure | Reaction Time Adherence Rate | CRMBW_RFCRTAR | Number of requests for change outside reaction time / number of open requests for change * 100 |