SAP ABAP Data Element QQTOTR (Total rows in table)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB4 (Application Component) DB2 for AS/400
     STU4 (Package) CCMS / AS/400
Basic Data
Data Element QQTOTR
Short Description Total rows in table  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type QQROWS    
Data Type INT4   4-byte integer, integer number with sign 
Length 10    
Decimal Places 0    
Output Length 10    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short 10 Tot. rows 
Medium Tot. rows 
Long 19 Total rows in table 
Heading Tot. rows 
Documentation

Definition

QQTOTR is the number of rows in the physical file (QQPTLN/QQPTFN) accessed before the query is executed.

QQTOTR is not available for records with QQRID 1000.

Note

  • For queries with a statement operation such as DELETE or INSERT, the number of rows after query execution may differ from number before query execution.
  • The optimizer takes QQTOTR into account when deciding how to implement the query.

History
Last changed by/on SAP  20070813 
SAP Release Created in