Relate between two tables in ALV REPORT(SAP-ABAP)

Hi

tables: kna1

select single KUNNR name1 ort01 from kna1 where kunnr = vbrk-kunrg.

or

select single KUNNR name1 ort01 from kna1 where kunnr = vbrk-kunag.

write: / kna1-kunnr, kna1-name1, kna1-ort01.

<b>

link between tables is

VBRK-KUNAG = KNA1-KUNNR (customer/Sold to party)

Reward points for useful Answers</b>

Regards

Anji

Message was edited by:

Anji Reddy Vangala

if condition.

select single * from kna1 into kna1 where

where kunnr = kna1-kunnr.

else.

select single * from kna1 into kna1

where kunnr = vbrk-kunag.

endif.

hi bapi,

u can relate the 2 tables by relating the fields kna1-kunnr = vbrk-kunag....

hope this will help u out..

please reward points in case usefull...

regards,

prashant