Skip to Content
avatar image
Former Member

"Search Term" fields in SU01

Hi experts,

Issue concerns my CRM 6.0 back end system. Here, I have a requirement to pull out a list of all users created without any value in field "Search Term 1" under Adress tabI found an old thread from some years back which says this field is not part of any user tables as it fell under address management back then:

SU01 Search Terms

Does anyone have knowledge on how I can run this query? SUIM, change history etc has no option to do a user search on this field. I checked out most of the user tables (USR*) and none of them also have this field "Search term 1" in them.

Also for some users on the same system this field is not visible alltogether (No header in SU01 --> Address which shows "Search terms" at all).

I am a little confused. Any help would be great....

Edited by: Soumya-Thomas on Mar 3, 2011 9:56 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 03, 2011 at 09:09 AM

    Sorry guys, it turns to be a lame question... I just figured the way to go about this....

    Sorry again, I dont find an option to delete the question alltogether hence marking it as solved.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Julius,

      Just noticed your answer to my thread, this is what I did:

      Table ADRP - got a list of all users (on field PERNR) with field value Search term1 (SORT1) against eahc user.

      Table USR21 - mapped the above PERNR value to user name here.

      Thus got a list of all usernames + Search Term1 (SORT1).

      Also, i didnt really use authority checks against the field Search Term.. may be it is used soemwhere, but i didnt get into that; since my mission was only to make sure that a set of users (as per our policy) were all created with specific reasons entered in "SU01 --> Search Term1" during user creation. For me it was a user master data updation task.