Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Maximum number of records fetched by ABAP Query

Former Member
0 Kudos

Hi Experts,

Please tell me what is the specific maximum numbers of records that can be handled by an ABAP Query.

Thanks in advance.

Regards,

Bilal

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi Bilal

an abap query can handle any number of records

<b>u know we tested for it and it went around 15 hours handling the data</b>

i dont think it was worth wasting time on it

so it depends upon ur requirement

regards

ravish

reward if useful

5 REPLIES 5

Former Member
0 Kudos

hi Bilal

an abap query can handle any number of records

<b>u know we tested for it and it went around 15 hours handling the data</b>

i dont think it was worth wasting time on it

so it depends upon ur requirement

regards

ravish

reward if useful

0 Kudos

As Nandha says "It will take Approx - max 86000 records in abap query."

It might take more than 15 hours to handle 86000 records.

This question arised, because i'm getting the 'time exceed' dump.

If using 'PACKAGE' can solve this, can you please tellme how to/ where to use 'PACKAGE' in SQ02(Infoset)

Thanks for response.

0 Kudos

Use a query similar to this.....

SELECT EBELN " Purchasing Document Number

ERNAM " Name of Person who Created

" the Object

LIFNR " Vendor's account number

EKGRP " Purchasing group

BEDAT " Purchasing Document Date

FROM EKKO

PACKAGE SIZE 10000

APPENDING TABLE T_EBELN

WHERE EBELN IN S_EBELN.

ENDSELECT.

Don't forget to write ENDSELECT.

Regards,

Pavan P.

Former Member
0 Kudos

We can select as many records as we like.

If the program goes for a dump, when ever we try to select more records,

use 'PACKAGE SIZE' option in the select query, so that all the records can be fetched in the form of packages.

Regards,

Pavan P.

Former Member
0 Kudos

HI,

It will take Approx - max 86000 records in abap query.

regards,

Nandha

Reward if it helps