Skip to Content
Author's profile photo Former Member

KP06 Excel Upload

                                                                            Creation of Planning Layout

Go to t.code: KP65

Planning Layout_1.jpg

Click on Create

Select the Version, Period and Fiscal year in the General Data Selection in the Menu Bar Edit –> Gen data selection –> Gen data selection

Planning Layout_2.jpg

Create the 3 Leading columns.

Double click on the 1st Leading Column for Cost Centers

Planning Layout_3.jpg

Double Click on the 2nd Leading Column for Cost Elements

Planning Layout_4.jpg

Double click on the 3rd Leading column for Activity types

Planning Layout_5.jpg

Double click on the next row key figure with characteristics

Planning Layout_6.jpg

If you would like to add the more key figures you need to add the another row for the same.

                                                                      Creation of Planner Profile

Go to the t.code: KP34

Go to the New Entries

Planning Profile_1.jpg

Double Click on the General Controlling on the Left hand side

Go to the New Entries

Select the Cost Ctrs: Cost Element / activity inputs

Planning Profile_2.jpg

Double click on the Layouts for Controlling on the left side

Go to the New Entries

Select the Layout, Integrated Excel check box and File Description

Planning Profile_3.jpg

Double Click on the Default parameters on the left side

Planning Profile_4.jpg

Click on the overview on the application menu bar

Planning Profile_5.jpg

Click on the Save file description, Save excel  layout and save the file format in the your Desktop.

                                                                 Upload of File


Fill the data according to the file format and convert in text (Tab delimited) format.

Go to the t.code: KE13 (This particular transaction code can be used for any excel upload in CO like KP26, KP06,KP46 etc.,)

Specify the File path and file description and execute

KP06_Execution_1.jpg

Execute or F8

KP06_Execution_2.jpg

File uploaded successfully.


Assigned tags

      27 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Srinivas Salpala
      Srinivas Salpala

      Hi Srinu,

      Nice end to end presentation. Keep sharing knowledge.

      BR, Srinivas Salpala

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Srinivas.

      Regards

      Srinu

      Author's profile photo Former Member
      Former Member

      Hi Srinu,

      Thank`s for sharing this document.

      Regards

      Nirabh

      Author's profile photo Alexandre Costacurta
      Alexandre Costacurta

      Hi Srinu,

      Very helpful presentation of the transactions/functionalities.

      Regards,

      Alexandre

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Alexandre.

      Regards

      Srinu

      Author's profile photo Former Member
      Former Member

      Hi Srinu,

      Good One  KP06 in nutshell.

      Regards,

      Sumit!

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Sumit,

      Thank you.

      Regards

      Srinu

      Author's profile photo Former Member
      Former Member

      Hi guys

      I tried to follow up the steps but no costs/values are showing in my cost center.Below is the screen shot.where am i missing it.

      Regards

      Rejoice

      Author's profile photo Former Member
      Former Member

      Thanks Srinu

      I have managed for certain cost centers

      I am still having problems esp with a few cost centers bt others are now okay

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi,

      Is it resolved your issue?

      Regards

      Srinu

      Author's profile photo Former Member
      Former Member

      Hi Srinu

      My issue is still pending.I would be happy if i find a solution sooner.

      Regards

      Rejoice

      Author's profile photo Former Member
      Former Member

      Nice Document Srinu.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you venkat

      Regards

      Srinu

      Author's profile photo Clinton Jones
      Clinton Jones

      can you verify that it is not possible to load real Excel files (with the extension .XLS)

      into the system. you have to store the file in Excel in the format "Text  (Tab delimited)", that is as a .TXT file ?

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Clinton,

      we can upload the excel sheet.

      Regards

      Srinu

      Author's profile photo Clinton Jones
      Clinton Jones

      but if you look at the screenshot in http://scn.sap.com/servlet/JiveServlet/showImage/38-85619-220270/KP06_Execution_1.jpg you can see it only supports CSV

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi  Clinton,

      Yes, we need to convert excel to csv file or text file.

      Regards

      Srinu

      Author's profile photo Former Member
      Former Member

      Hi Srinu

      I need help guys.I am using  FSI5  to develop a Cashflow statement .I am not sure on how to use formula for calculating increase in cash and cash equivalents ,increase in inventory etc.I understand  it should be current year minus previous year e.g Inventory /FY;&1FY.Maybe an outline of steps might help.

      regards

      Rejoice

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Rejoice,

      you have to add the formula in the Form, If you select the cash flow statement in display mode right hand corner system will show the Form for the particular Report, you can add the formula in the form.

      Regards

      Srinu

      Author's profile photo Former Member
      Former Member

      Thanks Srinu

      Maybe i wasnt very clear,in FSI5 on creating the form that is where i am having challenges.I understand the normal formula Like Y7-Y6.But when it comes to calculation of increase in cash and cash equivalents,inventory,trade receivables/payables etc it uses formula like Z045-Z044 of which Z045 might be inventory e.g Inventory /FY;&1FY.Maybe the following screen shot might help.Please take note  of the normal fomula field with Y bt when its Z it is something else.And i want to know how you come up with such Z fields.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi,

      Good question, As I know in SAP Y indicates Global and Z indicates Local.

      Regards

      Srinu

      Author's profile photo Former Member
      Former Member

      Hi Sumit,

      Very helpful  document!!

      Thanks!

      Author's profile photo Lakshmi Sama
      Lakshmi Sama

      Hi Srinu,

      Very useful and keep sharing the knowledge!

      Best Regards,

      Lakshmi S

      Author's profile photo Rajneesh Saxena
      Rajneesh Saxena

      Bro Srinu

      You helped me through this doc.

      Rajneesh

      Author's profile photo Former Member
      Former Member

      It's very helpful. Thanks!

      Author's profile photo Former Member
      Former Member

      Hi Srinu,

      Nice Document.

      Thanks for Sharing.

      Regards,

      Satya

      Author's profile photo Former Member
      Former Member

       

      Good document