SAP ABAP Table USMD0020 (Data Model: Entity Types)

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	USMD0020	Table Relationship Diagram
Short Description	Data Model: Entity Types

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	USMD001C
3	USMD_ENTITY	☑	USMD_ENTITY	USMD_ENTITY	CHAR	9	0	Entity Type
4	USAGE_TYPE	☐	USMD_USAGE_TYPE	USMD_USAGE_TYPE	CHAR	1	0	Storage and Use Type
5	KEY_HANDLING	☐	USMD_KEY_HANDLING	USMD_KEY_HANDLING	CHAR	1	0	Type of Key Assignment
6	USMD_VAL_ENTITY	☐	USMD_VALIDITY_ENTITY_TYPE	USMD_VALIDITY_ENTITY_TYPE	CHAR	1	0	Validity Concept for Entity Type
7	ROLLNAME	☐	USMD_ROLLNAME_ENT	ROLLNAME	CHAR	30	0	Data Element (Entity Type)	*
8	HRY	☐	USMD_HRY	USMD_HRY	CHAR	1	0	Hierarchies
9	USMD_VAL_HRY	☐	USMD_VALIDITY_HRY	USMD_VALIDITY_HRY	CHAR	1	0	Validity Concept for Hierarchy
10	F_MULTI_LANGU	☐	USMD_MULTI_LANGU	USMD_FLG	CHAR	1	0	Language-Dependent Texts
11	TXTLG_LEN	☐	USMD_TXTLG_LEN	USMD_TXTLG_LEN	NUMC	2	0	Long Text: Length
12	TXTMI_LEN	☐	USMD_TXTMI_LEN	USMD_TXTMI_LEN	NUMC	2	0	Medium Text: Length
13	TXTSH_LEN	☐	USMD_TXTSH_LEN	USMD_TXTSH_LEN	NUMC	2	0	Short Text: Length
14	F_HAS_ATTACHMENT	☐	USMD_HAS_ATTACHMENT	USMD_FLG	CHAR	1	0	Attachments (Indicator)
15	F_HAS_SET	☐	USMD_HAS_SET	USMD_FLG	CHAR	1	0	Sets Indicator
16	USMD_SEARCH_HLP	☐	USMD_SEARCH_HLP	SHLPNAME	CHAR	30	0	Search Help	*
17	USMD_FLD_TXTSH	☐	USMD_FLD_TXTSH	FDNAME	CHAR	30	0	Short Text: Source Field	*
18	USMD_FLD_TXTMI	☐	USMD_FLD_TXTMI	FDNAME	CHAR	30	0	Medium Text: Source Field	*
19	USMD_FLD_TXTLG	☐	USMD_FLD_TXTLG	FDNAME	CHAR	30	0	Long Text: Source Field	*
20	TMP_KEY_NROBJ	☐	NROBJ	NROBJ	CHAR	10	0	Name of number range object	TNRO
21	PP_DOMAIN	☐	USMD_PP_DOMAIN	USMD_PP_DOMAIN	CHAR	10	0	Active Area	*
22	ENTITY_DELETION	☐	USMD_ENTITY_DELETION	USMD_ENTITY_DELETION	CHAR	1	0	Deletion of Entities
23	USMD_APPL	☐	USMD_APPL	USMD_APPL	CHAR	10	0	Application
24	DISABLED	☐	USMD_SWITCH_DEFAULT	USMD_SWITCH_DEFAULT	CHAR	1	0	Standard Delivery Status
25	TAB_SOURCE	☐	USMD_TAB_SOURCE	AS4TAB	CHAR	30	0	ABAP Dictionary Structure/Table	DD02L
26	FLD_SOURCE	☐	USMD_FLD_SOURCE	FDNAME	CHAR	30	0	Source Field	DD03L
27	TAB_XFIELD	☐	USMD_TAB_XFIELD	AS4TAB	CHAR	30	0	ABAP Dictionary Structure for X-Fields	DD02L
28	GENERATED	☐	USMD_GENERATED	USMD_FLG	CHAR	1	0	Generated Element

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USMD0020	FLD_SOURCE	DD03L	FIELDNAME
2	USMD0020	TAB_SOURCE	DD02L	TABNAME
3	USMD0020	TAB_XFIELD	DD02L	TABNAME
4	USMD0020	TMP_KEY_NROBJ	TNRO	OBJECT	KEY	1	CN
5	USMD0020	USMD_MODEL	USMD001C	USMD_MODEL	KEY
6	USMD0020	USMD_OBJSTAT	USMD001C	USMD_OBJSTAT	KEY

History

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