Skip to Content

SAP BI Inventory bex query problem

Nov 24, 2016 at 12:29 PM


avatar image

Hello Experts,

I am facing a issue in populating storage location in SAP BI Bex Query (in Values Key-Figure Storage location is populated blank and in quantities Key-Figure it is getting populated correctly)

When I checked in datasource I am getting Storage location for concerned values field, But while using standard receipt and Issue values Key-Figure in query designer the storage location is coming blank.

Please let me know if I am missing anything in query designing or any other configuration to be done.

Also, Please find attached Screenshot for reference.

Any advice or help will be appreciated.

Thanks in advance.



test.jpg (71.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Frédéric Cincet Nov 24, 2016 at 03:03 PM

Work as designed.

As on the ECC side, the valuation of your stock only happens at plant level.

If you want to valuate your stock at a lower level, you will have to do it on the BW side (calculate an average price and use it to valuate your quantities).



10 |10000 characters needed characters left characters exceeded
FORAM SHAH Nov 25, 2016 at 05:52 AM

Thanks for the reply Frederic.

Storage loaction is populated at ECC side in a PO and same is reflected in SAP BI Datasource, But when the data is loaded in INFOCUBE storage location is not populated in key figures related to values.

Please let me know if anything can be done.



10 |10000 characters needed characters left characters exceeded
FORAM SHAH Nov 25, 2016 at 12:37 PM

Hi Frederic,

Further to our analysis I Found that there is a Start routine between BF Datasource and 0ic_c03 Infocube which shows one material document from datasource created 2 records in infocube and in these in one record in front of quantity shows perfect data in storage location field and other record there is blank storage location in front of amount key figure.

Also a standard start routine is there between BF Datasource and Inventory Infocube, So can we make changes in that if yes whether it will impact the existing values.Kindly let me know

Please find below screenshots so you will get to know what is the actual issue and also let me know how can we tackle the same.



10 |10000 characters needed characters left characters exceeded