To Sort Table Maintenance Before Display.
I found the below steps very useful to sort the table maintenance before display.
- Go to SE11 and enter table name(eg. ZTEST) ->Display
- Click UTILITIES menu->Table Maintenance Generator
- Click on ENVIRONMENT menu->Modification->Maintenance screens->Double click on record in the popup.
- Write one MODULE SORT_EXTRACT (in PBO of the maintenance view screen) to sort exactly before Table Control loop statement(LOOP AT EXTRACT WITH CONTROL)
- Write the below piece of code at SORT_EXTRACT to sort Table Maintenance.
MODULE SORT_EXTRACT OUTPUT.
DATA : IT_ZTEST LIKE ZTEST OCCURS 1WITHHEADER LINE .
IF NOT SY-UCOMM = ‘NEWL’.
IT_ZTEST[] = EXTRACT[].
SORT IT_ZTEST BY F1 F2 F3.
EXTRACT[] = IT_ZTEST[].
ENDIF.
ENDMODULE. ” SORT_EXTRACT OUTPUT
Source: An SAP Consultant: SAP ABAP – sorting Table maintenance
I have "optimized" the MODULE Content, to be able to use it more than once
CODE:
CASE objh-objectname. "global field 🙂
WHEN '<YOUR_MAINTVIEW>'.
DATA : IT_ZTEST LIKE <YOUR_MAINTVIEW> OCCURS 1 WITH HEADER LINE .
[...]
ENDCASE.
Hi Chitra Sankar,
Very nice, thanks.
Hello Chitra, it doesn't work, I've a dump OBJECTS_TABLES_NOT_COMPATIBLE ( description: Two internal tables are not compatible or convertible )
Hi Chitra / Leanid,
I have modified above code for better performance.
Thanks, quick and elegant.
Hi,Mr.Manoj Mohanty, thank you. this is a alternative solution to my question herehttps://answers.sap.com/questions/12903934/how-to-handle-this-error-assign-base-wrong-alignme.html?childToView=12903953&answerPublished=true#answer-12903953
Can you help check why that is happenning?
boss ! thanks this is working, but when we manipulate EXTRACT[] or TOTAL[] then standard
functionalities like SAVE, DELETE go high and they do not work in fact the memory id
(SAPLZMM_E006)<ACTION> is set to '#' instead of 'U' , so can u help on this ?
Hi Manoj Mohanty,
it works fine for sorting, but I can't delete rows. I have the message:
"Select entries before performing the function".
Hi Helen,
Try like this.
Thanks,
Manoj
If you want to be indepentent from regeneration, you can try event 10 with the following coding:
Best regards,
Christian
Thank you Christian. Simple and straight forward.
Hey, I'm a Functional Consultant so hopefully my code is not too woeful. I created a cluster view using transaction SE54. The records were not sorted, so I created a variation on the code above but tried to keep it generic so I can use the same module for any table to sort the underlying view by the primary index (a.k.a. key).
I was facing the same problem. I was able to sort but couldn't delete or copy rows.
The following solution fit for me to sort and still being able to delete and copy correctly: