SAP ABAP Table CCIHS_ACHIOT (EHS: IOTAB for Safety Measures (CCIHT_ACH))

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_ACHIOT	Table Relationship Diagram
Short Description	EHS: IOTAB for Safety Measures (CCIHT_ACH)

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: Safety Measures - Header
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	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
28	RECNTOBJ	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
29	REFOBJ	☐	CCIHE_IHREFOBJ	CCIHD_IHREFOBJ	CHAR	3	0	Reference Object	*
30	ACID	☐	CCIHE_ACID	CCIHD_ACID	CHAR	12	0	Safety Measure Key
31	ACCAT	☐	CCIHE_ACCAT	CCIHD_ACCAT	CHAR	3	0	Safety Measure Category	CCIHC_AC07
32	ACTYPE	☐	CCIHE_ACTYPE	CCIHD_ACTYPE	CHAR	4	0	Safety Measure Type	CCIHC_AC01
33	ACPRIO	☐	CCIHE_ACPRIO	CCIHD_ACPRIO	CHAR	3	0	Priority of a Safety Measure	CCIHC_AC03
34	ACSTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status	*
35	ACINITSTAT	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
36	PROTECTGOAL	☐	CCIHE_PROTECTGOAL	CCIHD_TEXT21	CHAR	21	0	Protection Goal of a Safety Measure
37	ACORIG	☐	CCIHE_ACORIG	CCIHD_ACORIG	CHAR	5	0	Origin of Safety Measure
38	ACDESCR	☐	CCIHE_ACDESCR	TEXT132	CHAR	132	0	Description of Safety Measure
39	ACDESCRFLG	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
40	PERSRESP	☐	CCIHE_PERSRESP	CCIHD_PERSON	CHAR	10	0	Person Responsible
41	PERSRESPEXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
42	RESPDESCR	☐	CCIHE_RESPDESCR	CCIHD_RESPDESCR	CHAR	30	0	Description of responsibility
43	DATPLAN	☐	CCIHE_DATPLAN	DATUM	DATS	8	0	Planned Execution Date
44	PSTDAT	☐	CCIHE_PSTDAT	DATUM	DATS	8	0	Planned Start Date
45	PSTTIME	☐	CCIHE_PSTTIME	TIME	TIMS	6	0	Planned Start Time for Safety Measure
46	PENDDAT	☐	CCIHE_PENDDAT	DATUM	DATS	8	0	Planned End Date
47	PENDTIME	☐	CCIHE_PENDTIME	TIME	TIMS	6	0	Planned End Time of Safety Measure
48	DATPROC	☐	CCIHE_DATPROC	DATUM	DATS	8	0	Execution Date
49	TIMPROC	☐	CCIHE_TIMPROC	TIME	TIMS	6	0	Execution Time
50	PROCPERS	☐	CCIHE_PROCPERS	CCIHD_PERSON	CHAR	10	0	Administrator for Safety Measure
51	PROCPERSEXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
52	DATCONTR	☐	CCIHE_DATCONTR	DATUM	DATS	8	0	Date of Check
53	TIMECONTR	☐	CCIHE_TIMECONTR	TIME	TIMS	6	0	Time of Check
54	RESPPCONTR	☐	CCIHE_RESPPCONTR	CCIHD_PERSON	CHAR	10	0	Person Responsible for Check
55	RESPPCONTREXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
56	ACEFF	☐	CCIHE_ACEFF	CCIHD_ACEFF	CHAR	3	0	Effectiveness of a Safety Measure	CCIHC_AC05
57	DECLINEFLG	☐	CCIHE_DECLINEFLG	ESDFLAG	CHAR	1	0	Safety Measure Rejected
58	NOTINUM	☐	CCIHE_NOTINUM	CHAR12	CHAR	12	0	Notification Number (Plant Management)
59	ACTIONNUM	☐	CCIHE_ACTIONNUM	NUM4	NUMC	4	0	Task Number (from Plant Maintenance or Elsewhere)
60	PERSRESPGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
61	PROCPERSGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
62	RESPPCONTRGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
63	ACHTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
64	COSTS	☐	CCIHE_ACCOSTS	CCIHD_METCOASTS	CURR	10	2	Safety Measure Costs
65	CURRENCY	☐	CCIHE_ACCUKY	WAERS	CUKY	5	0	Currency Key for Costs	TCURC
66	RECNTRC	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
67	NOTIPLANT	☐	CCIHE_NOTIPLANT	WERKS	CHAR	4	0	Notification Plant	*
68	MARKTEXT	☐	ESEMARKTXT	ESDICON	CHAR	60	0	Text field used to output selection text
69	ACCATTXT	☐	CCIHE_ACCATTXT	TEXT26	CHAR	26	0	Description of Safety Measure Category
70	ACTYPENAM	☐	CCIHE_ACTYPENAM	TEXT120	CHAR	120	0	Description of Safety Measure Type
71	ACSHSTATNAM	☐	CCIHE_ACSHSTATNAM	TEXT4	CHAR	4	0	Status of Safety Measure
72	ACSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
73	ACORIGNAM	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
74	ACPRIOTXT	☐	CCIHE_ACPRIOTXT	TEXT26	CHAR	26	0	Description for Priority of the Safety Measure
75	ACEFFTXT	☐	CCIHE_ACEFFTXT	TEXT26	CHAR	26	0	Description of the Effectiveness of a Safety Measure
76	PROTECTGOALTXT	☐	CCIHE_PROTECTGOALTXT	CHAR132	CHAR	132	0	Language-Dependent Description of a Protection Goal
77	RESPFULLNAME	☐	CCIHE_RESPFULLNAME	TEXT80	CHAR	80	0	Full Name of Person Responsible
78	PROCFULLNAME	☐	CCIHE_PROCFULLNAME	TEXT80	CHAR	80	0	Full Name of Administrator
79	CONTRFULLNAME	☐	CCIHE_CONTRFULLNAME	TEXT80	CHAR	80	0	Full Name of Person Responsible for Check
80	RESPPCONTRGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
81	PROCPERSGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
82	PERSRESPGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
83	NODETXT	☐	CCIHE_NODETXT	CCIHD_NODETXT	CHAR	128	0	Description of Cause or Root Cause
84	NODETYPETXT	☐	CCIHE_NODETYPETXT	CCIHD_NODETYPETXT	CHAR	60	0	Description of Cause Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_ACHIOT	ACCAT	CCIHC_AC07	ACCAT	REF	1	CN
2	CCIHS_ACHIOT	ACEFF	CCIHC_AC05	ACEFF	REF	1	CN
3	CCIHS_ACHIOT	ACHTIMEZONE	TTZZ	TZONE	REF	1	CN
4	CCIHS_ACHIOT	ACPRIO	CCIHC_AC03	ACPRIO	REF	1	CN
5	CCIHS_ACHIOT	ACTYPE	CCIHC_AC01	ACTYPE		1	CN
6	CCIHS_ACHIOT	AENNR	AENR	AENNR	REF	1	CN
7	CCIHS_ACHIOT	CURRENCY	TCURC	WAERS
8	CCIHS_ACHIOT	MANDT	T000	MANDT
9	CCIHS_ACHIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in