- Home
- Resources
- SAP Tables
- HSMS_MD - EHS: Hazardous Substance Basic Data (MARA-MATNR)
SAP Table HSMS_MD
EHS: Hazardous Substance Basic Data (MARA-MATNR)
HSMS_MD (EHS: Hazardous Substance Basic Data (MARA-MATNR)) 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 HSMS_MD to other SAP tables.
Source: HSMS_MD (EHS: Hazardous Substance Basic Data (MARA-MATNR))
HSMS_MD table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| RECN |
Data Record ID (GUID) |
BASE_RECNGUID |
|
RAW |
|
16 |
0 |
|
| ACTN |
Sequential Number of the Change State |
ESEACTN |
|
NUMC |
|
20 |
0 |
|
| VALFR |
Valid-From Date |
ESEVALFR |
|
DATS |
|
8 |
0 |
|
| VALTO |
Valid-To Date |
ESEVALTO |
|
DATS |
|
8 |
0 |
|
| AENNR |
Change Number |
ESEAENNR |
AENR
|
CHAR |
|
12 |
0 |
|
| DELFLG |
Deletion Indicator |
ESEDELFLG |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Indicator Is Active |
| NULL |
Indicator Is Inactive |
|
| PARKFLG |
Data Record Is Inactive |
ESEPARKFLG |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Indicator Is Active |
| NULL |
Indicator Is Inactive |
|
| CRDAT |
Created On |
ESECRDAT |
|
DATS |
|
8 |
0 |
|
| CRNAM |
Created By |
ESECRNAM |
|
CHAR |
|
12 |
0 |
|
| UPDDAT |
Changed On |
ESEUPDDAT |
|
DATS |
|
8 |
0 |
|
| UPDNAM |
Last Changed By |
ESEUPDNAM |
|
CHAR |
|
12 |
0 |
|
| SRSID |
Source of Data |
ESESRSID |
TCG56
|
CHAR |
|
10 |
0 |
|
| OWNID |
Data Provider |
ESEVENDRID |
|
CHAR |
|
10 |
0 |
|
| RECNROOT |
Data Record ID (GUID) |
BASE_RECNGUID |
|
RAW |
|
16 |
0 |
|
| MATNR |
Material Number |
MATNR |
MARA
|
CHAR |
|
18 |
0 |
|
| COUNTRY |
Country Key |
LAND1 |
T005
|
CHAR |
|
3 |
0 |
|
| REGION |
Region (State, Province, County) |
REGIO |
T005S
|
CHAR |
|
3 |
0 |
|
| STOKEY1 |
Hazard Rating 1 |
HSME_STOKEY1 |
HSMC_013
|
CHAR |
|
5 |
0 |
|
| STOKEY2 |
Hazard Rating 2 |
HSME_STOKEY2 |
HSMC_013
|
CHAR |
|
5 |
0 |
|
| WPC |
Water Pollution Class Is Legal Requirement |
HSME_WPC |
|
CHAR |
|
1 |
0 |
Possible values
|
| STWA |
Hazardous Substance Warning |
HSME_STWA |
|
CHAR |
|
30 |
0 |
|
| STMA |
State of Matter |
HSME_STMA |
|
CHAR |
|
30 |
0 |
|
| VBF |
Combustible Liquids (VbF) Hazard Class |
HSME_VBF |
|
CHAR |
|
30 |
0 |
|
| NAME |
Hazardous Substance Key |
HSME_NAME |
|
CHAR |
|
30 |
0 |
|
| DESCR |
Comment on Hazardous Substance |
HSME_DESC |
|
CHAR |
|
30 |
0 |
|
HSMS_MD foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| HSMS_MD |
AENNR |
SYST |
MANDT |
AENR |
Change Master |
MANDT |
| HSMS_MD |
AENNR |
HSMS_MD |
AENNR |
AENR |
Change Master |
AENNR |
| HSMS_MD |
COUNTRY |
HSMS_MD |
COUNTRY |
T005 |
Countries |
LAND1 |
| HSMS_MD |
COUNTRY |
SYST |
MANDT |
T005 |
Countries |
MANDT |
| HSMS_MD |
MANDT |
HSMS_MD |
MANDT |
T000 |
Clients |
MANDT |
| HSMS_MD |
MATNR |
HSMS_MD |
MATNR |
MARA |
General Material Data |
MATNR |
| HSMS_MD |
MATNR |
SYST |
MANDT |
MARA |
General Material Data |
MANDT |
| HSMS_MD |
REGION |
SYST |
MANDT |
T005S |
Taxes: Region (Province) Key |
MANDT |
| HSMS_MD |
REGION |
HSMS_MD |
COUNTRY |
T005S |
Taxes: Region (Province) Key |
LAND1 |
| HSMS_MD |
REGION |
HSMS_MD |
REGION |
T005S |
Taxes: Region (Province) Key |
BLAND |
| HSMS_MD |
SRSID |
HSMS_MD |
SRSID |
TCG56 |
EHS: Data Origin |
SRSID |
| HSMS_MD |
SRSID |
SYST |
MANDT |
TCG56 |
EHS: Data Origin |
MANDT |
| HSMS_MD |
STOKEY1 |
HSMS_MD |
STOKEY1 |
HSMC_013 |
EHS: Hazard Rating |
STOKEY |
| HSMS_MD |
STOKEY1 |
* |
|
HSMC_013 |
EHS: Hazard Rating |
STOCAT |
| HSMS_MD |
STOKEY1 |
SYST |
MANDT |
HSMC_013 |
EHS: Hazard Rating |
MANDT |
| HSMS_MD |
STOKEY2 |
HSMS_MD |
STOKEY2 |
HSMC_013 |
EHS: Hazard Rating |
STOKEY |
| HSMS_MD |
STOKEY2 |
* |
|
HSMC_013 |
EHS: Hazard Rating |
STOCAT |
| HSMS_MD |
STOKEY2 |
SYST |
MANDT |
HSMC_013 |
EHS: Hazard Rating |
MANDT |
