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.