Workload Overview 
Query: 0CCMSWORKLOAD
You use this query to obtain an overview of the workload in ABAP systems, broken down by various criteria.
When you execute the query, you can:
Specify days, weeks, or months for the time interval (see Time Interval for Selection), depending on which time periods data is available for in the Business Warehouse.
Restrict the query to specific landscapes, systems, or instances (see Server/System for Selection).
In the query itself, you can break down the workload according to one or more of the following criteria:
Application Component
Users
Client
Organizational Unit
Report
Instance
Transaction
Time Range
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
|
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of Dialog Steps |
0CCMACNT |
# |
| Total Response Time (Seconds) |
0CCMARETI |
# |
| Average Response Time per Dialog Step (Microseconds) |
'Total Response Time'/'Number of Dialog Steps' |
|
| Total CPU Time (Seconds) |
0CCMACPTI |
# |
| Average CPU Time per Dialog Step (Microseconds) |
'Total CPU Time'/'Number of Dialog Steps' |
|
| Total Processing Time (Seconds) |
0CCMAPRTI |
# |
| Average Processing Time per Dialog Step (Microseconds) |
'Total Processing Time'/'Number of Dialog Steps' |
|
| Total Database Time (Seconds) |
'Total Sequential Read Time' + 'Total Direct Read Time' + 'Total Logical DB Change Time' |
|
| Average Database Time per Dialog Step (Microseconds) |
'Total Database Time'/'Number of Dialog Steps' |
|
| Number of Sequential Reads |
0CCMARSCN |
# |
| Total Sequential Read Time |
0CCMARSTI |
# |
| Average Sequential Read Time (Microseconds) |
'Total Sequential Read Time'/'Number of Sequential Reads' |
|
| Number of Direct Reads |
0CCMARDCN |
# |
| Total Direct Read Time |
0CCMARDTI |
# |
| Average Direct Read Time (Microseconds) |
'Total Direct Read Time'/'Number of Direct Reads' |
|
| Number of Logical Database Changes |
0CCMACHCN |
# |
| Total Logical DB Change Time |
0CCMACHTI |
# |
| Average Logical DB Change Time per Change (Microseconds) |
'Total Logical DB Change Time'/'Number of Logical Database Changes' |
|
| Number of DB Procedure Calls |
0CCMADPCN |
# |
| Total DB Procedure Call Time |
0CCMADPTI |
# |
| Average DB Procedure Call Time per Call (Microseconds) |
'Total DB Procedure Call Time'/'Number of DB Procedure Calls' |
|
| Total Wait Time (Seconds) |
0CCMAQETI |
# |
| Average Wait Time per Dialog Step (Microseconds) |
'Total Wait Time'/'Number of Dialog Steps' |
|
| Total Roll-In Time (Seconds) |
0CCMARITI |
# |
| Average Roll-In Time per Dialog Step (Microseconds) |
'Total Roll-In Time'/'Number of Dialog Steps' |
|
| Total Roll-Wait Time (Seconds) |
0CCMARWTI |
# |
| Average Roll-Wait Time per Dialog Step (Microseconds) |
'Total Roll-Wait Time'/'Number of Dialog Steps' |
|
| Total GUI Time |
0CCMAGUTI |
# |
| Average GUI Time per Dialog Step (Microseconds) |
'Total GUI Time'/'Number of Dialog Steps' |
|
| Total Front End Network Time |
0CCMAGNTI |
# |
| Average Front End Network Time per Dialog Step (Microseconds) |
'Total Front End Network Time'/'Number of Dialog Steps' |
|
| Total Data Volume to Application Server (KB) |
0CCMATBI |
# |
| Average Data Volume to Application Server per Dialog Step (B) |
'Total Data Volume to Application Server'/'Number of Dialog Steps' |
|
| Total Data Volume to Front End (KB) |
0CCMATBO |
# |
| Average Data Volume to Front End per Dialog Step (B) |
'Total Data Volume to Front End'/'Number of Dialog Steps' |
|
| Number of Modified DB Records |
0CCMAPHRC |
# |
| Number of Records Read from Single Record Buffer |
0CCMARDBF |
# |