topic Re: Standard function for SELECT??? in Application Development and Automation Discussions

Standard function for SELECT???

Former Member — Tue, 17 Apr 2007 07:52:42 GMT

I need to do a dynamic select, because i only know table name dynamically.

I found DB_UPDATE_TABLE for update operations, but i need a similar function for select??

Any ideas???

Re: Standard function for SELECT???

Former Member — Tue, 17 Apr 2007 07:54:35 GMT

Hi Jose,

please check the link

<a href="/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap">/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap</a>

Regards

Re: Standard function for SELECT???

Former Member — Tue, 17 Apr 2007 07:55:23 GMT

Hi,

check this code...

*----- 

For dynamic table name.... 

REPORT demo_select_dynamic_database . 

DATA wa TYPE scarr. 
DATA name(10) TYPE c VALUE 'SCARR'. 

SELECT * 
INTO wa 
FROM (name) CLIENT SPECIFIED 
WHERE mandt = '000'. 
WRITE: / wa-carrid, wa-carrname. 
ENDSELECT. 

*-----

<b>For dynamic field list</b>

REPORT demo_select_dynamic_columns . 

DATA: itab TYPE STANDARD TABLE OF spfli, 
            wa LIKE LINE OF itab. 
DATA: line(72) TYPE c, 

list LIKE TABLE OF line(72). 

line = ' CITYFROM CITYTO '. 

APPEND line TO list. 

SELECT DISTINCT (list) 
INTO CORRESPONDING FIELDS OF TABLE itab 
FROM spfli. 

IF sy-subrc EQ 0. 

LOOP AT itab INTO wa. 
WRITE: / wa-cityfrom, wa-cityto. 
ENDLOOP. 

ENDIF.

Regards

Sudheer

Re: Standard function for SELECT???

athavanraja — Tue, 17 Apr 2007 08:35:30 GMT

you can also use RFC_READ_TABLE