topic Re: intenal table in Application Development and Automation Discussions

intenal table

Former Member — Tue, 20 May 2008 10:42:21 GMT

how is date and time field sorted if i do sort ascending on internal table

say i have date 1 = 10.04.2008

date 2 = todays date

sort ascending - how will it sort dates

Former Member — Tue, 20 May 2008 10:54:00 GMT

Hi ,

it will give u sort as follows,

10.04.2008

20.08.2008.

if u give it as descending...the result will be,

20.08.2008

10.04.2008

Regards,

kk.

Former Member — Tue, 20 May 2008 11:09:09 GMT

Date is stored internaly as YYYYMMDD format,thus,

Date 1 = 20080410

and current date = 20080520

so upon sort ascending :

20080410

20080520

i.e. date 1 will be on top as its less then current date.

Former Member — Wed, 21 May 2008 05:38:49 GMT

hi,

Internal Tables are sorted as follows.

SORT <itab> [ASCENDING|DESCENDING] [AS TEXT] [STABLE].

Former Member — Wed, 21 May 2008 05:44:57 GMT

Hi,

Try ds,

Sort ITAB by Date.

Regards,

Mehul Shah