cancel
Showing results for 
Search instead for 
Did you mean: 

ADR6 table and cleanup tools

Former Member
0 Kudos

Hi

ADR6 contain SMTP (E-mail Addresses). That's understood. Now for SRM to link to those addresses, I thought you have to use BUT000 and BUT052. That will give you the e-mail address for a Person linked to a particular organization unit. However, we have some users with multiple entries and multiple e-mail addresses in ADR6. The ADR6 record I found linking the person to an organization. Are there any programs to clean this up. Its affecting offline approval via email.

FYI I have used BUT052_ADR6_REPAIR that did not help.

Thank You

Nikhil

Accepted Solutions (0)

Answers (5)

Answers (5)

ivy_li
Active Contributor
0 Kudos

Hi Nikhil,

To get the email address for user(trx BP), please follow this:

=====

1, table BUT000
insert BP number to get PERSNUMBER

2, table ADCP
insert PERSNUMBER to get all the lists and then remember the
ADDRNUMBER for the line with value as 'P' in field COMP_PERS.

3, table ADR6
insert PERSNUMBER and ADDRNUMBER, and you will get the email address
for trx BP.

======

If you only insert PERSNUMBER in table ADR6, you might get more than one entry, and one email for trx BP, and the other is for su01.

Regards,

Ivy

Former Member
0 Kudos

Hi,

There was a SAP Note for this (with z report) but I have no access to service.sap.com/notes right now.

You can write your own report. Please, use this relations for a start:

1. Table BUT000 - in this table we have all BP's

2. Table BUT050 - relation table user-org with relation type BUR010

  - RELNR - relation ID (some kind of GUID). This ID must be same as BUT052-RELNR

  - PARTNER1 - ID of BP organisation

  - PARTNER2 - ID of BP person

  - RELTYP - relation type with table BUR010

3. Table BUT052 - relation table with BP-address

- RELNR - relation ID (some kind of GUID). This ID must be same as BUT050-RELNR

- PARTNER1 - ID of BP organisation

- PARTNER2 - ID of BP person

  - ADDRNUMBER - ID of org address (you can user FM BAPI_BUPA_ADDRESSES_GET for this)

4. Table ADCP - relation BP person and addresses. Use condition COMP_PERS = C and ADDRNUMBER from BUT052

  - ADDRNUMBER - ID of address from BUT052

  - PERSNUMBER - ID of BP person from BUT000-PERSNUMBER

  - COMP_PERS - C for CentralPerson

  - FLAGCOMM6 - this is flag for SMTP address. When is X that means we must use ADR6 table

5. Table ADR6 - relation person and SMTP address

  - ADDRNUMBER - ID of address from table ADCP or BUT052

  - PERSNUMBER - ID of person from BUT000

You can use combination of these tables and delete unwanted relations.

Regards,

Marcin

  -

Former Member
0 Kudos

Hi Marcin,

do you know the note yet?

Kind regards,

Herbert

former_member184111
Active Contributor
0 Kudos

Hi Nikhil,

Try tables BUT000 and BUT020 and then fetch email from ADR6.

Other FMs...

BAPI_USER_GETDETAIL

BAPI_BUPA_ADDRESS_GETDETAIL

ADDR_SELECT_ADR6_ARRAY

Thanks,

Anubhav

former_member208244
Active Participant
0 Kudos

Hello Nikhil,

I do not understand the problem, what do you need to do?

Do you want to clean system tables, why?

Are you facing problems?

Do you want to use thata data for a report?

Regards,

SG

Former Member
0 Kudos

We are seeing the same problem. I have used FM BBP_USER_CHANGE_FIELDS to manually update entries, but for some reason the entries are getting overwritten the next day. The ADR6 entry that seems to be used to approval routing in our case is the person number that is linked tot he Users BP. I find the person number via table BUT000.

Does anyone know the source of this the email address that is linked to the person number as mentioned above? I thought it came from the users BP record or SU01 record, but I have confirmed this is not the case.

Thanks,

Vincent