Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

RSUSR200 - Issue with sorting

Go to solution
Former Member

‎11-10-2009 11:32 AM

0 Kudos

Hi All,

In IDES-ECC 6.0 I am executing tcode RSUSR200 and trying to sort the result with "Last Logon" date field.

But it is not sorting the output correctly with last logon date.

Also I tried to sort the same report with "Creation date" / "Password changed date" fields and its working fine.

Can anyone help me here.

Regards

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎11-10-2009 11:39 AM

0 Kudos

Hi,

Last logon field is declared as character in the structure SIM_RSUSR200_ALV-TRDAT1. However the same last logon field declared as date field in usr02 table finally all the valurs are moved to the strcutre SIM_RSUSR200_ALV. If you sort the ALV output by last logon field it will not sort by date because it is a charater field.

Venkat

1 REPLY 1

Go to solution
Former Member

‎11-10-2009 11:39 AM

0 Kudos

Hi,

Last logon field is declared as character in the structure SIM_RSUSR200_ALV-TRDAT1. However the same last logon field declared as date field in usr02 table finally all the valurs are moved to the strcutre SIM_RSUSR200_ALV. If you sort the ALV output by last logon field it will not sort by date because it is a charater field.

Venkat