Skip to Content
0
Former Member
Jan 21, 2011 at 03:27 PM

USR21 and BUT000 table are not in sync

833 Views

Hi,

I'm trying to retrieve a username within table USR21. I therefore input the BUT000-PERSNUMBER in to the USR21-PERSNUMBER table however for most of our users the USR21-PERSNUMBER is a different id then the BUT000-PERSNUMBER.

I believe this is due to user creation/integration issues however i'm really welcoming any inputs and help anyone could provide on this matter. In addition do you believe that these numbers should be in sync? I've tested this with my own self-created user-id and they do contain the same persnumber in both tables.

edit-

I was wrong this isn't due to inconsistencies but instead is due to the persnumber in BUT000 and USR21 table being different at all times. The ADRC table does contain a correct persnumber however we can't retrieve this in a proper manner. Any advise? What i'm trying to do here is retrieve the user-id in table USR21 with only the requester partner details (PO document).

Kind regards,

Tim

Edited by: T. Schuffelen on Jan 21, 2011 4:41 PM