bmarsmasker
asked on
Eporting data from SAP 4.6C into a file or datawarehouse for Microsoft Access 2003 use.
What is the best version to download SAP into. Lotus 123 WK has a space allotment of 2 meg. Excel works, but there there has to be a bunch of manual manipulation to make it work.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
The best way to send the data would still be a CSV file usable by most applications. However, you'd need to segement the data export into more than one file if you're hitting a limit. Automatic segmentation is however not available in all SAP applications. Generally speaking manual splitting of the CSV file is the easiest way if you're only talking something done a few times. If automation is required, you may want to create a small ABAP program that will select and export the data you deisre in sufficiently small bits. However, if you choose to use ABAP, default output will be to the SERVER, not your client as the client may not (and indeed NEED not) be available during processing of the report. So you need to transfer data from the server before further processing.