topic NUMC data type - Sort issue in Application Development and Automation Discussions

NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 08:17:14 GMT

Hi,

In my internal table I have 1 field with data type NUMC - 5, it gives me a problem while sorting.

For Ex: my internal data is like this

A - Field

When I sort internal table by the Field A, it gives

But we expect

Pls let me know how to solve this and the feild I use is similar to EBELP field in - EKKO table

regards

Prabhu

Re: NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 08:24:27 GMT

Hi,

I suppose you meant EKPO-EBELP.I dint find any problem with sorting a numc type. Check this sample



data: begin of itab occurs 0,
      f1 type ekpo-ebeln,
      end of itab.
      
      itab-f1 = 11.
      append itab.
      
        itab-f1 = 12.
      append itab.
      
       itab-f1 = 1.
      append itab.
      
       itab-f1 = 3.
      append itab.
      
      sort itab.
      
      loop at itab.
      write:/ itab-f1.
      endloop.

Regards,

Vikranth

Re: NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 08:33:02 GMT

Hi,

This type of issue would arise only if the data type of the field is type C, if you use type EKPO-EBELP, then the record will be appended with 0's in the front, i.e, 11 will be 00011,1 will be 00001 and so on. If you sort the table on this field you will get the correct output. I have tried the same ans is working fine for me.

Regards,

Sachin

Re: NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 08:36:18 GMT

I am getting the sorted output as follows:

EKKO does not have EBELP. If you use datatype n and length 5 in declaration, you will get output as

00001

00003

00004

00011

00012

I see no problem in sorting. Can you give code sample of what you have written??

Re: NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 09:00:25 GMT

Hi,

I am using a customized structure where I have declared a customized field whose data element is standard - EBELP and I face this issue.

regards

Prabhu

Re: NUMC data type - Sort issue

former_member222860 — Fri, 18 Sep 2009 09:10:53 GMT

Check this :

DATA: begin of itab occurs 0,
        A TYPE EBELP,
      end of itab.

itab-A = 11.
append itab.

itab-A = 12.
append itab.

itab-A = 1.
append itab.

itab-A = 3.
append itab.

sort itab.

loop at itab.
  write:/ itab-A.
endloop.

Re: NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 09:14:15 GMT

Hi Prabhu ,

As per my understanding : It can be due to following reason :

Sort condition considering only first character of your field. You should check your code , by mistake you might have used one char somewhere.

Re: NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 09:16:06 GMT

Post the code you are using. There is nothing worng with the sort on the NUMC type. It must be due to some other error

Re: NUMC data type - Sort issue

Former Member — Fri, 18 Sep 2009 09:18:54 GMT

Hi,

After filling the data in Internal table (ITAB).

use :

Sort ITAB by Field_name ascending.

Re: NUMC data type - Sort issue

Former Member — Tue, 26 Oct 2010 08:55:43 GMT

I AM FACING THE SAME ISSUE.

SORTING FOR NUMC FIELD TYPE IS NOT WORKING.

code:-

EBELP TYPE ESSR-EBELP,

EXTROW TYPE ESLL-EXTROW,

SORT INTAB4 BY EBELP EXTROW ASCENDING.

this shows results in :-

100

kindly advise as to what the problem might be!

Thanks in advance!

Re: NUMC data type - Sort issue

Former Member — Mon, 18 Apr 2016 13:02:24 GMT

Hello,

The solution is to use the funcion :

CONVERSION_EXIT_ALPHA_INPUT'

Regards,

Re: NUMC data type - Sort issue

former_member700189 — Tue, 10 Aug 2021 13:04:50 GMT

Hi,

Please use INT2 data type for that field, it resolves the sorting issue 🙂

Regards,

Sai Kalyan