Fetching DAta against Max Date from table

[Former Member]

Dear All,

I have to fetch data against maximum date from table. i have tried this one but getting error :

EXEC SQL.

*IT_OUT-PR_APPRVD

SELECT single UDATE

INTO MAX_DATE

FROM CDHDR

WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = IT_OUT-PR_NO

AND CHANGENR = IT_OUT-CHANGENR1

AND TCODE LIKE 'ME%'

AND UDATE = (SELECT MAX(UDATE) FROM CDHDR WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = IT_OUT-PR_NO

AND CHANGENR = IT_OUT-CHANGENR1

AND TCODE LIKE 'ME%') .

ENDEXEC.

Plz suggest syntax for that.

Looking forward to your earliest response.

with Regards,

Gulrez Alam

[Former Member]

write this :

Look at the bold ones ... U need to put : against the field

MAX_DATE ..

EXEC SQL.

SELECT UDATE INTO :MAX_DATE

FROM CDHDR

WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = '0'

AND CHANGENR = '1'

AND TCODE LIKE 'ME%'

AND UDATE = (SELECT MAX(UDATE) FROM CDHDR WHERE CHANGE_IND = 'U'

AND OBJECTCLAS = 'BANF'

AND OBJECTID = '1'

AND CHANGENR = '1'

AND TCODE LIKE 'ME%'.) .

.

ENDEXEC.