Select statement

Former Member — Thu, 12 Jun 2008 11:08:45 GMT

Hi expert,

Can a select statement be used for dynamic fields say for eg.

select ..FIELDS from SOME_TABLE into corresponding INT_TAB.....

If yes then can we use join condition on such a dynamic select statement.

<REMOVED BY MODERATOR>

Kshitija

Edited by: Alvaro Tejada Galindo on Jun 12, 2008 4:59 PM

Re: Select statement

Former Member — Thu, 12 Jun 2008 11:16:43 GMT

Hi,

You can use dynamic filed in query as given below.

TYPES:

BEGIN OF st_bseg,

bukrs LIKE bseg-bukrs,

belnr LIKE bseg-belnr,

dmbtr LIKE bseg-dmbtr,

END OF st_bseg.

DATA:

sel_list TYPE STANDARD TABLE OF edpline,

li_bseg TYPE STANDARD TABLE OF st_bseg,

l_bseg TYPE st_bseg.

START-OF-SELECTION.

APPEND 'bukrs belnr dmbtr' TO sel_list.

SELECT (sel_list)

FROM bseg UP TO 100 ROWS

INTO TABLE li_bseg.

LOOP AT li_bseg INTO l_bseg.

WRITE : / l_bseg-bukrs, l_bseg-belnr, l_bseg-dmbtr.

ENDLOOP.