Skip to Content
0
Jan 11, 2011 at 08:20 AM

Actuals and Projected inventory in BEx

31 Views

Hi all,

currently i am doing APO-BI Project. I have a requirement to extract the closing stock from ECC and Projected(Forecasted) Closing stock from APO.

both are 2 different key figures 1 is from ECC and another one is from APO. I need to display in Bex report in

say for example, if we have 12 months in a year. if i run the report in Dec 2010 in the bex report it has to display the closing stock values from ECC from Jan to Dec of 2010 and Jan to Dec of 2011 to display Projected Opening stock values from APO.

I need different columns for different months in the report.

plz provide me the logic to achieve this report.

Pls Dont suggest other threads in SDN.I have gone thru all.