Skip to Content
Former Member
Jun 06, 2006 at 04:38 AM

how to write select to get data from diff tables


Hi folks,

i need to develope a report for sales tax, for that i need to get

the data from the tables bsis(fiedls budat, hkont bukrs), and

custemer number from bsid(for open items), bsad(for cleared items)

and custemer name from kna1 corresponding to bsis and from table bset(

belnr , gjahr,hwbas, txjcd) corresponding to bsis table and

i need to disply these all details using alv , how to write select for

this and how to get alv display in effient way,

pls help me to do this.

thanks in advance.