topic Select Max problem in Application Development and Automation Discussions

Select Max problem

Former Member — Thu, 27 Dec 2007 07:33:33 GMT

Hi currently i have this sql error problem which i do not know how to solve. below are my codes. I think there is something wrong with my sql statement.

DATA: M_TABLE TYPE TABNAME,

COLUMN_FIELD(14) TYPE C,

VALUE2 TYPE P DECIMAL 1.

M_TABLE = 'ZTABLE'.

COLUMN_FIELD = 'GPA'."example 2.1

SELECT MAX( COLUMN_FIELD ) FROM (M_TABLE) INTO VALUE2.

============================================

After solving this problem, i have another problem. Now my column_field 'GPA' is to decimal 1 as i have declared. But if i need to do it in dynamic example if another column field is money which i do not know the decimal will be placing at where, how should i declare it?

Re: Select Max problem

Former Member — Thu, 27 Dec 2007 07:42:14 GMT

HI,

do like this.

DATA: M_TABLE TYPE TABNAME,

COLUMN_FIELD(14) TYPE C,

VALUE2(10)." TYPE P DECIMALs 1.

M_TABLE = 'MARA'.

COLUMN_FIELD = 'MATNR'."example 2.1

SELECT MAX( MATNR ) FROM (M_TABLE) INTO VALUE2.

write:/ value2.

rgds,

bharat.

Re: Select Max problem

Former Member — Thu, 27 Dec 2007 07:50:18 GMT

Hi but can i do this? Put the variable column_field in the select statement? because the field might change. Now i only hard code it.

SELECT MAX( COLUMN_FIELD ) FROM (M_TABLE) INTO VALUE2.

Re: Select Max problem

Former Member — Thu, 27 Dec 2007 08:53:33 GMT

I have this error message when i execute my program.

SAPSQL_INVALID_FIELDNAME

Re: Select Max problem

former_member402443 — Thu, 27 Dec 2007 09:22:35 GMT

Hi,

Check this code. It might help you to solve the problem.

DATA: itab TYPE STANDARD TABLE OF spfli,

wa LIKE LINE OF itab.

DATA: line(72) TYPE c,

list LIKE TABLE OF line(72).

START-OF-SELECTION.

line = ' AIRPFROM AIRPTO '.

APPEND line TO list.

SELECT DISTINCT (list)

INTO CORRESPONDING FIELDS OF TABLE itab

FROM spfli.

IF sy-subrc EQ 0.

LOOP AT itab INTO wa.

WRITE 😕 wa-airpfrom,wa-airpto.

ENDLOOP.

ENDIF.

Reward Points, if useful.

Regards,

Manoj Kumar

Re: Select Max problem

Former Member — Tue, 08 Jan 2008 07:22:57 GMT

SOLVED. THANKS 😃