Show TOC

Service Query Locate this document in the navigation structure

Query Query: /CRMBW/CSRV_C01_Q0001

 

This query provides you with an overview of service tickets. 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 Tickets.

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.

This query is based on the InfoProvider /CRMBW/CSRV_C01.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

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

Object Type

Name

Technical Name

Value Restriction / Calculation

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

Posting Date

/CRMBW/POSTING

Characteristic Characteristic

Service Ticket

/CRMBW/SRV_ID

Characteristic Characteristic

Service Ticket Type

/CRMBW/PROCESS

Characteristic Characteristic

Status

/CRMBW/SRV_STC

Characteristic Characteristic

Status: Open

/CRMBW/STATOP

Characteristic Characteristic

Category ID

/CRMBW/CAT_ID

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

Characteristic Characteristic

Responsible Group

/CRMBW/RESP_GR

Characteristic Characteristic

Priority

/CRMBW/PRIORIT
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Lead Time

/CRMBW/LC_SRV

—

Key Figure Key Figure

No. of Service Tickets

/CRMBW/NUM_OF

—

Key Figure Key Figure

Average Lead Time

CRMBW_AVLEAD

Lead time / number of service tickets

Key Figure Key Figure

Closed Service Tickets

CRMBW_NUM_CL

—

Key Figure Key Figure

Closure Rate

CRMBW_CLRATE

Closed service tickets / number of service tickets * 100

Key Figure Key Figure

No. of Closed Items

/CRMBW/NUM_OFI

—

Key Figure Key Figure

Compl. by SLA Date

/CRMBW/KF_SRV

—

Key Figure Key Figure

Service Tickets 0-7 Days

CRMBW_NUM_07

—

Key Figure Key Figure

Service Tickets 8-30 Days

CRMBW_NUM_830

—

Key Figure Key Figure

Service Tickets 31-60 Days

CRMBW_NUM_316

—

Key Figure Key Figure

Service Tickets > 60 Days

CRMBW_NUM_60P

—

Key Figure Key Figure

New Service Tickets This Month

CRMBW_NUM_NM

—

Key Figure Key Figure

Open Service Tickets

CRMBW_NUM_OO

—