topic Re: Issue in sorting the date in Application Development and Automation Discussions

Issue in sorting the date

Former Member — Fri, 28 Mar 2014 11:09:25 GMT

i have sorted the internal table by ascending date_field

if i give the date in selection options as 25.02.2014 to 25.03.2014..

It is printed as 01.03.2014

.to

24.03.2014

from next line it is printed as 25.02.2014

25.03.2014

26.02.2014

26.03.2014

How to rectify this issue...

i need to display it as 25.02.2014 to 25.03.2014 by ascending

Re: Issue in sorting the date

Former Member — Fri, 28 Mar 2014 11:17:44 GMT

Hi Vishwaroop,

Can you please post your code here to let us know which technique you are following and where exactly is the problem.

Regards,

Rachna

Re: Issue in sorting the date

bernat_loscos — Fri, 28 Mar 2014 11:20:11 GMT

Hi,

I would like to see your code. Could you paste it here?

Regards

Re: Issue in sorting the date

Former Member — Fri, 28 Mar 2014 11:22:30 GMT

SORT lT_S1 DESCENDING BY MATNR WERKS SPTAG.

LOOP AT lt_S1 INTO ls_S1.

ASSIGN COMPONENT 'WERKS' OF STRUCTURE <DYNWA> TO <L_FIELD>.

<L_FIELD> = ls_S1-WERKS.

ASSIGN COMPONENT 'MATNR' OF STRUCTURE <DYNWA> TO <L_FIELD>.

<L_FIELD> = ls_S1-MATNR.

ASSIGN COMPONENT 'MAKTX' OF STRUCTURE <DYNWA> TO <L_FIELD>.

READ TABLE lt_MAKT INTO ls_MAKT WITH KEY MATNR = LS_S1-MATNR.

IF SY-SUBRC EQ 0.

<L_FIELD> = LS_MAKT-MAKTX.

ENDIF.

ASSIGN COMPONENT 'BASME' OF STRUCTURE <DYNWA> TO <L_FIELD>.

<L_FIELD> = ls_S1-BASME.

CALCDAT = LS_S1-SPTAG.

CONCATENATE CALCDAT+6(2) '.' CALCDAT+4(2) '.' CALCDAT(4) INTO g_SPTAG.

ASSIGN COMPONENT 'SPTAG' OF STRUCTURE <DYNWA> TO <L_FIELD>.

<L_FIELD> = g_SPTAG.

ASSIGN COMPONENT 'MZUBB' OF STRUCTURE <DYNWA> TO <L_FIELD>.

<L_FIELD> = ls_S1-MZUBB.

ASSIGN COMPONENT 'MAGBB' OF STRUCTURE <DYNWA> TO <L_FIELD>.

<L_FIELD> = ls_S1-MAGBB.

CALCDAT = LS_S1-SPTAG.

CALCDAT = CALCDAT - 1.

CONCATENATE CALCDAT+6(2) '.' CALCDAT+4(2) '.' CALCDAT(4) INTO G_SPTAG.

ASSIGN COMPONENT 'OPEN_STOCK' OF STRUCTURE <DYNWA> TO <L_FIELD>.

IF LS_S1-SPTAG EQ TODAY1.

READ TABLE LT_MBEW INTO LS_MBEW WITH KEY MATNR = LS_S1-MATNR BWKEY = LS_S1-WERKS.

IF SY-SUBRC EQ 0.

OPEN = LS_MBEW-LBKUM + LS_S1-MAGBB - LS_S1-MZUBB.

<L_FIELD> = OPEN.

ENDIF.

ELSE.

OPEN = OPEN + LS_S1-MAGBB - LS_S1-MZUBB.

<L_FIELD> = OPEN.

ENDIF.

CALCDAT = LS_S1-SPTAG.

CALCDAT = CALCDAT - 1.

CONCATENATE CALCDAT+6(2) '.' CALCDAT+4(2) '.' CALCDAT(4) INTO G_SPTAG.

ASSIGN COMPONENT 'CLOSE_STOCK' OF STRUCTURE <DYNWA> TO <L_FIELD>.

IF LS_S1-SPTAG EQ TODAY1.

READ TABLE LT_MBEW INTO LS_MBEW WITH KEY MATNR = LS_S1-MATNR BWKEY = LS_S1-WERKS.

IF SY-SUBRC EQ 0.

CLOS = OPEN - LS_S1-MAGBB + LS_S1-MZUBB.

<L_FIELD> = CLOS.

ENDIF.

ELSE.

CLOS = OPEN - LS_S1-MAGBB + LS_S1-MZUBB.

<L_FIELD> = CLOS.

ENDIF.

APPEND <DYNWA> TO <DYNTABLE>.

CLEAR: <DYNWA>.

endloop.

SORT <DYNTABLE> ASCENDING. ( here i gets the problem)

endmethod.

Re: Issue in sorting the date

former_member188827 — Fri, 28 Mar 2014 11:25:00 GMT

Make sure that you are declaring the variable as type d instead of type c. Do not refer to your field as Character type variable.

Regards

Re: Issue in sorting the date

Former Member — Fri, 28 Mar 2014 11:26:36 GMT

i declared the variable as type d only.

Re: Issue in sorting the date

former_member188827 — Fri, 28 Mar 2014 11:29:13 GMT

But you are assigning the value of G_SPTAG to field symbol which is type c variable. Please check this again.

Regards

Re: Issue in sorting the date

Former Member — Fri, 28 Mar 2014 11:37:51 GMT

Yes Sorry i gave it as type c...but if i give it as type d also am getting the same problem

Re: Issue in sorting the date

bernat_loscos — Fri, 28 Mar 2014 11:38:32 GMT

Hi Vishwaroop,

You try to change your line "SORT <DYNTABLE> ASCENDING. ( here i gets the problem)"

for this:

SORT <DYNTABLE> ASCENDING BY ('SPTAG').

Regards.

Re: Issue in sorting the date

Former Member — Fri, 28 Mar 2014 11:42:49 GMT

tried that also...but still getting same problem

Re: Issue in sorting the date

former_member189845 — Fri, 28 Mar 2014 11:48:56 GMT

Hi Prathap,

sort <<DYNTABLE> ASCENDING by date_field , make sure that length and data type of it and see how is the format like 'YYYYMMDD' or 'DDMMYYYY'

Can you try declaring the date field as below

data: date_field type sy-datum.

Thanks,

Siva

Re: Issue in sorting the date

former_member189845 — Fri, 28 Mar 2014 11:52:44 GMT

Hi Prathap,

Have you tried that ?

Thanks,

Siva

Re: Issue in sorting the date

Former Member — Fri, 28 Mar 2014 12:02:35 GMT


DATA: lv_data TYPE dats.
CONCATENATE calcdat(4) calcdat+4(2) calcdat+6(2) INTO lv_data.
* ...
<l_field> = lv_data.
" instead of
* CONCATENATE CALCDAT+6(2) '.' CALCDAT+4(2) '.' CALCDAT(4) INTO  G_SPTAG.

Re: Issue in sorting the date

Former Member — Fri, 28 Mar 2014 12:04:11 GMT

Tried siva...its in 'DDMMYYYY'

Re: Issue in sorting the date

muneshpatwari — Fri, 28 Mar 2014 12:09:04 GMT

Hi,

Keep one more field in your internal table where you can keep the date in the format - YYYYMMDD or DDMMYYYY without dot (.) and sort the table based on this field.

It should work hopefully.

Regards,

Munesh.

Re: Issue in sorting the date

former_member189845 — Fri, 28 Mar 2014 12:11:40 GMT

Prathap,

Your G_SPTAG is an string and your assigning those value to some other value ( date_field ) which you have declared it as data type 'C' but now you changed to 'D' right ?

Re: Issue in sorting the date

himanshu_gupta13 — Fri, 28 Mar 2014 12:32:15 GMT

Hi Vishwaroop,

Take the date into the internal table having the numeric type of field and then take data in format of YYYYMMDD and sort it and use it as per your requirement.

As I think your date is available iin format DDMMYYYY..

Many Thanks / Himanshu Gupta