SAP ABAP Table BAPI_1119_MD (EHS: Hazardous Substance Basic Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-HSM (Application Component) Hazardous Substance Management
     ⤷ CBHS (Package) Hazardous Substance Management

Basic Data

Table Category	INTTAB	Structure
Structure	BAPI_1119_MD	Table Relationship Diagram
Short Description	EHS: Hazardous Substance Basic Data

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	FUNCTION	☐	MSGFN	MSGFN	CHAR	3	0	Function
2	PRIMARYKEY	☐	HSME_PKEY	SYSUUID_C	CHAR	32	0	Artificial Primary Key for Specification Tables in BAPIs
3	FOREIGNKEY	☐	HSME_FKEY	SYSUUID_C	CHAR	32	0	Artificial Foreign Key in Specification Tables for BAPIs
4	FLGPRIMKEY	☐	ESEFLGPKEY	ESDFLAG	CHAR	1	0	Data Record Created with Artificial Primary Key
5	FLGFRGNKEY	☐	ESEFLGFKEY	ESDFLAG	CHAR	1	0	New Parent Record Was Created
6	RECORD_NO	☐	HSME_GUID	SYSUUID_C	CHAR	32	0	Data Record ID (GUID)
7	CHNGSTATUS	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
8	VALID_FROM	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
9	VALID_TO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
10	CHANG_NO	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
11	DEL_IND	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
12	PARK_IND	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
13	CREATED_ON	☐	ESECRDAT	DATUM	DATS	8	0	Created On
14	CREATED_BY	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
15	CHANGD_ON	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
16	CHANGD_BY	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
17	DATAORIGIN	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
18	DATA_PROV	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
19	RECNO_ROOT	☐	HSME_GUID	SYSUUID_C	CHAR	32	0	Data Record ID (GUID)
20	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
21	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
22	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
23	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
24	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
25	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
26	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
27	STORAGE_KEY1	☐	HSME_STOKEY1	HSMD_STOKEY	CHAR	5	0	Hazard Rating 1	HSMV_STOKEY
28	STORAGE_KEY2	☐	HSME_STOKEY2	HSMD_STOKEY	CHAR	5	0	Hazard Rating 2	HSMV_STOKEY
29	WATER_POLL_CLASS_IND	☐	HSME_WPC	ESDBOOLE	CHAR	1	0	Water Pollution Class Is Legal Requirement
30	DANGER_NOTE	☐	HSME_STWA	CHAR30	CHAR	30	0	Hazardous Substance Warning
31	AGGREGATE_STATE	☐	HSME_STMA	CHAR30	CHAR	30	0	State of Matter
32	DANGER_CLASS_VBF	☐	HSME_VBF	CHAR30	CHAR	30	0	Combustible Liquids (VbF) Hazard Class
33	KEY_NAME_HAZ_MATERIAL	☐	HSME_NAME	CHAR30	CHAR	30	0	Hazardous Substance Key
34	COMMENT_HAZ_MATERIAL	☐	HSME_DESC	CHAR30	CHAR	30	0	Comment on Hazardous Substance

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI_1119_MD	CHANG_NO	AENR	AENNR	REF	1	CN
2	BAPI_1119_MD	COUNTRY	T005	LAND1	KEY	1	CN
3	BAPI_1119_MD	DATAORIGIN	TCG56	SRSID	REF	1	CN
4	BAPI_1119_MD	REGION	T005S	BLAND
5	BAPI_1119_MD	STORAGE_KEY1	HSMV_STOKEY	STOKEY	KEY	1	CN
6	BAPI_1119_MD	STORAGE_KEY2	HSMV_STOKEY	STOKEY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600