This website is not affiliated with, sponsored by, or approved by SAP AG.

KP06 Cost Centre Planning - Upload??

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, darkduck, Baz

KP06 Cost Centre Planning - Upload??

Postby NANDTALK » Mon Dec 05, 2005 6:31 am


Am working on Version 5 SAP R/3. In TC KP06 for Cost Centre Planning., I find a Extra>Excel Planning> Upload.. But I dont find provision for upload of the same into SAP.

Could any of the CO Guru`s out there help me out. Client wants a directupload through Excel and the PM does not want a BDC/LSMW for the same

Thanks in anticipation

Postby Ruler » Mon Dec 05, 2005 7:19 am

I remember you have the possibility to define an excel format in which you can plan and later on upload it again. Crucial as far as I can remember is that the format is defined in SAP first and then downloaded for further planning.
Posts: 275
Joined: Wed Mar 30, 2005 4:35 am
Location: Paradise...

Postby NANDTALK » Mon Dec 05, 2005 7:28 am

Tried to do just that... Personal Profile in Config Settings.. and coming upto Layout level.. then what???

Postby JCravero » Mon Dec 05, 2005 1:33 pm

1 Define a layout (or find an existing one you like)
2 Assign the layout to a profile and click the Int.Excel ON
3 Step through the default parameters screen.
4 Save the Excel layout
5 Back through the default parameters screen without saving (or you will force default cost center, year, etc into the KP06 online screen)
6 Name the File Description
7 Now in KP06 > Extras > Excel Planning > Upload, there should be available the File Description.
Posts: 358
Joined: Mon Oct 28, 2002 12:14 pm
Location: Illinois

Postby NANDTALK » Tue Dec 06, 2005 7:17 am

Sorry Cravero.

Am not able to save & download the Excel file in STEP 4..

Also when i give the FILE DESCRIPTION, the system is not picking up and displaying in KP06..

Please note that am using Version 5 of SAP.


Return to Financials

Who is online

Users browsing this forum: No registered users and 2 guests

This website is not affiliated with, sponsored by, or approved by SAP AG.