SAP ABAP View DD05P (View on foreign key fields)

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	DD05P
Short Description	View on foreign key fields
Root table	DD05S	Foreign key fields

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DD05S	DD05S
2	DD03L	DD05S
3	DD08L	DD03L
4	DD08T	DD05S

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DD08L	TABNAME	JL	EQ				0	0
2	DD05S	TABNAME	JR	EQ			AND	0	0
3	DD05S	TABNAME	JL	EQ				0	0
4	DD08T	TABNAME	JR	EQ			AND	0	0
5	DD08L	FIELDNAME	JL	EQ				0	0
6	DD05S	FIELDNAME	JR	EQ			AND	0	0
7	DD05S	FIELDNAME	JL	EQ				0	0
8	DD08T	FIELDNAME	JR	EQ			AND	0	0
9	DD08L	CHECKTABLE	JL	EQ				0	0
10	DD03L	TABNAME	JR	EQ			AND	0	0
11	DD05S	PRIMPOS	JL	EQ				0	0
12	DD03L	POSITION	JR	EQ			AND	0	0
13	DD03L	AS4LOCAL		EQ	'A'		AND	0	0
14	DD05S	AS4LOCAL		EQ	'A'		AND	0	0
15	DD08T	AS4LOCAL		EQ	'A'		AND	0	0
16	DD08L	AS4LOCAL		EQ	'A'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	TABNAME	DD08L	TABNAME		☐	TABNAME	☐	Table Name
2	FIELDNAME	DD08L	FIELDNAME		☐	FORFIELD	☐	Name of the field to be checked
3	DDLANGUAGE	DD08T	DDLANGUAGE		☐	DDLANGUAGE	☐	Language Key
4	PRIMPOS	DD05S	PRIMPOS		☐	PRIMPOS	☐	Position of corresp. foreign key field in primary key
5	FORTABLE	DD05S	FORTABLE		☐	FORTABLE	☐	Table of the foreign key field
6	FORKEY	DD05S	FORKEY		☐	FORKEY	☐	Names of Foreign Key Fields
7	CHECKTABLE	DD03L	TABNAME		☐	TABNAME	☐	Table Name
8	CHECKFIELD	DD03L	FIELDNAME		☐	FIELDNAME	☐	Field Name

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