Skip to Content
0
Former Member
Jun 04, 2008 at 08:06 PM

Performance issue fetching huge number of record with "FOR ALL ENTRIES"

29 Views

Hello,

We need to extract an huge amount of data (about 1.000.000 records) from VBEP table, which overall dimension is about 120 milions records.

We actually use this statements:

CHECK NOT ( it_massive_vbep[] IS INITIAL ) .

SELECT (list of fields) FROM vbep JOIN vbap

ON vbepvbeln = vbapvbeln AND

vbepposnr = vbapposnr

INTO CORRESPONDING FIELDS OF w_sched

FOR ALL ENTRIES IN it_massive_vbep

WHERE vbep~vbeln = it_massive_vbep-tabkey-vbeln

AND vbep~posnr = it_massive_vbep-tabkey-posnr

AND vbep~etenr = it_massive_vbep-tabkey-etenr.

notice that internal table it_massive_vbep contains always records with fully specified key.

Do you think this query could be further optimized?

many thanks,

-Enrico