SAP DB2IXDETL table - Detailed Information on a DB2 Index details in SAP


SAP DB2IXDETL table summary

Object Name: DB2IXDETL
Dictionary Type: Structure
Description: Detailed Information on a DB2 Index


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

Details
DB2IXDETL-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

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

DB2IXDETL-TBNAME table field - Name of the table on which the index is defined

Description: Name of the table on which the index is defined
Field Name: TBNAME
Data Element: DB2TBNAME
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

DB2IXDETL-TBCREATOR table field - Authorization ID of the owner of the table

Description: Authorization ID of the owner of the table
Field Name: TBCREATOR
Data Element: DB2TBCREA
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 TBCREATOR

DB2IXDETL-UNIQUERULE table field - Whether the index is unique

Description: Whether the index is unique
Field Name: UNIQUERULE
Data Element: DB2UNIQUE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2UNIQUE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UNIQUERULE

DB2IXDETL-COLCOUNT table field - Number of columns in the key

Description: Number of columns in the key
Field Name: COLCOUNT
Data Element: DB2KCOLCNT
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 COLCOUNT

DB2IXDETL-CLUSTERING table field - Whether CLUSTER was specified when the index was created

Description: Whether CLUSTER was specified when the index was created
Field Name: CLUSTERING
Data Element: DB2CLUSTER
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLUSTERING

DB2IXDETL-CLUSTERED table field - Whether the table is actually clustered by the index

Description: Whether the table is actually clustered by the index
Field Name: CLUSTERED
Data Element: DB2CLUSTRD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLUSTERED

DB2IXDETL-DBNAME table field - Database name

Description: Database name
Field Name: DBNAME
Data Element: DB2DBNAME
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: D2DBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

DB2IXDETL-INDEXSPACE table field - Name of the indexspace that contains the index

Description: Name of the indexspace that contains the index
Field Name: INDEXSPACE
Data Element: DB2IXSPACE
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 INDEXSPACE

DB2IXDETL-PARTITIONS table field - Number of partitions of a tablespace or index

Description: Number of partitions of a tablespace or index
Field Name: PARTITIONS
Data Element: DB2NUMPART
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 PARTITIONS

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

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

DB2IXDETL-BPOOL table field - DB2/390: Buffer pool

Description: DB2/390: Buffer pool
Field Name: BPOOL
Data Element: DB2BUFPOOL
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2BUFPOOL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BPOOL

DB2IXDETL-PGSIZE table field - DB2 for OS/390 page size in KBytes

Description: DB2 for OS/390 page size in KBytes
Field Name: PGSIZE
Data Element: DB2PGSIZE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2PGSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PGSIZE

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

DB2IXDETL-STATSTIME table field - Date and time of last RUNSTATS

Description: Date and time of last RUNSTATS
Field Name: STATSTIME
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 STATSTIME

DB2IXDETL-INDEXTYPE table field - Index type

Description: Index type
Field Name: INDEXTYPE
Data Element: DB2IXTYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2IXTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDEXTYPE

DB2IXDETL-FIRSTKEY table field - Number of distinct values in the first key column

Description: Number of distinct values in the first key column
Field Name: FIRSTKEY
Data Element: DB2FRSTKEY
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRSTKEY

DB2IXDETL-FULLKEY table field - Number of distinct values of the key

Description: Number of distinct values of the key
Field Name: FULLKEY
Data Element: DB2FULLKEY
Data Type: FLTP
length (Dec): 16(16)
Check table:
Conversion Routine:
Domain Name: FLTP
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLKEY

DB2IXDETL-CREATEDTS table field - Time when the CREATE statement was executed

Description: Time when the CREATE statement was executed
Field Name: CREATEDTS
Data Element: DB2CREADTS
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 CREATEDTS

DB2IXDETL-ALTEREDTS table field - Time of most recent ALTER statement on the object

Description: Time of most recent ALTER statement on the object
Field Name: ALTEREDTS
Data Element: DB2ALTEDTS
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 ALTEREDTS


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table