SAP ABAP Table T7EHS00_SRV_PROT (Health Surv. Protocols for a Med. Service)

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_SRV_PROT	Table Relationship Diagram
Short Description	Health Surv. Protocols for a Med. Service

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	SRV_NUMBER	☑	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service	T7EHS00_SERVICE
3	PGROUP	☑	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
4	PNUMBER	☑	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number	T7EHS00_PROT
5	POWNER	☐	EHS00_POWNER	EHS00_POWNER	CHAR	20	0	Protocol Owner	T7EHS00_POWNER
6	SRV_PROTTYPE	☐	EHS00_FRTYP	EHS00_FRTYP	CHAR	3	0	Examination Type	T7EHS00_FREQTYP
7	SRV_PROTRESULT	☐	EHS00_SRV_PRES	CHAR03	CHAR	3	0	Reservations About Health	T7EHS00_SRV_PRE
8	SRV_PRES_UNTIL	☐	EHS00_SRV_PRDAT	DATUM	DATS	8	0	Limitation Date for Reservations about Health
9	SRV_PROT_DECLIND	☐	EHS00_SRV_PDCL	XFLAG	CHAR	1	0	Next Examination Date Rejected
10	SRV_PROT_UDAT	☐	EHS00_SRV_PCLT	DATUM	DATS	8	0	Planned Examination Date
11	SRV_PROTTYPENEXT	☐	EHS00_FRTYPNXT	EHS00_FRTYP	CHAR	3	0	Next Examination Type	T7EHS00_FREQTYP
12	SRV_PROTNESCHEDA	☐	EHS00_NEXT_SCHED	DATS	DATS	8	0	Next Due
13	LAST_SCHED	☐	EHS00_LAST_SCHED	DATUM	DATS	8	0	Last Scheduled Appointment for Health Surveillance Protocol
14	SRV_PROT_RECDATE	☐	EHS00_SRV_RECDATE	DATUM	DATS	8	0	Entry Date for Reservations for Health Reasons
15	SRV_PHYSICIAN	☐	EHS00_SRVPHYSICIAN	BU_PARTNER	CHAR	10	0	Physician Responsible	*
16	PHYSFLAG	☐	EHS00_INEXFLAG	EHS00_INEXFLAG	CHAR	1	0	Internal/External Person
17	UNAME	☐	AENAME	UNAME	CHAR	12	0	Last Changed By
18	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
19	PROT_PRESP	☐	EHS00_PRESP	EHS00_PARNR	CHAR	10	0	Service Provider/Person Responsible
20	DATE_PERFORMED	☐	EHS00E_DATE_PERFORMED	DATS	DATS	8	0	Date Health Surveillance Protocol Performed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T7EHS00_SRV_PROT	MANDT	T000	MANDT	KEY
2	T7EHS00_SRV_PROT	PGROUP	T7EHS00_PGROUP	PGROUP	KEY	1	CN
3	T7EHS00_SRV_PROT	PNUMBER	T7EHS00_PROT	PNUMBER	KEY	1	CN
4	T7EHS00_SRV_PROT	POWNER	T7EHS00_POWNER	POWNER	REF	C	N
5	T7EHS00_SRV_PROT	SRV_NUMBER	T7EHS00_SERVICE	SRV_NUMBER	KEY	1	CN
6	T7EHS00_SRV_PROT	SRV_PROTRESULT	T7EHS00_SRV_PRE	SRV_PRES	REF	1	CN
7	T7EHS00_SRV_PROT	SRV_PROTTYPE	T7EHS00_FREQTYP	PROT_FRTYP	REF	1	CN
8	T7EHS00_SRV_PROT	SRV_PROTTYPENEXT	T7EHS00_FREQTYP	PROT_FRTYP	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in