DBSTATTDB4 SAP (Table Sizes in the Database) Table details

Dictionary Type: Table
Description: Table Sizes in the Database




ABAP Code to SELECT data from DBSTATTDB4
Related tables to DBSTATTDB4
Access table DBSTATTDB4




Table field list including key, data, relationships and ABAP select examples

DBSTATTDB4 is a standard SAP Table which is used to store Table Sizes in the Database data and is available within R/3 SAP systems depending on the version and release level.

The DBSTATTDB4 table consists of various fields, each holding specific information or linking keys about Table Sizes in the Database data available in SAP. These include ANDAT (Analysis date (yyyymmddhhmm)), VWTYP (Single-Character Indicator), TABSIZE (Used blocks of a table in KB), CURROWS (Number of rows in a table).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DBSTATTDB4 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TABNAMETable name TNAMECHAR30Assigned to domainAS4TAB
ANDATAnalysis date (yyyymmddhhmm) AM_DATECHAR12CHAR12
VWTYPSingle-Character Indicator CHAR1CHAR1CHAR1
TABSIZEUsed blocks of a table in KB UBLOCKS_KBDEC11DEC11
CURROWSNumber of rows in a table OROWSDEC15DEC15
INDBSUsed blocks of an index-Btree (kb) BBLOCKS_KBDEC15DEC15
DLTROWSiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMOPENiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMCLOSEiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMINSERTiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMUPDATEiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMDELETEiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMLREADiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMPREADiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
NUMCSTiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
CSTSIZEiSeries: Number of rows / object size DB4_ANZ15DEC15DB4_ANZ15
CRTDATEDate DATUMDATS8DATUM
CRTTIMECharacter field of length 6 CHAR6CHAR6CHAR6
SAVDATEDate DATUMDATS8DATUM
SAVTIMECharacter field of length 6 CHAR6CHAR6CHAR6
RSTDATEDate DATUMDATS8DATUM
RSTTIMECharacter field of length 6 CHAR6CHAR6CHAR6

Key field Non-key field



How do I retrieve data from SAP table DBSTATTDB4 using ABAP code

The following ABAP code Example will allow you to do a basic selection on DBSTATTDB4 to SELECT all data from the table
DATA: WA_DBSTATTDB4 TYPE DBSTATTDB4.

SELECT SINGLE *
FROM DBSTATTDB4
INTO CORRESPONDING FIELDS OF WA_DBSTATTDB4
WHERE...

How to access SAP table DBSTATTDB4

Within an ECC or HANA version of SAP you can also view further information about DBSTATTDB4 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!