SAP ABAP Table CCIHS_WAQSIOT (EHS: IOTAB Work Area Assignment Specific Questionnaire)

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_WAQSIOT	Table Relationship Diagram
Short Description	EHS: IOTAB Work Area Assignment Specific Questionnaire

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	EHS: Standard fields for IOTABs (step loop library)
2	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
3	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
4	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
5	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
6	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
7	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
8	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
9	.INCLUDE	☐				0	0	EHS: Work Area - Specific Questionnaire Assignment
10	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
11	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
12	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
13	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
14	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
15	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
16	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
17	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
18	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
19	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
20	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
21	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
22	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
23	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
24	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
25	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
26	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
27	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
28	CONCATKEY	☐	CCIHE_QSCONCATKEY	TEXT30	CHAR	30	0	Specific Questionnaire Key	T7EHS00_RESQINFO
29	INDATE	☐	CCIHE_INDATE	DATUM	DATS	8	0	Date of Questioning
30	Q_ID	☐	EHS00_QID	NUMC06	NUMC	6	0	Number of General Questionnaire
31	OPCONDTXT	☐	CCIHE_OPCONDTXT	TEXT30	CHAR	30	0	Description of Operation Status
32	Q_NAME	☐	EHS00_QNAME	TEXT50	CHAR	50	0	Description of General Questionnaire
33	QSDESCRTXT	☐	CCIHE_QSCONCATKEYNAM	TEXT50	CHAR	50	0	Description of Specific Questionnaire
34	COMPLETEFLG	☐	EHS00_YESCRIT	BOOLEAN	CHAR	1	0	Question Answered with 'Yes'

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_WAQSIOT	AENNR	AENR	AENNR	REF	1	CN
2	CCIHS_WAQSIOT	CONCATKEY	T7EHS00_RESQINFO	CONCATKEY
3	CCIHS_WAQSIOT	MANDT	T000	MANDT
4	CCIHS_WAQSIOT	OPCOND	CCIHC_OC01	OPCOND
5	CCIHS_WAQSIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in