topic Re: GETTING LATEST DATE in Application Development and Automation Discussions

GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:36:38 GMT

Hi,

I want to collect the latest date from a table containing a number of dates.

how do i achieve dis???

Re: GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:38:12 GMT

Hi,

Sort the date in descending order and then read the first table entry.

Hope this helps.

Regards,

Richa

Re: GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:38:27 GMT

Hi,

For internal table..

SORT ITAB BY DATE DESCENDING.

get the latest date

READ TABLE ITAB INTO WA INDEX 1.

For database table

SELECT MAX( DATE) INTO V_DATE FROM ztable WHERE ..

Thanks,

Naren

Re: GETTING LATEST DATE

gopi_narendra — Tue, 05 Jun 2007 04:38:31 GMT

sort it_tab by <date> descending.

read it_tab index 1.

Regards

Gopi

Re: GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:38:45 GMT

SORT itab BY date DESCENDING.

Now your first record will have latest date.

Reward points if useful.

Regards,

Atish

Re: GETTING LATEST DATE

sreeramkumar_madisetty — Tue, 05 Jun 2007 04:39:10 GMT

Sort the date in descending order and then read the first table entry

Regards,

Sree

Message was edited by:

sree ram

Re: GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:39:12 GMT

DATA : BEGIN OF ITAB OCCURS 0,

VDATE LIKE SY-DATUM,

END OF ITAB.

SELECT MAX( <DATE FIELD> ) INTO TABLE ITAB FROM DBTAB WHERE <CONDITION>.

LOOP AT ITAB.

WRITE : ITAB-VDATE.

ENDLOOP.

REGARDS

SHIBA DUTTA

Re: GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:39:40 GMT

Can you be little more clear with your requirement?

with respect to which module or which table you are asking this?

Regards

Anji

Re: GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:41:15 GMT

Hi,

try this..

select max( date ) into v_date from ztable.

select max( time ) into v_time from ztable.

Re: GETTING LATEST DATE

Former Member — Tue, 05 Jun 2007 04:42:42 GMT

Hi,

U can get the latest date by sorting ur internal table with key as date descending.

{Also if u coding in HR abap,

use rp_provide_from_last p0001 space pn-begda pn-endda

This wil help u to fetch the latest records for the entered begin date and end date.}

Hope this helps.

****Rewars points if helpful.

All the best