topic Re: sorting char field in Application Development and Automation Discussions

sorting char field

former_member188001 — Fri, 20 Nov 2009 02:58:03 GMT

All,

I have to sort an internal table with single field. This field is of type CHAR25. When I sort it, the actual data is lost and I see some wierd data.

Please let me know how do I sort this kind of an internal table.

Thanks,

Salil

Re: sorting char field

Former Member — Fri, 20 Nov 2009 03:21:11 GMT

Hi,

paste in your code.

how did you execute sort.

sort itab by field(char25).

or just sort itab?

regards,

Re: sorting char field

former_member188001 — Fri, 20 Nov 2009 03:24:35 GMT

TYPES : BEGIN OF ty_card,
          ccnum TYPE ccnum,
        END OF ty_card.

        gt_output      TYPE STANDARD TABLE OF ty_card,
       gw_output      TYPE ty_card.


SORT gt_output BY ccnum.
DELETE ADJACENT DUPLICATES FROM gt_output.
DESCRIBE TABLE gt_output LINES g_total.

Re: sorting char field

former_member194669 — Fri, 20 Nov 2009 04:13:45 GMT

I think field CCNUM is for credit card numbers , please check whether the data in this field is encrypted or not

a®

Re: sorting char field

former_member188001 — Fri, 20 Nov 2009 04:25:02 GMT

yes, all the cards are encrypted. and i want to sort them.

Re: sorting char field

former_member194669 — Fri, 20 Nov 2009 04:29:39 GMT

If it encrypted then it may contain some system characters. so sorting will not work on this. Your option will be either decrypt the and then sort. ( I think in credit card numbers that will not be allowed due to security reasons)

Better talk to business users

a®

Re: sorting char field

former_member188001 — Mon, 17 May 2010 21:32:20 GMT

Well, we adopted a different approach to take care of the entire credit card stuff.