Entering content frame

Key figure Records Selected from the Database Locate the document in its SAP Library structure

Technical name: 0TCTNDBSEL

Use

The Records Selected from the Database key figure (0TCTNDBSEL) counts the records that are read to the database with a query in order to calculate the result.

The number of records that are selected from the database are different from the number of records that are transferred from the database (see Records Transferred from the Database) if the data is grouped together and read: In this case, several records are grouped together for a resulting record. Therefore, the number of records selected from the database needs to be greater than or equal to the number of records that are transferred from the database.

From the ratio between the key figures Records Selected from the Database and Records Transferred from the Database (or from the ratio of the respective fields for the table RSDDSTAT, namely QDBSEL and QDBTRANS), you can determine whether it would be useful to use an aggregate: The larget the QDBSEL/QDBTRANS quotient is, the more helpful an aggregate would be, as long as the time needed for the database is significant (see Time, Reading from the Database).

Technical Data

Available as of Release

2.0/02

Unit

No

Aggregation

SUM

Exception Aggregation

Summation

Calculation

No

Restriction

No

 

 

Leaving content frame