on 08-08-2008 1:42 PM
I am looking into using Excel to load our Planning Data in KP06 for Cost Centres & Cost Elements. I have started reading the documentation and understand I need a planning layout which I am going to start work on. Can I just clarify, if I want to load multiple cost centres and cost elements, and some for a number of months to be variable, some a 12 month split, is this possible in one file? Or will I need a separate file per cost centre? The reason I ask is that when we load manually we do enter each cost centre separately by entering this in the header screen.
Eli
Thanks for that, makes much more sense. Quick question, I assume that I only need to enter the Cost Centre and Element once per match, and then have 12 columns after that for the data?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Eli
Gold stars for you!!! Thanks
I am having a go at setting this up now.
Normally we would enter a Distribution Key, 0 for monthly amounts and 2 for yearly amounts to be evenly split over the year. Do you know if I would still need this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Eli
Thanks for you comment. I am struggling then with the first hurdle. In the Planning, should I be selecting one of the standard ones to copy? In the header, teh constand fields would be Version, from & to period, and year. The remaing data would need to go into the Line layout then I guess, using vertical dimensions and horizontal months.
In the line layout, we would need to load Cost Centre, Cost Element, Fixed Plan Costs, Distrbution key, then either the full year value, or into months. Do you know which plan version may be best to start with?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Wendy,
If you want to enter different amounts for every month, then you should not put them in the header, but to create a plan figure for every month, putting it as a restriction for the field. So, it will be 12 columns for the planning itself + cost centre + cost element. There is no need for distribution (could be kept in general parameters), as you are uploading every month separately.
It's always easier to take one standard layout, copy it and work on it.
Regards,
Eli
Hi Wendy,
It's possible. All these things depend on the layout, you will create for the planning profile. If the layout puts cost centre/cost element in the vertical dimensions and months in horizontal dimensions, you will achieve your goal.
Regards,
Eli
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
8 | |
6 | |
6 | |
5 | |
4 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.