how to download voluminous data from SAP

[Former Member]

Hello Expert

I have a requirement of downloading all the part No. from MARA table . But the volume is very huge , is there another method of downloading them except SE16 ?

Yours sincerely

[Former Member]

HI,

You can download from se11 also i guess, if you dont want from there you can write

a report using GUI_DOWNLOAD function module to download the required data.

Regards and Best wishes.

[Former Member]

Thanks for your response.

I know SE11/SE16N , but this is not desired , because if the volume of data is more than 30000000 , the rate will be very slow.

I hope a method which can read the data from database directly and download them.

[Former Member]

Goto to SE16 => MARA execute it and press SHIFT + F8

You can download it to excel.

If you want only few fields, press CTRL + F9 and select the fields and then download.

You can do it programatically as well but its the same thing.

you will have to hit the database anyways to select the data. Be it through transaction or be it through program.

Standard transaction will be faster and perfect.

Thanks

[Former Member]

hi,

you can write a BDC for downloading data and run it in background.

The code can put all data in a flat file on your application server.

hope it helps,

Raj

[Former Member]

For truly humongous data sets and one-time requests I usually like to head over to the basis admins and bug them to do a quick extract on database level. As long as that is in compliance with your company's security policies and the data is not considered confidential this should be ok (but be sure to check, to avoid getting anybody into trouble).

With compression (gzip or zip) the huge data extracts usually come down to nice manageable files (at least that's true in the western world with mostly ASCII data on key fields, your mileage may vary).

I know it's a silly suggestion, but just in case it hadn't crossed your mind yet, I thought I'd mention it (especially since in SE16 sooner or later you'll hit the memory limit and it's just plain awkward to package the data into chunks by specifying for example material number ranges).

Cheers, harald

[Former Member]

As a Function Engineer , I only know how to download data using SE16/SE11 , normally I just download little data for analysis . But this time , I want to download all the part No. from MARA table , the volume will be very huge. If through SE16 , I am afraid memory capacity and Basis Admin. So I want to know if there is a method or T-code which is designed to download data ?

[Former Member]

Just a thought in that case...

Find the "Created On" date of the very first material.

Starting from that year, hit select on mara with the condition on "created on" date.

Get yearly chunks programatically and put it on application file.

In next iteration, get data for the next year and append the file.

You may filter the selection on quarters or half yearly or even monthly if the yearly volume is high.

Just a vague idea I know but I guess this will be a one time activity.