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: 

performance problem with KONV table

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

Hi,

Try using FM 'KONV_BUFFER_READ'

if this also doen't improve performance try to write u r own code to select required data from the KONV. As u r caling FM inside loop ...endloop it will supress performance. So better to use select with FOR ALL ENTRIES on KONV table.

Regards,

Sankar

Former Member
0 Kudos

since KNUMU is key field in KONV, use for all entries for KONV select.

select * from konv

into table it_konv

for all entries in it_vbrk

where knumv = it_vbrk-knumv.

Cheers

Hema