Skip to Content

CO-OM_Cost center planning for 12 months with Excel upload

Steps:

1. Create Planning Layout: Tcode KP65

Example:

Planning layout: Z1-103EXCEL

Copy from layout: 1-103

2. Change Planning Layout: Tcode KP66

a. Chosse your new layout

b. Go to Edit / Gen. Data Selection / Gen. Data Selection

– Choose Period field in the left list, and remove it to the right list.

– Then click “Confirm”

Result:

/wp-content/uploads/2013/04/2013_02_27_110735_189727.jpg

c. Double click on ‘Plan Fix Costs’ Column in layout, choose the Period in the right side and move it to the left side

– Enter the value 1

– Then click “Confirm”

– Change the name of this column by putting the cursor at this column, choose ‘Change text’ button, enter the new name, example: Plan cost 1

Result:

/wp-content/uploads/2013/04/2013_02_27_111256_189732.jpg

d. Copy Plan cost 1 column to another one and change text, change value of period to 2, 3, 4 until 12.

Note that the copied column is created in the left side of current column.

e. Delete some unnesessary columns like Plan Consu., Dist (atfer Plan consu. column), Uni, Q

f. Save the layout.

Result:

/wp-content/uploads/2013/04/2013_02_27_112112_189733.jpg

3. Assign the layout to Planning profile:

Path: SPRO > IMG > Controlling > Cost Center Accounting > Planning > Manual Planning > Define User-defined Planner Profiles

– Choose the Profile you’re using (or you can create new Profile), go to “General Controlling” tab

+ If Planning Area “Cost ctrs: Cost element/activity inputs” exists, choose it and go to “Layout for Controlling”

+ If Planning Area “Cost ctrs: Cost element/activity inputs” doesn’t exist, create new and choose it and go to “Layout for Controlling”

– In “Layouts for Controlling” tab:

Create new entry with assigning the new layout, check on Overview and Integrated Excel box.

Result:

/wp-content/uploads/2013/04/2013_02_27_112944_189742.jpg

Choose it and go to “Default parameter” tab:

– It goes to the same layout, enter some example parameter:

/wp-content/uploads/2013/04/2013_02_27_113538_189743.jpg

– After that, the message is appeared:

/wp-content/uploads/2013/04/2013_02_27_113123_189744.jpg

– Click “Overview screen” button, the message is appeared, choose “Enable Macros”:

/wp-content/uploads/2013/04/2013_02_27_113147_189745.jpg

– Then, click on “Save file description”

/wp-content/uploads/2013/04/2013_02_27_113240_189746.jpg

– Besides that,save as this file to another excel file to make it as temple for uploading.

– Go back, the file description is creared and updated automatically

Result:

/wp-content/uploads/2013/04/2013_02_27_113433_189747.jpg

4. So now, you prepare the data in the excel file and save it as .txt

– You can change to another cost center and add more cost element.

But you need to copy correct name of cost center and cost element.

Example: I have an upload file:

/wp-content/uploads/2013/04/2013_02_27_115248_189748.jpg

5. Upload planning data: tcode KP06, specify the layout your created.

– Go to menu Extras > Excel Planning > Upload…

– One screen is display, specify the location of upload file, choose the correct file description has been assigned to your layout

/wp-content/uploads/2013/04/2013_02_27_115034_189749.jpg

– Execute it.

– The log is appear if successful like this:

/wp-content/uploads/2013/04/2013_02_27_115022_189750.jpg

End.

29 Comments
You must be Logged on to comment or reply to a post.