Question:
Hi All,
I'm using version 4.6C and have a problem with my user tables especially table USR03 it seems to be out of sync with other user tables.
I did schedule PFCG_TIME_DEPENDENCY to run every night hoping this was going to synchronise these tables but USR03 keeps on having inconsistent data like new users created using SU01 some show in this table some do not, all are dialog users. Some deleted users are still showing in this table.
Please help, I do not know how to sort this out.
Thank you in advance.
Benny_M
Answer:
Table USR03 has not been used since version 2.2. In version 3.0 SAP introduced the address management system and abandoned USR03. There is not sync and you should not use the table or its contemts.
Answer:
John, thank you so much. Tell me what table can I use to find user address data.
Regards
Benny_M
Answer:
I think you should not want to know it.
The users personal data are stored in the table ADRP. The key field is PERSNUM not the username. The relationship between them is in the table USR21.
The addresses are stored in the ADCP table. The key field are PERSNUM and ADDRNUMBER
You can request all user data with the function 'BAPI_USER_GET_DETAIL'. It has 1 input BNAME and several tables as output.
Regards
Zav