database table

Moderator message: please use meaningful subject in future

select kunnr from <fv_kna1>...

This fv_kna1 contains the db name KNA1...

The requirement is that.. im having 3 to 4 tables which are having the same structure and extraction is also similar for all the tables.

Instead of extracting each time.. can i assign a variable that can be used as a db table..

I hav tried but its not working but however trying to check for other approaches...

It would be helpfull i anyone can provide the solution.

Thanks,

Rohith

Edited by: Matt on Nov 21, 2008 10:02 AM