hi this is your solution...
report .
tables:likp .
data: begin of it_final occurs 0,
vbeln like likp-vbeln,
tknum like vttp-tknum,
fknum like vfkk-fknum,
end of it_final .
data: begin of itab occurs 0,
vbeln like likp-vbeln,
vbtyp like likp-vbtyp,
end of itab .
data: begin of itab1 occurs 0,
vbeln like likp-vbeln,
tknum like vttp-tknum,
end of itab1 .
data: begin of itab2 occurs 0,
vbtyp like vfkk-vbtyp,
fknum like vfkk-fknum,
end of itab2.
select-options:s_vbeln for likp-vbeln .
select vbeln
vbtyp
from likp
into table itab
where vbeln in s_vbeln .
select vbeln
tknum
from VTTP
into table itab1
for all entries in itab
where vbeln = itab-vbeln.
select VBTYP
fknum
from vfkk
into table itab2
for all entries in itab
where vbtyp = itab-vbtyp .
loop at itab .
it_final-vbeln = itab-vbeln.
read table itab1 with key vbeln = itab-vbeln.
it_final-tknum = itab1-tknum.
read table itab2 with key vbtyp = itab-vbtyp.
it_final-fknum = itab2-fknum .
append it_final .
endloop .
loop at it_final.
write:/ it_final-vbeln,
it_final-tknum,
it_final-fknum.
endloop.
regards,
venkat.
Bluesky
