topic Re: Select Max date value from a tabel in Application Development and Automation Discussions

Select Max date value from a tabel

anuradha_wijesinghe — Wed, 28 Aug 2013 04:02:15 GMT

hello everyone,

I have a table like bellow.

KALNR	KADKY	POSNR	MATNR	WERTN
100200250	01.04.2013	9	6001220	0.02
100200250	01.05.2013	9	6001220	0.02
100200250	01.06.2013	9	6001220	0.02
100200250	01.07.2013	9	6001220	0.02
100200250	01.04.2013	10	6000920	0.02
100200250	01.05.2013	10	6000920	0.02
100200250	01.06.2013	10	6000920	0.02
100200250	01.07.2013	10	6000920	0.02

So I need to get the maximum date value in this table (01.07.2013) . So how can I get this value using a SELECT command in ABAP.

Re: Select Max date value from a tabel

Arun_Prabhu_K — Wed, 28 Aug 2013 04:54:30 GMT

Hello Anuradha.

Use MAX function.

select max( COLUMN ) from TABLE into dt.

Refer ABAPDOCU tcode.

Regards.

Re: Select Max date value from a tabel

former_member209120 — Wed, 28 Aug 2013 05:02:41 GMT

Hi Anuradha,

See this link http://scn.sap.com/thread/709182

Re: Select Max date value from a tabel

Former Member — Wed, 28 Aug 2013 05:12:38 GMT

DATA d type d.

select max( KADKY ) from TABLE into d.

in this situation DAta store in kadky table as yyyymmdd

so its pick up maximum on base of amount.

Re: Select Max date value from a tabel

Former Member — Wed, 28 Aug 2013 05:14:01 GMT

Hi,

A simple example..

Replace xxx by ur structure name & 'YYY' table name.

DATA : d type s_date.

TYPES: BEGIN OF ty_xxx,

              KADKY TYPE S_DATE,

              END OF ty_xxx.

DATA: t_xxx TYPE TABLE OF ty_xxx,

      x_xxx TYPE ty_xxx.

SELECT KADKY from YYY INTO TABLE t_xxx.

IF d is INITIAL.

     LOOP AT t_sflight INTO x_sflight.
        d = x_xxx-KADKY.
    ENDLOOP.

ELSE.

    LOOP AT t_xxx INTO x_xxx.

     IF d > x_xxx-KADKY .

        d = x_xxx-KADKY

.
ENDIF.

ENDLOOP.

ENDIF.

WRITE d.

Regards,

Farid.

Re: Select Max date value from a tabel

sivaganesh_krishnan — Wed, 28 Aug 2013 05:15:59 GMT

Hi anuradha,

Use Max Function to get the maximum value of column in table.

I have tried this,

select MAX( MATCH_DATE -->( Column) )

           FROM zapt_header_tb---> (Table)

           into date.

if sy-subrc EQ 0.
    WRITE date.
    ENDIF.

This will give the maximum date .

Regards,

Sivaganesh

Re: Select Max date value from a tabel

sandeep_ramesh88 — Wed, 28 Aug 2013 05:23:33 GMT

Hi,

Either try as praveen suggested or

select the data required into an internal table.

Sort the internal table by KADKY descending.

Read the first line from the internal table.

Thanks.

Re: Select Max date value from a tabel

Former Member — Wed, 28 Aug 2013 05:27:32 GMT

Hi,

select kalnr max(kadky) posnr matnr wertn

from some_table

into some_other_table

where some_condition.

Re: Select Max date value from a tabel

Former Member — Wed, 28 Aug 2013 05:38:41 GMT

Hi,

First declare a variable of type sy-datum.

DATA : v_date TYPE sy-datum.

Then use the below select query to fetch the maximum date from the table.

While writng the select query please take care of the spaces between the parentheses.

SELECT MAX( ADKY ) FROM <table_name> INTO v_date.

WRITE : v_date.

Regards,
Riju Thomas.

Re: Select Max date value from a tabel

former_member308418 — Wed, 28 Aug 2013 06:10:32 GMT

Hi,

I guess you need to get max date value from your internal table. If this is the case then simply follow it,

SORT itab by kadky DESCENDING.

READ TABLE itab INDEX 1.

WRITE :/ itab-kadky.

by this you will get the max field value from your internal table.

Re: Select Max date value from a tabel

former_member224797 — Wed, 28 Aug 2013 06:45:33 GMT

Hi , Please check the code below,,

TYPES: BEGIN OF TY_001,

KALNR TYPE TABLE-KALNR,

KADKY TYPE TABLE-KADKY,

POSNR TYPE TABLE-POSNR,

MATNR TYPE TABLE-MATNR,

WERTN TYPE TABLE-WERTN,

TYPES:END OF TY_001.,

DATA LS_TABLINE TYPE TY_001.

SELECT KALNR MAX(KADKY) POSNR MATNR WERTN

INTO LS_TABLINE "--->LOCAL STRUCTURE .

FROM <TABLE>

WHRER <ANY CONDITIONS>

POINTS PLEASE.....

Re: Select Max date value from a tabel

Former Member — Wed, 28 Aug 2013 08:49:04 GMT

Hi,

If you have data in data base table use Francy 001 reply, suppose you have data in internal table use ABAP 2 reply.

Regards,

John.

Re: Select Max date value from a tabel

former_member864989 — Tue, 24 Sep 2013 10:55:02 GMT

Hi,

To fetch only date value

SELECT KADKY FROM <dbtable> INTO LV_KADKY WHERE <field> = cond1 ORDER BY KADKY DESCENDING.

ENDSELECT.

to fetch a single record.

SELECT KALNR KADKY POSNR MATNR WERTN FROM <dbtable> INTO WA_1 WHERE <field> = cond1 ORDER BY KADKY DESCENDING.

ENDSELECT.

Regards,

Lokesh

Re: Select Max date value from a tabel

RaymondGiuseppi — Tue, 24 Sep 2013 11:02:17 GMT

Did you read Abap online documentation like http://help.sap.com/abapdocu_731/en/abapselect_aggregate.htm or transaction ABAPDOCU or F1 on source editor.

Regards,

Raymond

Re: Select Max date value from a tabel

Former Member — Tue, 24 Sep 2013 11:12:17 GMT

Hi Anuradha,

Try this query...

select max(field name) from table name into wa-fieldname

where condition......

sure this will solve...

Re: Select Max date value from a tabel

Former Member — Fri, 22 Jan 2016 04:44:09 GMT

This message was moderated.