topic Re: dynamic database table in a select statement in Application Development and Automation Discussions

dynamic database table in a select statement

Former Member — Wed, 15 Aug 2007 04:11:26 GMT

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 — Wed, 15 Aug 2007 04:17:38 GMT

yes it can possiable.

Former Member — Wed, 15 Aug 2007 04:35:08 GMT

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 — Wed, 15 Aug 2007 05:15:18 GMT

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 — Wed, 15 Aug 2007 05:26:00 GMT

Thank you.

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