topic Re: Dynamic Select Query with dynamically determined fields and table in Application Development and Automation Discussions

Dynamic Select Query with dynamically determined fields and table

Former Member — Tue, 11 Nov 2014 15:18:00 GMT

Hello Experts,

I have got a requirement in which I have to fetch the table name from table TAB1 and fields from table TAB2.

I am not sure which all fields will be present in TAB2 and hence I cannot do a Select * on TAB1. I have to select only those fields which are mentioned in TAB2.

Can anyone suggest which logic with some code so that this requirement can be fulfilled.

Thanks

Jaydeep

Re: Dynamic Select Query with dynamically determined fields and table

Former Member — Tue, 11 Nov 2014 15:39:46 GMT

Hello,

Have a look at this:

DATA: itab TYPE STANDARD TABLE OF spfli,
wa LIKE LINE OF itab.

DATA: line(72) TYPE c,

list LIKE TABLE OF line(72).

parameters: p_table(30) type c default 'T001'.

line = ' CITYFROM CITYTO '.

APPEND line TO list.

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

IF sy-subrc EQ 0.

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

ENDIF.

(most parts copied from How can we give dynamic table name in select statement?)

br,

Nikolaus

Re: Dynamic Select Query with dynamically determined fields and table

Former Member — Tue, 11 Nov 2014 16:24:58 GMT

hi jaydeep,

do you mean to say that TAB1 has table names and TAB2 has corresponding fields?

Your requirement is to make a select query based on the parameter of table name from TAB1 isnt't?

Re: Dynamic Select Query with dynamically determined fields and table

Former Member — Wed, 12 Nov 2014 06:33:46 GMT

Yes Abdul. First line of your statement is right.

I will have to pick up only those fields from table which will be mentioned in TAB2.

Re: Dynamic Select Query with dynamically determined fields and table

Former Member — Wed, 12 Nov 2014 08:21:22 GMT

I got the way out guys with help of Nikolaus Harrich.

DATA: line(72) TYPE c,

list LIKE TABLE OF line(72).

*ITAB2

LOOP AT gt_fields INTO gs_fields.

MOVE gs_fields-field_name TO line.

APPEND line TO list.

ENDLOOP.

*ITAB1

READ TABLE gt_table INTO gs_table INDEX 1.

IF sy-subrc = 0.

IF gs_table-where2 IS NOT INITIAL.

MOVE gs_table-where2 TO line.

ENDIF.

IF gs_table-where3 IS NOT INITIAL.

CONCATENATE line 'AND' INTO line SEPARATED BY space.

CONCATENATE line gs_table-where3 INTO line SEPARATED BY space.

ENDIF.

* SELECT data FROM table.

SELECT (list)

INTO CORRESPONDING FIELDS OF TABLE <dyn_table>

FROM (p_table)

WHERE (line).

Thanks Nikolaus !