Skip to Content

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

Calculating 'historical' stock balances with 2LIS_03_BF *ONLY*

Hello All,

I have gone through a few posts, where it has been suggested that, we can use 2lis_03_bf alone to calculate the Beginning / Ending balances for each month: Current, In the Past and Future. And we do not need 2lis_03_bx if we have all the material movements loaded into BW from ECC (from the time ECC went live).

In my case, I ran the setup tables for 2lis_03_bf wide open in ECC to get everything since it went LIVE, so I am assuming that I have all the 'movements' captured. My question is:

1. If I have loaded BW today (05/31/2011), how can I calculate the Beginning / Ending balance for a period, say: March 2010 or Nov 2009?

2. Do I have perform the calculations in the backend (ABAP routines) or can I do it in the query itself??

3. The requirement is to display Opening Balance, Issues - Receipts, Closing Balance for any period (history, current and going forward) in a report. Any suggestions on how to do this?

Regards,

Srini.

Former Member

Helpful Answer

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