Question Re: Table to get Characteristics Value in Product Lifecycle Management Q&A

Table to get Characteristics Value

Former Member — Tue, 08 Nov 2011 14:35:55 GMT

Hello Everyone,

I need to fetch State Of Matter(SAP_EHS_1013_001_VALUE) for several Real Substances. Could anyone tell me the table in which i can get the values for all the Specifications in single shot.

Thanks in advance,

Vignesh

Re: Table to get Characteristics Value

JuanCarlosDelga — Tue, 08 Nov 2011 15:02:08 GMT

Hi VigneshKeddy,

You can use instead the function BAPI_BUS1077_GETDETAIL, just check the flags and fill the field SUBSTANCE in table SUB_HEADER with the specification numbers. You get the property values in the table PROP_DATA.

Regards.

Re: Table to get Characteristics Value

christoph_bergemann — Tue, 08 Nov 2011 17:34:42 GMT

Dear Vignesh

in addition to what has been explained yet:

EH&S does have a number of standard output variants, which can be used to get all data without additional programming. To get data you can use (based on hit list) e.g. output variant:

- Valuation

- EXCEl

- SUB_OUTPUT

Keep in mind that you need to populate correct the interface of BAPI_BUS1077_GETDETAIL; keep in mind that you can have nnumber of sort sequences/data records/value assignments per substance/specification.

The enumarted output variants provide you the necessary data by default.

As you did not describe the need of your request: it is clear that you can get the "same" result by using WWI techniques to retrieve the data from the characteristic.

Hope that this helps

With best regards

C.B.

Edited by: Christoph Bergemann on Nov 8, 2011 6:35 PM

Edited by: Christoph Bergemann on Nov 9, 2011 8:59 PM