SAP DB6CATIX table - SYSCAT.INDEXES details in SAP


SAP DB6CATIX table summary

Object Name: DB6CATIX
Dictionary Type: Structure
Description: SYSCAT.INDEXES


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

Details
DB6CATIX-INDSCHEMA table field - DB6: Schema Name

Description: DB6: Schema Name
Field Name: INDSCHEMA
Data Element: DB6SCHEMA
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDSCHEMA

DB6CATIX-INDNAME table field - DB6: long table name

Description: DB6: long table name
Field Name: INDNAME
Data Element: DB6TABNAML
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDNAME

DB6CATIX-DEFINER table field - DB6: File Path

Description: DB6: File Path
Field Name: DEFINER
Data Element: DB6PATH
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: DB6PATH
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFINER

DB6CATIX-TABSCHEMA table field - DB6: Schema Name

Description: DB6: Schema Name
Field Name: TABSCHEMA
Data Element: DB6SCHEMA
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABSCHEMA

DB6CATIX-TABNAME table field - DB6: long table name

Description: DB6: long table name
Field Name: TABNAME
Data Element: DB6TABNAML
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABNAME

DB6CATIX-COLNAMES table field - Index Column Names

Description: Index Column Names
Field Name: COLNAMES
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 COLNAMES

DB6CATIX-UNIQUERULE table field - Unique Rule

Description: Unique Rule
Field Name: UNIQUERULE
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 UNIQUERULE

DB6CATIX-MADE_UNIQUE table field - Index created unique

Description: Index created unique
Field Name: MADE_UNIQUE
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 MADE_UNIQUE

DB6CATIX-COLCOUNT table field - Number of columns in for the key

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

DB6CATIX-UNIQUE_COLCOUNT table field - Number of columns required for a unique key

Description: Number of columns required for a unique key
Field Name: UNIQUE_COLCOUNT
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 UNIQUE_COLCOUNT

DB6CATIX-INDEXTYPE table field - Type of index

Description: Type of index
Field Name: INDEXTYPE
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 INDEXTYPE

DB6CATIX-ENTRYTYPE table field -

Description:
Field Name: ENTRYTYPE
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 ENTRYTYPE

DB6CATIX-PCTFREE table field -

Description:
Field Name: PCTFREE
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 PCTFREE

DB6CATIX-IID table field - Internal index ID

Description: Internal index ID
Field Name: IID
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 IID

DB6CATIX-NLEAF table field - Number of leaf pages

Description: Number of leaf pages
Field Name: NLEAF
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 NLEAF

DB6CATIX-NLEVELS table field - Number of index levels

Description: Number of index levels
Field Name: NLEVELS
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 NLEVELS

DB6CATIX-FIRSTKEYCARD table field - Number of distinct first key values

Description: Number of distinct first key values
Field Name: FIRSTKEYCARD
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 FIRSTKEYCARD

DB6CATIX-FIRST2KEYCARD table field - Number of distinct keys using the first two columns

Description: Number of distinct keys using the first two columns
Field Name: FIRST2KEYCARD
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 FIRST2KEYCARD

DB6CATIX-FIRST3KEYCARD table field - Number of distinct keys using the first three columns

Description: Number of distinct keys using the first three columns
Field Name: FIRST3KEYCARD
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 FIRST3KEYCARD

DB6CATIX-FIRST4KEYCARD table field - Number of distinct keys using the first four columns

Description: Number of distinct keys using the first four columns
Field Name: FIRST4KEYCARD
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 FIRST4KEYCARD

DB6CATIX-FULLKEYCARD table field - Number of distinct full key values

Description: Number of distinct full key values
Field Name: FULLKEYCARD
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 FULLKEYCARD

DB6CATIX-CLUSTERRATIO table field - Degree of data clustering with the index

Description: Degree of data clustering with the index
Field Name: CLUSTERRATIO
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 CLUSTERRATIO

DB6CATIX-CLUSTERFACTOR table field - Finer measurement of degree of clustering

Description: Finer measurement of degree of clustering
Field Name: CLUSTERFACTOR
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 CLUSTERFACTOR

DB6CATIX-SEQUENTIAL_PAGES table field -

Description:
Field Name: SEQUENTIAL_PAGES
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 SEQUENTIAL_PAGES

DB6CATIX-DENSITY table field -

Description:
Field Name: DENSITY
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 DENSITY

DB6CATIX-USER_DEFINED table field - 1 if this index was defined by a user, else 0

Description: 1 if this index was defined by a user, else 0
Field Name: USER_DEFINED
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 USER_DEFINED

DB6CATIX-SYSTEM_REQUIRED table field -

Description:
Field Name: SYSTEM_REQUIRED
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 SYSTEM_REQUIRED

DB6CATIX-CREATE_TIME table field - DBA: ISO conform timestamp with ms precission

Description: DBA: ISO conform timestamp with ms precission
Field Name: CREATE_TIME
Data Element: DB6DATETIM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATE_TIME

DB6CATIX-STATS_TIME table field - DBA: ISO conform timestamp with ms precission

Description: DBA: ISO conform timestamp with ms precission
Field Name: STATS_TIME
Data Element: DB6DATETIM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATS_TIME

DB6CATIX-MINPCTUSED table field -

Description:
Field Name: MINPCTUSED
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 MINPCTUSED

DB6CATIX-REVERSE_SCANS table field - support for reverse scans (Y or N)

Description: support for reverse scans (Y or N)
Field Name: REVERSE_SCANS
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 REVERSE_SCANS

DB6CATIX-INTERNAL_FORMAT table field -

Description:
Field Name: INTERNAL_FORMAT
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 INTERNAL_FORMAT

DB6CATIX-REMARKS table field - User-supplied comment, or null.

Description: User-supplied comment, or null.
Field Name: REMARKS
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 REMARKS

DB6CATIX-INDEX_OBJECTID table field - Index object identifier for the table.

Description: Index object identifier for the table.
Field Name: INDEX_OBJECTID
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 INDEX_OBJECTID

DB6CATIX-NUMRIDS table field - Total number of row identifiers (RIDs) in the index.

Description: Total number of row identifiers (RIDs) in the index.
Field Name: NUMRIDS
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 NUMRIDS

DB6CATIX-NUMRIDS_DELETED table field - Total number of RIDs in the index that are marked as deleted

Description: Total number of RIDs in the index that are marked as deleted
Field Name: NUMRIDS_DELETED
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 NUMRIDS_DELETED

DB6CATIX-NUM_EMPTY_LEAFS table field - Leaf pages that have all of their RIDs marked as deleted

Description: Leaf pages that have all of their RIDs marked as deleted
Field Name: NUM_EMPTY_LEAFS
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 NUM_EMPTY_LEAFS

DB6CATIX-AVERAGE_RANDOM_FETCH_PAGES table field -

Description:
Field Name: AVERAGE_RANDOM_FETCH_PAGES
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 AVERAGE_RANDOM_FETCH_PAGES

DB6CATIX-AVERAGE_RANDOM_PAGES table field -

Description:
Field Name: AVERAGE_RANDOM_PAGES
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 AVERAGE_RANDOM_PAGES

DB6CATIX-AVERAGE_SEQUENCE_GAP table field -

Description:
Field Name: AVERAGE_SEQUENCE_GAP
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 AVERAGE_SEQUENCE_GAP

DB6CATIX-AVERAGE_SEQUENCE_FETCH_GAP table field -

Description:
Field Name: AVERAGE_SEQUENCE_FETCH_GAP
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 AVERAGE_SEQUENCE_FETCH_GAP

DB6CATIX-AVERAGE_SEQUENCE_PAGES table field -

Description:
Field Name: AVERAGE_SEQUENCE_PAGES
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 AVERAGE_SEQUENCE_PAGES

DB6CATIX-AVERAGE_SEQUENCE_FETCH_PAGES table field -

Description:
Field Name: AVERAGE_SEQUENCE_FETCH_PAGES
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 AVERAGE_SEQUENCE_FETCH_PAGES

DB6CATIX-TBSPACEID table field - Internal identifier for the index table space.

Description: Internal identifier for the index table space.
Field Name: TBSPACEID
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 TBSPACEID

DB6CATIX-PCTPAGESSAVED table field -

Description:
Field Name: PCTPAGESSAVED
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 PCTPAGESSAVED

DB6CATIX-COMPRESSION table field -

Description:
Field Name: COMPRESSION
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 COMPRESSION

DB6CATIX-INDCARD table field - DB6: Index Cardinality

Description: DB6: Index Cardinality
Field Name: INDCARD
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 INDCARD

DB6CATIX-AVGLEAFKEYSIZE table field -

Description:
Field Name: AVGLEAFKEYSIZE
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 AVGLEAFKEYSIZE

DB6CATIX-AVGNLEAFKEYSIZE table field -

Description:
Field Name: AVGNLEAFKEYSIZE
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 AVGNLEAFKEYSIZE

DB6CATIX-COLLECTSTATISTICS table field -

Description:
Field Name: COLLECTSTATISTICS
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 COLLECTSTATISTICS

DB6CATIX-LASTUSED table field - DBA: ISO conform timestamp with ms precission

Description: DBA: ISO conform timestamp with ms precission
Field Name: LASTUSED
Data Element: DB6DATETIM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTUSED

DB6CATIX-SNAPSHOT_TIMESTAMP table field - DBA: ISO conform timestamp with ms precission

Description: DBA: ISO conform timestamp with ms precission
Field Name: SNAPSHOT_TIMESTAMP
Data Element: DB6DATETIM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SNAPSHOT_TIMESTAMP


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table