07-03-2007 1:49 PM
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
07-03-2007 2:01 PM
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
07-03-2007 2:01 PM
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
07-03-2007 2:22 PM
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.
07-03-2007 2:36 PM
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.
07-03-2007 2:01 PM
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.
07-03-2007 2:04 PM
HI,
It will take Approx - max 86000 records in abap query.
regards,
Nandha
Reward if it helps