SAP ABAP View DBVIEW_PROT (DB View for Tables T7EHS00_PROT and T7EHS00_PROTAGNT)

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

View Type	D	Database View
Database View	DBVIEW_PROT
Short Description	DB View for Tables T7EHS00_PROT and T7EHS00_PROTAGNT
Root table	T7EHS00_PROT	Health Surveillance Protocols

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T7EHS00_PROT	T7EHS00_PROT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	PGROUP	T7EHS00_PROT	PGROUP		☐	EHS00_PGROUP	☐	Health Surveillance Protocol Category
2	PNUMBER	T7EHS00_PROT	PNUMBER		☐	EHS00_PNUMBER	☐	Protocol Number
3	ENDDA	T7EHS00_PROT	ENDDA		☐	ENDDATUM	☐	End Date
4	BEGDA	T7EHS00_PROT	BEGDA		☐	BEGDATUM	☐	Start Date
5	LTA_TRIGGER	T7EHS00_PROT	LTA_TRIGGER		☐	EHS00_AERT1	☐	Long-Term Average Trigger Level
6	NRT_TRIGGER	T7EHS00_PROT	NRT_TRIGGER		☐	EHS00_NRTTR	☐	Nonroutine Task
7	AND_LTA_TRIGGER	T7EHS00_PROT	AND_LTA_TRIGGER		☐	EHS00_AERT2	☐	Additional Long-Term Average Trigger Level
8	ER_RAT_TRIG	T7EHS00_PROT	ER_RAT_TRIG		☐	EHS00_AERT3	☐	Short-Time Exposure Rating
9	ER_RAT_FREQ_TRIG	T7EHS00_PROT	ER_RAT_FREQ_TRIG		☐	EHS00_RAT01	☐	Exposure Frequency Trigger Level
10	SKINEXPFREQ_TRIG	T7EHS00_PROT	SKINEXPFREQ_TRIG		☐	EHS00_RAT02	☐	Skin Absorption Trigger Level
11	SKINEFFFREQ_TRIG	T7EHS00_PROT	SKINEFFFREQ_TRIG		☐	EHS00_RAT03	☐	Skin Exposure Effects Trigger Level
12	INGESTFREQ_TRIG	T7EHS00_PROT	INGESTFREQ_TRIG		☐	EHS00_RAT04	☐	Ingestion Effects Trigger Level
13	UNAME	T7EHS00_PROT	UNAME		☐	AENAM	☐	Name of Person Who Changed Object

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in