08-02-2007 9:35 AM
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
08-02-2007 9:59 AM
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
08-02-2007 10:31 AM
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