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).
Dig Deeper on SAP Basis
Related Q&A from Axel Angeli
An SAP user is receiving an error message while integrating SAP iDoc PORDCR1 for a purchase order. Continue Reading
SAP expert Axel Angeli explains how to update the "further dates" tab information in am SAP transaction through an SAP IDoc. Continue Reading
An SAP R/3 4.7 user wants looking to post a document entry using different trading partner fields for credit and debit for function FB01. Continue Reading