SAP ABAP Table TREXS_INDEX_INFO_TEXT (Details relevant for physical and logical indexes in TREX)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TRX-API (Application Component) TREX ABAP + JAVA API
     ⤷ STREX (Package) TREX ABAP client

Basic Data

Table Category	INTTAB	Structure
Structure	TREXS_INDEX_INFO_TEXT	Table Relationship Diagram
Short Description	Details relevant for physical and logical indexes in TREX

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	INDEX_ID	☐	TREXD_INDEX_ID	TREXD_INDEX_ID	CHAR	64	0	Index Id
2	INDEX_STATE	☐	TREXD_INDEX_STATE	TREXD_INDEX_STATE	NUMC	2	0	Index state in TREX
3	INDEX_TYPE	☐			CHAR	40	0
4	PHYSICAL_INDEXES	☐			CHAR	200	0
5	LOGICAL_INDEXES	☐			CHAR	200	0
6	DESCRIPTION	☐			CHAR	32	0
7	LANGUAGE	☐			CHAR	100	0
8	LAST_INDEXING	☐			CHAR	23	0
9	LAST_OPTIMIZE	☐			CHAR	23	0
10	LAST_DELTA_MERGE	☐			CHAR	23	0
11	SEARCHABLE_DOCS_TOTAL	☐			INT4	10	0
12	SEARCHABLE_DOCS_MAIN	☐			INT4	10	0
13	SEARCHABLE_DOCS_DELTA	☐			INT4	10	0
14	SEARCHABLE_DOCS_DELTA2	☐			INT4	10	0
15	OPTIMIZABLE_DOCS_NEW	☐			INT4	10	0
16	OPTIMIZABLE_DOCS_UPDATE	☐			INT4	10	0
17	OPTIMIZABLE_DOCS_DELETE	☐			INT4	10	0
18	MEMORY_SIZE_TOTAL	☐			INT4	10	0
19	MEMORY_SIZE_SE	☐			INT4	10	0
20	MEMORY_SIZE_AE	☐			INT4	10	0
21	MEMORY_SIZE_TM	☐			INT4	10	0
22	DISK_FREE_SPACE	☐			INT4	10	0
23	DISK_SIZE_TOTAL	☐			INT4	10	0
24	DISK_SIZE_SE	☐			INT4	10	0
25	DISK_SIZE_AE	☐			INT4	10	0
26	DISK_SIZE_TM	☐			INT4	10	0
27	DELTA_INDEX_DISK_SIZE_TOTAL	☐			INT4	10	0
28	DELTA_INDEX_DISK_SIZE_SE	☐			INT4	10	0
29	DELTA_INDEX_DISK_SIZE_AE	☐			INT4	10	0
30	DELTA_INDEX_DISK_SIZE_TM	☐			INT4	10	0
31	NUMBER_OF_TERMS	☐			INT4	10	0
32	DELTA_IS_LOADED	☐			CHAR	10	0
33	SIZE_FOR_DELTA_INDEX	☐			INT4	10	0
34	USE_TEMPORARY_DELTA_INDEXES	☐			CHAR	10	0
35	RETURN_CODE	☐			INT4	10	0
36	RETURN_TEXT	☐			CHAR	200	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	710