on 03-02-2012 8:52 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
-
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.