Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Create Query using data from 0IC_C03 to show stock balance

Dear All,

I have successfully setup 0IC_C03. I have loaded in the data in accordance with the documentation. I check the result and it seems the stock balance match with the data source.

However, my question is how can I setup a formula in the query so I can look up stock balance based on the date I put in to run the query.

For example, I loaded in the data on Oct 13, 2008. For material A, I have a key figure called Quantity total stock which is the net of receipt and issue total stock is 10,000 LB as of Oct 13, 2008.

When I run the same query using the date as of Oct 31, 2005, the quantity total stock show -10,000 LB. The stock balance of material should be 0 LB on Oct 31, 2005. I know I can't just simply create 2 key figures - one using the loading date (Oct 13, 2008) and one using the input variable date to add up together since I will have trouble if I enter Oct 13, 2008 as the input variable day because it will zero out.

Please advise. Thanks.

Not what you were looking for? View more on this topic or Ask a question