SAP ABAP Table EHQMT_BASIC_DATA (EH&S-QM: Basic Data for Inspection Plans)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ CBQM (Package) EH&S-QM Interface

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EHQMT_BASIC_DATA	Table Relationship Diagram
Short Description	EH&S-QM: Basic Data for Inspection Plans

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	ID	☑	CHAR012	CHAR12	CHAR	12	0	Character field of length 12
3	ORD	☑	NUMC5	NUM5	NUMC	5	0	5 Character Numeric NUMC
4	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
5	SUBID	☐	ESESUBID	ESDSUBID	CHAR	12	0	Specification
6	.INCLUDE	☐				0	0	EH&S-QM: Selection Screen
7	VALDAT	☐	ESEDIAGVD	DATUM	DATS	8	0	Key Date
8	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	VACLID	☐	ESEVACLID	ESDVACLID	CHAR	10	0	Rating	TCG86
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
12	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
13	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
14	ALLVACL	☐	EHQME_ALLVACL	EHQMD_ALLVACL	CHAR	1	0	EH&S-QM: Group All Ratings

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHQMT_BASIC_DATA	AENNR	AENR	AENNR		1	CN
2	EHQMT_BASIC_DATA	KUNNR	KNA1	KUNNR		1	CN
3	EHQMT_BASIC_DATA	LIFNR	LFA1	LIFNR		1	CN
4	EHQMT_BASIC_DATA	MANDT	T000	MANDT		1	CN
5	EHQMT_BASIC_DATA	MATNR	MARA	MATNR		1	CN
6	EHQMT_BASIC_DATA	VACLID	TCG86	VACLID
7	EHQMT_BASIC_DATA	WERKS	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C