SAP ABAP Table T7EHS00_DIAGSL (Diagnosis Key)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-HEA (Application Component) Occupational Health
     ⤷ P99Q1 (Package) EH&S: Occupational Health

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T7EHS00_DIAGSL	Table Relationship Diagram
Short Description	Diagnosis Key

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DIAGN_CTLG	☑	EHS00_DIAG_CAT	CHAR02	CHAR	2	0	Diagnosis Catalog	T7EHS00_DIAGKT
3	DIAGN_CODE	☑	EHS00_DIAGN_CODE	EHS00_DIAGN_CODE	CHAR	6	0	Diagnosis Code
4	DIAGN_TYPE	☑	EHS00_DIAGN_TYPE	CHAR01	CHAR	1	0	Diagnosis Key Category	T7EHS00_DIAGNTY
5	DIAGN_GROUP	☐	EHS00_DIAGN_GR	CHAR01	CHAR	1	0	Diagnosis Group	T7EHS00_DIAGNGR
6	DIAGN_PRIO	☐	EHS00_DIAGN_PRIO	CHAR01	CHAR	1	0	Diagnosis Priority	T7EHS00_DIAGNPR
7	LUSER	☐	UNAME	UNAME	CHAR	12	0	User Name
8	LDATE	☐	AEDTM	DATUM	DATS	8	0	Changed on

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_DIAGSL	DIAGN_CTLG	T7EHS00_DIAGKT	CATID	KEY	C	CN
2	T7EHS00_DIAGSL	DIAGN_GROUP	T7EHS00_DIAGNGR	DIAGN_GROUP	REF	1	CN
3	T7EHS00_DIAGSL	DIAGN_PRIO	T7EHS00_DIAGNPR	DIAGN_PRIO	REF	1	CN
4	T7EHS00_DIAGSL	DIAGN_TYPE	T7EHS00_DIAGNTY	DIAGN_TYPE	KEY	1	CN
5	T7EHS00_DIAGSL	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in