Skip to Content
avatar image
Former Member

transfer historical data from 2005 to the plan data 2006

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Apr 19, 2006 at 05:45 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Apr 19, 2006 at 06:14 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2006 at 12:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2006 at 03:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded