SAP ABAP Table INFTABS (INFORMIX: (Technical) Information for a Table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-INF (Application Component) Informix
     ⤷ SINF (Package) Informix Porting

Basic Data

Table Category	INTTAB	Structure
Structure	INFTABS	Table Relationship Diagram
Short Description	INFORMIX: (Technical) Information for a Table

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	TABNAME	☐	INFTABNAME	CHAR18	CHAR	18	0	Informix Monitor Table Name
2	INIT_EXT	☐	INITEXTENT	SINT4_NOS	INT4	10	0	Size of Initial Extent (KB)
3	NEXT_EXT	☐	NEXT_EXT		INT4	10	0	NextExtent: Size of next extent
4	N_EXT	☐	INFTABEXTS	INT2	INT2	5	0	INFORMIX: Number of 'extents' (for specified table)
5	TOTAL_SZ	☐	INFTABSIZE	INT4	INT4	10	0	INFORMIX: Size of a table (in KB)
6	USED_SZ	☐	INFTABSIZE	INT4	INT4	10	0	INFORMIX: Size of a table (in KB)
7	DATA_SZ	☐	INFTABSIZE	INT4	INT4	10	0	INFORMIX: Size of a table (in KB)
8	N_ROWS	☐	NROWS	SINT4_NOS	INT4	10	0	Number of Rows in Table
9	N_COLS	☐	INFTABCOL	INT2	INT2	5	0	INFORMIX: Number of columns for a table
10	ROW_SZ	☐	INFROWSIZE	INT4	INT4	10	0	INFORMIX: Line size of a table (in bytes)
11	N_IND	☐	NINDEXES	INT2	INT2	5	0	INFORMIX: Number of indexes (for specified table)
12	DBSNAME	☐	DBSNAME	CHAR18	CHAR	18	0	DBSpace Name
13	FRAG_FL	☐	INFFRAGFL	CHAR1	CHAR	1	0	INFORMIX: Is the current table a fragment? ('sysfragments')

History

Last changed by/on	SAP	20130604
SAP Release Created in