Skip to Content
0
Former Member
Aug 02, 2007 at 08:35 AM

performance problem with KONV table

307 Views

SELECT vbrkvbeln vbrkerdat vbrkkunrg vbrkxblnr

vbrkmwsbk vbrkknumv vbrkfksto vbrpposnr

INTO TABLE it_vbrk

from ( vbrk as vbrk

inner join vbrp as vbrp on vbrkvbeln eq vbrpvbeln )

WHERE vbrk~vkorg IN s_vkorg

AND vbrk~vtweg IN s_vtweg AND

vbrk~spart IN s_spart AND

vbrk~erdat IN s_fkdat AND

vbrkkunrg IN s_kunrg AND vbrkfkart IN s_fkart

AND vbrk~sfakn EQ ''

AND vbrk~vbeln IN s_vbeln

and vbrp~pstyv in s_pstyv.

loop at it_vbrk.

move-corresponding it_vbrk to w_komk.

CALL FUNCTION 'RV_KONV_SELECT'

EXPORTING

comm_head_i = w_komk

tables

tkomv = it_komv.

.

endloop.

In the above code I getting strucked up while retrieving data from KONV table,

It is taking long time and closing up, Can any body suggest me any betterway to retrieve the data from KONV or provide me any BAPI, if available.

Thanks in Advance,

Regards

Ravi