DBSTAIDB2N SAP (Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform) Structure details

Dictionary Type: Structure
Description: Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform




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




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

DBSTAIDB2N is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DBSTAIDB2N TYPE DBSTAIDB2N.

The DBSTAIDB2N table consists of various fields, each holding specific information or linking keys about Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform data available in SAP. These include CREATOR (DB2 creator name), TIMESTAMP (Date and time of last RUNSTATS), TBNAME (DB2 table name), VWTYP (Type of Usage of Table Entry).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DBSTAIDB2N structure 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
NAMEName of a DB2 for OS/390 index DB2IDXNAMECHAR18CHAR18
CREATORDB2 creator name DB2CREATORCHAR8CHAR8
TIMESTAMPDate and time of last RUNSTATS DB2STATSTMCHAR26DB2TMSTMP
TBNAMEDB2 table name DB2TABNAMECHAR18CHAR18
VWTYPType of Usage of Table Entry AM_VWTYPCHAR2AM_VWTYPE
CLURATIOClusterratio: Percentage of rows in clustering order DB2CLURAT2INT25DB2SINT
FIRSTKCARDNumber of distinct values in key (first column or full key) DB2KEYCARDFLTP16(16) FLOATING
FULLKCARDNumber of distinct values in key (first column or full key) DB2KEYCARDFLTP16(16) FLOATING
NLEAFNumber of active leaf pages in the index DB2NLEAFINT410
NLEVELSDB2 for OS/390 number of levels in the index tree DB2NLEVELSINT25DB2SINT
NEAROFFPOSNumber of referred to rows near/far from optimal position DB2OFFPOSFFLTP16(16) FLOATING
FAROFFPOSNumber of referred to rows near/far from optimal position DB2OFFPOSFFLTP16(16) FLOATING
LEAFDIST100 * avg number of leaf pages between successive leaf pages DB2LEAFDISINT410
DSSIZEDB2 for OS/390 size of a dataset in KBytes DB2SIZEKDEC15DB2SIZEK

Key field Non-key field



How do I retrieve data from SAP structure DBSTAIDB2N using ABAP code?

As DBSTAIDB2N is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DBSTAIDB2N as there is no data to select.

How to access SAP table DBSTAIDB2N

Within an ECC or HANA version of SAP you can also view further information about DBSTAIDB2N 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!