SAP ABAP Table USMD0026 (Data Model: Foreign Key Definition)

Hierarchy

☛ MDG_FND (Software Component) MDG Foundation
   ⤷ CA-MDG-AF (Application Component) Application Framework
     ⤷ USMD1 (Package) Master Data: Data Modeling

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	USMD0026	Table Relationship Diagram
Short Description	Data Model: Foreign Key Definition

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
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	USMD_MODEL	☑	USMD_MODEL	USMD_MODEL	CHAR	2	0	Data Model	USMD001C
2	USMD_OBJSTAT	☑	USMD_OBJSTAT	USMD_OBJSTAT	CHAR	1	0	Activation Status
3	FR_ENTITY	☑	USMD_FR_ENTITY	USMD_ENTITY	CHAR	9	0	From-Entity Type	USMD0020
4	RELATION	☑	USMD_RELATION	USMD_RELATION	CHAR	9	0	Relationship Between Entity Types	USMD0023
5	FIELD_FROM	☑	USMD_FIELD_FROM	FDNAME	CHAR	30	0	"From" Field in Foreign Key Relationship (Check Table Field)	*
6	FIELD_TO	☐	USMD_FIELD_TO	FDNAME	CHAR	30	0	"To" Field in Foreign Key Relationship (Foreign Key Field)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USMD0026	FR_ENTITY	USMD0020	USMD_ENTITY	KEY	1	CN
2	USMD0026	RELATION	USMD0023	RELATION	KEY	1	CN
3	USMD0026	USMD_MODEL	USMD001C	USMD_MODEL	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	703