Skip to Content
Technical Articles
Author's profile photo Satyanarayana Reddy

Data handling for the EH&S Open Content Connector

Introduction:

To upload the Specification data into Specification data base we use OCC,

OCC needs certain format to update the data , we can upload both online and offline data modes.

 

The sequence of the columns is not predefined. However, SAP recommends you enter the specification ID in the firstcolumn, and that you use the next to import identifiers to the specification.InSpecification Management, identifiers are stored in table ERSTI. Therefore, the first letter for mapping identifiers is”I”.The value “IDENT” follows a colon for the field in which the identifier is stored. Information about identifier type (fieldIDTYPE) and category (field IDCAT) follow, separated by commas.

 

Note : For specification data should be present in 4 th line.

First save as Text Tab delimited .txt

Main portion:

Based on the tables used in SAP EH&S ,

Example : ESTRH for Specification Header and H (Table) : SUBID (field) is the syntax we used to update the data.Following table and Syntax structure Table and Field which is used to update the data for OCC.

H: ESTRH (specification header)

I: ESTRI (identifier)

M: Property in property tree

U: ESTDU (usage)

U: EXCLFLG (exclude indicator)

U: ACTVFLG (active indicator)

U: ESNTFLG (relevance indicator)

F: ESTDF (user defined text)

S: Source

R: Assessment

L: Regulatory list

A: Administration data for the value assignment type data record

V: Inheritance

7: Transport approval data

B: Packaging approval data

D: Dangerous goods classification data

F: Transport classification data

T:   Fields from external tables

String :

/STRING – A numeric value is read in the text form defined in the SAP classification system (for example 1–2 mg/kg). This option has no effect when writing. The decimal separator is always set to the English.

Phrases upload (field Data) :

CATPIN

CATDATE

CATVERS

NUMRNGE

PHRGRP

PHRID

SRLANGU

LANGU

PHRTEXT

 

Note : For Phrase upload data should be start from second Row .

First change it to Text Tab De limited .txt then save as PIT.

Phrase Data Structure :

 

 Conclusion:

Here is the common example data attached ,

With the below format Header data, we can create the excel to upload into SAP.

 

Next blog will be on Property tree structure loading using OCC tool.

 

Source :Fact Mapping

 

See you soon Thanks for your time.

 

Regards

– Satya

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Holger Hartung
      Holger Hartung

      Hi Satya,

      very helpful but where can I download EH&S OCC tool?

      Author's profile photo Satyanarayana Reddy
      Satyanarayana Reddy
      Blog Post Author

      Hey Holger ,

       

      You can download it from SAP market place.

      Best

      Satya

      Author's profile photo Holger Hartung
      Holger Hartung

      Hi Satya,

      is the OCC tool part of a support package or is as a stand alone application availaible?

      I only found OSS 680352, where mentioned "The front end of the EH&S Open Content Connector is contained in the setup of the EH&S Expert as of EH&S Expert 2.7B / 3.2, SP09"

      Author's profile photo Satyanarayana Reddy
      Satyanarayana Reddy
      Blog Post Author

      Hi ,

      Its not stand alone application , it will come with Expert rule set up , but you can install it independent to expert server.

       

      Best

      Satya

      Author's profile photo Holger Hartung
      Holger Hartung

      Hi Satya,

      After a few teething problems, I now have the OCC up and running. However, another difficulty has arisen when creating new specifications.
      How can I create completely new specifications for which automatic number assignment is active? I.e. there is no SUBID.... in the *.dat file.

      Author's profile photo Satyanarayana Reddy
      Satyanarayana Reddy
      Blog Post Author

      Hi Holger ,

       

      Yes ,that's right leave SUBID blank , then your specification will be created with internal number range , if you need any further personal assistance you can reach out to me via email reddymscorg@gmail.com.

      Best

      Satya

      Author's profile photo Jordi Roca
      Jordi Roca

      Hello I am trying to assign a phrase set to a phrase by OCC but I think so that my document is not correct, please help me with a example.

      Phrase%20set

      Phrase set

      I don't know the difference between "KEY (PHRID)" and (JPHRID), please help me with a correct document to assign a phrase set.

      Jordi.

      Author's profile photo Satyanarayana Reddy
      Satyanarayana Reddy
      Blog Post Author

      Hello

      Its PHRID - Phrase key there is nothing called JPHRID to load Phrase Set, its just a link.

      SAP Offline Word Template

      Page No: 50.

      Best

      Satya

      Author's profile photo Jordi Roca
      Jordi Roca

      Hello,

      Yes, if it exists:

      I have already been able to load the set of phrases.

      Thanks for your help

      Best

      Jordi