Q

Upload data from Excel to SAP

I am new to SAP and would like to know how to upload data from an Excel sheet into the SAP scenario, like, if we are given customer master and material master data in Excel sheets, how do we upload this into the SAP scenario?

SAP does not support direct upload of Excel native format. You may export the data (save to file as .csv) and use the function GUI_UPLOAD or WS_UPLOAD. Then you have to convert the ASCII file into appropriate structures
(hint: command SPLIT ..into itab is very helpful).

This was first published in January 2005

Dig deeper on SAP Basis administration and NetWeaver administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close