topic Select Query in Application Development and Automation Discussions

Select Query

Former Member — Wed, 07 Nov 2007 06:16:51 GMT

Hi Freinds,

I have a small doubt.

What I am doing is....I have a custom table,which will contain entries this way.

CONDITION TABLE NAME

A MARA

B VBAK

C EKKO

So,based on the condition I need to fire a Select Query on the respective table.

I am doing the selection in a subroutine.

Now,I am Selecting from v_tabname...v_tabname contains table name.

But,this is an error, coz Select query always allows to select from DB table.

Is there any way to dynamically get the table name in Select Query.

Any Object Programming ?

Eg., SELECT FROM TABNAME

Regards,

Imran.

varma_narayana — Wed, 07 Nov 2007 06:18:38 GMT

hi.

sample code:

REPORT ZSEL_BGJOB.

DATA : REF_TAB TYPE REF TO DATA.

FIELD-SYMBOLS: <FTAB> TYPE TABLE.

DATA: L_TABNAME TYPE DD02L-TABNAME VALUE 'EKPO'.

CREATE DATA REF_TAB TYPE TABLE OF (L_TABNAME).

ASSIGN REF_TAB->* TO <FTAB>.

SELECT * FROM (L_TABNAME) INTO TABLE <FTAB>.

DESCRIBE TABLE <FTAB>.

WRITE:/ SY-TFILL.

Reward if Helpful.

Former Member — Wed, 07 Nov 2007 06:20:25 GMT

U can refer these links:

http://www.sap-img.com/abap/how-can-we-give-dynamic-table-name-in-select-statement.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/67/93b80914a911d2953c0000e8353423/content.htm

Thanks

Vasudha