2 Replies Latest reply: Aug 2, 2007 11:31 AM by Hemalingeswar Polisetty RSS

performance problem with KONV table

ravi g
Currently Being Moderated

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

Actions