Actuals and Projected inventory in BEx

[ms_k]

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.

[Former Member]

You have to use a structure with 24 elements. The first 12 will have the ECC key figure, the second 12 will have the APO key figure. The elements should be restricted further by calendar month / year. Use offset variables to get the following year for the APO data.

[ms_k]

can you elaborate on how to restrcict the calmonth and calyear in both ECC and APO KF's.

For example if user enters 2010 as year and 03.2010 as month, he needs to get the last 12 motnhs ECC KF values including 03.2010 and next 12 months i.e from 04.2010 to 03.2011 he should get APO KF values.

[ms_k]

For example,it should be in this below format.

Actuals Projections

Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11

1009 1010 1011 1012 1013 1014 1015 1016 1017 1018

[ms_k]

can anyone pls respond to my query...