SAP DBSTAIDB2N table - Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform details in SAP

SAP DBSTAIDB2N table summary

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

Field list for DBSTAIDB2N table on an S/4 SAP system

Details

DBSTAIDB2N-NAME table field - Name of a DB2 for OS/390 index ▼

Description: Name of a DB2 for OS/390 index
Field Name: NAME
Data Element: DB2IDXNAME
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

DBSTAIDB2N-CREATOR table field - DB2 creator name ▼

Description: DB2 creator name
Field Name: CREATOR
Data Element: DB2CREATOR
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATOR

DBSTAIDB2N-TIMESTAMP table field - Date and time of last RUNSTATS ▼

Description: Date and time of last RUNSTATS
Field Name: TIMESTAMP
Data Element: DB2STATSTM
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: DB2TMSTMP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMESTAMP

DBSTAIDB2N-TBNAME table field - DB2 table name ▼

Description: DB2 table name
Field Name: TBNAME
Data Element: DB2TABNAME
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBNAME

DBSTAIDB2N-VWTYP table field - Type of Usage of Table Entry ▼

Description: Type of Usage of Table Entry
Field Name: VWTYP
Data Element: AM_VWTYP
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: AM_VWTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VWTYP

DBSTAIDB2N-CLURATIO table field - Clusterratio: Percentage of rows in clustering order ▼

Description: Clusterratio: Percentage of rows in clustering order
Field Name: CLURATIO
Data Element: DB2CLURAT2
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLURATIO

DBSTAIDB2N-FIRSTKCARD table field - Number of distinct values in key (first column or full key) ▼

Description: Number of distinct values in key (first column or full key)
Field Name: FIRSTKCARD
Data Element: DB2KEYCARD
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTKCARD

DBSTAIDB2N-FULLKCARD table field - Number of distinct values in key (first column or full key) ▼

Description: Number of distinct values in key (first column or full key)
Field Name: FULLKCARD
Data Element: DB2KEYCARD
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLKCARD

DBSTAIDB2N-NLEAF table field - Number of active leaf pages in the index ▼

Description: Number of active leaf pages in the index
Field Name: NLEAF
Data Element: DB2NLEAF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NLEAF

DBSTAIDB2N-NLEVELS table field - DB2 for OS/390 number of levels in the index tree ▼

Description: DB2 for OS/390 number of levels in the index tree
Field Name: NLEVELS
Data Element: DB2NLEVELS
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NLEVELS

DBSTAIDB2N-NEAROFFPOS table field - Number of referred to rows near/far from optimal position ▼

Description: Number of referred to rows near/far from optimal position
Field Name: NEAROFFPOS
Data Element: DB2OFFPOSF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEAROFFPOS

DBSTAIDB2N-FAROFFPOS table field - Number of referred to rows near/far from optimal position ▼

Description: Number of referred to rows near/far from optimal position
Field Name: FAROFFPOS
Data Element: DB2OFFPOSF
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLOATING
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAROFFPOS

DBSTAIDB2N-LEAFDIST table field - 100 * avg number of leaf pages between successive leaf pages ▼

Description: 100 * avg number of leaf pages between successive leaf pages
Field Name: LEAFDIST
Data Element: DB2LEAFDIS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEAFDIST

DBSTAIDB2N-DSSIZE table field - DB2 for OS/390 size of a dataset in KBytes ▼

Description: DB2 for OS/390 size of a dataset in KBytes
Field Name: DSSIZE
Data Element: DB2SIZEK
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DB2SIZEK
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSSIZE

View list of all SAP tables(S4H/ECC)

Select data from SAP table