Calculating 'historical' stock balances with 2LIS_03_BF *ONLY*
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?