cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Stock Balance

Former Member
0 Kudos

We have a requirement to store the current inventory balance in an ODS. No date, just materials and on-hand balance.

My question is, is it better to update it though material movements or is there a way to just extract inventory balance info (like a snap-shot), where we can delete the contents of the ODS and then refill.

Will reward.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

We already have the standard inventory cube activated and is being filled. However, we want to extract the current balance. We have tried RSCRM_BAPI over the cube, but the cube is growing. Our idea is to create an ODS with no date field.

If we now want to initialize this new ODS, do we have to run the Stock Initialization for just the ODS and then change the BF and UM deltas to update both the current cube and the new ODS? Will that work?

Thanks in adavance.

Former Member
0 Kudos

Hi George,

How are you doing.

1. I can think of two solutions for this scenario...like if you are concerned about the RSRCRM_BAPI limitation of key figures then you can use a work around instead of BAPI that is

First get your Infocube data through your Inventory report into an ODS through APD (Analysis process designer) so you will have your stock balances in calculated form, and from this ODS by using the Open Hub Service to move the data from ODS.

2. I think you can straightaway update the ODS from your Infocube which is already having all the data. like data mart scenario and then do deltas from next time.

This is my understanding on the inventory scenario.

thanks

Sreedhar

Former Member
0 Kudos

Hi George,

Can you please send me the docs for the above report(Inventory Stock Balance),any help on how to check these reports -Excessive Stock Usage,Excessive stock movement report & Pending order report,in R/3 so that if they need any customization I would like to go for BI,any logic appreciated.

my email is raga0411@gmail.com

Thanks in advace,

Raga

Former Member
0 Kudos

Hi all,

also pls send me the documents on how to retrive stock as on , at the plant & material level from the standard inventory cube in BI 7.0

Sagar Patil

Former Member
0 Kudos

Hi

I've sent the documentation.

Regards

Asign point if useful please.

Former Member
0 Kudos

If you want to storre inventory i recommend you to activate the standard Inventory Cube and follows the best practices, i have done a few times and it was worked OK.

If you want i can send the best practices with a document that explain how to handle inventory managment.

Regards

Asigns point if useful

Former Member
0 Kudos

Marcus, thanks for your quick reply. I would appreciate any details you could provide. Please forward to geoshann@aol.com.

Much appreciated.

Former Member
0 Kudos

Hi George,

check the below how to manage the Inventory Senarios in BW.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/0ea8a990-0201-0010-2796-fa9...

Regards