Skip to Content
0
Former Member
Sep 15, 2010 at 11:35 AM

getting dumb when using MAX query

30 Views

hi all,

i have to use MAX keyword in my coding, so i have write this code:

SELECT SINGLE MAX( bedat )  badat  
      FROM    eban
      INTO    gi_reqdate
      WHERE   EBELN IN S_EBELN
      AND     banfn eq gi_eban-banfn
      AND     ekorg eq p_ekorg
      AND     spras eq 'E'
      GROUP BY bedat badat.

when i execute it will give me dump at SELECT SINGLE MAX( bedat ) badat .I can't understand why it is given me Dump...

Thanks.