Manual Cost Center planning with excel upload

[Former Member]

Hi All,

Can anyone tell me step by step process for Manual planning in cost center with a excel upload functionality. I would appreciate it.

Thanks

MKR

[former_member182098]

Hello,

To do integrated excel upload of cost center plan data.

IMG ==> Controlling ==> Cost Center Accounting ==> Planning ==> Manual Planning User Defined Layouts - Create your own layout or copy from standard layout and change it.

IMG ==> Controlling ==> Cost Center Accounting ==> Planning ==> Define User Defined Planner Profiles

Copy the SAPALL to ZSAPALL. You cannot change SAPALL as it is standard.

In ZSAPALL planner profile, select proper planning area and enter your layout.

Tick Integrate Excel.

Once the popup for KP06 comes, you need enter the data and save it. It would generate the file name.

With the same file name you need upload the plan data by using KP06.

In KP06

Extras ==> Excel Planning ==> Upload

Select the file as prepared in accordance with format at the time of generating the file name.

Hope this solves your problem.

Regards,

Ravi

[Former Member]

There are many threads on excel upload, just search on...you should get it