SAP ABAP View INFO_TABLS (Repository Infosystem: View of Table fields and TADIR)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO (Application Component) Workbench Tools: Editors, Painters, Modelers
     ⤷ SEUI (Package) Repository Information System

Basic Data

View Type	D	Database View
Database View	INFO_TABLS
Short Description	Repository Infosystem: View of Table fields and TADIR
Root table	DD03L	Table Fields

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DD03L	DD03L
2	TADIR	DD03L
3	DD02L	QCM1PEST01

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TADIR	OBJ_NAME	JL	EQ				0	0
2	DD02L	TABNAME	JR	EQ			AND	0	0
3	DD02L	TABNAME	JL	EQ				0	0
4	DD03L	TABNAME	JR	EQ			AND	0	0
5	DD02L	AS4LOCAL	JL	EQ				0	0
6	DD03L	AS4LOCAL	JR	EQ			AND	0	0
7	TADIR	PGMID		EQ	'R3TR'		AND	0	0
8	TADIR	OBJECT		EQ	'TABL'		OR	0	0
9	TADIR	OBJECT		EQ	'VIEW'		OR	0	0
10	TADIR	OBJECT		EQ	'SQLT'		AND	0	0
11	DD02L	AS4LOCAL		EQ	'A'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	TABNAME	DD02L	TABNAME		☐	TABNAME	☐	Table Name
2	FIELDNAME	DD03L	FIELDNAME		☐	FIELDNAME	☐	Field Name
3	AS4LOCAL	DD03L	AS4LOCAL		☐	AS4LOCAL	☐	Activation Status of a Repository Object
4	TABCLASS	DD02L	TABCLASS		☐	TABCLASS	☐	Table category
5	SQLTAB	DD02L	SQLTAB		☐	SQLAPPDTAB	☐	Name of an SQL table or an appended table
6	POSITION	DD03L	POSITION		☐	TABFDPOS	☐	Position of the field in the table
7	KEYFLAG	DD03L	KEYFLAG		☐	KEYFLAG	☐	Identifies a key field of a table
8	MANDATORY	DD03L	MANDATORY		☐	MANDATORY	☐	Flag: Field is required (not blank)
9	ROLLNAME	DD03L	ROLLNAME		☐	ROLLNAME	☐	Data element (semantic domain)
10	CHECKTABLE	DD03L	CHECKTABLE		☐	CHECKTABLE	☐	Check table name of the foreign key
11	ADMINFIELD	DD03L	ADMINFIELD		☐	ADMINFIELD	☐	Nesting depth for includes
12	INTTYPE	DD03L	INTTYPE		☐	INTTYPE	☐	ABAP data type (C,D,N,...)
13	INTLEN	DD03L	INTLEN		☐	INTLEN	☐	Internal Length in Bytes
14	REFTABLE	DD03L	REFTABLE		☐	REFTABLE	☐	Table for reference field
15	PRECFIELD	DD03L	PRECFIELD		☐	PRECFIELD	☐	Name of included table
16	REFFIELD	DD03L	REFFIELD		☐	REFFIELD	☐	Reference field for currency and qty fields
17	NOTNULL	DD03L	NOTNULL		☐	NOTNULL	☐	Indicator for initial values in database fields
18	DOMNAME	DD03L	DOMNAME		☐	DOMNAME	☐	Domain name
19	DATATYPE	DD03L	DATATYPE		☐	DATATYPE_D	☐	Data Type in ABAP Dictionary
20	LENG	DD03L	LENG		☐	DDLENG	☐	Length (No. of Characters)
21	DEVCLASS	TADIR	DEVCLASS		☐	DEVCLASS	☐	Package
22	TABLETYPE	DD03L	TABLETYPE		☐	DDTABTYPE	☐	DD: Flag if it is a table
23	DEPTH	DD03L	DEPTH		☐	TYPEDEPTH	☐	DD: Depth for structured types
24	COMPTYPE	DD03L	COMPTYPE		☐	COMPTYPE	☐	DD: Component Type
25	AS4USER	DD02L	AS4USER		☐	AS4USER	☐	Last Changed By
26	AS4DATE	DD02L	AS4DATE		☐	AS4DATE	☐	Date of Last Change

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20141013
SAP Release Created in