on 03-12-2008 9:36 AM
Hi
At present, I am able to do upload the cost planning template via Excel Planning functionality in CJR2 transaction for the overview screen.
There are two screens once CJR2 is executed.
1. Overview screen
2. Period screen
Can u please help me on how to upload the cost planning data in Period Screen format instead Overview Screen for cost element planning in layout 1 - 701.
Regards,
Basavaraj T.
You need to create your own layout for that. Something like below
WBS Element Cost Element Plan P1 Plan P2 Plan P3 Plan P4 Plan P5 Plan P6 Plan P7 Plan P8 Plan P9 Plan P10 Plan P11 Plan P12
(All fields P1- P12 for each period in different columns)
Use the Characteristic 'Period' and in the field 'From' use 1-12 for each column.
For creating layout, please refer the link below:
Regards
Sreenivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srinivas
It;s a great document. Can u just elaborate further on how to do this for the different periods. I am unable to insert the columns as lead columns during creation of planning layout
The data I would like to upload looks like this below:
SAP Plan Version 0
Year 2008
WBS Element EW-RC293239
Cost Element 71909710
January 100
February 100
March 100
April 100
May 100
June 100
July 100
August 100
September 100
October 100
November 100
December 100
Regards,
Basavaraj
Refer the same blog.
Under from the general selection move out 'Period' and then insert an element (not lead colum) and pull in 'Period' from right available field to left (Selected Characteristics) and then mention 'From' as 1. Change the description to 'Plan 1'.
Similarly do the same for period 2-12. Now your layout will have single header row : WBS,Cost Element, Plan1- Plan 12. Play around till your satisfied with your layout.
Regards
Sreenivas
Hi
This functionality worked well with a single WBS element and single cost element. Is there any way to do this for multiple WBS elements and multiple cost elements. Presently I am able to get the tempate for single object. The requirement is to upload the costs for around 500 WBS elements in one go with single or multiple cost elements associated with them.
Regards,
Basav
Hi,
I'm uploading excel file through CJR2 transaction and i'm reffering the link that you gave in your post
in this link i'm facing the problem in step "layout for controlling" in KP34 T-code in the field description.as it is giving the error that file description does not exist.could you please resove my problem.
Alse in the T-code CJR2 when i'm uploading the excel file .It is giving me error as file description does not exist.
Please resolve my problem.
User | Count |
---|---|
105 | |
14 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.