topic Re: Dynamic SQL with field symbol in Application Development and Automation Discussions

Dynamic SQL with field symbol

tim82 — Tue, 13 Oct 2020 17:25:14 GMT

Hi experts,

my requirement seems a little weird, but maybe you can help me.

We have a custom db-table, which comes with two colomns: table and field.

In this table (ZB01), the customer has values like KNA1 & NAME1, or KNVV & AUFSD.

The customer number is always known.

I would like to know, if it is possible to create a dynamic select with dynamic output like:

DATA: LT_ZB01 type STANDARD TABLE OF zb01.

Select * from zb01 into TABLE lt_zb01.

loop at lt_zb01 ASSIGNING FIELD-SYMBOL(<zb01>).

Select single (<zb01>-FIELD) from (<zb01>-TABLE)
into @data(lv_var)
where
kunnr = '0000030047'.
ENDLOOP.

In this custom table, there could be any table and table-field coming to have being selected.

I have tried with creation of "type ref to data" and @data(var) as output, but nothing works.

Is this possible? (We are in a S/4HANA environment)

Thanks in advance

Re: Dynamic SQL with field symbol

Sandra_Rossi — Tue, 13 Oct 2020 19:42:22 GMT

Please use the CODE button when you post code.

Re: Dynamic SQL with field symbol

Sandra_Rossi — Tue, 13 Oct 2020 19:42:53 GMT

You have to create the data object dynamically:

DATA dref_field TYPE REF TO data.
FIELD-SYMBOLS <field> TYPE ANY.

CREATE DATA dref_field TYPE (<zb01>-field).
ASSIGN dref_field->* TO <field>.

Select single (<zb01>-FIELD) 
    from (<zb01>-TABLE)
    into @<field>
    where kunnr = '0000030047'.

Of course, handle all exception situations like field is not valid...

Re: Dynamic SQL with field symbol

tim82 — Tue, 13 Oct 2020 19:49:26 GMT

Thank your very much, this works!

Re: Dynamic SQL with field symbol

RaymondGiuseppi — Thu, 15 Oct 2020 10:16:25 GMT

Don't tag your own answer as the correct one, tag sandra.rossi's one.