KP06 Excel Upload
Creation of Planning Layout
Go to t.code: KP65
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
Create the 3 Leading columns.
Double click on the 1st Leading Column for Cost Centers
Double Click on the 2nd Leading Column for Cost Elements
Double click on the 3rd Leading column for Activity types
Double click on the next row key figure with characteristics
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
Double Click on the General Controlling on the Left hand side
Go to the New Entries
Select the Cost Ctrs: Cost Element / activity inputs
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
Double Click on the Default parameters on the left side
Click on the overview on the application menu bar
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
Execute or F8
File uploaded successfully.
Hi Srinu,
Nice end to end presentation. Keep sharing knowledge.
BR, Srinivas Salpala
Thanks Srinivas.
Regards
Srinu
Hi Srinu,
Thank`s for sharing this document.
Regards
Nirabh
Hi Srinu,
Very helpful presentation of the transactions/functionalities.
Regards,
Alexandre
Thank you Alexandre.
Regards
Srinu
Hi Srinu,
Good One KP06 in nutshell.
Regards,
Sumit!
Hi Sumit,
Thank you.
Regards
Srinu
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
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
Hi,
Is it resolved your issue?
Regards
Srinu
Hi Srinu
My issue is still pending.I would be happy if i find a solution sooner.
Regards
Rejoice
Nice Document Srinu.
Thank you venkat
Regards
Srinu
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 ?
Hi Clinton,
we can upload the excel sheet.
Regards
Srinu
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
Hi Clinton,
Yes, we need to convert excel to csv file or text file.
Regards
Srinu
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
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
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.
Hi,
Good question, As I know in SAP Y indicates Global and Z indicates Local.
Regards
Srinu
Hi Sumit,
Very helpful document!!
Thanks!
Hi Srinu,
Very useful and keep sharing the knowledge!
Best Regards,
Lakshmi S
Bro Srinu
You helped me through this doc.
Rajneesh
It's very helpful. Thanks!
Hi Srinu,
Nice Document.
Thanks for Sharing.
Regards,
Satya
Good document