Dear Surya,
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>
With Regards,
Akshay
Moderator message: "correct answer" removed.
Message was edited by: Thomas Zloch
hi ,
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.
Regards..
Surya
