SAP ABAP View HSMV_STOKEY (EHS: Hazard Rating for Country/Region)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-EHS (Application Component) Environment, Health and Safety: Master Data
     ⤷ CBEHS_HSM (Package) Hazardous Substance Master Data

Basic Data

View Type	D	Database View
Database View	HSMV_STOKEY
Short Description	EHS: Hazard Rating for Country/Region
Root table	HSMC_015	EHS: Assignment Storage Hazard Type to Country/Region

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HSMC_015	HSMC_015
2	HSMC_011
3	HSMC_013

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HSMC_011	MANDT	JL	EQ				0	0
2	HSMC_015	MANDT	JR	EQ			AND	0	0
3	HSMC_011	STOCAT	JL	EQ				0	0
4	HSMC_015	STOCAT	JR	EQ			AND	0	0
5	HSMC_011	MANDT	JL	EQ				0	0
6	HSMC_013	MANDT	JR	EQ			AND	0	0
7	HSMC_011	STOCAT	JL	EQ				0	0
8	HSMC_013	STOCAT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HSMC_015	MANDT		☐	MANDT	☐	Client
2	COUNTRY	HSMC_015	COUNTRY		☐	LAND1	☐	Country Key
3	REGION	HSMC_015	REGION		☐	REGIO	☐	Region (State, Province, County)
4	STOCATNUM	HSMC_015	STOCATNUM		☐	HSME_STOCATNUM	☐	Storage Hazard Number
5	STOCAT	HSMC_011	STOCAT		☐	HSME_STOCAT	☐	Storage Hazard Type
6	STOKEY	HSMC_013	STOKEY		☐	HSME_STOKEY	☐	Hazard Rating

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in	700