topic Re: Sorting problem in ALV Report ( + and - Value sorting) in Application Development and Automation Discussions

Sorting problem in ALV Report ( + and - Value sorting)

former_member242166 — Fri, 08 Mar 2013 08:35:56 GMT

Hi ABAP experts,

I have one ALV Report . In that Report i Have one column Named 'Days'. In that days column contains both positive and Negative Value. When i choose filter on that column and select value as 0 to 10 . The Output shows negative value also.

Example :

The days column contains the value like 0, 2,4, -4, -6, -20, -11, 10

When i choose 0 to 10 in filter.

The output contains:

0, 2, 4, -4, -6, and 10 Only. & -11, -20 Is not coming.

But i dont want -4, -6 value also. I dont want negative value. when i choose 0 to 10.

Why this negative value is coming. What is the problem. Please help me friends.

Thanks and Regards,

Linganathan.K

Re: Sorting problem in ALV Report ( + and - Value sorting)

Former Member — Fri, 08 Mar 2013 09:18:16 GMT

What is the type of field 'DAYS'? It seems to be issue with the data type.

Re: Sorting problem in ALV Report ( + and - Value sorting)

former_member242166 — Fri, 08 Mar 2013 09:27:58 GMT

Dear Soumyasanto Sen,

The data type of DAYS is char.

Thanks and Regards,

Linganathan.K

Re: Sorting problem in ALV Report ( + and - Value sorting)

Former Member — Fri, 08 Mar 2013 09:32:05 GMT

Please use some numeric data type. Signed value couldn't be recognized in char type.

Re: Sorting problem in ALV Report ( + and - Value sorting)

RaymondGiuseppi — Fri, 08 Mar 2013 09:49:21 GMT

As already written, use numeric type (here integer) else you will have to manage the adjustment of character an the sort order between numbers, space and minus sign "-"...

Regards,

Raymond