pick up data from different legacy systems to an excel sheet...
I have to pick data from 4 different legacy systems into an excel sheet(mapping data available) and then upload whole data into SAP using transaction ME21N..How should i proceed..
I have to create 4 separate files first and then transfer the combined data into an excel sheet...Plzz explain the steps??
Also explain how to append data of one file to another and den combine whole into an excel sheet.
Assume that the 4 files have same number of fields 40 .
please give me the detailed steps..by an example if possible