SAP DB4SYSIXADV table - iSeries: SQE Index Advised Information details in SAP


SAP DB4SYSIXADV table summary

Object Name: DB4SYSIXADV
Dictionary Type: Structure
Description: iSeries: SQE Index Advised Information


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

Details
DB4SYSIXADV-RECORD_NUMBER table field - iSeries: Number of rows / object size

Description: iSeries: Number of rows / object size
Field Name: RECORD_NUMBER
Data Element: DB4_ANZ15
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: DB4_ANZ15
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORD_NUMBER

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-REASON_ADVISED table field - Character field length 24

Description: Character field length 24
Field Name: REASON_ADVISED
Data Element: CHAR24
Data Type: CHAR
length (Dec): 24(0)
Check table:
Conversion Routine:
Domain Name: CHAR24
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REASON_ADVISED

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-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

DB4SYSIXADV-KEY_COLS_ADVISED table field -

Description:
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

DB4SYSIXADV-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