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