cancel
Showing results for 
Search instead for 
Did you mean: 

USR21 and BUT000 table are not in sync

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Ramki
Active Contributor
0 Kudos

Hi,

For each SRM document, there is a FM to get details of the document.

For example, for RFx response, it is BBP_PD_QUOT_GETDETAIL. For PO, I think it's BBP_PD_PO_GETDETAIL.

When you execute this FM for any document, in E_PARTNER, you get partners details along with PERS_NO and ADDR_NO also.

Try this ADDR_NO in ADRC table.

Best regards,

Ramki