How to configure Environment Parameter BW_SPEC_USAGE to get multiple Usages

[Former Member]

We are extracting EHS data from R/3 to BW system. The Environment Parameter BW_SPEC_USAGE can allow only ONE Rating and ONE Validity Area. Our EHS is maintained for many different Ratings and Validity Areas. Does any experts know how to configure Environment Parameter BW_SPEC_USAGE to get data from multiple Usages (the combinations of Rating and Validity Areas).

The default usage is PUBLIC: REG_WORLD (Rating: Validity Area), so we configure the default Usage as sort sequence 0. EHS data maintained for PUBLIC: REG_WORLD is then extracted to BW system successfully. Then, I try to create another sort sequence of BW_SPEC_USAGE as CUSTOMER: REG_EU, but the data maintained for CUSTOMER: REG_EU has never been extracted to BW. I guess this may be the solution to carry multiple Usages, but not sure it is the correct way to do it. Plus, I don't know what to input to the field "Parameter Value" and don't know if the "Parameter Value" matters.

Does any expert have experience to configure Environment Parameter BW_SPEC_USAGE?

Thank you in advance

Tina Wu

[Former Member]

Hello Tina,

did you found a solution to extract REG_EU? and if yes: could you share?
Regards,

Thomas

[christoph_bergemann]

Hello Tina

I have done a small review of this paramater. I believe by using this paramter there is no "further option". But: to my knowlegde you can define several "extractors" (via customizing etc.) (e.g. )

You can define any type of extraktor. EHS does have some "standard extraktors" (please consult corresponding release information). In preparing a "customer specific" extraktor it is clear that you can do there what you would like to get. (retrieve data with several usages). We have done that recently successfully.

take a look here:

SAP NetWeaver -> SAP Business Information Warehouse -> BI

Content -> Product Lifecycle Management -> Environment, Health and Safety (help.sap.com)

With best regards

C.B.