Data handling for the EH&S Open Content Connector

[satya11719]

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

😧 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

[holger_hartung]

Hi Satya,

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

[satya11719]

Hey Holger ,

 

You can download it from SAP market place.

Best

Satya

[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"

[satya11719]

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

[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.

[satya11719]

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

[former_member803878]

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 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.

[satya11719]

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

[former_member803878]

Hello,

Yes, if it exists:

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

Thanks for your help

Best

Jordi

[matthias_strobl]

Hi,

is OCC still working when using Recipe Development?

 

Thanks!

Regards

[satya11719]

Yes, it does as it is the same architecture.

[Trompetter]

Hello,

currently we have an OCC server with an installed SAP Logon. Users have to access the server over RDP and logon to the GUI to use the OCC functionaliy over CG02.

Is there a way, to have a central server and users can make use, using their SAP Logon from the normal client computer?

Best regards

Peter