SAP ABAP Table CCIHS_WATREEINF (EHS: Structure for Displaying the Work Area Hierarchy)

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

Table Category	INTTAB	Structure
Structure	CCIHS_WATREEINF	Table Relationship Diagram
Short Description	EHS: Structure for Displaying the Work Area Hierarchy

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	ID	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
2	TLEVEL	☐	SEU_LEVEL	SEU_LEVEL	NUMC	2	0	Node level
3	.INCLUDE	☐				0	0	EHS: Work Area - Header
4	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
7	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
8	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
9	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
10	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
11	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
12	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
13	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
14	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
15	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
16	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
17	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
18	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
19	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
20	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
21	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
22	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
23	WATYPE	☐	CCIHE_WATYPE	CCIHD_WATYPE	CHAR	2	0	Work Area or Pattern Type	CCIHC_WA01
24	WASTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status	*
25	WAINITSTAT	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
26	WAVERS	☐	CCIHE_WAVERS	CHAR5	CHAR	5	0	Work Area Version
27	AUTHGRP	☐	CCIHE_WAAUTHGRP	CCIHD_WAAUTHGRP	CHAR	10	0	Authorization Group for Work Area or Pattern	CCIHC_WA11
28	RVLID	☐	ESERVLID	ESDRVLID	CHAR	10	0	Validity Area	TCG91
29	MTNLANGU	☐	CCIHE_MTNLANGU	SPRAS	LANG	1	0	Language of Entry	T002
30	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area	*
31	WAPLANT	☐	CCIHE_WAPLANT	WERKS	CHAR	4	0	Plant	T001W
32	WACOORD	☐	CCIHE_WACOORD	TEXT20	CHAR	20	0	Work Area Coordinates
33	WACOSTAC1	☐	CCIHE_WACOSTAC	KOSTL	CHAR	10	0	Cost Center of Work Area	*
34	WACTRAREA	☐	CCIHE_WACTRAREA	CACCD	CHAR	4	0	Controlling Area for Work Area	*
35	WACOCODE	☐	CCIHE_WACOCODE	BUKRS	CHAR	4	0	Company Code for Work Area	*
36	PTUSAGEFLG	☐	CCIHE_PTUSAGEFLG	ESDBOOLE	CHAR	1	0	Usage Indicator for Pattern
37	OVERALLRAT	☐	CCIHE_OVERALLRAT	CCIHD_RATING	CHAR	3	0	Overall Rating of Exposure Situation in Work Area	*
38	RECEIVEDRAT	☐	CCIHE_RECEIVEDRAT	CCIHD_RATING	CHAR	3	0	Received Rating in Work Area	*
39	WATYPENAM	☐	CCIHE_WATYPENAM	TEXT20	CHAR	20	0	Description of Work Area Type
40	WAPLANTNAM	☐	CCIHE_WAPLANTNAM	TEXT30	CHAR	30	0	Plant Description
41	WASPID	☐	CCIHE_WASPID	CCIHD_WAID	CHAR	20	0	Higher-Level Work Area
42	WASPNAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_WATREEINF	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_WATREEINF	AUTHGRP	CCIHC_WA11	AUTHGRP		1	CN
3	CCIHS_WATREEINF	MANDT	T000	MANDT
4	CCIHS_WATREEINF	MTNLANGU	T002	SPRAS	REF	1	CN
5	CCIHS_WATREEINF	RVLID	TCG91	RVLID		1	CN
6	CCIHS_WATREEINF	SRSID	TCG56	SRSID	REF	1	CN
7	CCIHS_WATREEINF	WAPLANT	T001W	WERKS		1	CN
8	CCIHS_WATREEINF	WATYPE	CCIHC_WA01	WATYPE	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in