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.

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