SAP ABAP View DD16V (View of fields of SQL tables)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD
     ⤷ SDTB (Package) ABAP/4 Dictionary: Tables

Basic Data

View Type	D	Database View
Database View	DD16V
Short Description	View of fields of SQL tables
Root table	DD16S	R/3 DD: SQL table fields

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DD16S	DD16S
2	DD06L
3	DD06T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DD06L	SQLTAB	JL	EQ				0	0
2	DD16S	SQLTAB	JR	EQ			AND	0	0
3	DD06L	SQLTAB	JL	EQ				0	0
4	DD06T	SQLTAB	JR	EQ			AND	0	0
5	DD06T	AS4LOCAL		EQ	'A'		AND	0	0
6	DD16S	AS4LOCAL		EQ	'A'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	SQLTAB	DD06T	SQLTAB		☐	SQLTABLE	☐	Name of Pool/Cluster in the Database
2	FIELDNAME	DD16S	FIELDNAME		☐	SFIELDNAME	☐	Name of database table field
3	DDLANGUAGE	DD06T	DDLANGUAGE		☐	DDLANGUAGE	☐	Language Key
4	POSITION	DD16S	POSITION		☐	TABFDPOS	☐	Position of the field in the table
5	KEYFLAG	DD16S	KEYFLAG		☐	KEYFLAG	☐	Identifies a key field of a table
6	DATATYPE	DD16S	DATATYPE		☐	DATATYPE_D	☐	Data Type in ABAP Dictionary
7	LENG	DD16S	LENG		☐	DDLENG	☐	Length (No. of Characters)
8	INTTYPE	DD16S	INTTYPE		☐	INTTYPE	☐	ABAP data type (C,D,N,...)
9	INTLEN	DD16S	INTLEN		☐	INTLEN	☐	Internal Length in Bytes

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	20110908
SAP Release Created in