SAP ABAP Table EHS00S_SRV_PROT (Structure: Health Surveillance Protocols in the 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	INTTAB	Structure
Structure	EHS00S_SRV_PROT	Table Relationship Diagram
Short Description	Structure: Health Surveillance Protocols in the Med. Service

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Health Surv. Protocols for a Med. Service
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	SRV_NUMBER	☐	EHS00_SRVNUMBER	NUMC12	NUMC	12	0	Number of Medical Service	T7EHS00_SERVICE
4	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
5	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number	T7EHS00_PROT
6	POWNER	☐	EHS00_POWNER	EHS00_POWNER	CHAR	20	0	Protocol Owner	T7EHS00_POWNER
7	SRV_PROTTYPE	☐	EHS00_FRTYP	EHS00_FRTYP	CHAR	3	0	Examination Type	T7EHS00_FREQTYP
8	SRV_PROTRESULT	☐	EHS00_SRV_PRES	CHAR03	CHAR	3	0	Reservations About Health	T7EHS00_SRV_PRE
9	SRV_PRES_UNTIL	☐	EHS00_SRV_PRDAT	DATUM	DATS	8	0	Limitation Date for Reservations about Health
10	SRV_PROT_DECLIND	☐	EHS00_SRV_PDCL	XFLAG	CHAR	1	0	Next Examination Date Rejected
11	SRV_PROT_UDAT	☐	EHS00_SRV_PCLT	DATUM	DATS	8	0	Planned Examination Date
12	SRV_PROTTYPENEXT	☐	EHS00_FRTYPNXT	EHS00_FRTYP	CHAR	3	0	Next Examination Type	T7EHS00_FREQTYP
13	SRV_PROTNESCHEDA	☐	EHS00_NEXT_SCHED	DATS	DATS	8	0	Next Due
14	LAST_SCHED	☐	EHS00_LAST_SCHED	DATUM	DATS	8	0	Last Scheduled Appointment for Health Surveillance Protocol
15	SRV_PROT_RECDATE	☐	EHS00_SRV_RECDATE	DATUM	DATS	8	0	Entry Date for Reservations for Health Reasons
16	SRV_PHYSICIAN	☐	EHS00_SRVPHYSICIAN	BU_PARTNER	CHAR	10	0	Physician Responsible	*
17	PHYSFLAG	☐	EHS00_INEXFLAG	EHS00_INEXFLAG	CHAR	1	0	Internal/External Person
18	UNAME	☐	AENAME	UNAME	CHAR	12	0	Last Changed By
19	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
20	PROT_PRESP	☐	EHS00_PRESP	EHS00_PARNR	CHAR	10	0	Service Provider/Person Responsible
21	DATE_PERFORMED	☐	EHS00E_DATE_PERFORMED	DATS	DATS	8	0	Date Health Surveillance Protocol Performed
22	PGROUPNAM	☐	EHS00_PGROUPNAM	TEXT20	CHAR	20	0	Description of Health Surveillance Protocol Category
23	PNAME	☐	EHS00_PNAME	TEXT40	CHAR	40	0	Description of Health Surveillance Protocol
24	POWNERNAM	☐	EHS00_POWNERNAM	TEXT40	CHAR	40	0	Owner Name
25	PROT_FRTYPNAM	☐	EHS00_FRTYPNAM	TEXT40	CHAR	40	0	Name of Examination Type
26	RESULTTEXT	☐	EHS00_SRV_RESTXT	TEXT50	CHAR	50	0	Description of Reservations about Health
27	PROT_FRTYPNAMNXT	☐	EHS00_FRTYPNXTNAM	TEXT40	CHAR	40	0	Description of Next Examination Type
28	SCHEDNR	☐	EHS00_SCHED	EHS00_SCHED	CHAR	1	0	Health Surveillance Protocol Type	*
29	SCHEDNAM	☐	EHS00_SCHEDNAM	TEXT20	CHAR	20	0	Description of Protocol Type
30	PROT_PHYSNAM	☐	EHS00_PHYSICIANT	TEXT80	CHAR	80	0	Physician/Health Center
31	PROT_PHYSNAM_S	☐	EHS00_PHYSICIANT	TEXT80	CHAR	80	0	Physician/Health Center
32	PGFLG	☐	EHS00_PGFLG	EHS00_PGFLG	CHAR	2	0	Delimitation of Health Surveillance Protocols
33	TEXT_DDTEXT	☐	EHS00E_PROT_CHARACTER_NAME	DDTEXT	CHAR	60	0	Identification of Health Surveillance Protocol Category

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in