Data handling for the EH&S Open Content Connector
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
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)
L: Regulatory list
A: Administration data for the value assignment type data record
7: Transport approval data
B: Packaging approval data
D: Dangerous goods classification data
F: Transport classification data
T: Fields from external tables
/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) :
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 :
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.
very helpful but where can I download EH&S OCC tool?
Hey Holger ,
You can download it from SAP market place.
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"
Its not stand alone application , it will come with Expert rule set up , but you can install it independent to expert server.
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.
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 firstname.lastname@example.org.
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.
I don't know the difference between "KEY (PHRID)" and (JPHRID), please help me with a correct document to assign a phrase set.
Its PHRID - Phrase key there is nothing called JPHRID to load Phrase Set, its just a link.
SAP Offline Word Template
Page No: 50.
Yes, if it exists:
I have already been able to load the set of phrases.
Thanks for your help
is OCC still working when using Recipe Development?
Yes, it does as it is the same architecture.