Do the following steps
1. Generate the view of your table.
2. Assign transaction to your view using SE93.
3. Call that view(transaction code) in your report as follows:
CALL TRANSACTION "T-code of your View".
To assign t-code to your view go through the following link.
<link to blocked site removed by moderator>
Moderator message: "correct answer" removed.
Message was edited by: Thomas Zloch
go to SE11 and click on the view radio button. click create and u get 4 type of views. select database views. database views are created using "INNER JOINS".
in "table/joins conditions " screen, give the two table names which you to join using views.And then in "view flds" tab, give the field names u want to use.
U can use them in abap sql just like any other table name.