Introduction Part 1

christoph_bergemann · ‎2014 Nov 13

Introduction Part 1

EHS classic is quite flexible. You can extend it easily. Some options are mentioned in: Customer Exits in SAP EHS MANAGEMENT

One option to enhance EHS is using Rule Sets or Secondary Data Determination. By using these options you can speed up the data management.

Using these options you can support maintenance actions: refer to: How to deal with legal/regulatory changes (using SAP EHS MANAGEMENT)?

As you can see in EHS Expert WWI Installation SAP R/3 Enterprise - Toolbox for IT Groups the installation topics might be not understood very well.

Intentio of this blog is to "reference" discussions in context of

Rule Set and Secondary Data Determination

OCC topics

KEEP IN MIND

We have to differentiate two different areas of "ruleset" stories

If you buy content you should be on the "safe side". As part of the "Content" you will receive documents explaning on some detail what hast changes from version X to Y.

But if you create you own rulesets using the EHS Expert options.. this is a different story. Here most of us can not help.

Regarding the OCC part we can split as well a little bit

Many discussions here are running like: hot to make the "proper set up of OCC"; some are running: how to upload "legal data" (content) and some are running how to use the "EXCEL templates" to load data.

Here the same is true to a certain extent. For "Legal data load": You should have a "good documentation" in place (which the "data provider" should deliver

But for the "set up part".... the documentations seems not to be "good". For "EXCEL Upload"... at the end it s a "learning by doing". Those of you who has used in the past the old "Data Editor" from TechniData has may be a beetter chance to start.

Introduction Part 2

As this blog is a little bit outdated I have decided to generate a new list of "links" to important stories to check and read.

Therefore: the "OCC part" will get now an update; The ruleset part I currently will not update.

In Scope

I will try to give an high level overview of the two options more from point of view of business (and partially clearly we find many threads discussing "technical issues").

Out of Scope

I will not provide the details.

Secondary Data Determination

May be check: Secondary Data Determination - Basic Data and Tools (EHS-BD) - SAP Library as a starting point in reading.

If you read cross the term "Secondary Data Determination" might not be a good one. E.g. This option is used to integrate OCC or other tools which can be used to "upload" data. This is more or less a "data import". One other subtype is the "Rule Set" integration and the next one would be the use of a "customer" specific exit.

Therefore you could generate this list in context of the term "Secondary Data Determination":

it can be used to do data loads (as with OCC)

it can be used to execute Rule Sets (with the use of EH&S Expert)

it can be used to incorporate completely company specific programming

Long time ago SAP provided some "Secondary Data Determination" "programs" as part of EHS. This is not supported any more.

Rule Set

As always a good option is to start with the SAP help and the IMG (Customizing). I will do slightly different.

Therefore check these links:

Set up	Link
EHS_MD_135_01 - Set Up EH&S Expert	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_01
EHS_MD_135_02 - Set Up Windows Registry	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_02
EHS_MD_135_03 - Set Up SAPRFC.INI	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_03
EHS_MD_135_04 - Extend Entry in Secondary Data Determination	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_04
EHS_MD_135_05 - Set Up RFC Destination	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_05
EHS_MD_135_06 - Set Up Easy Expert	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_06
EHS_MD_135_07 - Set Up EH&S Expert Server As a Windows Service	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_07
EHS_MD_135_08 - Configure Call of Rule Sets in a Rule Set Sequence	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_135_08

So if you "google" you find some useful results (and not only on the SAP help page).

From technical point of view. Rule Sets and Secondary Data determination option are "only" special cases of an "Exit". They are "default" ones (which are always present in CG02; that means they are part of the SAP menue (without content; the content need to be customized)); Other exits need to be prepared to show up in CG02 (refer above to the document mentioned there).

SAP help starts with: EH&amp;S Expert - SAP Library

So as you can see: We have to differentiate between "SAP EHS Expert" and "SAP EHS Easy Expert". In most cases the "Easy Expert" can only be used for "very" simple "calculations" of something. On daily business normally this will not be enough. In reality the "Easy Expert" approach is "to simple" incomparison to the "complex" rules you need in daily business(e.g. refer to SAP online help: EH&amp;S Easy Expert - EH&amp;S Expert - SAP Library).

Using rulesets is one approach to speed up in maintenance of data and can help in "Change Management" (after regulatory data has changed).

What are the cons: you need to understand the set up of EHS Server and how to define the rule (including mapping etc. etc.). With EnhPack 3 a lot of performance optimizations have been done. Please read cross the SAP help. On high level: the performance critical step is the reading of the data; this is "improved" in EnhPack 3 (together with other improvements as well).

Keep in mind: to enhance rules sets in prod you need to execute a lot of steps (which are in regrads of complexity etc. may be on level of: how to distribute a WWI layout from dev to qual to prod).

If you do not want to "learn" EHS Expert you need to buy content from a data provider. Prerequisite is: you should not ! have changed the STANDARD tree. You need to use standard SAP data model (with rating, validity areas etc. etc. etc.). Additional prerequisite:

- you need to use the same UOMs as described by the service provider

- you need to use the same phrases (or you need to map them)

Any rule set delivered (according to my knowledge) assume that you are using STANDARD SAP tree without any customer enhancements.

Here a small list of threads:

Link
Question on regulatory content provider and expert server
EH&S Expert server rules
Migrate WWI and Expert Rules to new server
Sizing of SAP Expert Server/ WWI Server
EHS EH & S Expert and Easy Expert
Will windows server 2003 support sap ehs glm module
EHS_EXPERT Transaction program not registered.
start EHS expert using JCo
SAP EHS Expert
Method to find version of EHS WWI server
How to regester SAP system wit EHS system through rfc connectivety.
Calculate standard composition via EH&S Expert
EHS Substance - creation of new reference specification
SAP front end issue
Recipe Management - Composition of an Output Substance error
SAP EH&S Regulatory Content and SAP Unit of Measures (UoM) are definied different
EHS Expert Rules Mapping
EHS Easy Expert-job in background-successmessage for each specification
EHS expert server issue
Data Model for MSDS Authoring with SERC
Sap Easy Expert
how to open expert rule file
update new rules from new serc update
GHSUS expert Rule
Expert rule - help document
Expert Rule - Secondary Data Determination
how to open expert rule file
How to create an Expert rule to update existing VAT instance(s) ?
How to display of the rule explanation screen within claim expert mode (ICLDCD02)
ehs expert rule - input and output data for GHS , Sara Comp and DAPEC
SAP EH&S Expert Rule- Short Dump-RFC_CONVERSION_FIELD
EHS expert rules log
MSDS maker usage
Registry entry not found OCC ehs
Expert Rules User Exit
Expert rules for substance with out CAS or UN
SERC 2013-1: Errors
Custom MSDS Maker
use of msds maker and set up process
How to add customer specific output of MSDSmaker
easy expert error
sap ehs expert rule -dapec and clean water act rule
example to explain how expert rules use access database in its calculation and for the output
How to Read .RUC (Rule File) ?
how to connect msds maker tool to sap
EHS - DATA EDITOR - COPYING FUNCTION
MSDS Maker Question ?
Expert Rules - Secondary Data determination

OCC Set up

OCC is a tool which can be used to import data. E..g. refer to these links:

EH&amp;S Open Content Connector - Basic Data and Tools (EHS-BD) - SAP Library

IMPORTANT NOTE: The old "DataEditor" functionality as delivered by TechniData is now part of OCC (on high level). You can now use OCC to upload specification data and phrase data

Topic	Link
EHS_MD_300_10 - Set Up EH&S Open Content Connector	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_300_10
EHS_MD_300_20 - Set Up Windows Registry for EH&S OCC	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_300_20
EHS_MD_300_30 - Set Up RFC Destination for EH&S OCC	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_300_30
EHS_MD_300_40 - Edit Mapping for EH&S OCC	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_300_40
EHS_MD_300_50 - Extend Entry in Secondary Data Determination for EH&S OCC	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_300_50
EHS_MD_300_60 - Specify Mapping for EH&S OCC	https://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_300_60
EH&S Open Content Connector (EH&S OCC) (New) ( RELNEHS_BD_500_OCC )	https://www.consolut.com/nc/de/s/sap-ides-zugriff/d/e/doc/YP-RELNEHS_BD_500_OCC.html

Did you know that regarding there is an US patent in place? I identified two patents:

http://www.google.com/patents/US7680803

http://www.google.pl/patents/US20050283374

May be read as well: http://patentimages.storage.googleapis.com/pdfs/US7680803.pdf and US20050283374.pdf

(which are pdf files representing the US patents).

E.g. http://www.google.com/patents/EP1852796A1?cl=en could be of interest too.

OCC is a tool to import data as part of an "XML"data stream and in the current version you can use "text oriented files strcutures" as well . In most cases you use it to upload "regulatory data" provided from a data provider. In most case not more than 10 persons in a company need to do the upload (and therefore need the knowledge and corresponding skills to do so). So there is not a need to install OCC on any client.

The set up and installaiton and use of OCC seems to be having many pitfalls (refer to the many threads). As with WWI: it is not easy to install nor to use the tool/process. And there is more or less no real help available via SAP Msrketplace (we have a good ! dcoumentation of EXCEL based load via OCC but not a "set up" guideline for OCC (e.g. discussing offline and onlline modus differences).

May be check as well: Examples of Data sharing demands in SAP EHS Management using XML

Here a small list of threads discussing OCC:

Links
EH&S OCC
SAP EH&S OCC question
Ehs OCC (Open Content Connector ) Application error
Regulatory Content & OCC
SAP Environment, Health and Safety - Open Content Connector (EH&S-OCC)
Difference between SAP EHS Expert Server and SAP OCC
EHS data upload from Content providers through EHS OCC
Open Content Connector
Release Note Documentation OPS_EHS_CI_1
Question on regulatory content provider and expert server
Difference between SAP EHS Expert Server and SAP OCC
WWI and Expert Rules Servers upgrade to 2008 R2
Sizing of SAP Expert Server/ WWI Server
Initial SERC Load with OCC
SERC content package and service package
Characteristic of Data Type = Date follows User Profile Only
Handling Packing
SAP Substance WorkBench
How to manage the regulatory data import into specification database?
Data Import with the EH&S Open Content Connector
Mass upload of data in property trees in EH&S
data editor tool
Different steps in loading data from occ
Data Editor for Mass Update
Where to download EH&S Data Editor tool
Data editor
OCC Rule Run for product Safety Error Message
Create mass specifications and update value assignments
Upload value assignments to substances
Connection to Partner 'IP Address:Port' Broken / CPIC-CALL : 'ThSAPCMRCV' : cm
Help on LSMW template
can we import phrase and phrase set without importing transports from sap content first
occ dg set up issue
OCC error - State of matter not found
occ to load specification
What is DCT ( data collection tool from technidata) for SPRC How this can be used ?
How to install EHS , Master data and transaction data
how to upload phrase set in sap
OCC capabilities
Please update how to migrate and create1000 substance specs in SAP EHS through legacy system
Unable to log in to the data editor
EH&S data editor - Logon error
EH&S Data Editor errors (meaning)
EH&S Data Editor Monomer and Exact Compositions data load problem
how to connect OCC to sap for online data load (spec and phrases )
EH&S Data Editor - Create Dangerous Goods Class Load File in Data Editor
https://answers.sap.com/questions/614781/can-occ-import-spec-idenitfiers-with-a-specific-us.html
https://answers.sap.com/questions/502205/how-to-connect-occ-to-sap-to-do-data-load.html
https://answers.sap.com/questions/212332/how-to-change-the-user-exit-parameters-in-occ-when.html
https://answers.sap.com/questions/495887/is-there-a-document-listing-step-by-step-instructi.html
https://answers.sap.com/questions/474439/what-is-the-use-of-application-log-level-in-ehs-oc.html
https://answers.sap.com/questions/693422/open-content-connector-cpic-callcmrcv-no-data-rece.html