topic SELECT MAX query in Application Development and Automation Discussions

SELECT MAX query

Former Member — Tue, 14 Apr 2009 06:06:34 GMT

Hai Friends,

The following is my select query

SELECT MAX( MBLNR )

FROM ZMIGO

INTO TABLE IT_MAX.

Right now my Z table is empty. but when i debug the program it showing 1 entry and when i double the internal table there is no value and it is blank. why it is showing as 1 entry.

Re: SELECT MAX query

I355602 — Tue, 14 Apr 2009 06:26:16 GMT

Hi,

Try using:-


DATA : v_mblnr TYPE zmigo-mblnr.

SELECT MAX( DISTINCT mblnr ) FROM zmigo INTO v_mblnr.
IF sy-subrc NE 0.
  CLEAR v_mblnr.
ENDIF.

Hope this helps you.

Regards,

Tarun