SAP ABAP Table T7EHS00_DIAGSLT (Diagnosis Key (Matchcode Table))

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_DIAGSLT	Table Relationship Diagram
Short Description	Diagnosis Key (Matchcode Table)

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	T7EHS00_DIAGSL
4	DIAGN_TYPE	☑	EHS00_DIAGN_TYPE	CHAR01	CHAR	1	0	Diagnosis Key Category	T7EHS00_DIAGNTY
5	DIAGN_LANG	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
6	DIAGN_MC	☐	EHS00_DIAG_MC	CHAR160	CHAR	160	0	Matchcode for String Search for Diagnosis Key

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_DIAGSLT	DIAGN_CODE	T7EHS00_DIAGSL	DIAGN_CODE	TEXT	1	CN
2	T7EHS00_DIAGSLT	DIAGN_CTLG	T7EHS00_DIAGKT	CATID	KEY	C	CN
3	T7EHS00_DIAGSLT	DIAGN_LANG	T002	SPRAS	KEY	1	CN
4	T7EHS00_DIAGSLT	DIAGN_TYPE	T7EHS00_DIAGNTY	DIAGN_TYPE	KEY	1	CN
5	T7EHS00_DIAGSLT	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in