Skip to Content

Introduction

Because of thread : Property Tree Value Assignment may be it is time to discuss the EHS standard data model. Please check as well this very good document: Important compositions in EH&S and how they are used

Check as well: SAP EHS DISCUSSIONS !!!!: SAP EH&S Data Model – Use of Compositions

You will find many other threads asking question: what is a “PURE_SUB”/”LIST_SUB” etc. Please just use search options in SCN to find such threads. You will find helpful information of many kind. At the end of this document some references are collected discussing SAP EHS standard model (topics of many kind).

The standard data model of SAP EHS classic is described here: https://help.sap.com/saap/sap_bp/EHS_ERP605_Global/Documentation/EHSM_DATA_MODEL_605_EN.ppt

History/State of the Art

Based on the input of many chemical companies the SAP EHS standard data model was developped and will be improved in the future if there are e.g. legal needs to do so. E.g. one need in the last years was the REACh and the GHS regulations etc.

The SAP standard delivers the “STANDARD” property tree and the “OBSOLETE” property tree. These are the core once to discuss in this document.

On the top SAP delivers a number of identifiers etc. and other customizing stuff which can be used to start an EHS project. On the top SAP delivers as well “Content” (other companies do the same). This content include e.g.:

  • Phrases

  • Layouts to generate SDS/MSDS

  • Rulesets (e.g. to support data generation for supporting the SDS/MSDS process)

  • and other stuff (like regulatory content)

Therefore: any of these “content” pieces can be used only if the SAP EHS Standard Data model is used. If you deviate from that you will get problem in using these “on top” options.

Property Tree STANDARD

This tree combines the “Best practise” value assignment types/properties which are needed to support many of the subsequent EHS processes (e.g. SDS/MSDS/Label generation, DG topics, etc. etc.). This tree is represents the “full” scope of the SAP EHS standard data model regarding value assignment types/properties. It is very common to prepare special property trees which support the user better to maintain data related to SDS/MSDS etc.

Property Tree Obsolete

This tree combines “old properties” which are now “obsolete”. Mainly either because regulations has changed or because of the fact that the use of the properties is limited etc.

Rating/Validity Areas

As well SAP delivers standard validity areas and ratings.

Identifiers

Same is true in context of identifiers (e.g. NUM, CAS and other stuff)

Other customizing

On the top SAP delivers standard set up for component type, specification types etc. etc.

Conclusion:

You should not delete SAP default customizing. If you are looking for to use SAP content you should not change the standard data model.

Options to extend EHS

You can add on top new “objects” with out any risk using customizing options which are used in SAP EHS-BD.

Examples are:

  • substance authorization groups

  • substance nature

  • specification category/type (new categories should only be added if you have understood the EHS data model !)

  • Rating

  • Validity area

  • Component type

  • Property tree

  • New value assignment types/classes
  • etc.

Substance authorization group

The substance authorization group can be used mainly to “group” specifications. The set up is done mainly in such a way that authorization rights can be administered easily. E.g. if your company is organized by “branches” you can simply use terms as: “Food”, “Feed”, “Pharma”, “Waste” etc.  Any specification belong to one branch can be created in the corresponding substance authorization group. The used terminology should follow to a creation extent the organisation of the company acting; you are completely free to here for set up.

Any specification must be set up in one authorization group.

Substance nature

The substance nature can describe on first glance the “chemistry” involved; it is used mainly as a search criteria but can be used different. Terms as: WASTE, SUB_POLY, SUB_NOPOLY etc. are quite common.

Specification header remark/note

You can maintain on specification level if needed one remark/note.  You can not maintain the information with a “language”. This information can be used as well in inquiries in the system.

Identifiers

By SAP default: we have “Names” (NAM), “Numbers” (NUM) and “Formulars” (FRM) which can be used to describe the chemistry. The identifier can

  • be longer than 132 characters
  • can be language dependent (or not)
  • can get a “check function ” assigned (e.g. mostly used for numbers)
  • can have no, one or more of one usages assigned
  • can have no, one or more of one regulatory lists assigned
  • one can maintain more than one identifer (e.g. you can have many “NAM, SYN”)

Identifiers are one of the core data elements in EHS and are used at many locations in the system (e.g. via identification listings) and are used very often in context of  WWI development. They are used quite often for inquiries in the system.

Restriction

The restriction can be used to “enhance” the access concept in one authorization group. This functionality is used very rarely.

Status

You can use the Status  sure that one “data collection” is checked and released by a responsible person. You can implemenent lot of check. By default a status net is delivered by SAP. The functionality is not used often; but it is used more often than “Restrictions”.

Reference

As EHS started only “Reference” was supported. By using “Reference” you can easily inherit data from one specification to another. It is very useful option to support the users in maintenance actions.

Inheritance

With higher EHS versions “Inheritance” was shipped and can be used. The functionality of “Inheritance” is broader than “reference” but the idea is the same. You maintain one data element and reuse this information very often. Using Inheritance you can inherit identifier information as well; this is not possible with “Reference”. You can inherit the data very “flexible” by using “groups of properties” etc.  But you need more experience in using this and you must understand nearly perfect the idea of the “inheritance template” topic.

Material Assignment

With the material assignment you link EHS world to the Material world. Therefore this information is a critical one. With this link all the subsequent processes in EHS are “enabled” (e.g. DG, SVT, GLM, Report distribution etc. You can assign materials in EHS but you can use MM to assign specifications as well. You can use e.g. as well BOMBOS interface to link EHS to logistic processes.

Value Assignment Types/Properties

Component type

In properties of type “Composition” you need the “component type” for data maintenance. Even considering that under some conditions you need not to maintain this information, this information can be a “key” part in your maintenance. E.g. for “Trade Secret” topic you can define one or more component types which canbe used to suport the “Trade Secret” topic.


Exeption value

The “Exception value” is part of the composition. It is used rarely but can indicate additional information on a component.


UOM

The “UOM” is part as well of the “composition”. Here we have two pieces. One describing the “principle” part (is e.g. composition of type “weight” or not) and the “core” part. In most cases value as “%”, “%0” are used to describe the concentration of the component in the composition

Specification listing

Here you “only” list a number of components. This option makes sense e.g. if you would like to define: chemistry which should not get in touch with the “whole” product; or you canlist components which are generated if the product is burning etc.

Source


By assigning a “Source” you can make clear, which source you have used to derive the data (e.g. Literature and if so which..)


Assessment

Assessment is a “mandatory” field; but in real life does not have practical value (in most cases). E.g. you can “assess” that the data is “valid”, “proofed” etc.


User defined text

This option is used quite often in daily maintenance. By defining “text types” you can add additional information which are “such specific” that you can not (or will not) generate a phrase. On top: with higher SAP releases you can use this option to linkto a DMS etc. document; e.g. you could link to a “test document” in which the real test results are shown (e.g. density, flashpoint etc.).


Usage

The defintion of the “Usage” is one of the core tasks in EHS classic data management. You can steer with Usage:

  • Access topics
  • and print out in WWI reports
  • and DG management
  • and SVT
  • and….

Usage is a combination of “Rating” and “Validity area”. To a validity area one or more countries can be assigned. This is crucail in most case for WWI reports.

Class/Characteristic based data

Most of the “value assignment types” (may be 70%) are set up in such a way that there is a SAP EHS class assigned with one or more characteristics. These properties and their use belongs to the “core” pieces in EHS. You can have characteristics which are “phrase” based, does have a “regulatory list” assignment, are of type “Numeric” with or without UOM assignment.

Discussions about EH&S Data model/Other soures of information

Small list of threads (mainly EHS data model oriented) of many kind

Please use search option in SCN to look for similar topics

Link Description
Change in SAP EHS Data model from using Specification of REAL_SUB as compositions to other REAL_SUB type specification to a New Specification of LIST_SUB type Change of data model in living system
⚡Presentation "EH&S Data Model SAP Best Practices for Chemicals SAP Best Practices." Link to SAP EHS standard slides (EHS Standard model)
SAP EHS DISCUSSIONS !!!!: SAP EH&S Data Model – Use of Compositions Discusission about composition
https://help.sap.com/saap/sap_bp/EHhttp://help.sap.com/bp_chem603/Chem_global/Documentation/EH&S Data Model_EN.pptS_ERP605_Global/Documentation/EHSM_DATA_MODEL_605_EN.ppt Link to Best Practise (please check for most current version)
http://help.sap.com/bp_chem603/Chem_global/Documentation/EH&S Data Model_EN.ppt Link to Best Practise (please check for most current version)
Data Model for MSDS Authoring with SERC About data model (SERC)
The use of Listed substance About use of listed substances
Re: types of substances in ehs Specification types in EHS
Re: Substance nature in Specification Header Substance nature
EHS Substance – creation of new reference specification
Diefference between various specification types
INCI codes and CAS-numbers in EH&S About compositions
Substance from DG Handling for SVT
Identification Types in Specifications…..
A question over the link between materials and substances
value assignments under danger goods regulations
Update EHS Regulatory Content
SAP EHS Related regulatory data
Question on DG_CL_Sub
Store original class after successful bonfire test? (Dangerous Goods)
Calculate standard composition via EH&S Expert
GLM – material specification assignment
input help: missing specification type
EHS_What Specification Type to Choose When Creating a Document Template
2 questions about COMPOSITON (value assignment)
IATA Config
SAP EHS Related regulatory data
chemical kits: DGM data for one material number containing several items with different UN #s
Standard SAP solution for dealing with 2-compound glues and kits
Solid composition in a property treee
Component type in property tree
property tree in specifications – add new node on the fly ?
How to change the node description in property Tree
Authorization restriction in Property Tree
Error in Property Tree
Waste Code is not able to Assign in Real Substance Property Tree
authorisation object for property tree in CG02
Mapping regulatory data for food contact in property tree
Reference Value – property tree
Problem with Property Tree Value Assignments – Recipe Management

http://scn.sap.com/thread/1936694

Import Standard Property Tree
how shall i add new tab in cgab transaction under property tree.
EHS Agent Property value assignment
table based value assignment
value assignment and value assignment type in the specification workbench
EHS and Enhancement package 3 and
Move Class & Chracteristics from Dev to Prod
Properties Values are passed when not included in Inheritance Template
Mapping of properties to Characteristic Fields
What is propertytree with name “workflow” used for
The specified item was not found.
value assignment category B & D
Phrase set is not getting assigned to newly created characteristics.
Piece list  transport for SAP standard class.
EHS – Phrase set to Characteristic Assignment
Save  NFPA (National Fire Protection Association) Diamond Data in SAP
Not able to enter values in CG02 for the new chracteristics
Moving(transporting) Class/Char/phrase from Dev to Quality
Identification Listing
Status tab in specification
The specified item was not found.
REA_SUB_E
Data Type change of Characteristics
CG02 Characteristic is not Displayed for Entry
Set Up Table Based Value Assignment
Recommand std EHS substance structure, properties, characteristic ?
Missing characteristics in new eSDS properties
Does anybody know how to get the Allergens Tab Page in EHS?
EHS: REACH Compliance: Value assignment type was not yet generated
specification workbench screen got two sections
EHS – value assignment types
CGAB changes in phrase set assignment are not reflecting in charateristics
real_sub_e for supplier data
Set up Table based Value Assignments
Question on Packaged Product
Regulatory Affairs Application
How to make a characteristic invalid / or delimit in a class in SAP EHS
spec import_inheritance data
EHS_Specification
Validity area specific output
Dangerous Goods – where to store Water Capacity W/C?
Specification status
How to manage the regulatory data import into specification database?
No values in assignment tab
Missing data when exporting specification (LS_UN_SUB)
Making Changes to Specifications
Component type Designed / Purchased in Compliance workbench
Change Number Issue in CG02
Is the specification type PURE_SUB not delivered as a standard?
I/E default in specification type (SAP EHS)
Specification type authorizations
Why use specification type MAT_PART or  BULK – is UOM the criteria?
input help: missing specification type
value assignment and value assignment type in the specification workbench
What is a substance and Specification……
Create a new specification category ?
Specification management in EHS
EHS_Specification
EHS Substance – creation of new reference specification
Specification Copy Template
Characteristic of the type CHAR30 not appearing in CGAB

OSS Notes

Attached is a short list of OSS notes with relevance to “STANDARD” property tree/and or topics wiht SAP classes/characteristics. Section will be extended if needed

  • 1375848

  • 874508

  • 774006

  • 955194

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply