Skip to Content
0
Former Member
Dec 30, 2005 at 04:43 PM

ABAP help

14 Views

Hellow Gurus,

1. I need to pull 24 months of forecast data from Infocube1 to InfoCube2. InfoCube1 contains 60 months of forecast data and the fields calmonth,key figures.InFoCube2 contains forecastmnth, calmonth and key figures. Forecastmnth is populated from a table based on current date.We load data every month.

2. When we will load in next month we need to keep previous load forecastmnth and calmonth as history if forecast is equal to calmonth and remaining 23 months of data we need to delete and current 24 months of data we need to load.

I a ABAP routine to add in my Infopackage to fullfill my above requirements(1 & 2). I don't know how to write this code. This is Urgent. I would appreciate your quick reply.

Example:

Example - Data in Infocube1(60 months of data)

calmonth kf1 kf2 ........

12/2005

01/2006

-


-


01/2010

I need to load 24 months of data out of 60 months from Infocube1 to Infocube2. After loading data should be like this in InfoCube2.

OUTPUT:

INFOCUBE2 -

First month time load(I need data like this)

Forecastmnth

12/2005

calmonth kf1 kf2

12/2005

01/2006

02/2006

03/2006

04/2006

-


-


01/2008

Second month load(I need data like this)

Forecastmnth

12/2005

01/2006

calmonth kf1 kf2

12/2005

01/2006

02/2006

03/2006

04/2006

-


-


01/2008

Third month load(I need data like this)

Forecastmnth

12/2005

01/2006

02/2006

calmonth kf1 kf2

12/2005

01/2006

02/2006

03/2006

04/2006

-


-


02/2008

I think this format is OK.I appreciate your quick reply.

Thanks

Pramod