Service Order Query

Query Query: /CRMBW/SVO_C01_Q0001

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 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.

End of the note.

To use this query, you must activate the business function SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB).

Structure

Filters
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)

Free Characteristics
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`

Rows
Object Type	Name	Technical Name
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`

Columns
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