How to get the values assigned to property tree of the material specification for preparing a report

[Former Member]

Hi Gurus,

Here is my requirement please help out me.

I want to  fetch the data from specification property tree in EHS.

EX: I want the data or characteristic value of 'FLASH POINT' which is a node under

'safety data' which is inturn a node under property tree of material specification.

Like this i want all physical and chemical property characteristic values based on requirement.

I found the BAPI 'BAPI_BUS1077_GETDETAIL' but this need some authorizations where client/customer dont permitted.

So in our case we cant use this BAPI.

Can anyone kindly help me by giving the code for acheiving this requirement by using some tables which related to material specification.

And im having input parameters as material number and characteristic name.

Thanks in advance.

Sreehari

[christoph_bergemann]

Dear Sreehari

if you customer does not allow to use BAPI as mentioned he will as well not allow to use the function module as mentioned (e.g.). If you dig deepre you will detect that BAPI (according to my knowledeg) will call the function module as mentioned internally.

To read the data via "table" fetch is the "worst" you can do; you need to have a super perfect understanding of the very special EHS data model; and at the end: you select data ignoring any authorization concept.; normally no customer which I know will accept something like that. PLease dig deeper why you are not allowed to use the BAPI: My "simple" answer to the customer would be: If I am not allowed to use the BAPI then I can not help you. (or you should not do it)

C.B.

[Former Member]

Hi Sreehari,

Does the report only require Specification Data?

If so we need not go for a custom code to get data for a specific value assignment types.

You can use the Output variant options provided in the Specification Database.

Displaying Specification Data - Basic Data and Tools (EHS-BD) - SAP Library

However if the requirement is a custom code at any cost then work with the developer to analyze the list of tables related and provided in the below link.

http://www.scribd.com/doc/258013038/EH-S-Data-Structure#scribd

[Former Member]

Hi Sreehari,

Try using Function modules of the function group - C1F5

Particularly this one - C1F5_SPECIFICATIONS_READ.

Regards,

Neeraj

[Former Member]

Hi Sree,

You need to explore tables ESTVA, ESTVH and link it with TCG66 & ESTRH through record and root numbers.

Regards,

PAVAN

[Former Member]

Hi pavan,

Thanks for your response.

I have tried on these tables but i didn't achieve my requirement.

Can i have example code for linking these tables to meet my requirement i.e., fetching data from material specification.

Thanks,

Sreehari