SAP SQIXADVDB4 table - Structure for Index Advised Information details in SAP

SAP SQIXADVDB4 table summary

Object Name: SQIXADVDB4
Dictionary Type: Structure
Description: Structure for Index Advised Information

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

Details

SQIXADVDB4-TABLE_SCHEMA table field - iSeries: SQL schema name of table or view ▼

Description: iSeries: SQL schema name of table or view
Field Name: TABLE_SCHEMA
Data Element: TAB_SCHEMA
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQTLN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_SCHEMA

SQIXADVDB4-TABLE_NAME table field - Table name ▼

Description: Table name
Field Name: TABLE_NAME
Data Element: TNAME
Data Type: CHAR
length (Dec): 30(0)
Check table: *
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_NAME

SQIXADVDB4-PARTITION_NAME table field - DB2/400: Name of a Table Partition ▼

Description: DB2/400: Name of a Table Partition
Field Name: PARTITION_NAME
Data Element: DB4PARTNAME
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: DB4PARTNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTITION_NAME

SQIXADVDB4-INDEX_TYPE table field - Text field length 14 ▼

Description: Text field length 14
Field Name: INDEX_TYPE
Data Element: CHAR14
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: CHAR14
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEX_TYPE

SQIXADVDB4-LAST_ADVISED table field - iSeries: Record Creation Timestamp (Database Monitor) ▼

Description: iSeries: Record Creation Timestamp (Database Monitor)
Field Name: LAST_ADVISED
Data Element: QQTIME
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: QQTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_ADVISED

SQIXADVDB4-TIMES_ADVISED table field - Alt. Type for INT8 (-9223372036854775808..922337203685476) ▼

Description: Alt. Type for INT8 (-9223372036854775808..922337203685476)
Field Name: TIMES_ADVISED
Data Element: SDB4_INT8
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: SDB4_INT8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIMES_ADVISED

SQIXADVDB4-EST_CREATE_TIME table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: EST_CREATE_TIME
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EST_CREATE_TIME

SQIXADVDB4-REASON_ADVISED table field - iSeries: Reason Code for Used Index (Database Monitor) ▼

Description: iSeries: Reason Code for Used Index (Database Monitor)
Field Name: REASON_ADVISED
Data Element: QQRCODIDU
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: QQRCOD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REASON_ADVISED

SQIXADVDB4-LOGICAL_PAGESIZE table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: LOGICAL_PAGESIZE
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGICAL_PAGESIZE

SQIXADVDB4-MOST_EXP_QUERY table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: MOST_EXP_QUERY
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MOST_EXP_QUERY

SQIXADVDB4-AVG_QUERY_EST table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: AVG_QUERY_EST
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_QUERY_EST

SQIXADVDB4-TABLE_SIZE table field - Alt. Type for INT8 (-9223372036854775808..922337203685476) ▼

Description: Alt. Type for INT8 (-9223372036854775808..922337203685476)
Field Name: TABLE_SIZE
Data Element: SDB4_INT8
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: SDB4_INT8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_SIZE

SQIXADVDB4-NLSS_TABLENAME table field - iSeries: iSeries system name of table or view ▼

Description: iSeries: iSeries system name of table or view
Field Name: NLSS_TABLENAME
Data Element: SYS_TNAME
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QCHAR10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NLSS_TABLENAME

SQIXADVDB4-NLSS_TABLESCHEMA table field - iSeries: SQL schema name of table or view ▼

Description: iSeries: SQL schema name of table or view
Field Name: NLSS_TABLESCHEMA
Data Element: TAB_SCHEMA
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQTLN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NLSS_TABLESCHEMA

SQIXADVDB4-MTI_USED table field - Alt. Type for INT8 (-9223372036854775808..922337203685476) ▼

Description: Alt. Type for INT8 (-9223372036854775808..922337203685476)
Field Name: MTI_USED
Data Element: SDB4_INT8
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: SDB4_INT8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTI_USED

SQIXADVDB4-MTI_CREATED table field - 4 Byte Signed Integer ▼

Description: 4 Byte Signed Integer
Field Name: MTI_CREATED
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MTI_CREATED

SQIXADVDB4-LAST_MTI_USED table field - iSeries: Record Creation Timestamp (Database Monitor) ▼

Description: iSeries: Record Creation Timestamp (Database Monitor)
Field Name: LAST_MTI_USED
Data Element: QQTIME
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: QQTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_MTI_USED

SQIXADVDB4-KEY_COLS_ADVISED table field - Key columns advised ▼

Description: Key columns advised
Field Name: KEY_COLS_ADVISED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KEY_COLS_ADVISED

SQIXADVDB4-LEADING_COL_KEYS table field - Leading column keys ▼

Description: Leading column keys
Field Name: LEADING_COL_KEYS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LEADING_COL_KEYS

SQIXADVDB4-AVG_QUERY_EST_MICR table field - Alt. Type for INT8 (-9223372036854775808..922337203685476) ▼

Description: Alt. Type for INT8 (-9223372036854775808..922337203685476)
Field Name: AVG_QUERY_EST_MICR
Data Element: SDB4_INT8
Data Type: DEC
length (Dec): 19(0)
Check table:
Conversion Routine:
Domain Name: SDB4_INT8
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_QUERY_EST_MICR

View list of all SAP tables(S4H/ECC)

Select data from SAP table