SAP ABAP Table VHSMT_MD (Change Document Structure; Generated by RSSCD000)

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	VHSMT_MD	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

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	.INCLUDE	☐				0	0	EHS: Hazardous Substance Basic Data
2	.INCLUDE	☐				0	0	EHS: Structure for Standard Key Fields in Master Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	RECN	☐	BASE_RECNGUID	SYSUUID	RAW	16	0	Data Record ID (GUID)
5	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
6	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
7	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
8	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
9	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
10	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
11	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
12	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
13	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
14	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
15	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
16	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
17	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
18	RECNROOT	☐	BASE_RECNGUID	SYSUUID	RAW	16	0	Data Record ID (GUID)
19	.INCLUDE	☐				0	0	EHS: Logical Key for Hazardous Substance
20	MATNR	☐	BASE_MATID	BASD_MATID	CHAR	40	0	Material or Product (Internal Key)
21	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
22	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
23	.INCLUDE	☐				0	0	EHS: Data Structure for Hazardous Substance Basic Data
24	.INCLUDE	☐				0	0	EHS: Data Structure for Hazard Ratings 1 ... n
25	STOKEY1	☐	HSME_STOKEY1	HSMD_STOKEY	CHAR	5	0	Hazard Rating 1	HSMV_STOKEY
26	STOKEY2	☐	HSME_STOKEY2	HSMD_STOKEY	CHAR	5	0	Hazard Rating 2	HSMV_STOKEY
27	WPC	☐	HSME_WPC	ESDBOOLE	CHAR	1	0	Water Pollution Class Is Legal Requirement
28	STWA	☐	HSME_STWA	CHAR30	CHAR	30	0	Hazardous Substance Warning
29	STMA	☐	HSME_STMA	CHAR30	CHAR	30	0	State of Matter
30	VBF	☐	HSME_VBF	CHAR30	CHAR	30	0	Combustible Liquids (VbF) Hazard Class
31	NAME	☐	HSME_NAME	CHAR30	CHAR	30	0	Hazardous Substance Key
32	DESCR	☐	HSME_DESC	CHAR30	CHAR	30	0	Comment on Hazardous Substance
33	.INCLUDE	☐				0	0	Structures for generating change document update programs
34	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VHSMT_MD	AENNR	AENR	AENNR	REF	1	CN
2	VHSMT_MD	COUNTRY	T005	LAND1	KEY	1	CN
3	VHSMT_MD	MANDT	T000	MANDT	KEY	1	CN
4	VHSMT_MD	REGION	T005S	BLAND	KEY	1	CN
5	VHSMT_MD	SRSID	TCG56	SRSID	REF	1	CN
6	VHSMT_MD	STOKEY1	HSMV_STOKEY	STOKEY	KEY	1	CN
7	VHSMT_MD	STOKEY2	HSMV_STOKEY	STOKEY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in