Show TOC

Service Order Query Locate this document in the navigation structure

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 Characteristic

Report Area

/CRMBW/REPORTA

Service Order (SERVICEORDER)

Characteristic Characteristic

Application Server

/CRMBW/APPLS

Application server (/CRMBW/V_APPLS)

Characteristic Characteristic

Logical System

/CRMBW/LOGSYS

Source system (/CRMBW/V_LOGSY)

Characteristic Characteristic

Selection ID

/CRMBW/SELID

Selection ID (/CRMBW/V_SELID)

Characteristic Characteristic

User Name

/CRMBW/UNAME

Current User (/CRMBW/V_UNAME)

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Category 1

/CRMBW/CATL11

Characteristic Characteristic

Category 2

/CRMBW/CATL21

Characteristic Characteristic

Category 3

/CRMBW/CATL31

Characteristic Characteristic

Category 4

/CRMBW/CATL41

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Currency

/CRMBW/CURNCY

Characteristic Characteristic

Service Order

/CRMBW/SRV_ORD

Characteristic Characteristic

Service Order ID

/CRMBW/SVORDID

Characteristic Characteristic

Posting Date

/CRMBW/POSTING

Characteristic Characteristic

Created On

/CRMBW/CREA_AT

Characteristic Characteristic

Changed On

/CRMBW/CHA_AT

Characteristic Characteristic

Day (Posting Date)

0CALDAY

Characteristic Characteristic

Week (Posting Date)

0CALWEEK

Characteristic Characteristic

Month (Posting Date)

0CALMONTH

Characteristic Characteristic

Quarter (Posting Date)

0CALQUARTER

Characteristic Characteristic

Year (Posting Date)

0CALYEAR

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

Characteristic Characteristic

Responsible Sales Org. Unit

/CRMBW/SLS_RES

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

Characteristic Characteristic

Service Organization

/CRMBW/SRV_ORG

Characteristic Characteristic

Responsible Service Org. Unit

/CRMBW/SRV_RES

Characteristic Characteristic

Service Team

/CRMBW/SRV_TM

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

Characteristic Characteristic

Priority

/CRMBW/PRIORIT

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

Characteristic Characteristic

Country

/CRMBW/COUNTRY

Characteristic Characteristic

Region

/CRMBW/REGION

Characteristic Characteristic

Installed Base

/CRMBW/IBASE

Characteristic Characteristic

Installed Base: Component (Instance)

/CRMBW/INSTANC

Characteristic Characteristic

Reference Product

/CRMBW/GUID_OB

Characteristic Characteristic

Reference Product ID

/CRMBW/PRODUCT

Characteristic Characteristic

Activity Category

/CRMBW/ACT_CAT

Characteristic Characteristic

Status

/CRMBW/SVO_STC

Characteristic Characteristic

Accounting Indicator

/CRMBW/AC_INDI

Characteristic Characteristic

Category ID

/CRMBW/CAT_ID

Characteristic Characteristic

Coherent Cat. - Aspect ID

/CRMBW/ASPID

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Gross Value Header (Document Currency)

/CRMBW/GV_H_DC

Key Figure Key Figure

Gross Value of Service Orders (Document Currency)

/CRMBW/SVO_GH_DC

Key Figure Key Figure

Gross Value of Unplanned Service Confirmations (Doc. Curr.)

/CRMBW/UPSC_GV_DC

Key Figure Key Figure

Gross Value Header

/CRMBW/GV_SVOH

Key Figure Key Figure

Gross Value of Service Orders

/CRMBW/SVO_GV

Key Figure Key Figure

Gross Value of Unplanned Service Confirmations

/CRMBW/UPSC_GV

Key Figure 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 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 Key Figure

No. of Service Orders

/CRMBW/NO_SRVO

Key Figure Key Figure

No. of Unplanned Service Confirmations

/CRMBW/NO_USVC

Key Figure Key Figure

No. of Service Orders and Unplanned Service Confirmations

CRMBW_NOSOAUSC

Number of service orders plus number of unplanned service confirmations

Key Figure Key Figure

No. of Open Service Orders

CRMBW_NOOSO

Key Figure Key Figure

Completion Rate % (Service Order)

CRMBW_CRSO

Number of open service orders / number of service orders * 100

Key Figure Key Figure

No. of Service Confirmations

/CRMBW/NO_SVCO

Key Figure Key Figure

No. of Open Service Confirmations

CRMBW_NOOSC

Key Figure Key Figure

Completion Rate % (Service Confirmation)

CRMBW_CRSC

Number of open service confirmations / number of service confirmations

Key Figure 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 Key Figure

Service Order Lead Time

/CRMBW/SRVD_LC

Key Figure Key Figure

Average Service Order Lead Time

CRMBW_ASOLT

Service order lead time / number of service orders

Key Figure Key Figure

No. of Closed Service Orders This Month

/CRMBW/CLSVOTM

Key Figure Key Figure

No. of New Service Orders This Month

CRMBW_NSOTM

Key Figure Key Figure

No. of Open Service Orders Created Prior to This Month

CRMBW_OSOCPTTM

Key Figure 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