SAP ABAP Table CCIHS_ACPMIOT (EHS: IOTAB for Safety Measure/Task Link to Plant Maint.)

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_ACPMIOT	Table Relationship Diagram
Short Description	EHS: IOTAB for Safety Measure/Task Link to Plant Maint.

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: IOTAB for Safety Measures (CCIHT_ACH)
2	.INCLUDE	☐				0	0	EHS: Standard fields for IOTABs (step loop library)
3	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
4	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
5	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
6	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
7	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
8	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
9	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
10	.INCLUDE	☐				0	0	EHS: Safety Measures - Header
11	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
12	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
13	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
14	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
15	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
16	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
17	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
18	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
19	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
20	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
21	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
22	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
23	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
24	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
25	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
26	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
27	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
28	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
29	RECNTOBJ	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
30	REFOBJ	☐	CCIHE_IHREFOBJ	CCIHD_IHREFOBJ	CHAR	3	0	Reference Object	*
31	ACID	☐	CCIHE_ACID	CCIHD_ACID	CHAR	12	0	Safety Measure Key
32	ACCAT	☐	CCIHE_ACCAT	CCIHD_ACCAT	CHAR	3	0	Safety Measure Category	CCIHC_AC07
33	ACTYPE	☐	CCIHE_ACTYPE	CCIHD_ACTYPE	CHAR	4	0	Safety Measure Type	CCIHC_AC01
34	ACPRIO	☐	CCIHE_ACPRIO	CCIHD_ACPRIO	CHAR	3	0	Priority of a Safety Measure	CCIHC_AC03
35	ACSTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
36	ACINITSTAT	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
37	PROTECTGOAL	☐	CCIHE_PROTECTGOAL	CCIHD_TEXT21	CHAR	21	0	Protection Goal of a Safety Measure
38	ACORIG	☐	CCIHE_ACORIG	CCIHD_ACORIG	CHAR	5	0	Origin of Safety Measure
39	ACDESCR	☐	CCIHE_ACDESCR	TEXT132	CHAR	132	0	Description of Safety Measure
40	ACDESCRFLG	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
41	PERSRESP	☐	CCIHE_PERSRESP	CCIHD_PERSON	CHAR	10	0	Person Responsible
42	PERSRESPEXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
43	RESPDESCR	☐	CCIHE_RESPDESCR	CCIHD_RESPDESCR	CHAR	30	0	Description of responsibility
44	DATPLAN	☐	CCIHE_DATPLAN	DATUM	DATS	8	0	Planned Execution Date
45	PSTDAT	☐	CCIHE_PSTDAT	DATUM	DATS	8	0	Planned Start Date
46	PSTTIME	☐	CCIHE_PSTTIME	TIME	TIMS	6	0	Planned Start Time for Safety Measure
47	PENDDAT	☐	CCIHE_PENDDAT	DATUM	DATS	8	0	Planned End Date
48	PENDTIME	☐	CCIHE_PENDTIME	TIME	TIMS	6	0	Planned End Time of Safety Measure
49	DATPROC	☐	CCIHE_DATPROC	DATUM	DATS	8	0	Execution Date
50	TIMPROC	☐	CCIHE_TIMPROC	TIME	TIMS	6	0	Execution Time
51	PROCPERS	☐	CCIHE_PROCPERS	CCIHD_PERSON	CHAR	10	0	Administrator for Safety Measure
52	PROCPERSEXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
53	DATCONTR	☐	CCIHE_DATCONTR	DATUM	DATS	8	0	Date of Check
54	TIMECONTR	☐	CCIHE_TIMECONTR	TIME	TIMS	6	0	Time of Check
55	RESPPCONTR	☐	CCIHE_RESPPCONTR	CCIHD_PERSON	CHAR	10	0	Person Responsible for Check
56	RESPPCONTREXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
57	ACEFF	☐	CCIHE_ACEFF	CCIHD_ACEFF	CHAR	3	0	Effectiveness of a Safety Measure	CCIHC_AC05
58	DECLINEFLG	☐	CCIHE_DECLINEFLG	ESDFLAG	CHAR	1	0	Safety Measure Rejected
59	NOTINUM	☐	CCIHE_NOTINUM	CHAR12	CHAR	12	0	Notification Number (Plant Management)
60	ACTIONNUM	☐	CCIHE_ACTIONNUM	NUM4	NUMC	4	0	Task Number (from Plant Maintenance or Elsewhere)
61	PERSRESPGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
62	PROCPERSGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
63	RESPPCONTRGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
64	ACHTIMEZONE	☐	CCIHE_TIMEZONE	TZNZONE	CHAR	6	0	Valid Time Zone	TTZZ
65	COSTS	☐	CCIHE_ACCOSTS	CCIHD_METCOASTS	CURR	10	2	Safety Measure Costs
66	CURRENCY	☐	CCIHE_ACCUKY	WAERS	CUKY	5	0	Currency Key for Costs	TCURC
67	RECNTRC	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
68	NOTIPLANT	☐	CCIHE_NOTIPLANT	WERKS	CHAR	4	0	Notification Plant	*
69	MARKTEXT	☐	ESEMARKTXT	ESDICON	CHAR	60	0	Text field used to output selection text
70	ACCATTXT	☐	CCIHE_ACCATTXT	TEXT26	CHAR	26	0	Description of Safety Measure Category
71	ACTYPENAM	☐	CCIHE_ACTYPENAM	TEXT120	CHAR	120	0	Description of Safety Measure Type
72	ACSHSTATNAM	☐	CCIHE_ACSHSTATNAM	TEXT4	CHAR	4	0	Status of Safety Measure
73	ACSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
74	ACORIGNAM	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
75	ACPRIOTXT	☐	CCIHE_ACPRIOTXT	TEXT26	CHAR	26	0	Description for Priority of the Safety Measure
76	ACEFFTXT	☐	CCIHE_ACEFFTXT	TEXT26	CHAR	26	0	Description of the Effectiveness of a Safety Measure
77	PROTECTGOALTXT	☐	CCIHE_PROTECTGOALTXT	CHAR132	CHAR	132	0	Language-Dependent Description of a Protection Goal
78	RESPFULLNAME	☐	CCIHE_RESPFULLNAME	TEXT80	CHAR	80	0	Full Name of Person Responsible
79	PROCFULLNAME	☐	CCIHE_PROCFULLNAME	TEXT80	CHAR	80	0	Full Name of Administrator
80	CONTRFULLNAME	☐	CCIHE_CONTRFULLNAME	TEXT80	CHAR	80	0	Full Name of Person Responsible for Check
81	RESPPCONTRGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
82	PROCPERSGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
83	PERSRESPGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
84	NODETXT	☐	CCIHE_NODETXT	CCIHD_NODETXT	CHAR	128	0	Description of Cause or Root Cause
85	NODETYPETXT	☐	CCIHE_NODETYPETXT	CCIHD_NODETYPETXT	CHAR	60	0	Description of Cause Type
86	MNCATTYPE	☐	QKATART	QKATART	CHAR	1	0	Catalog	TQ15
87	MNGRP	☐	RFC_MAGRP	QCODEGRP	CHAR	8	0	Code Group - Tasks	QPGR
88	MNCOD	☐	MNCOD	QCODE	CHAR	4	0	Task code	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_ACPMIOT	ACCAT	CCIHC_AC07	ACCAT	REF	1	CN
2	CCIHS_ACPMIOT	ACEFF	CCIHC_AC05	ACEFF	REF	1	CN
3	CCIHS_ACPMIOT	ACHTIMEZONE	TTZZ	TZONE	REF	1	CN
4	CCIHS_ACPMIOT	ACPRIO	CCIHC_AC03	ACPRIO	REF	1	CN
5	CCIHS_ACPMIOT	ACTYPE	CCIHC_AC01	ACTYPE		1	CN
6	CCIHS_ACPMIOT	AENNR	AENR	AENNR	REF	1	CN
7	CCIHS_ACPMIOT	CURRENCY	TCURC	WAERS
8	CCIHS_ACPMIOT	MANDT	T000	MANDT
9	CCIHS_ACPMIOT	MNCATTYPE	TQ15	KATALOGART		C	CN
10	CCIHS_ACPMIOT	MNGRP	QPGR	CODEGRUPPE	REF	C	CN
11	CCIHS_ACPMIOT	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in