Linking Excel to SAP
I am trying to upload Excel s/sheet data onto SAP. I can record the data in SAP eg the fields that need to be populated etc and than download those in Excel to be populated accordingly. How do I link the data from the s/sheet to SAP? Is this a VB question or SAP?
I can not get it to work.
This is an SAP issue and it is handled using the "Data Transfer Workbench"(Transaction SXDA) or the "Legacy System Migration Workbench" (available as transports from SAPServX) and then Batch Input sessions. However, it is possible to write a VB program that reads the data from Excel and puts it in SAP. This is a more complicated method, though. And, you need to use the GUI Automation.
I recommend you get a free copy of the "Data Transfer Made Easy" guidebook at www.saplabs.com or directly at http://wwwtech.saplabs.com/datatransfer/default.asp
This guidebook will provide you all the information you need.
Dig Deeper on SAP Basis
Related Q&A from Giovanni Davila
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila. Continue Reading
Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip. Continue Reading
Describes how to run transaction SU01 to verify if CUA is used on an SAP system. Continue Reading