Skip to Content
0
Former Member
Apr 17, 2009 at 10:08 AM

classical report

20 Views

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&regards

deepika.