SAP ABAP Table USMD0025 (Data Model: Relationships for Deriving Hierarchy Attributes)

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	USMD0025	Table Relationship Diagram
Short Description	Data Model: Relationships for Deriving Hierarchy Attributes

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	USMD_ENTITY	☑	USMD_ENTITY	USMD_ENTITY	CHAR	9	0	Entity Type	USMD0021
4	ENTITY_FOREIGN	☑	USMD_ENTITY_NOD	USMD_ENTITY	CHAR	9	0	Entity Type of Node	USMD0021
5	RELATION_HRY	☑	USMD_RELATION_HRY	USMD_RELATION	CHAR	9	0	Hierarchy Attribute from Reference	*
6	FR_ENTITY_HRY	☐	USMD_FR_ENTITY_HRY	USMD_ENTITY	CHAR	9	0	Reference Entity Type	USMD0020
7	ROLLNAME	☐	USMD_ROLLNAME_AHRY	ROLLNAME	CHAR	30	0	Data Element (Hierarchy Attribute)	*
8	F_NO_EXIST_CHECK	☐	USMD_NO_EXIST_CHECK	USMD_FLG	CHAR	1	0	No Existence Check

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USMD0025	ENTITY_FOREIGN	USMD0021	ENTITY_FOREIGN
2	USMD0025	FR_ENTITY_HRY	USMD0020	USMD_ENTITY
3	USMD0025	USMD_ENTITY	USMD0021	USMD_ENTITY
4	USMD0025	USMD_MODEL	USMD001C	USMD_MODEL

History

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