Examples of SAP EHS specification DAT file processing

It is relatively easy to export various data out of SAP EH&S Product Safety, generating DAT files:

• substances (list_sub)
• products (real_sub)
• phrases and phrase sets
• property trees (+ classes and characteristics)

But the processing of the processing of these DAT files is complex. eSpheres has develop versatile tools to parse or transform these DAT files:

• either to re-import transformed data
• or to generate lists, tables to ease the read, analysis and comparisons.

Examples

list, table examples:

1. list of VAT in a property tree
2. list of VAT with several languages + list of characteristics
3. list of phrases (items)
4. list of DG data per substance
5. list of substance identifiers (NUM:CAS, NUM:EC, NAM:PROD, ...., NUM:REACH_REG)
6. list of (standard) compositions
7. list of material assignments per specification

special reports:

1. html file documenting a property tree with list of VAT and characteristics (no toc, no identation)
2. html file documenting a property tree with list of VAT and characteristics (with toc and indentation)
3. to analyse differences between 2 property trees
4. to compare phrase items (using levenshteim distance)
5. to compare classification data between systems or before/after regulatory content update
6. to compare DG data between systems or before/after regulatory content update
7. phrases with text with languages in a kind of pivot table (to check translations and identify missing translations)

DAT file to re-import transformed data:

1. to change some rating to OBSOLETE for oldest value assignments
2. to duplicate substances changing specification key and specification type (for instance, list_sub into pure_sub)
3. to remove all value assignments computed by an expert rule sets, also correcting some validity areas and changing specification statuses

DAT files generated from spreadsheets

1. phrasesets import file for a defined set of phrases
2. phrases import file