How to do a select from a table whose name is saved in a field?

[Former Member]

Hello,

This is an abap report.

I need to do a select from a table whose name is saved in a field of Z* table.

Like this..

SELECT * FROM znodos.

SELECT * FROM znodos-tabla. "znodos-tabla contain the Z* table name

move zodos-tabla-txtmd to.....

.....

endselect.

endselect.

Is this possible??

Thanks

[Former Member]

Hi Ilie Aleman

Give variable name in ().. Variable name refers to variable which contains table name

SELECT * FROM (znodos-tabla).

Regards,

Mohaiyuddin

Edited by: Mohaiyuddin Soniwala on Jan 22, 2008 5:18 PM

[jack_graus2]

SELECT * FROM (znodos-tabla) INTO INTO CORRESPONDING FIELDS OF ....

ENDSELECT.

Regards Jack