Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Down loading One Million records cluster table BSET -Intersteing Challenge

Former Member

‎2011 Nov 26 8:26 PM

0 Likes
755

Hi All ,

There is a requirement to down load 1 million records from BSET table into an excel for futher analysis . We tried running the Se16 and SQVI to down load the data in back ground , but it is taking huge amount of time and still running ( > 20 Hours ) . Maximum records that we can down load into EXCEL may also be a constraint even if the job is successful .

This Quite Intersting . Could you please suggest me a way to have the whole data in BSET to be downloaded for Analysis purpose ?

Thanks in Advance .

Regards,

Dharma.

Hi All ,

There is a requirement to down load 1 million records from BSET table into an excel for futher analysis . We tried running the Se16 and SQVI to down load the data in back ground , but it is taking huge amount of time and still running ( > 20 Hours ) . Maximum records that we can down load into EXCEL may also be a constraint even if the job is successful .

This Quite Intersting . Could you please suggest me a way to have the whole data in BSET to be downloaded for Analysis purpose ?

Thanks in Advance .

Regards,

Dharma.

Reply
2 REPLIES 2
Read only

Former Member

‎2011 Nov 26 8:45 PM

0 Likes
662

Hi,

Best way to download the data is using different jobs with different selection criteria.

Use Company code/ Document number range / Financial Year as combination to download the data. May be document number range alone is a best one to be used. Give a try it should work out. You can identify the number range to be used based on the system config.

hope this helps.

Regards,

Prasanna

Read only

Former Member

‎2011 Nov 27 2:02 PM

0 Likes
662

I feel its better to write simple code of select * to download using GUI_DOWNLOAD, which can be more faster than SE16.

As it is BSET table huge FI transactions will be stored, so as prasanna suggested in your custom code you can put a selection screen with KEY field which can download data still more faster.

Correct me if im wrong.

Venkat