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...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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).
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.