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?

    Requires Free Membership to View

    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

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.