SAP ABAP View H_EHS00EXAM (DB View for Examinations (without Service Agent))

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	H_EHS00EXAM
Short Description	DB View for Examinations (without Service Agent)
Root table	T7EHS00_EGROUP	Examination Category

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T7EHS00_EGROUP	T7EHS00_EGROUP
2	T7EHS00_EGROUPT
3	T7EHS00_EXAM
4	T7EHS00_EXAMT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T7EHS00_EGROUP	MANDT	JL	EQ				0	0
2	T7EHS00_EGROUPT	MANDT	JR	EQ			AND	0	0
3	T7EHS00_EGROUP	EXAM_GROUP	JL	EQ				0	0
4	T7EHS00_EGROUPT	EXAM_GROUP	JR	EQ			AND	0	0
5	T7EHS00_EGROUP	MANDT	JL	EQ				0	0
6	T7EHS00_EXAM	MANDT	JR	EQ			AND	0	0
7	T7EHS00_EGROUP	EXAM_GROUP	JL	EQ				0	0
8	T7EHS00_EXAM	EXAM_GROUP	JR	EQ			AND	0	0
9	T7EHS00_EXAM	MANDT	JL	EQ				0	0
10	T7EHS00_EXAMT	MANDT	JR	EQ			AND	0	0
11	T7EHS00_EXAM	EXAM_GROUP	JL	EQ				0	0
12	T7EHS00_EXAMT	EXAM_GROUP	JR	EQ			AND	0	0
13	T7EHS00_EXAM	EXAM_CODE	JL	EQ				0	0
14	T7EHS00_EXAMT	EXAM_CODE	JR	EQ			AND	0	0
15	T7EHS00_EXAMT	SPRAS	JL	EQ				0	0
16	T7EHS00_EGROUPT	SPRAS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T7EHS00_EXAM	MANDT		☐	MANDT	☐	Client
2	EXAM_GROUP	T7EHS00_EXAM	EXAM_GROUP		☐	EHS00_EGROUP	☐	Examination Category
3	EXAM_CODE	T7EHS00_EXAM	EXAM_CODE		☐	EHS00_ECODE	☐	Examination Number
4	ENDDA	T7EHS00_EXAM	ENDDA		☐	ENDDATUM	☐	End Date
5	BEGDA	T7EHS00_EXAM	BEGDA		☐	BEGDATUM	☐	Start Date
6	ENAME	T7EHS00_EXAMT	ENAME		☐	EHS00_ENAME	☐	Name of Examination
7	EXAM_GROUPNAM	T7EHS00_EGROUPT	EXAM_GROUPNAM		☐	EHS00_GROUPNAM	☐	Description of Examination Category
8	SPRAS	T7EHS00_EXAMT	SPRAS		☐	SPRAS	☐	Language Key

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