topic Re: select in Application Development and Automation Discussions

select

Former Member — Mon, 20 Aug 2007 08:34:28 GMT

how to select recent date record in a table

Former Member — Mon, 20 Aug 2007 08:37:25 GMT

select * from table-name where date = max(date)

Former Member — Mon, 20 Aug 2007 08:40:40 GMT

Hi Pandu,

First select all the entries into itab, Then sort it by timestamp in descending order,

then delete the entries other than first occurance.

Code,

SORT ITAB BY FIELD1 ASCENDING TIMESTMP DESCENDING.

READ TABLE ITAB INTO WA_ITAB.

LOOP AT ITAB.

IF WA_ITAB-FIELD1 = ITAB-FIELD1 AND SY-TABIX NE 1.

DELETE ITAB INDEX SY-TABIX.

ELSE.

MOVE ITAB TO WA_ITAB.

ENDIF.

ENDLOOP.

Former Member — Mon, 20 Aug 2007 08:40:51 GMT

hi,

u have select data based on some field.

that may be date (if date field is there),or somthing else.

You cant select recent data without any specific field. So search for that option.