Problem solve Get help with specific problems with your technologies, process and projects.

Importing cost element plan data into SAP 3.1

I want to import cost element plan data from a spreadsheet into SAP 3.1. What is the simplest way to do this?

There are software packages available off the shelf designed to automatically upload spreadsheet data into SAP. Some of the more sophisticated ones are written in Visual Basic, but the operation is similar to macros: Go down one cell, move right two cells, grab the value in that cell, switch to SAP, paste the value here, switch back to the spreadsheet and repeat the process.

These programs require discipline in the spreadsheets - the next number to be input should always be the same relative cell reference (for example, down one cell then right two cells). Otherwise, you'll have a tough time programming the upload software to handle the inconsistencies in spreadsheet locations.

This was last published in May 2002

Dig Deeper on SAP financial management

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.