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?
When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.
Hannah Smalltree, Editorial Director
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).
Dig Deeper
-
People who read this also read...
This was first published in January 2005
Join the conversationComment
Share
Comments
Results
Contribute to the conversation