topic SELECT statement dynamic in Application Development and Automation Discussions

SELECT statement dynamic

f_allocca — Wed, 11 Nov 2020 11:39:01 GMT

Hello experts,

I have to make a program that extracts fields according to a select options, my select already extracts two static fields (fieldA fieldB) and I should add the fields of the select-options in input

example

select-options = 1 - 3

SELECT fieldA fieldB field1 field2 field3

How can I it?

thanks

Re: SELECT statement dynamic

sergey_muratov — Wed, 11 Nov 2020 11:47:48 GMT

Hi.

May be this link help you.

Re: SELECT statement dynamic

ClausB — Thu, 12 Nov 2020 09:44:47 GMT

should help

  DATA lt_sflight type TABLE OF sflight.
  DATA lt_column TYPE TABLE OF char32.

  lt_column = VALUE #( ( 'CARRID' )
                       ( 'CONNID' )
                       ( 'FLDATE' )
                       ( 'PRICE' ) ).

  SELECT (lt_column) FROM sflight INTO CORRESPONDING FIELDS Of TABLE lt_sflight.

Re: SELECT statement dynamic

RaymondGiuseppi — Thu, 12 Nov 2020 13:43:46 GMT

Press F1 on SELECT statement and look for 'column' in the documentation.