topic Re: SELECT Max where column is dynamic in abap program in Application Development and Automation Discussions

SELECT Max where column is dynamic in abap program

Former Member — Sun, 10 Mar 2013 06:14:28 GMT

How to perform a SELECT MAX query where the column is dynamic in abap program?

This is how the code looks like:

FORM get_max_ref_field USING    p_tabname
                                                   p_field
                         CHANGING p_max_date.

      SELECT MAX( p_field ) INTO p_max_date
     FROM (p_tabname).

ENDFORM.                    " GET_MAX_REF_FIELD

Thanks,

Vika

Re: SELECT Max where column is dynamic in abap program

Aliaksandr — Sun, 10 Mar 2013 13:30:04 GMT

Hi Vika,

I have adapted your form a little(see below). I hope it will be suitable solution for you.

form get_max_ref_field using p_tabname

p_field

changing p_max_date.

data: l_max_field(72).

concatenate 'MAX(' p_field ')' into l_max_field separated by space.

select single (l_max_field) into p_max_date from (p_tabname).

endform.

Kind regards, Aliaksandr.

Re: SELECT Max where column is dynamic in abap program

Former Member — Mon, 11 Mar 2013 06:02:48 GMT

Hi Vika,

In your code

FORM get_max_ref_field USING    p_tabname
                                                   p_field
                         CHANGING p_max_date.

      SELECT MAX( p_field ) INTO p_max_date

FROM (p_tabname).

p_field is a required field to get the data. Make p_field as field-symbol. To make any field as dynamic better to use field symbol concept.

Regards,

Vineesh.

Re: SELECT Max where column is dynamic in abap program

Former Member — Mon, 11 Mar 2013 11:12:01 GMT

Hi Vika,

Check this Code ..

PERFORM MY_SELECT USING `CITYFROM` `max( DISTANCE )` `SPFLI`. " Group by Column name , Max with Column name , Table Name

FORM MY_SELECT USING L_GROUP TYPE STRING

L_MAX TYPE STRING

T_NAME TYPE STRING .

DATA: L_COLUMNS TYPE TABLE OF STRING,

L_CONTAINER TYPE STRING,

L_COUNT TYPE I.

APPEND L_GROUP TO L_COLUMNS.

APPEND L_MAX TO L_COLUMNS.

SELECT (L_COLUMNS)

FROM (T_NAME) "spfli

INTO (L_CONTAINER, L_COUNT)

GROUP BY (L_GROUP).

WRITE: / L_COUNT,L_CONTAINER.

ENDSELECT.

ENDFORM.

Regard's

Smruti