1. Home
  2. Resources
  3. SAP Tables
  4. BAPI1240_ACH - EHS: BAPI - Structure for IHS Safety Measures

SAP Table BAPI1240_ACH

EHS: BAPI - Structure for IHS Safety Measures

BAPI1240_ACH (EHS: BAPI - Structure for IHS Safety Measures) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPI1240_ACH to other SAP tables.

BAPI1240_ACH table fields

Field Data element Checktable Datatype Length Decimals
FUNCTION Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
LOGLOCKMOD Logical Lock Mode ESELGLCKMD CHAR 1 0
EXTINFO External Information ESEEXTINFO CHAR 10 0
PRIMARYKEY Artificial Primary Key for Specification Tables in BAPIs ESEPKEY NUMC 20 0
FOREIGNKEY Artificial Foreign Key in Specification Tables for BAPIs ESEFKEY NUMC 20 0
FLGPRIMKEY Data Record Created with Artificial Primary Key ESEFLGPKEY CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
FLGFRGNKEY New Parent Record Was Created ESEFLGFKEY CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
CLIENT Client MANDT T000 CLNT 3 0
RECORD_NO Sequential Number of Data Record ESERECN NUMC 20 0
CHNGSTATUS Sequential Number of the Change State ESEACTN NUMC 20 0
VALID_FROM Valid-From Date ESEVALFR DATS 8 0
VALID_TO Valid-To Date ESEVALTO DATS 8 0
CHANG_NO Change Number ESEAENNR AENR CHAR 12 0
DEL_IND Deletion Indicator ESEDELFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PARK_IND Data Record Is Inactive ESEPARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
CREATED_ON Created On ESECRDAT DATS 8 0
CREATED_BY Created By ESECRNAM CHAR 12 0
CHANGD_ON Changed On ESEUPDDAT DATS 8 0
CHANGD_BY Last Changed By ESEUPDNAM CHAR 12 0
DATAORIGIN Source of Data ESESRSID TCG56 CHAR 10 0
DATA_PROV Data Provider ESEVENDRID CHAR 10 0
RECNO_ROOT Sequential Number of Data Record ESERECN NUMC 20 0
OBJECT_NO Object number J_OBJNR CHAR 22 0
RECORD_NO_OBJECT Sequential Number of Data Record ESERECN NUMC 20 0
REF_OBJECT Reference Object CCIHE_IHREFOBJ CHAR 3 0
WA Reference to work areas, table CCIHT_WAH
IAL Reference to incident/accident log entries, table CCIHT_IAL
FAL Reference to injury/illness log entries, table CCIHT_FAL
HAS Reference to exposure assignment, table CCIHT_ERH
AFP Reference to person affected, table CCIHT_IPEVA
SUB Reference to substance (agent) value assignment, table ESTVA
QTY Reference to exposure amounts, table CCIHT_ERQT
SAM Reference to safety measures, table CCIHT_ACH
MP Reference to measurement project, table CCIHT_MP
MJ Reference to measurement, table CCIHT_MJ
SFTY_MEAS Safety Measure Key CCIHE_ACID CHAR 12 0
SMEAS_CATEGORY Safety Measure Category CCIHE_ACCAT CCIHC_AC07 CHAR 3 0
SMEAS_TYPE Safety Measure Type CCIHE_ACTYPE CCIHC_AC01 CHAR 4 0
PRIORITY Priority of a Safety Measure CCIHE_ACPRIO CCIHC_AC03 CHAR 3 0
STATUS Object status J_STATUS CHAR 5 0
INITIAL_STATUS Initial Status of an Object CCIHE_INITSTATUS CHAR 5 0
PROTECT_GOAL Protection Goal of a Safety Measure CCIHE_PROTECTGOAL CHAR 21 0
ORIGIN Origin of Safety Measure CCIHE_ACORIG CHAR 5 0
RA Risk assessment
OH Occupational health
IA Accident processing
OT Other
DESCRIPTION Description of Safety Measure CCIHE_ACDESCR CHAR 132 0
FLAG_LONG_TEXT Long Text ESELTXTFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PERS_RESP Person Responsible CCIHE_PERSRESP CHAR 10 0
PERS_GRP_REPONSIBLE Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
RESPONSIBLE_DESCRIPTION Description of responsibility CCIHE_RESPDESCR CHAR 30 0
PLANNED Planned Execution Date CCIHE_DATPLAN DATS 8 0
PLANNED_START_DATE Planned Start Date CCIHE_PSTDAT DATS 8 0
PLANNED_START_TIME Planned Start Time for Safety Measure CCIHE_PSTTIME TIMS 6 0
PLANNED_END_DATE Planned End Date CCIHE_PENDDAT DATS 8 0
PLANNED_END_TIME Planned End Time of Safety Measure CCIHE_PENDTIME TIMS 6 0
EXECUTION_DATE Execution Date CCIHE_DATPROC DATS 8 0
EXECUTION_TIME Execution Time CCIHE_TIMPROC TIMS 6 0
PROCESSOR Administrator for Safety Measure CCIHE_PROCPERS CHAR 10 0
PERS_GRP_PROCESSOR Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
CHECK_DATE Date of Check CCIHE_DATCONTR DATS 8 0
CHECK_TIME Time of Check CCIHE_TIMECONTR TIMS 6 0
CONTROLLER Person Responsible for Check CCIHE_RESPPCONTR CHAR 10 0
PERS_GRP_CONTROLLER Person Group CCIHE_PERSGRP CHAR 1 0
A Employee
B Applicant
C External person
EFFECTIVENESS Effectiveness of a Safety Measure CCIHE_ACEFF CCIHC_AC05 CHAR 3 0
REJECTED Safety Measure Rejected CCIHE_DECLINEFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PM_NOTIFICATION_NO Notification Number (Plant Management) CCIHE_NOTINUM CHAR 12 0
PM_TASK_NO Task Number (from Plant Maintenance or Elsewhere) CCIHE_ACTIONNUM NUMC 4 0
SMEAS_COSTS Safety Measure Costs CCIHE_ACCOSTS CURR 10 2
CURRENCY Currency Key for Costs CCIHE_ACCUKY TCURC CUKY 5 0
CURR_ISO ISO Currency Code CCIHE_CURR_ISO CHAR 3 0
REF_RECN_ROOT_CAUSE Sequential Number of Data Record ESERECN NUMC 20 0
TIME_ZONE Valid Time Zone CCIHE_TIMEZONE TTZZ CHAR 6 0
PM_NOTIFICATION_PLANT Notification Plant CCIHE_NOTIPLANT CHAR 4 0

BAPI1240_ACH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPI1240_ACH CHANG_NO * AENR Change Master MANDT
BAPI1240_ACH CHANG_NO BAPI1240_ACH CHANG_NO AENR Change Master AENNR
BAPI1240_ACH CLIENT BAPI1240_ACH CLIENT T000 Clients MANDT
BAPI1240_ACH CURRENCY BAPI1240_ACH CURRENCY TCURC Currency Codes WAERS
BAPI1240_ACH CURRENCY * TCURC Currency Codes MANDT
BAPI1240_ACH DATAORIGIN * TCG56 EHS: Data Origin MANDT
BAPI1240_ACH DATAORIGIN BAPI1240_ACH DATAORIGIN TCG56 EHS: Data Origin SRSID
BAPI1240_ACH EFFECTIVENESS * CCIHC_AC05 EHS: Effectiveness of a Safety Measure MANDT
BAPI1240_ACH EFFECTIVENESS BAPI1240_ACH EFFECTIVENESS CCIHC_AC05 EHS: Effectiveness of a Safety Measure ACEFF
BAPI1240_ACH PRIORITY * CCIHC_AC03 EHS: Priorities for Safety Measures MANDT
BAPI1240_ACH PRIORITY BAPI1240_ACH PRIORITY CCIHC_AC03 EHS: Priorities for Safety Measures ACPRIO
BAPI1240_ACH SMEAS_CATEGORY * CCIHC_AC07 EHS: IHS Safety Measure Category MANDT
BAPI1240_ACH SMEAS_CATEGORY BAPI1240_ACH SMEAS_CATEGORY CCIHC_AC07 EHS: IHS Safety Measure Category ACCAT
BAPI1240_ACH SMEAS_TYPE BAPI1240_ACH SMEAS_TYPE CCIHC_AC01 EHS: Safety Measure Types ACTYPE
BAPI1240_ACH SMEAS_TYPE * CCIHC_AC01 EHS: Safety Measure Types MANDT
BAPI1240_ACH TIME_ZONE * TTZZ Time zones CLIENT
BAPI1240_ACH TIME_ZONE BAPI1240_ACH TIME_ZONE TTZZ Time zones TZONE