SAP ABAP Table T7EHS00_VACCH (EHS: Vaccination Data Header Information)

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_VACCH	Table Relationship Diagram
Short Description	EHS: Vaccination Data Header Information

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	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	CRDTIMESTAMP	☐	EHS00_CRTS		DEC	15	0	Creation Time
19	UPDTIMESTAMP	☐	EHS00_UPDTS		DEC	15	0	Time of Last Change
20	PERNR	☐	EHS00_PERNR	EHS00_PERNR	NUMC	8	0	Personnel number	T7EHS00_MAPPERNR
21	SERVICENO	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service
22	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	VT7EHS00_PGROUPV
23	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number	T7EHS00_PROT
24	SRV_PROTTYPE	☐	EHS00_FRTYP	EHS00_FRTYP	CHAR	3	0	Examination Type	T7EHS00_PROTFREQ
25	VACC_ID	☐	EHS00_VACCID	EHS00_VACCID	CHAR	20	0	Vaccination
26	VACC_DATE	☐	EHS00_VACCDATE		DATS	8	0	Vaccination Date
27	VACC_STATUS	☐	EHS00_VACCSTATUS	EHS00_VACCSTATUS	CHAR	1	0	Vaccination Status
28	BRAND_NAME	☐	EHS00_BRANDNAME	EHS00D_BRANDNAME	CHAR	50	0	Brand Name
29	BATCHNO	☐	EHS00_BATCHNO		CHAR	20	0	Batch Number
30	VACC_COMMENT	☐	EHS00_VACCCMNT	TEXT75	CHAR	75	0	Comment on Vaccination
31	VACC_PHYSICIAN	☐	EHS00_SRVPHYSICIAN	BU_PARTNER	CHAR	10	0	Physician Responsible	*
32	VACC_PHYSFLG	☐	EHS00_INEXFLAG	EHS00_INEXFLAG	CHAR	1	0	Internal/External Person
33	PRIVATFLG	☐	EHS00_PRIVATEFLG	ESDFLAG	CHAR	1	0	Vaccination to Be Settled Privately

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_VACCH	AENNR	AENR	AENNR	REF	1	CN
2	T7EHS00_VACCH	MANDT	T000	MANDT
3	T7EHS00_VACCH	PERNR	T7EHS00_MAPPERNR	INTPERNR
4	T7EHS00_VACCH	PGROUP	VT7EHS00_PGROUPV	PGROUP
5	T7EHS00_VACCH	PNUMBER	T7EHS00_PROT	PNUMBER
6	T7EHS00_VACCH	SRSID	TCG56	SRSID	REF	1	CN
7	T7EHS00_VACCH	SRV_PROTTYPE	T7EHS00_PROTFREQ	PROT_FRTYP

History

Last changed by/on	SAP	20110901
SAP Release Created in	200