SAP HSMS_MD table - Hazardous Substance Basic Data (MARA-MATNR) details in SAP

SAP HSMS_MD table summary

Object Name: HSMS_MD
Dictionary Type: Structure
Description: Hazardous Substance Basic Data (MARA-MATNR)

Field list for HSMS_MD table on an S/4 SAP system

Details

HSMS_MD-MANDT table field - Client ▼

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

HSMS_MD-RECN table field - Data Record ID (GUID) ▼

Description: Data Record ID (GUID)
Field Name: RECN
Data Element: BASE_RECNGUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECN

HSMS_MD-ACTN table field - Sequential Number of the Change State ▼

Description: Sequential Number of the Change State
Field Name: ACTN
Data Element: ESEACTN
Data Type: NUMC
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: ESDACTN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ACTN

HSMS_MD-VALFR table field - Valid-From Date ▼

Description: Valid-From Date
Field Name: VALFR
Data Element: ESEVALFR
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALFR

HSMS_MD-VALTO table field - Valid-To Date ▼

Description: Valid-To Date
Field Name: VALTO
Data Element: ESEVALTO
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALTO

HSMS_MD-AENNR table field - Change Number ▼

Description: Change Number
Field Name: AENNR
Data Element: ESEAENNR
Data Type: CHAR
length (Dec): 12(0)
Check table: AENR
Conversion Routine: ALPHA
Domain Name: AENNR
MemoryID: AEN
AppClass: CS
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field AENNR

HSMS_MD-DELFLG table field - Deletion Indicator ▼

Description: Deletion Indicator
Field Name: DELFLG
Data Element: ESEDELFLG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ESDFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELFLG

HSMS_MD-PARKFLG table field - Data Record Is Inactive ▼

Description: Data Record Is Inactive
Field Name: PARKFLG
Data Element: ESEPARKFLG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ESDFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARKFLG

HSMS_MD-CRDAT table field - Created On ▼

Description: Created On
Field Name: CRDAT
Data Element: ESECRDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CRDAT

HSMS_MD-CRNAM table field - Created By ▼

Description: Created By
Field Name: CRNAM
Data Element: ESECRNAM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: USNAM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CRNAM

HSMS_MD-UPDDAT table field - Last Changed On ▼

Description: Last Changed On
Field Name: UPDDAT
Data Element: ESEUPDDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPDDAT

HSMS_MD-UPDNAM table field - Last Changed By ▼

Description: Last Changed By
Field Name: UPDNAM
Data Element: ESEUPDNAM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: USNAM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field UPDNAM

HSMS_MD-SRSID table field - Source of Data ▼

Description: Source of Data
Field Name: SRSID
Data Element: ESESRSID
Data Type: CHAR
length (Dec): 10(0)
Check table: TCG56
Conversion Routine:
Domain Name: ESDSRSID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SRSID

HSMS_MD-OWNID table field - Data Provider ▼

Description: Data Provider
Field Name: OWNID
Data Element: ESEVENDRID
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field OWNID

HSMS_MD-RECNROOT table field - Data Record ID (GUID) ▼

Description: Data Record ID (GUID)
Field Name: RECNROOT
Data Element: BASE_RECNGUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECNROOT

HSMS_MD-MATNR table field - Material Number ▼

Description: Material Number
Field Name: MATNR
Data Element: MATNR
Data Type: CHAR
length (Dec): 40(0)
Check table: MARA
Conversion Routine: MATN1
Domain Name: MATNR
MemoryID: MAT
AppClass: MG
SHLP: S_MAT1
SHLP Field: MATNR
ConvExit: MATN1

See all SAP tables containing field MATNR

HSMS_MD-COUNTRY table field - Country/Region Key ▼

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

HSMS_MD-REGION table field - Region (State, Province, County) ▼

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

HSMS_MD-STOKEY1 table field - Hazard Rating 1 ▼

Description: Hazard Rating 1
Field Name: STOKEY1
Data Element: HSME_STOKEY1
Data Type: CHAR
length (Dec): 5(0)
Check table: HSMC_013
Conversion Routine:
Domain Name: HSMD_STOKEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STOKEY1

HSMS_MD-STOKEY2 table field - Hazard Rating 2 ▼

Description: Hazard Rating 2
Field Name: STOKEY2
Data Element: HSME_STOKEY2
Data Type: CHAR
length (Dec): 5(0)
Check table: HSMC_013
Conversion Routine:
Domain Name: HSMD_STOKEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STOKEY2

HSMS_MD-WPC table field - Water Pollution Class Is Legal Requirement ▼

Description: Water Pollution Class Is Legal Requirement
Field Name: WPC
Data Element: HSME_WPC
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ESDBOOLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WPC

HSMS_MD-STWA table field - Hazardous Substance Warning ▼

Description: Hazardous Substance Warning
Field Name: STWA
Data Element: HSME_STWA
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STWA

HSMS_MD-STMA table field - State of Matter ▼

Description: State of Matter
Field Name: STMA
Data Element: HSME_STMA
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMA

HSMS_MD-VBF table field - Combustible Liquids (VbF) Hazard Class ▼

Description: Combustible Liquids (VbF) Hazard Class
Field Name: VBF
Data Element: HSME_VBF
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VBF

HSMS_MD-NAME table field - Hazardous Substance Key ▼

Description: Hazardous Substance Key
Field Name: NAME
Data Element: HSME_NAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

HSMS_MD-DESCR table field - Comment on Hazardous Substance ▼

Description: Comment on Hazardous Substance
Field Name: DESCR
Data Element: HSME_DESC
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESCR

View list of all SAP tables(S4H/ECC)

Select data from SAP table