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

[former_member242166]

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

[Former Member]

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

[former_member242166]

Dear Soumyasanto Sen,

The data type of DAYS is char.

Thanks and Regards,

Linganathan.K

[Former Member]

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

[RaymondGiuseppi]

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