Email addresses for Business partners

[Former Member]

Hi ,

We have a requirement to purge out email addresses for

1. Specific business partners - BP nos would be provided by the customer.

My understanding is that the Business partner information is stored in the table BUT000 and that the email address information is stored in ADR6 table.

I could identify that ADR6 and ADRC join on Address number and Person Number. However, am not able to identify the common link between ADRC and BUT000..

Can you kindly advise if I am looking in the correct dimension and alternateively help me with the set of tables and the join logic between them,

2. Email addresses specified in the SPRO configuration for Action Definitions( Customs Management)

This information is again stored in ADR6.. How can we identify the mapping between the Action Definition and the email address from the backend tables and purge the same from all the involved tables.

What would be the tables involved.

[Former Member]

Hi,

1. Check the table BUT020. Here you have the common link of Address Number field with ADRC table.

Regards,

Shiva Shankar

[Former Member]

Thank you Shiva..

Can you kindly share some details on how to tie the email address in customs management configuration ( specified for the action definitions ) with the backend table ADRC.

Regards

Jasmit