TABLE_COUNT

Data Description

The TABLE_COUNT event is used in SAP to count the number of records and storage size for the largest tables in an SAP system.

Potential Use Cases

This event could be used for the following scenarios:

• Determine candidates for data archiving.

• Understand if records for a large table were unexpectedly deleted.

Metric Filters

Metric filter is available in Administrator->Metric Filters->More->Record count filter menu option

The filter accepts the list of tables which needs to checked:

Metric Configuration

By default, the extractor pulling top 50 tables by record count. However, in case manual input is used, the recommendation is to set the parameter below to 0 in Administrator->Setup Metric->Metric Configuration menu option.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Navigate to this data by using the SE16 transaction code. Then enter the table name of interest in the Table Name field, and hit the Enter key on your keyboard.

Then use the number of entries button from the selection screen.

Then the information regarding the record count, which matches the data in Splunk will appear.