topic Re: Sorting Numeric Characters as numbers in Application Development and Automation Discussions

Sorting Numeric Characters as numbers

Former Member — Thu, 26 Sep 2013 19:12:10 GMT

Hey guys,

I have an ALV Grid that needs to display a column of numbers with a percent at the end and any negative values in the front.

-35.4%

8.7%

13.4%

-100.3%

8732.9%

This was done, but while within the ALV, if they click on the sorting buttons, it does not sort correctly.

It is because the system column HAS to be a string to display it like it is, but as a string it sorts differently from how numbers sort.

Has anyone come up with a solution to this?

Re: Sorting Numeric Characters as numbers

Former Member — Thu, 26 Sep 2013 21:41:44 GMT

Why dont you put '%', eg Marks in % ,in the heading of the column and put just the values in column?

Your issue would be solved.

Regards,

Susmitha

Re: Sorting Numeric Characters as numbers

Former Member — Fri, 27 Sep 2013 02:35:48 GMT

If we convert its type by NUMC i thing then also it will work. Just give a try.

ChanS

Re: Sorting Numeric Characters as numbers

former_member185177 — Fri, 27 Sep 2013 03:08:08 GMT

Hi Tom

I agree with "Susmitha's" reply please go through that one your issue will resolve.

Regards,

Krishna Chaitanya.

Re: Sorting Numeric Characters as numbers

former_member209120 — Fri, 27 Sep 2013 03:21:47 GMT

Hi Tom Neikam,

Put '%' in Field Text instead of displaying in filed ,

Remove % in column

Display values lie this

Field Name %

-35.4

8.7

13.4

-100.3

8732.9

instead of

Field Name

-35.4%

8.7%

13.4%

-100.3%

8732.9%

Re: Sorting Numeric Characters as numbers

rosenberg_eitan — Fri, 27 Sep 2013 05:12:29 GMT

Hi,

If the end customer insist that you use the format 13.4% .

You can hold your data as numeric (for sorting).

Create your own CONVERSION_EXIT_PRCNT_OUTPUT and put ==PRCNT in the EDIT_MASK for this field in the field catalog .

Use can use the edit_mask of in the field catalog for formatting the output.

http://help.sap.com/saphelp_erp2004/helpdata/en/ff/4649baf17411d2b486006094192fe3/content.htm

http://help.sap.com/saphelp_erp2004/helpdata/en/33/206bc8012e11d3b495006094192fe3/content.htm

Regards.

Re: Sorting Numeric Characters as numbers

Former Member — Fri, 27 Sep 2013 12:12:27 GMT

That's similar to the answer I proposed, I added a new column with % in the column.

BUT they still want the - sign to be in front of the number, not behind the number.

In order to put the - sign in front, I have to use strings. Which gives me the exact same problem I had before; SAP uses the sorting rules for strings, not for numerics.

Because the % is at the end, it is a constant and I can find work arounds for it.

But to have the negative symbol in front of the string causes the problems.

Re: Sorting Numeric Characters as numbers

Former Member — Fri, 27 Sep 2013 12:14:07 GMT

This does not fix the problem, because I still have to use strings to move the negative sign.

Re: Sorting Numeric Characters as numbers

rosenberg_eitan — Fri, 27 Sep 2013 14:16:26 GMT

Hi,

I did a small test using CONVERSION_EXIT.

Here is the output:

Regards.

Re: Sorting Numeric Characters as numbers

Former Member — Fri, 27 Sep 2013 14:20:22 GMT

How did you set up the edit mask for this to work?

Re: Sorting Numeric Characters as numbers

rosenberg_eitan — Fri, 27 Sep 2013 14:28:31 GMT

Hi ,

Some blood some sweat some tears some luck.....

I will upload the code shortly.

Regards.

Re: Sorting Numeric Characters as numbers

Former Member — Fri, 27 Sep 2013 14:43:51 GMT

Hah, thanks!

Re: Sorting Numeric Characters as numbers

rosenberg_eitan — Fri, 27 Sep 2013 14:51:28 GMT

Hi,

Function: (Any CONVERSION_EXIT_????_OUTPUT can be used as a skeleton)

Code:

FORM conversion_yts01

USING

p_input

CHANGING

p_output .

DATA: buffer_1 TYPE char32 .

WRITE p_input TO buffer_1 NO-SIGN NO-ZERO RIGHT-JUSTIFIED .

IF p_input IS INITIAL .

p_output = space .

RETURN.

ENDIF .

CONDENSE buffer_1 .

CONCATENATE '+' buffer_1 '%' INTO buffer_1 .

IF p_input LT 0 .

WRITE '-' TO buffer_1+0(1) .

ENDIF .

CONDENSE buffer_1 .

p_output = buffer_1 .

ENDFORM. " CONVERSION_YTS01

Program:

In this case I use CL_SALV_TABLE ALV but this will work also in other ALV.

Just use the EDIT_MASK in the field catalog.

Full source included.

Regards.