topic Wrong sort in SM30 in Application Development and Automation Discussions

Wrong sort in SM30

Former Member — Tue, 17 Jan 2006 09:37:52 GMT

I've created a maintenance dialog view for a Z*-table. In the PBO of the created screen I have added a module (before the LOOP AT EXTRACT WITH CONTROL) in which I sort the selected data. Instead of a sort by the key-fields the customer wants a sort on two other (non-key) fields.

Code:

MODULE sort_extract_zjghost OUTPUT.
*
  SORT extract BY TABLE_LINE+13(3)
                  TABLE_LINE+16(2)
                  TABLE_LINE+3(10).
*
ENDMODULE.

In the Development and QA environment it is working fine. But in the Production environment the sort is performed on different parts of the line. Instead of the 'fields' mentioned above the sort is done on the 'fields' TABLE_LINE10(3), TABLE_LINE13(2) and TABLE_LINE+0(10).

The tableline has no structure but contains the fields client(CLNT3), kunnr (CHAR10), ritnr (CHAR3), volg (CHAR2) and some extra fields.

Can someone tell me why there is a difference between Development/QA and the Production environment when sorting the data? I checked the transports and they are OK.

Thanks,

Arjan.

Re: Wrong sort in SM30

Former Member — Tue, 17 Jan 2006 09:45:05 GMT

Hi Arjan,

are you sure your client field is maintained with some values in the prod environment?

Is there any possibility that the mandt field has no values and the table_line is condensed and that is the reason for this behavior??

Re: Wrong sort in SM30

Former Member — Tue, 17 Jan 2006 09:53:06 GMT

Hi Ravi,

thanks for your quick reply.

When I look in debugging mode the lines contain the same fields. So both Development/QA and Production contains data for client, kunnr, ritnr, volg and so on.

The code, the data, everything looks the same in debugging. The only thing that is different is the result of the SORT.

Re: Wrong sort in SM30

hendrik_brandes — Tue, 17 Jan 2006 09:57:44 GMT

Hi Arjan,

I don't know your exact structures, but I seems that your sorting routine doesn't handle the MANDT-Field correctly.

Try to copy your extract table to a structured table, do sorting and copy back.

Another thing: Use the events within the table maintainance. Go to se11 -> Utilities -> Table Maintenance Generator -> Environment -> Modification -> Events. There you can define specific code for the different states in the dialog. Your solution to modify your created dynpro, is not the preferred option, because you have a lot more effort to maintain your dialogs (Think only about new fields in the screen).

Regards,

Hendrik

Re: Wrong sort in SM30

Former Member — Tue, 17 Jan 2006 10:56:06 GMT

Hi Hendrik,

thanks for your reply.

I used the <i>'events within the table maintenance'</i> as you suggested but no event is suitable for my purpose. I placed a break-point in my form and only two events reached it. But in both cases no data was selected yet.

Leaves the <i>'copy extract table to a structured table'</i> suggestion. I can program it that way but the only place to test it, is the Production environment.

And on the other hand... at the moment I've got a solution which is working perfectly except in the Production environment. I prefer to put some time in finding the explanation why this is so.

Re: Wrong sort in SM30

Former Member — Tue, 17 Jan 2006 11:16:51 GMT

HI Arjan,

Do you see the same code that you see in DEV and Qual systems in Production environment also??

If you don't see the code that way, there may be some problem in transporting the object from QA to Prod or something like that.

Or possibly there is another request with a primitive code which you have developed in DEv/QA environments, where the sort os actually done on done on the 'fields' TABLE_LINE10(3), TABLE_LINE13(2) and TABLE_LINE+0(10).

instead of the original one.

Regards,

Ravi

Re: Wrong sort in SM30

Former Member — Tue, 17 Jan 2006 11:45:22 GMT

Hi Ravi,

yes, I see the same code. A remote compare does also not give any differences.

Greetings,

Arjan.

Re: Wrong sort in SM30

Former Member — Tue, 17 Jan 2006 11:52:12 GMT

Hi Arjan Hoes,

1. Goto SE11 -> Give Ur table Name -> Change

2. Now Goto Menu Utilities -> Table Maintanance Generator -> Change

3. Check Create Maintanance Screen -> ok.

4. Check Overview Of Screen -> ok.

This steps recreate the maintanance screen. Now, transport newly created request to Production.

Regards,

Digesh Panchal

Note : Please reward points if it solve ur problem