SAP ABAP Table EHS00PERSRELPROT (Proposal List: Assignment Person and Health Surv. Protocol)

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	EHS00PERSRELPROT	Table Relationship Diagram
Short Description	Proposal List: Assignment Person and Health Surv. Protocol

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	Assign Persons -> Protocols
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PERNR	☐	EHS00_PERNR	EHS00_PERNR	NUMC	8	0	Personnel number	*
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
6	PROT_TYPE	☐	EHS00_FRTYP	EHS00_FRTYP	CHAR	3	0	Examination Type	T7EHS00_FREQTYP
7	STATUS_SCHED	☐	EHS00_STAT_SCHED	XFLAG	CHAR	1	0	Service Available
8	LAST_SCHED	☐	EHS00_LAST_SCHED	DATUM	DATS	8	0	Last Scheduled Appointment for Health Surveillance Protocol
9	NEXT_SCHED	☐	EHS00_NEXT_SCHED	DATS	DATS	8	0	Next Due
10	STATUS_PROT	☐	EHS00_STAT_PROT	CHAR1	CHAR	1	0	Status of Assignment	T7EHS00_STATPR
11	BYHAND_FLAG	☐	EHS00_MANFLG	EHS00_MANFLG	CHAR	1	0	Perform
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
14	VACC_SEQ_FLG	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
15	PNAME	☐	EHS00_PNAME	TEXT40	CHAR	40	0	Description of Health Surveillance Protocol
16	SCHEDNAM	☐	EHS00_SCHEDNAM	TEXT20	CHAR	20	0	Description of Protocol Type
17	PROT_FRTYPNAM	☐	EHS00_FRTYPNAM	TEXT40	CHAR	40	0	Name of Examination Type
18	PROT_NO_CHANGE	☐	EHS00_PNC	BOOLEAN	CHAR	1	0	Ignore Proposal
19	PROT_ADD	☐	EHS00_PADD	BOOLEAN	CHAR	1	0	Add Health Surveillance Protocol
20	PROT_INACTIVATE	☐	EHS00_PINACT	BOOLEAN	CHAR	1	0	Remove Health Surveillance Protocol
21	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
22	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
23	REASON	☐	EHS00_COMMENT	TEXT255	CHAR	255	0	Additional Information

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00PERSRELPROT	MANDT	T000	MANDT	KEY
2	EHS00PERSRELPROT	PGROUP	T7EHS00_PGROUP	PGROUP	KEY
3	EHS00PERSRELPROT	PROT_TYPE	T7EHS00_FREQTYP	PROT_FRTYP	REF
4	EHS00PERSRELPROT	STATUS_PROT	T7EHS00_STATPR	STATUS_PROT	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in