Dynamic Query

Former Member — Wed, 16 Jul 2014 21:21:52 GMT

SELECT ryear

rtcur

racct

rbukrs

SUM( tsl06 ) AS tbal

SUM( hsl06 ) AS rbal

FROM faglflext INTO TABLE lt_bal

WHERE ryear =<input> AND rbukrs IN <input> GROUP BY ryear rtcur racct rbukrs.

In the above query , how can I dynamically change the field name TSL06 based on the period. It means that if the current fiscal perid 5, dynamically, it has to come as SUM (TSL05) instead of SUM (TSL06). How can I do this ? I need this SUM only for the current fiscal period.

Re: Dynamic Query

Former Member — Wed, 16 Jul 2014 22:54:13 GMT

Hi Selva,

You can use the below code for your reference. I have used a connstant, but you can replace that with variable within the DO loop.

CONSTANTS: lv_var TYPE FIELDNAME VALUE 'TSL06',

lv_tab TYPE TABNAME VALUE 'FAGLFLEXT'.

ASSIGN LV_VAR TO <lv_field>.

ASSIGN lv_tab TO <lv_tab>.

CONCATENATE 'RYEAR' 'RTCUR' 'RACCT' 'RBUKRS' 'SUM( lv_var )' INTO lv_string SEPARATED BY space.

REPLACE ALL OCCURRENCES OF 'lv_var' IN lv_string WITH <lv_field> .

ASSIGN lv_string to <lv_string> .

SELECT (<lv_string>) FROM (<lv_tab>) INTO CORRESPONDING FIELDS OF TABLE lt_bal UP TO 10 rows.

Hope this will help.

topic Re: Dynamic Query in Application Development and Automation Discussions

Dynamic Query

Re: Dynamic Query