topic Re: Max statement not working in Application Development and Automation Discussions

Max statement not working

Former Member — Fri, 17 May 2013 12:17:28 GMT

Dear experts,

I am using a MAX statement in one of my query but it fails to work and there is data present in the database table.

SELECT MAX( aznum ) INTO l_aznum FROM febko

WHERE bukrs = wa_ff67_hdr-bukrs

AND hbkid = wa_ff67_hdr-hbkid

AND hktid = wa_ff67_hdr-hktid.

though it is very easy but still not working.

Re: Max statement not working

matt — Fri, 17 May 2013 13:00:59 GMT

It is unlikely in the extreme that the max statement has suddenly stopped working. Far more likely is that you've made a mistake.

Have you checked that wa_ff67_hdr-bukrs -hbkid and -hktid contain any data?

Have you checked whether there are conversion exits on the domains these fields are built upon?

Re: Max statement not working

manukapur — Fri, 17 May 2013 13:35:23 GMT

Please ensure l_aznum is of the same type as aznum. Query seems to be fine.

Check if have data issues.

The other way is to fetch the data and sort it in descending order on aznum.

Regards,

Manu

Re: Max statement not working

former_member420878 — Fri, 17 May 2013 15:11:48 GMT

Hi,

Please check whether database is containing any record with given selection.

Type of l_aznum should be matched with AZNUM_EB.

Otherwise query is OK.

Regards,

Neha

Re: Max statement not working

Former Member — Fri, 17 May 2013 17:57:10 GMT

Hi,

Check whether the condition you specified has any record or not. There is no problem with the query.

Re: Max statement not working

arindam_m — Sat, 18 May 2013 03:05:43 GMT

Hi,

May be you have multiple statement number lines try this:

SELECT MAX( DISTINCT aznum ) INTO l_aznum FROM febko

WHERE bukrs = wa_ff67_hdr-bukrs

AND hbkid = wa_ff67_hdr-hbkid

AND hktid = wa_ff67_hdr-hktid.

Hope it helps.

Cheers,

Arindam

Re: Max statement not working

Former Member — Sat, 18 May 2013 03:58:55 GMT

Hi Mahesh

Pls try the below code:

SELECT single MAX( aznum ) INTO l_aznum

FROM febko

WHERE bukrs = wa_ff67_hdr-bukrs

AND hbkid = wa_ff67_hdr-hbkid

AND hktid = wa_ff67_hdr-hktid.

Regards,

Suganya

Re: Max statement not working

Former Member — Sat, 18 May 2013 04:44:26 GMT

Hi Mahesh,

Is there any error message you got...?

If not the where condition not match with you data available in your database table.

Regards,

R.S.K

Re: Max statement not working

Former Member — Sat, 18 May 2013 04:45:52 GMT

Dear all,

wa_ff67_hdr-hbkid was passed in small case and it needs to be passed in upper case. So solved the issue by observing it.

Thanks for reply.

Re: Max statement not working

manukapur — Sat, 18 May 2013 08:47:22 GMT

So it was a data issue.