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..