SELECT statement performance in ABAP compared to SE16N
We have one custom program which has been running fine. Now, we have added following code and program is taking 5-7 minutes compared to 8-10 seconds. SELECT ACCVOUCHERNO EWBNUMBER FROM ZDIGI_OOWARD_H INTO TABLE gt_zdigi_ooward_h FOR ALL ENTRIES IN gt_vbrk WHERE ACCVOUCHERNO = gt_vbrk–vbeln. Number of records in gt_vbrk is approx. 2000 (rows and 2 columns) and using gt_vbrk-vbeln values in SE16N is taking max. 15 seconds. Also, ACCVOUCHERNO is key field …
SELECT statement performance in ABAP compared to SE16N Read More »