Qlik Gold Client: Resolve User address inconsistencies

[Miguelsantunes]

In SAP, addresses are stored centrally in ADRC for various entities, such as users, business partners (customers/vendors), employees, etc. 

If the best practices for Gold Client are not followed, especially creating an empty target client, copying master data and executing the Number Range bump (to artificially increase the current numbers and avoid conflicts between data in source vs target), inconsistencies can happen.

Scenario One

A common scenario is when the users or company addresses between the source and the target are not aligned.

If you do a client copy, the users will get inconsistent because of divergent entries in Address data (ADRC table). This can lead to short dumps. Example: When creating new users in SU01.

Follow this standard approach to resolve the above scenario:

1. Go to transaction SUCOMP
2. On the title bar, select: Company then Standard address (Shift + F6)
3. The Company field contains the default company name 
4. On the header, select: Change (Shift + F4)
5. The default company address can be maintained 

After the default company is maintained please execute the report RSADRCK2 via transaction SE38 to assign the default company address to the users.

Afterwards, the address data will also be shown in SU01.

Scenario Two

In other scenarios for Adress Data in:  Business Partners, Customers, Vendors, Users or Employees when the matching address data can be realigned with Qlik Gold Client.

For that, please EXPORT the corresponding data from the source using /HTG/ZGOLD -> Data Snap and then IMPORT on target using  /HTG/ZGOLD -> Import Control with option Replace Conflicting Data.

Data types:

• SEC - USER DATA (for users + profiles)
• CA - BUSINESS PARTNERS (for BPs)
• CA - VENDOR MASTER (for vendors)
• SD - CUSTOMER MASTER (for customers)
• HR - EMP MAST WITH PAY POSTING (for employees)

If you cannot resolve the issue, submit a support case with Qlik Support, and the Qlik Gold Client team will respond accordingly. See How to Submit a Qlik Gold Client Support Case for details.

Related Content

Refer to SAP notes:

• 0459763 - Data inconsistency in table USR21
• 2310559 - Error in SU01 user creation - CX_SUID_IDENTITY_NO_CHECK dump
• 2468479 - How to maintain the default company address
• 3151050 - There is a data inconsistency in the company addresses

Environment

• Qlik Gold Client