hi friends.
what is wrong in this logic?
6666( kunnr ) is not available in vbak but available in kna1 eventhough it is displaying in the output as like few more records also displaying.
i have to generate output list where kna1-kunnr = vbak-kunnr.
tables : vbak,kna1 .
data : begin of itab occurs 0,
kunnr like vbak-kunnr,
adrnr like kna1-adrnr,
land1 like kna1-land1,
name1 like kna1-name1,
name2 like kna1-name2,
ort01 like kna1-ort01,
pstlz like kna1-pstlz,
regio like kna1-regio,
telf1 like kna1-telf1,
telfx like kna1-telfx,
end of itab.
select-options : s_kunnr for vbak-kunnr.
select vbakkunnr kna1adrnr kna1land1 kna1name1 kna1name2 kna1ort01 kna1pstlz kna1regio kna1telf1 kna1telfx
into table itab
from vbak
inner join
kna1 on vbakkunnr = kna1kunnr where vbak~kunnr in s_kunnr.
loop at itab.
write : /10 itab-kunnr,25 itab-adrnr,40 itab-land1,60 itab-name1,80 itab-name2,100 itab-ort01,120 itab-pstlz,140 itab-regio, 160 itab-telf1, 180 itab-telfx.
endloop.
can anyone suggest.
thanks®ards
deepika.