CCIHS_BW_IAL_MD SAP (EHS: BW: Master Data for Incident/Accident Log) Structure details
Description: EHS: BW: Master Data for Incident/Accident Log
Related tables to CCIHS_BW_IAL_MD
Access table CCIHS_BW_IAL_MD
Structure field list including key, data, relationships and ABAP select examples
CCIHS_BW_IAL_MD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "EHS: BW: Master Data for Incident/Accident Log" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CCIHS_BW_IAL_MD TYPE CCIHS_BW_IAL_MD.
The CCIHS_BW_IAL_MD table consists of various fields, each holding specific information or linking keys about EHS: BW: Master Data for Incident/Accident Log data available in SAP. These include MARKFLG (Row Is Selected), SELEFLG (Step Loop Line Selected), LINENO (General Auxiliary Counter), LINEMOD (Processing status or mode of a record/step loop line).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CCIHS_BW_IAL_MD structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MARKFLG | Row Is Selected | ESEMARKFLG | CHAR | 1 | ESDFLAG | ||||
SELEFLG | Step Loop Line Selected | ESESELEFLG | CHAR | 1 | ESDFLAG | ||||
LINENO | General Auxiliary Counter | ESECOUNTER | NUMC | 10 | NUMC10 | ||||
LINEMOD | Processing status or mode of a record/step loop line | ESELINEMOD | CHAR | 1 | CHAR1 | ||||
CHCOFLG | Indicator: Change number collision | ESECHCOFLG | CHAR | 1 | ESDFLAG | ||||
LOCKMOD | Lock Mode (Shared, Exclusive) | ESELOCKMOD | CHAR | 1 | CHAR1 | ||||
INTRFLG | Flag for Internal Use | ESEINTRFLG | CHAR | 1 | ESDFLAG | ||||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RECN | Sequential Number of Data Record | ESERECN | NUMC | 20 | ALPHA | ESDRECN | |||
ACTN | Sequential Number of the Change State | ESEACTN | NUMC | 20 | ALPHA | ESDACTN | |||
VALFR | Valid-From Date | ESEVALFR | DATS | 8 | DATUM | ||||
VALTO | Valid-To Date | ESEVALTO | DATS | 8 | DATUM | ||||
AENNR | Change Number | ESEAENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
DELFLG | Deletion Indicator | ESEDELFLG | CHAR | 1 | ESDFLAG | ||||
PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | ESDFLAG | ||||
CRDAT | Created On | ESECRDAT | DATS | 8 | DATUM | ||||
CRNAM | Created By | ESECRNAM | CHAR | 12 | USNAM | ||||
UPDDAT | Changed On | ESEUPDDAT | DATS | 8 | DATUM | ||||
UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 12 | USNAM | ||||
SRSID | Source of Data | ESESRSID | CHAR | 10 | TCG56 | ESDSRSID | |||
OWNID | Data Provider | ESEVENDRID | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
RECNROOT | Sequential Number of Data Record | ESERECN | NUMC | 20 | ALPHA | ESDRECN | |||
IALID | Incident/Accident Log Entry | CCIHE_IALID | CHAR | 20 | CHRID | CCIHD_IAID | |||
IATYPE | Incident/Accident Log Entry Type | CCIHE_IATYPE | CHAR | 3 | CCIHC_IATYPE | CCIHD_IATYPE | |||
IAPLANT | Plant Assignment for the Log Entry | CCIHE_IAPLANT | CHAR | 4 | T001W | WERKS | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
IASTATUS | Status | EHSBE_STATUS | CHAR | 5 | J_STATUS | ||||
EVDESC | Event Description | CCIHE_EVDESCLXT | CHAR | 60 | TEXT60 | ||||
DMTYPE | Type of Damage | CCIHE_DMTYPE | CHAR | 21 | CCIHD_DMTYPE | ||||
TPLNR | Functional Location | CCIHE_FUNLOC | CHAR | 30 | Assigned to domain | CCIHD_FUNLOC | IFL | IFLM | |
EQUNR | Equipment Number | CCIHE_EQUNR | CHAR | 18 | Assigned to domain | CHAR18 | EQN | EQUI | |
EQDESC | Description of Machine | CCIHE_EQDESC | CHAR | 80 | TEXT80 | ||||
FATALFLG | Fatality | CCIHE_FATALFLG | CHAR | 1 | ESDFLAG | ||||
CNTRFLG | Contractor Affected | CCIHE_CNTRFLG | CHAR | 1 | ESDFLAG | ||||
INVRESULT | Investigation Result | CCIHE_INVRESULT | CHAR | 60 | TEXT60 | ||||
INVRESULTFLG | Indicator for SAPscript Text | CCIHE_INVRESULTFLG | CHAR | 1 | FLAG | ||||
PMFLG | Maintenance Required | CCIHE_PMFLG | CHAR | 1 | ESDFLAG | ||||
PRODLFLG | Production Time Lost | CCIHE_PRODLFLG | CHAR | 1 | ESDFLAG | ||||
MTNLANGU | Language of Entry | CCIHE_MTNLANGU | LANG | 1 | T002 | ISOLA | SPRAS | ||
EVDAT | Event Date | CCIHE_EVDAT | DATS | 8 | DATUM | ||||
EVTIME | Event Time | CCIHE_EVTIME | TIMS | 6 | TIME | ||||
RECNTWAH | Reference to Work Area | CCIHE_RECNTWAH | NUMC | 20 | ALPHA | ESDRECN | |||
ACLOC | Accident Location | CCIHE_ACLOC | CHAR | 10 | CCIHD_ACLOC | ||||
ACLOCDESC | Description of Accident Location | CCIHE_ACLOCDESC | CHAR | 60 | TEXT60 | ||||
EVTIMEZONE | Valid Time Zone | CCIHE_TIMEZONE | CHAR | 6 | TTZZ | TZNZONE | CCIH_TZONE | ||
IAREPHDFLG | Reportable Event | CCIHE_IAREPHDFLG | CHAR | 1 | ESDFLAG | ||||
FLPLANT | Functional Location Plant | CCIHE_FLPLANT | CHAR | 4 | T001W | WERKS | |||
IALDEADFLG | Fatality | CCIHE_FATALFLG | CHAR | 1 | ESDFLAG | ||||
IATYPETXT | Description of Log Entry Type | CCIHE_IATYPETXT | CHAR | 40 | TEXT40 | ||||
IAPLANTXT | Description of Plant for Incident/Accident Log Entry | CCIHE_IAPLANTTXT | CHAR | 30 | TEXT30 | ||||
DMTYPETXT | Description of Damage Type | CCIHE_DMTYPETXT | CHAR | 132 | TEXT132 | ||||
PLTXT | Description of functional location | PLTXT | CHAR | 40 | TEXT40 | ||||
EQTXT | Description of technical object | KTX01 | CHAR | 40 | TEXT40 | ||||
WAID | Work Area or Pattern | CCIHE_WAID | CHAR | 20 | CHRID | CCIHD_WAID | |||
WANAM | Language-Dependent Description of Work Area/Pattern | CCIHE_WANAM | CHAR | 60 | TEXT60 | ||||
ACLOCTXT | Description of Accident Location | CCIHE_ACLOCTXT | CHAR | 40 | TEXT40 | ||||
ACFLG | Safety Measures Exist | CCIHE_ACFLG | CHAR | 1 | ESDFLAG | ||||
WTLFLG | Witness List Entry Available | CCIHE_WTLFLG | CHAR | 1 | ESDFLAG | ||||
PMOFLG | Maintenance Orders Exist | CCIHE_PMOFLG | CHAR | 1 | ESDFLAG | ||||
COFLG | Costs Exist | CCIHE_COFLG | CHAR | 1 | ESDFLAG | ||||
QUESFLG | Questionnaire Exists | CCIHE_QUESFLG | CHAR | 1 | ESDFLAG | ||||
IASHSTATNAM | Incident/Accident Log Entry Status | CCIHE_IASHSTATNAM | CHAR | 4 | TEXT4 | ||||
IASTATNAM | Object status | J_TXT30 | CHAR | 30 | TEXT30 | ||||
KEYDRAWNFLG | Key Assigned Automatically | CCIHE_KEYDRAWN | CHAR | 1 | ESDFLAG | ||||
TMODNEWFLG | Transport Mode Injury/Illness Log to Incident/Accident Log | CCIHE_TRANSMOD | CHAR | 1 | ESDFLAG | ||||
TMODEXSFLG | Transport Mode Injury/Illness Log to Incident/Accident Log | CCIHE_TRANSMOD | CHAR | 1 | ESDFLAG | ||||
MTNLANGUTXT | Name of Language | SPTXT | CHAR | 16 | SPTXT16 | DSB | |||
SRV_NUMBER | Number of Medical Service | EHS00_SRVNUMBER | NUMC | 12 | NUMC12 | EHS00SERVNO | |||
FLPLANTTXT | Name of Functional Location Plant | CCIHE_FLPLANTTXT | CHAR | 30 | TEXT30 | ||||
STRNO | Functional Location Label | CCIHE_STRNO | CHAR | 40 | CHAR40 |
Key field | Non-key field |
How do I retrieve data from SAP structure CCIHS_BW_IAL_MD using ABAP code?
As CCIHS_BW_IAL_MD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CCIHS_BW_IAL_MD as there is no data to select.How to access SAP table CCIHS_BW_IAL_MD
Within an ECC or HANA version of SAP you can also view further information about CCIHS_BW_IAL_MD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects