SAP ABAP Table /SDF/ORATABINF2 (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/ORATABINF2	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	ANALY_ID	☐			CHAR	14	0
2	STMT_ID	☐			CHAR	2	0
3	.INCLUDE	☐				0	0	Oracle table information
4	TABLE_OWNER	☐			CHAR	30	0
5	TABLE_NAME	☐			CHAR	30	0
6	NUM_ROWS	☐			DEC	31	0
7	BLOCKS	☐			DEC	17	0
8	EMPTY_BLKS	☐			DEC	17	0
9	AVG_SPACE	☐			DEC	17	0
10	CHAIN_CNT	☐			DEC	17	0
11	AVG_ROW_LN	☐			DEC	17	0
12	SAMPL_SIZE	☐			DEC	31	0
13	LAST_ANALY	☐			CHAR	14	0
14	LAST_CHANG	☐			CHAR	20	0
15	BUFF_TYPE	☐			CHAR	6	0
16	TABLESPACE_NAME	☐			CHAR	30	0
17	IOT_NAME	☐			CHAR	30	0
18	STATUS	☐			CHAR	8	0
19	PCT_FREE	☐			DEC	3	0
20	LOGGING	☐			CHAR	3	0
21	BACKED_UP	☐			CHAR	1	0
22	AVG_SP_FREL_BLK	☐			DEC	30	0
23	NUM_FREL_BLCKS	☐			DEC	30	0
24	DEGREE	☐			CHAR	10	0
25	INSTANCES	☐			CHAR	10	0
26	CACHE	☐			CHAR	5	0
27	TABLE_LOCK	☐			CHAR	8	0
28	PARTITIONED	☐			CHAR	3	0
29	IOT_TYPE	☐			CHAR	12	0
30	BUFFER_POOL	☐			CHAR	7	0
31	ROW_MOVEMENT	☐			CHAR	8	0
32	GLOBAL_STATS	☐			CHAR	3	0
33	USER_STATS	☐			CHAR	3	0
34	TEMPORARY	☐			CHAR	1	0
35	DURATION	☐			CHAR	15	0
36	SKIP_CORRUPT	☐			CHAR	8	0
37	DEPENDENCIES	☐			CHAR	8	0
38	COMPRESSION	☐			CHAR	8	0
39	COMPRESS_FOR	☐			CHAR	18	0
40	DROPPED	☐			CHAR	3	0
41	CREATED	☐			CHAR	14	0
42	LAST_DDL_TIME	☐			CHAR	14	0
43	STMT_SOURCE	☐			CHAR	1	0
44	DBA_HIST_B_TS	☐			CHAR	19	0
45	DBA_HIST_E_TS	☐			CHAR	19	0

History

Last changed by/on	SAP	20140922
SAP Release Created in