topic Re: Defining field for sorting in Application Development and Automation Discussions

Defining field for sorting

Former Member — Thu, 17 May 2007 15:44:20 GMT

If I have numeric values and alpha values and want to sort them according to numeric and alphabetcial order, should I define the field as NUMC or CHAR?

Re: Defining field for sorting

Former Member — Thu, 17 May 2007 15:45:40 GMT

Hi,

You have to define it as char..As NUMC will not accept alpha values..

Thanks,

Naren

Re: Defining field for sorting

Former Member — Thu, 17 May 2007 15:46:46 GMT

Hi,

1. If the field contains Alphabets,

then we cannot take NUMC,

(Bcos NUMC can contain only digits, in char format)

2. Hence, we have to take CHAR.

regards,

amit m.

Re: Defining field for sorting

Former Member — Thu, 17 May 2007 15:47:10 GMT

u can use CHAR..

later u can sort as u like

Regards

SAB

Re: Defining field for sorting

Former Member — Thu, 17 May 2007 15:48:42 GMT

DEFINE CHAR

SORT BY CHAR FIELD

Re: Defining field for sorting

ferry_lianto — Thu, 17 May 2007 15:53:25 GMT

Hi,

You may need to define two seperate fields. One is NUMC and the other one is CHAR.


DATA: BEGIN OF I_INPUT OCCURS 0,
        FIELD1(10) TYPE N,
        FIELD2(10) TYPE C,
        MATNR      TYPE MARA-MATNR.
DATA: END OF I_INPUT.

...

SORT T_INPUT BY FIELD1 FIELD2 ASCENDING.

Regards,

Ferry Lianto

Re: Defining field for sorting

Former Member — Thu, 17 May 2007 15:56:02 GMT

Hi All,

I have the following scenario with these values:

When I use the field as CHAR, the sort becomes

I would want the result to be

What would you recommend on how to approach this. It seems that some ABAP logic is required to to this?

Thanks

null

Re: Defining field for sorting

Former Member — Thu, 17 May 2007 15:58:54 GMT

Hi,

If you are in AFS..

you will have a function module that can be used to sort according to the size..

I don't remember the function module name..

GO to SE37..Give JSORTSIZE*

Thanks,

Naren

Re: Defining field for sorting

Former Member — Thu, 17 May 2007 15:58:58 GMT

Hi,

My problem is that I would have to use just one field for these values. I am not sure about your suggestions. Would you clarify

Thanks

Re: Defining field for sorting

ferry_lianto — Thu, 17 May 2007 16:05:55 GMT

Hi,

Please try this ...


DATA: BEGIN OF ITAB OCCURS 0,
        SORT(1) TYPE C,
        FIELD1(5) TYPE C,.
DATA: END OF ITAB1.

LOOP AT ITAB.
   IF ITAB-FIELD1 CO SY-ABCDE.
     ITAB-SORT = 'B'.
   ELSE.
     ITAB-SORT = 'A'.
   ENDIF. 
  
   MODIFY ITAB.
ENDLOOP.

SORT ITAB BY SORT FIELD1 ASCENDING.

LOOP AT ITAB.
  WRITE: / ITAB-FIELD1.
ENDLOOP.

Regards,

Ferry Lianto

Re: Defining field for sorting

ferry_lianto — Thu, 17 May 2007 16:30:15 GMT

Hi,

Please try this ... it works for me.


DATA: BEGIN OF ITAB OCCURS 0,
        SORT(1) TYPE C,
        SEQ(5)  TYPE N,
        FIELD1(5) TYPE C.
DATA: END OF ITAB1.

LOOP AT ITAB.
   IF ITAB-FIELD1(1) CA SY-ABCDE.
     ITAB-SORT = 'B'.
     ITAB-SEQ = '99999'.
   ELSE.
     ITAB-SORT = 'A'.
     ITAB-SEQ = ITAB-FIELD1.
   ENDIF. 
  
   MODIFY ITAB.
ENDLOOP.

SORT ITAB BY SORT SEQ ASCENDING.

LOOP AT ITAB.
  WRITE: / ITAB-FIELD1.
ENDLOOP.

Regards,

Ferry Lianto

Message was edited by:

Ferry Lianto