topic Re: Unsort a SORTed table. in Application Development and Automation Discussions

Unsort a SORTed table.

former_member202771 — Thu, 24 Apr 2014 10:41:24 GMT

Hi Experts,

Do we have provision is SAP to unsort a sorted table.

I have used SORT itab by f1 f2.

now after few more changes and modifications on itab, I need the itab in same order before the sort statement but with modified values..

Thanks,

Anil

Re: Unsort a SORTed table.

Former Member — Thu, 24 Apr 2014 10:55:47 GMT

Hi Anil.

You can store the ITAB data in 1 more internal table ITAB2 and dont sort it.

When you are modifying the data in ITAB then read the record in itab2 and modify the desired field value in itab2 as well.

Regards,

Sudeesh Soni

Re: Unsort a SORTed table.

rajkumarnarasimman — Thu, 24 Apr 2014 11:01:36 GMT

Dear Anil,

Unsort option is not available in ABAP.

For this requirement, add the field(slno) in itab(Internal Table) and maintain values in ascending order(From 1 to n) before sorting itself.

"Sorting before modifications

Sort itab by f1 f2.

After the sorting and modifications done in itab, do the same sorting based on slno as shown below.

"Sorting after modifications - based on Serial Number

Sort itab by slno.

Regards

Rajkumar Narasimman

Re: Unsort a SORTed table.

ceedee666 — Thu, 24 Apr 2014 11:02:04 GMT

Hi Anil,

something like that is not possible. How should it be achieved? The system would have to keep track of all sort operations in the background to enable the "unsort" your are asking for.

The question is, what are you really trying to achieve? There is certainly a way to implement you requirements without the magic "unsort" function....

Christian

Re: Unsort a SORTed table.

Former Member — Thu, 24 Apr 2014 12:43:34 GMT

Thats good way of solving this. Extend the itab by one component


slno type sy-tabix

To store the line index, before first sort add something like (or maybe you can include this in the routine where you are filling the itab)


field-symbols: <fs> like line of itab.
loop at itab assigning <fs>.
  <fs>-slno = sy-tabix.
endloop.

In the case you can not extend itab directly, you need to create a copy of the itab table if there is enough ram in the system = could be performance problem with big tables, or create some separated index internal table (little bit more complicated)

Re: Unsort a SORTed table.

former_member202771 — Thu, 24 Apr 2014 14:41:38 GMT

Hi Narasimman & Riha,

That will work beautifully. I would use the solution you suggest, if I was coding in a custom report.

My problem is I want to do this operation in SAPLV03R and there are no enhancement options available at these positions.

SORT output BY isort isort_et and

SORT output STABLE BY matnr

werks

kunnr

vbeln

posnr.

Any other way in these situations.

Thanks,

Anil

Re: Unsort a SORTed table.

Jelena_Perfiljeva — Thu, 24 Apr 2014 18:33:23 GMT

I believe that in the user exits / enhancements it's better to create a local copy of the global table and then do whatever you need to do with a local copy. If you need to update the global table at the end then it'd probably need to be done in a LOOP. In an enhancement I would imagine there shouldn't be a very large number of records.

There is no "unsort" feature, unfortunately, we can only re-sort using different fields. But can you share with us what are you trying to achieve exactly? Maybe there is no sorting needed to begin with...

Re: Unsort a SORTed table.

Former Member — Fri, 25 Apr 2014 04:24:21 GMT

Hi Anil,

You can follow given logic:

1. Do not sort the Main table-Output

2. Create the new Internal table-Output1 of Output table type adding new field-Sequence.

3. Populate the Output1 table with Output table data and also populate the sequence field.

4. Sort the Output1 table based on required fields.

5. Modify the Output1 table record as per reqirement

6. Sort the Output1 table based on Sequence in ascending.

7. Refresh the Output table and populate it with Output1 table data.

Regards,

Sudeesh Soni

Re: Unsort a SORTed table.

Former Member — Fri, 25 Apr 2014 05:35:09 GMT

This message was moderated.