topic Re: Need dynamic select statement in Application Development and Automation Discussions

Need dynamic select statement

Former Member — Wed, 10 Apr 2013 09:09:13 GMT

data : gv_string type c.

concadinate 'ce4' p_bukkrs into gv_string.-----> gv_string having my table name gv_string is dynamicaly (ex. ce4100 , ce430000 ce49000 like that )

i need to select some fields from that table (gv_string)

select * from
gv_string -
into table gt_acct.

am getting error any solution to select the fields from gv_string

Re: Need dynamic select statement

Former Member — Wed, 10 Apr 2013 09:53:57 GMT

Hi,

try this example

REPORT ztx1406.

data : gv_string type string

data:it_mara type STANDARD TABLE OF mara.

CONCATENATE 'MA' 'RA' into gv_string.

select * from

(gv_string)

into table it_mara.

select * from

(gv_string)

into table gt_acct.

Re: Need dynamic select statement

former_member194152 — Wed, 10 Apr 2013 09:59:13 GMT

Specifying Source dynamically :

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.

Specifying Column dynamically :

DATA: itab TYPE STANDARD TABLE OF spfli,

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.

wa LIKE LINE OF itab.

ENDIF.