This query provides you with an overview of service orders. 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 Service Orders
.
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 service orders, there is a maximum of 5 schemas available, with 10 categories each. In the Service Order Query
, only four 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 |
Service Order (SERVICEORDER) |
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 | Category 1 |
/CRMBW/CATL11 |
Characteristic | Category 2 |
/CRMBW/CATL21 |
Characteristic | Category 3 |
/CRMBW/CATL31 |
Characteristic | Category 4 |
/CRMBW/CATL41 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Currency |
/CRMBW/CURNCY |
|
Characteristic | Service Order |
/CRMBW/SRV_ORD |
|
Characteristic | Service Order ID |
/CRMBW/SVORDID |
|
Characteristic | Posting Date |
/CRMBW/POSTING |
|
Characteristic | Created On |
/CRMBW/CREA_AT |
|
Characteristic | Changed On |
/CRMBW/CHA_AT |
|
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 | 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 | Installed Base |
/CRMBW/IBASE |
|
Characteristic | Installed Base: Component (Instance) |
/CRMBW/INSTANC |
|
Characteristic | Reference Product |
/CRMBW/GUID_OB |
|
Characteristic | Reference Product ID |
/CRMBW/PRODUCT |
|
Characteristic | Activity Category |
/CRMBW/ACT_CAT |
|
Characteristic | Status |
/CRMBW/SVO_STC |
|
Characteristic | Accounting Indicator |
/CRMBW/AC_INDI |
|
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 Header (Document Currency) |
/CRMBW/GV_H_DC |
— |
Key Figure | Gross Value of Service Orders (Document Currency) |
/CRMBW/SVO_GH_DC |
— |
Key Figure | Gross Value of Unplanned Service Confirmations (Doc. Curr.) |
/CRMBW/UPSC_GV_DC |
— |
Key Figure | Gross Value Header |
/CRMBW/GV_SVOH |
— |
Key Figure | Gross Value of Service Orders |
/CRMBW/SVO_GV |
— |
Key Figure | Gross Value of Unplanned Service Confirmations |
/CRMBW/UPSC_GV |
— |
Key Figure | Gross Value of Service Orders and Unplanned Service Confirm. |
CRMBW_GVOSOAUSC |
Gross value of service orders plus gross value of unplanned service confirmations |
Key Figure | Average Gross Value of Service Orders and Unplanned Service Confirmations |
CRMBW_AOSOAUSC |
Gross value of service orders and unplanned service confirmations / (number of service orders (/CRMBW/NO_SRVO) plus number of unplanned service confirmations (/CRMBW/NO_USVC)) |
Key Figure | No. of Service Orders |
/CRMBW/NO_SRVO |
— |
Key Figure | No. of Unplanned Service Confirmations |
/CRMBW/NO_USVC |
— |
Key Figure | No. of Service Orders and Unplanned Service Confirmations |
CRMBW_NOSOAUSC |
Number of service orders plus number of unplanned service confirmations |
Key Figure | No. of Open Service Orders |
CRMBW_NOOSO |
— |
Key Figure | Completion Rate % (Service Order) |
CRMBW_CRSO |
Number of open service orders / number of service orders * 100 |
Key Figure | No. of Service Confirmations |
/CRMBW/NO_SVCO |
— |
Key Figure | No. of Open Service Confirmations |
CRMBW_NOOSC |
— |
Key Figure | Completion Rate % (Service Confirmation) |
CRMBW_CRSC |
Number of open service confirmations / number of service confirmations |
Key Figure | No. of Open Service Orders and Service Confirmations |
CRMBW_NOOSO_SC |
Number of open service orders plus number of open service confirmations |
Key Figure | Service Order Lead Time |
/CRMBW/SRVD_LC |
— |
Key Figure | Average Service Order Lead Time |
CRMBW_ASOLT |
Service order lead time / number of service orders |
Key Figure | No. of Closed Service Orders This Month |
/CRMBW/CLSVOTM |
— |
Key Figure | No. of New Service Orders This Month |
CRMBW_NSOTM |
— |
Key Figure | No. of Open Service Orders Created Prior to This Month |
CRMBW_OSOCPTTM |
— |
Key Figure | Closure Rate This Month |
CRMBW_CRTM |
Number of closed service orders this month / (number of new service orders this month plus number of open service orders created prior to this month) * 100 |