transfer historical data from 2005 to the plan data 2006

[Former Member]

Hallo,

I am absolute beginner in BPS. Now I have a problem and I hope somebody can provide me with a solution.

I created two planning-areas, one for historical data and one for the plan data. I also created a multi-planning-area. I also customized a Web-Interface for the historical-data.

Now I try to do the same for plan-data. I want to plan the Year 2006 and I want to see at the beginning the historical data from the year 2005.

I tried to solve this problem with the planning function copy. But I failed.

Can somebody provide me a step by step guide to reach my goals.

thanks

[Former Member]

Hi Hari,

the link which you sent to me are good. But I have read it already.

It is for me too abstract. Because I have problems in various stages to define a copy function. I said already, I am a absolute beginner in this area. I need a more detailed guide.

But thank you very much for your effort.

Bye

Oktay

[Former Member]

Thanks for the quick response. But unfortunately the answers are not what I am searching for. I need realy a "step by step" introduction. Can somebody help me?

bye

[Former Member]

Oktay,

Have a look at this step-by-step Application examples to copy data in a "Multi-Planning Area" based on "Historical data & plan data".

http://help.sap.com/saphelp_sem320bw/helpdata/en/1d/94b0f45bd511d4b2e20050dadfb23f/content.htm

This topic covers "basic COPY function" and also "FOX function" if your requirement is complicated.

Hope it helps.

Hari Immadi

http://immadi.com

SEM BW Analyst

[Former Member]

Hello Oktay,

As you have already created a Multiplanning Area so hopefully you alerady have both planning and Actuals with you just create planning layout and get both the data there and then use your logic whether you like to save both the data together in planning or seprately like actuals in actual (BW) Cube and Planning data in Planning Cube.

Hope it helps.

San.

[Former Member]

Hei

Copy fuction does not allways do the trick. Perhaps you could try to crate a planning function of type exit.

In the Function module loop over your data and save them with the new year.

Hope this helps you

Maryon

F.eks.

FUNCTION Z_COPY_EXIT.

*"----

---

""Local Interface:

*" IMPORTING

*" REFERENCE(I_AREA) TYPE UPC_Y_AREA

*" REFERENCE(I_PLEVEL) TYPE UPC_Y_PLEVEL

*" REFERENCE(I_METHOD) TYPE UPC_Y_METHOD

*" REFERENCE(I_PARAM) TYPE UPC_Y_PARAM

*" REFERENCE(I_PACKAGE) TYPE UPC_Y_PACKAGE

*" REFERENCE(IT_EXITP) TYPE UPF_YT_EXITP

*" REFERENCE(ITO_CHASEL) TYPE UPC_YTO_CHASEL

*" REFERENCE(ITO_CHA) TYPE UPC_YTO_CHA

*" REFERENCE(ITO_KYF) TYPE UPC_YTO_KYF

*" EXPORTING

*" REFERENCE(ET_MESG) TYPE UPC_YT_MESG

*" CHANGING

*" REFERENCE(XTH_DATA) TYPE HASHED TABLE

*"----

---

data: data_ref type ref to data.

field-symbols:

<ls_data> type any,

<ls_chas> type any,

<ls_kyfs> type any.

create data data_ref like line of xth_data.

ASSIGN data_ref->* to <ls_data>.

ASSIGN COMPONENT 'S_CHAS' OF STRUCTURE <ls_data> TO <ls_chas>.

ASSIGN COMPONENT 'S_KYFS' OF STRUCTURE <ls_data> TO <ls_kyfs>.

DATA: pctr(10) TYPE C,

ls_file TYPE as_file,

cpctr(10) TYPE C,

lift TYPE P LENGTH 16 DECIMALS 2,

own TYPE P LENGTH 16 DECIMALS 2.

DATA wa_at_file LIKE LINE OF at_file.

• Internal tables

DATA: bt_file TYPE STANDARD TABLE OF as_file WITH DEFAULT KEY.

• Field symbols

FIELD-SYMBOLS: <s_chas> TYPE ANY,

<0COMP_CODE> TYPE ANY,

<0CO_AREA> TYPE ANY,

.....

• Processing actual data

LOOP AT xth_data ASSIGNING <s_chas>.

ASSIGN COMPONENT 'S_CHAS-0COMP_CODE' OF STRUCTURE <s_chas> TO

<0COMP_CODE>.

ASSIGN COMPONENT 'S_CHAS-0CO_AREA' OF STRUCTURE <s_chas> TO

<0CO_AREA>.

ls_file-0COMP_CODE = <0COMP_CODE>.

ls_file-0CO_AREA = <0CO_AREA>.

ls_file-PROFIT_C = cpctr.

ls_file-PL_YEAR = <PL_YEAR> === Change your year ti new year.

APPEND ls_file TO bt_file.

ENDLOOP.

• Change data

refresh xth_data.

• Transferring of data

LOOP AT bt_file INTO ls_file.

MOVE-CORRESPONDING ls_file TO <ls_chas>. " Map characteristics

MOVE-CORRESPONDING ls_file TO <ls_kyfs>. " Map key figures

modify table xth_data from <ls_data>.

• Transferring data to BPS

insert <ls_data> into table xth_data.

ENDLOOP.

ENDFUNCTION.

[former_member699913]

Hi Oktay Demir,

If u have created a multiplannning area on plan and actual data.

then u create a layout on multi planning area, whereby you will have entries from both the planning areas,

then in the layout you make the entries for actual data in comparison column(the data in comparison column cannot be manipulated) and adjacent to it will be ur plan data fields corresponding to planning area for plan data.

now in the layout you can plan accordingle viewing the actuals data.

hope it helps,

ajay