Excel upload for Cost Centre Planning

[Former Member]

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.

[Former Member · Accepted solution]

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?

[iklovski · Accepted solution]

Precisely.

CCtr :: Cost Element :: 1 :: 2 :: ... :: 12

[Former Member]

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?

[iklovski]

Hi Wendy,

I doubt that. I'd just put everything on monthly basis; if it's equal distribution, just divide your amount by 12 and put them in the file. Then, you can 'throw away' this field from your layout, as it will have no meaning.

Regards,

Eli

[Former Member]

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?

[iklovski]

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

[iklovski]

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