topic Re: Issue with sorting in TMG in Application Development and Automation Discussions

Issue with sorting in TMG

sriram_ramesh — Tue, 29 Mar 2016 06:43:17 GMT

Hi,

I have a TMG and tcode for it.

I'm sorting the table based on material by adding code in PBO.

gt_table[] = extract[].

sort gt_table by matnr.

extract[] = gt_table[].

Sorting works fine.

But, when I try to add new entry to the table, it all goes to display mode.

I tried using check before the sorting code. (if sy-ucomm <> 'NEWL').

But during save sy-ucomm goes initial.

Is there anyother way to sort?

Thanks in advance

Re: Issue with sorting in TMG

sriram_ramesh — Tue, 29 Mar 2016 09:18:22 GMT

Re: Issue with sorting in TMG

RaymondGiuseppi — Tue, 29 Mar 2016 09:27:19 GMT

By sorting itab EXTRACT you may trigger some unconsistencies with itab TOTAL?

Could you consider creation of a maintenance view on your table, defining MANDT and MATNR as the first keys (if required add MARA as first table then your table)

Regards,

Raymond

Re: Issue with sorting in TMG

Former Member — Tue, 29 Mar 2016 09:56:25 GMT

Hi,

if sy-ucomm NE 'NEWL' AND

sy-ucomm NE 'SAVE' AND

sy-ucomm NE 'DELE'.

gt_table[] = extract[].

sort gt_table by matnr.

extract[] = gt_table[].

endif.

try using above code. It may be helpful. In case of these OK codes, MATNRS in Extract[] are displayed as "L'.

So if sorted, there is an inconsistency and everything goes blank. So I just made a workaround by excluding these OK codes. This is just a guidance and I sincerely suggest you to test all kind of scenarios in your requirement before really using this workaround.

Regards

Pallavi

Re: Issue with sorting in TMG

sriram_ramesh — Tue, 29 Mar 2016 10:35:23 GMT

Hi pallavi,

What If I enter a new entry and click on enter? ok code will be space.

And when I run the tcode, ok code will be space.

so cant really use it

Re: Issue with sorting in TMG

Former Member — Wed, 30 Mar 2016 07:10:08 GMT

Hi sriram,

gt_ztest_pal1[] = extract[].

DELETE gt_ztest_pal1[] WHERE matnr EQ space. "MATNR will be space for any action other than display

SORT gt_ztest_pal1[] BY matnr. "sort the remaining

LOOP AT gt_ztest_pal1.

LOOP AT extract.

lv_temp = extract.

IF lv_temp+3(18) EQ gt_ztest_pal1-matnr.

DELETE extract. "Delete records which are being manipulated(add or del)

ENDIF.

ENDLOOP.

INSERT LINES OF gt_ztest_pal1 INTO extract[] INDEX 1."insert sorted lines from index 1 .

Hope this code will help you, this code doesn't require to check on any UCOMM .

Code is not in pro with the performance(loop with in the loop), couldn't spend much time on this.

Please take care of this in case if you are using.

Regards

Pallavi

Re: Issue with sorting in TMG

sriram_ramesh — Wed, 30 Mar 2016 07:23:20 GMT

Thanks for your reply.

My case is little different so it didn't work.

Re: Issue with sorting in TMG

sriram_ramesh — Wed, 30 Mar 2016 07:23:49 GMT

Thanks Pallavi,

This is exactly what I did.