topic performance problem with KONV table in Application Development and Automation Discussions

performance problem with KONV table

Former Member — Thu, 02 Aug 2007 08:35:28 GMT

SELECT vbrk_{vbeln vbrk}erdat vbrk_{kunrg vbrk}xblnr

vbrk_{mwsbk vbrk}knumv vbrk_{fksto vbrp}posnr

INTO TABLE it_vbrk

from ( vbrk as vbrk

inner join vbrp as vbrp on vbrk_{vbeln eq vbrp}vbeln )

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

vbrk_{kunrg IN s_kunrg AND vbrk}fkart 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

Re: performance problem with KONV table

Former Member — Thu, 02 Aug 2007 08:59:11 GMT

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

Re: performance problem with KONV table

Former Member — Thu, 02 Aug 2007 09:31:57 GMT

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