SAP ABAP Table /SDF/ORATABINFO (Oracle table information)

Hierarchy

☛ ST-PI (Software Component) SAP Solution Tools Plug-In
   ⤷ SV-SMG-SDD (Application Component) Service Data Download
     ⤷ /SDF/STPI_DDIC (Package) DDIC for /SDF/STPI Development

Basic Data

Table Category	INTTAB	Structure
Structure	/SDF/ORATABINFO	Table Relationship Diagram
Short Description	Oracle table information

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	TABLE_OWNER	☐			CHAR	30	0
2	TABLE_NAME	☐			CHAR	30	0
3	NUM_ROWS	☐			DEC	31	0
4	BLOCKS	☐			DEC	17	0
5	EMPTY_BLKS	☐			DEC	17	0
6	AVG_SPACE	☐			DEC	17	0
7	CHAIN_CNT	☐			DEC	17	0
8	AVG_ROW_LN	☐			DEC	17	0
9	SAMPL_SIZE	☐			DEC	31	0
10	LAST_ANALY	☐			CHAR	14	0
11	LAST_CHANG	☐			CHAR	20	0
12	BUFF_TYPE	☐			CHAR	6	0
13	TABLESPACE_NAME	☐			CHAR	30	0
14	IOT_NAME	☐			CHAR	30	0
15	STATUS	☐			CHAR	8	0
16	PCT_FREE	☐			DEC	3	0
17	LOGGING	☐			CHAR	3	0
18	BACKED_UP	☐			CHAR	1	0
19	AVG_SP_FREL_BLK	☐			DEC	30	0
20	NUM_FREL_BLCKS	☐			DEC	30	0
21	DEGREE	☐			CHAR	10	0
22	INSTANCES	☐			CHAR	10	0
23	CACHE	☐			CHAR	5	0
24	TABLE_LOCK	☐			CHAR	8	0
25	PARTITIONED	☐			CHAR	3	0
26	IOT_TYPE	☐			CHAR	12	0
27	BUFFER_POOL	☐			CHAR	7	0
28	ROW_MOVEMENT	☐			CHAR	8	0
29	GLOBAL_STATS	☐			CHAR	3	0
30	USER_STATS	☐			CHAR	3	0
31	TEMPORARY	☐			CHAR	1	0
32	DURATION	☐			CHAR	15	0
33	SKIP_CORRUPT	☐			CHAR	8	0
34	DEPENDENCIES	☐			CHAR	8	0
35	COMPRESSION	☐			CHAR	8	0
36	COMPRESS_FOR	☐			CHAR	18	0
37	DROPPED	☐			CHAR	3	0
38	CREATED	☐			CHAR	14	0
39	LAST_DDL_TIME	☐			CHAR	14	0

History

Last changed by/on	SAP	20140922
SAP Release Created in