how to create a dynamic field sql?

former_member625844 — Mon, 18 May 2020 09:48:03 GMT

I want to query data from faglflext table by given accounting period. In this table each month is a column. like HSL01,HSL02,HSL03....I wonder is it possible to dynamcie create a SQL like select HSL01,HESL02,...from select-options. Such as if I enter accounting period as 3 to 5, then the SQL is select HSL03,HSL04,HSL05...like. I wonder can EXEC be used for that? Thx.

Re: how to create a dynamic field sql?

MateuszAdamus — Mon, 18 May 2020 10:21:34 GMT

Hi loki_luo15

Something like this?

PARAMETERS: p_prstr TYPE i.
PARAMETERS: p_prend TYPE i.

DATA:
  lv_period TYPE n LENGTH 2,
  lt_fields TYPE TABLE OF string.

lv_period = p_prstr.
WHILE lv_period <= p_prend.
  APPEND |HSL{ lv_period }| TO lt_fields.
  lv_period = lv_period + 1.
ENDWHILE.

SELECT (lt_fields)
  FROM faglflext
  INTO TABLE lt_results

You could also retrieve all HSL fields, for all months and then read the data only from fields for which the period was specified on the selection screen.

Regards,

Mateusz

topic Re: how to create a dynamic field sql? in Application Development and Automation Discussions

how to create a dynamic field sql?

Re: how to create a dynamic field sql?