Data Description

The SM51 event is used in SAP to to display list of active application servers that have registered in the SAP message server. You can manage & display the status, users, work process in all application servers belonging to the SAP System.

Potential Use Cases

This event could be used in the following scenarios:

  • Alert on long-running work processes.

  • Alert on work process utilization.

  • Correlate work process data with other data from the SAP environment including batch jobs, work process trace files, database processes, user experience transactions, etc.

  • Visualize system utilization over time by work process type.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Log into the managed system and execute the SM51 transaction code. Double-click on the application server of interest.

The information on this screen is collected by the SM51 extractor. Select a work process of interest and hit the details button.

The information from this screen will also be collected by the SM51 extractor.

Field Mapping

Field

Description

Unit of Measure

ABGC_ALLOC_OBJS

Number of Objects Created Between Two Garbage Collector Runs

Number

ABGC_CALLED_EXPL

Number of GC Runs Started Directly by the Application

Boolean

ABGC_FREED_OBJS

Number of Objects Released During this ABAP GC Run

Number

ABGC_RUN_COUNT

Number of ABAP Garbage Collector Runs

Number

ABGC_TIME

Time Required by the ABAP Garbage Collector

Number

ACT_RQ_CA

Dummy for B20 int1 (Local Everywhere)

Number

BTCJOBCNT

Job ID

Number

BTCJOBNAME

Background job name

String

CLI_INFO_CA

Dummy for B20 int1 (Local Everywhere)

Number

COMMAND_ZZ

Command for top cpu using by "SAPOSCOL"

Number

COMMITTI

DB time spent in commit operations

Number

CONTEXT_ID

ID of Context (External Session)

Integer

CONV_ID_CA

Conversation ID

Number

CPU_TIME_ZZ

CPU time for top cpu using by "SAPOSCOL"

Number

CPU_UTIL_ZZ

Data for tables to call "SAPOSCOL"

Number

CUAPROGRAM

CUA program name

String

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

DBPROCCNT

Statistics, counter field in raw statistical record

Number

DELCNT

DB count of delete operations

Number

DELREC

DB number of deleted records

Number

DELTI

DB time spent in delete operations

Number

DEST_CA

Logical Destination (Specified in Function Call)

String

DIALOG_STEP

Dialog Step Number of Session

Number

DSQLCNT

Statistics, counter field in raw statistical record

Number

DYNPRONR

Screen number or transaction name

Number

EVENT_SUBTYPE

String

EVENT_TYPE

SM51

String

FCODE

Function code

String

HTTPCNT

Number of HTTP Requests

Number

HTTPTIME

Time Spent Waiting for HTTP Requests

Number

INSCNT

DB count of insert operations

Number

INSREC

DB number of inserted records

Number

INSTANCE_NAME

Application Server Instance

String

INSTI

DB time spent in insert operations

Number

LOCKCNT

DB number of lock operations

Number

LOCKTI

DB time spent in lock operations

Number

LOGON_HDL_CA

Natural Number

Number

LOGON_ID_CA

Natural Number

Number

MEMORY_ABAP

ABAP memory

Number (kilobytes)

MEMORY_BRUTTO

Gross memory

Number (kilobytes)

MEMORY_HEAP

Heap memory

Number (kilobytes)

MEMORY_HYPER

Hyper memory

Number (kilobytes)

MEMORY_NET

Net memory

Number (kilobytes)

MEMSUM

Extended memory

Number (kilobytes)

PRIORITY_ZZ

Data for tables to call "SAPOSCOL"

Number

PRIVMODE

Statistics, hex 1 field

Boolean

PRIVSUM

Heap (private) Memory

Number

PRIV_PAGES_ZZ

Data for tables to call "SAPOSCOL"

Number

PROC_ID_ZZ

Data for tables to call "SAPOSCOL"

Number

QUEUETIME

Time the request had to wait in the dispatcher queue

Number

READDIRCNT

DB count of direct read operations

Number

READDIRREC

DB number of records selected during direct read

Number

READDIRTI

DB time spent in direct reads

Number

READSEQCNT

DB count of sequential read operations

Number

READSEQREC

DB number of records selected during sequential read

Number

READSEQTI

DB time spent in sequential reads

Number

REQ_TIME_CA

Natural Number

Number

RESPTIME

Response Time of Dialog Step

Number

RES_SIZE_ZZ

Data for tables to call "SAPOSCOL"

Number

RFCCNT

Statistics, counter field in raw statistical record

Number

RFCTI

Double field for statistics

Number

ROLLED_OUT

Response Time of Dialog Step

Number

SERIALNR_ZZ

Serial number in saposcol result structure

String

SESSION_HDL_CA

Natural Number

Number

SQL_TEXT

SQL statement text

String

SRCLODCNT

Statistics, counter field in raw statistical record

Number

STARTDATE

Start date for dialog step

YYYYMMDD

STARTTIME

Start time for dialog step

HHMMDD

STATE_CA

Dummy for B20 int1 (Local Everywhere)

Number

SUBTYPE_ZZ

Subtype in saposcol result structure

Boolean

TCODE

Transaction code

String

TID_MODE_CA

Terminal ID and External Session Number

String

TYPE_CA

Dummy for B20 int1 (Local Everywhere)

Number

TYPE_ZZ

Type in saposcol result structure

Boolean

T_ACT_RQ_CA

Actual request description

String

T_CLI_INFO_CA

Client info description

String

T_STATE_CA

State description

Number

T_TYPE_CA

Type description

Number

UPDCNT

DB count of update operations

Number

UPDREC

DB number of updated records

Number

UPDTI

DB time spent in update operations

Number

USEDBYTES

DEC type that is suitable for 64 bit integer

Number

USERNAME_ZZ

User name

String

USER_CA

User Name

String

UTCDIFF

The UTC OFFSSET in HHMMSS that the data was collected in

HHMMSS

UTCSIGN

The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.

+ | -

WP_ACTION

Current Activity of the Work Process

String

WP_BNAME

User Currently Served

String

WP_CPU

CPU

Number

WP_DUMPS

Number of Dumps of the Work Process

Number

WP_ELTIME

Previous Runtime of Request (elapsed)

Number (seconds)

WP_IACTION

Current activity of the work process

Number

WP_INDEX

Work Process Number

Number

WP_INDEX_CA

Natural Number

Number

WP_IRESTRT

Restart After Error

Number

WP_ISTATUS

Work process status

Number

WP_ITYPE

Internal work process type

Number

WP_IWAIT

Reason for wait

Number

WP_MANDT

Client

Number

WP_MTX

Mutex Counter

Number

WP_MTX_EXCL

Exclusive Mutex Counter

Number

WP_MTX_SHRD

Shared Mutex Counter

Number

WP_NO

(Deprecated) Use WP_UNDEX

Number

WP_PID

Process Identification

Number

WP_REPORT

Report now running

String

WP_RESTART

Restart work process after dump?

Boolean

WP_SEM

Semaphore that the work process is waiting for

Number

WP_SEM1

Number of Locked Semaphore

Number

WP_SEM2

Number of Locked Semaphore

Number

WP_SEM3

Number of Locked Semaphore

Number

WP_SEM4

Number of Locked Semaphore

Number

WP_SEM5

Number of Locked Semaphore

Number

WP_SEMSTAT

Internal work process type

Number

WP_SEM_LOCKING

Number of Locking Semaphores

Number

WP_SERVER

Server Name

String

WP_STATUS

Work process status

String

WP_TABLE

DB table last accessed by the work process

String

WP_TYP

Type

String

WP_WAITINF

Additional information about the reason for waiting

String

WP_WAITING

Why Work Process is Waiting

String

WP_WAITTIM

Time when waiting started

HH:MM:SS