Skip to Content
0
Former Member
Mar 05, 2009 at 08:25 AM

Performance

58 Views

Hi Frnds,

I have a program.

in that requirement is like first fetch kdgrp from kotg908 table then..using KDGRP,......fetch knumh from a910 table..

then using knumh fetch kbetr from konp table..

Ihave written coding for the above requirement as below..

SELECT * FROM kotg908 INTO CORRESPONDING FIELDS OF TABLE i_extract_kotg

WHERE kappl EQ c_sales AND

kschl EQ c_cond_type AND

vkorg EQ p_sorg AND

vtweg EQ p_dich AND

spart EQ p_div AND

zzkonda IN s_cpg AND

kondm IN s_mpg AND

datbi GE sy-datum AND

datab LE sy-datum.

IF sy-subrc = 0.

LOOP AT i_extract_kotg WHERE zzkonda IN s_cpg.

SELECT knumh FROM a910 INTO TABLE i_extract_910

WHERE kappl EQ c_sales AND

kschl EQ c_cond_type AND

vkorg EQ p_sorg AND

vtweg EQ p_dich AND

spart EQ p_div AND

kdgrp EQ i_extract_kotg AND

datbi GT sy-datum AND

datab LE sy-datum.

IF sy-subrc = 0.

LOOP AT i_extract_910.

SELECT SINGLE kbetr FROM konp INTO i_extract_910-kbetr

WHERE knumh EQ i_extract_910-knumh.

can u suggest a better way as per performance? Plaese..