on 04-18-2006 3:22 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
SEM BW Analyst
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.