SAP ABAP View CCIHV_ERQTWAH (EHS: Risk Assessments for Work Areas)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
     ⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety

Basic Data

View Type	D	Database View
Database View	CCIHV_ERQTWAH
Short Description	EHS: Risk Assessments for Work Areas
Root table	CCIHT_WAH	EHS: Work Area - Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CCIHT_WAH	CCIHT_WAH
2	CCIHT_ERH
3	CCIHT_ERQT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CCIHT_WAH	RECN	JL	EQ				0	0
2	CCIHT_ERH	RECNTWAH	JR	EQ			AND	0	0
3	CCIHT_ERH	RECN	JL	EQ				0	0
4	CCIHT_ERQT	RECNROOT	JR	EQ			AND	0	0
5	CCIHT_WAH	MANDT	JL	EQ				0	0
6	CCIHT_ERH	MANDT	JR	EQ			AND	0	0
7	CCIHT_ERH	MANDT	JL	EQ				0	0
8	CCIHT_ERQT	MANDT	JR	EQ			AND	0	0
9	CCIHT_WAH	DELFLG		EQ	' '		AND	0	0
10	CCIHT_ERH	DELFLG		EQ	' '		AND	0	0
11	CCIHT_ERQT	DELFLG		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CCIHT_WAH	MANDT		☐	MANDT	☐	Client
2	RECN	CCIHT_ERH	RECN		☐	ESERECN	☐	Sequential Number of Data Record
3	WAID	CCIHT_WAH	WAID		☐	CCIHE_WAID	☐	Work Area or Pattern
4	WVALFR	CCIHT_WAH	VALFR		☐	ESEVALFR	☐	Valid-From Date
5	WVALTO	CCIHT_WAH	VALTO		☐	ESEVALTO	☐	Valid-To Date
6	WUPDDAT	CCIHT_WAH	UPDDAT		☐	ESEUPDDAT	☐	Changed On
7	HVALFR	CCIHT_ERH	VALFR		☐	ESEVALFR	☐	Valid-From Date
8	HVALTO	CCIHT_ERH	VALTO		☐	ESEVALTO	☐	Valid-To Date
9	HUPDDAT	CCIHT_ERH	UPDDAT		☐	ESEUPDDAT	☐	Changed On
10	TVALFR	CCIHT_ERQT	VALFR		☐	ESEVALFR	☐	Valid-From Date
11	TVALTO	CCIHT_ERQT	VALTO		☐	ESEVALTO	☐	Valid-To Date
12	TUPDDAT	CCIHT_ERQT	UPDDAT		☐	ESEUPDDAT	☐	Changed On

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	200