Connection SAP EH&S with SAP BO

[Former Member]

Hi All,

We are planning to connect SAP EHS system to SAP BO for reporting purpose to extract the safety data and other fields.

But we are unable in creating connection for SAP EHS system using SAP ERP 6 (SAP Java Connector) in Information Design Tool and trying to create Universe for this data.

Do let me know if anyone has any pointers to help in this area.

Thanks in advance.

Regards,

Gaurish Dessai

[Former Member]

Hi All,

Thanks for sharing the Information earlier. I just wanted you to update on the approach we used.

We transferred the EHS Specifications Data from ECC to an Reporting database via SAP PI interface and connected BO to this database to read the required specification data.

Might be of help for readers.

Regards,

Gaurish

[christoph_bergemann]

Dear Gaurish

well done. I assume you distribute spec data including phrase data via SAP PI as with out phrase data normally you will not achieve the objective.

C.B.

[Former Member]

Hi Mark,

Thanks for your inputs. we tried with C1F5* function to read the data but yould not read the same. below are the steps we are following:

1. Created Connection (using SAP ERP6-Java Connector) to SAP EHS System using  “Information Design Tool” in BO 4.1 Version.

Note: Information Design Tool is used to create Universe(semantic layer b/w BO and Database, where we provide the Joins b/w tables and use the columns from the tables) .We will create BO Report on the top of this Universe

2. While creating Connection we have provided function Names (BAPI) and could not find the tables (ESTRH and ESTRI). is there any way we can access the EST* tables directly?

Do let us know I if anyone has information on the issue. it would be very helpful.

Regards,

GAurish Dessai

[Mark-Pfister]

Hi Gaurish,

I'm not sure why you can not find the tables:

The SAP ERP6-Java Connector  should create a function or method that should have the same interface as the BAPI Function Module in SAP (At least this is how I remember it from years back).

SAP DB Table Name	Parametername in BAPI_BUS1077_GETDETAIL
ESTRH	SUB_HEADER
ESTRI	IDENT_HEADER

Can you show a screenshot of the generated object?

Hope this helps

Mark

[christoph_bergemann]

Dear Gaurish

you are using the "wrong" approach. First you need to understand the use of the BAPI correct (what are the input parameters, what are the output parameters) Take a look at:

You will find therein the reference to the "sample" reports of SAP which are using internally the BAPIs. Try to learn from the report structure how to use the BAPis properly.

The following document (refer below) contains many link to many discussion about the use of FMs/BAPIs etc. in EH&S

BUt if you just do a query you will find many more examples (Using BAPI_BUS1077_GETDETAIL to read hazard ind... | SCN,

As well you will find discussions on the right use of this BAPI outside of SCN (example: http://www.wikiguga.com/topic/637995d4ed052a951460c75f59ea8094)

MAy be as well this link is of interest:

SAP ABAP Function Module BAPI_BUS1077_GETDETAIL - SAP Datasheet - The Best Run SAP Run SAPDatasheet

You should not use these BAPIs by "thinking" on ztable level. First you need toask your self. what do I whould like to get as data back. The BAPIs execute alll the necessary steps internal (read of ESTRH, ESTRI etc.)

On the top I can recommend to read this document:

C.B:

PPS: check as well this thread which is trying to get something similar:

PS: as well:

[Former Member]

Hi Mark,

I am working with Gaurish Dessai  regarding connecting SAP BO to SAP EHS system. This is the first time i am trying to connect to SAP EHS system from SAP BO "Information Design Tool ". I am unable to find the tables ESTRH and ESTRI for BAPI_BUS1077_GETDETAIL FM in IDT.

After Creating Connection (to BAPI_BUS1077_GETDETAIL M),I could see below List in Data Foundation layer of IDT. I could n't find the tables(ESTRH and ESTRI) in any of the below list .Could you please suggest?

Thanks,

Anusha

[Former Member]

Hi Christoph,

Thanks you let again to point me to the right links. In fact, the document you recommended me to read was prepared by me so you reminded me of that approach and it worked.

Regards,

Gaurish Dessai

[christoph_bergemann]

Dear Anusha

Mark tried to help a little bit. As mentioned in my answer: the correct use of BAPI BAPI_BUS1077_GETDETAI is explained in many threads.

Before you can use this BAPI you need to understand the data model of EHS.

Based on proper "flagging" of the "import" parameter you can get result data which is linked to ESTRH etc.

E:G: links mentioned below might help

BAPI_BUS1077_GETDETAIL EHS: Read Specification - Function - ABAP - SAP

SAP ABAP Function Module BAPI_BUS1077_GETDETAIL - SAP Datasheet - The Best Run SAP

Run SAPDatasheet

https://www.consolut.com/en/s/sap-ides-access/d/s/doc/F-BAPI_BUS1077_GETDETAIL

So you should think here in "tables" but in "business objects". Some of the return parameters clearly represent content of tables as ESTRH, ESTRI, ESTVH etc. So you achieve the goal by using the right input parameter.

The use this BAPI depends on your business need (which data ro present etc.)

You need to keep in mind that if you use the BAPI direct you have no option of "refinement" of inquiry as in CG02; so the most important topic to consider is: PERFORMANCE !!! If you have a database in place with 500.000 specifications and lots of data records the input paramter of the BAPI are the "key" factor to get results in "short" time.

C.B.

[Former Member]

Hello Christoph, Natalia,

Thank you very much for the inputs. Unfortunately, we are using EHS Classic; so we do not have the component extension in place for us.

We are trying to pass BAPI_BUS1077_GETDETAIL as a function to the SAP Java Connector, but it is unable to read the BAPI Return Tables. Is there any other function we could pass to access the EST* Tables directly ?

Thanks for your inputs.

Regards,

Gaurish

[Mark-Pfister]

Hi Gaurish,

You cloud try the C1F5* FMs to read the EST* tables. But these FM are not RFC enabled.

Regarding BAPI_BUS1077_GETDETAIL:
Are you sure that you are calling it in a way so that it is actually returning data? I'm not sure why the SAP JAVA Connector should not be able to access these tables correctly...

Kind Regards

Mark

[christoph_bergemann]

Dear Gaurish

please pay attention with the term "EH&S". Natalia (thanks to here) provided you link to the "Component Extension for EHS Management" solution and not to "EH&S classic". I assume this is exactly what you are looking for.

C.B:

[former_member190267]

Hello Gaurish,

Maybe this link can help you:

https://help.sap.com/saphelp_ehsext30/helpdata/en/6e/e41e5e11734cd08088265beb1b8547/content.htm?fram...

Best regards,

Natália