dynamic database table in a select statement

[Former Member]

Please let me know, if the following statement is possible in SAP release 45B?

select * from (tabname) where x = y.

tabname is defined as data: tabname type dd08v-tabname.

Thanks in advance.

[Former Member]

yes it can possiable.

[Former Member]

Hi,

This is correct syntax. without saying INTO TABLE or INTO WORKAREA it won't allow.

select *

from tabname

into table internal_tabname

where conditon.

select *

from tabname

into workarea

where conditon.

Regards,

Surya

[Former Member]

hi ,

take care that table name should be defined as:

data: tabname type dd08v-tabname Value 'MARA.

select * from (tabname) into table itab where x = y.

Revert back if any issues,

Rewadr with points if helpful.

Regards,

Naveen

[Former Member]

Thank you.

I have written the table name in small letters which caused the error.