How to identify the correct BP email address?

[former_member1135226]

Hi,

I am trying to work out what the correct email address is for our BP's both currently and historically.

Currently I am joining the following tables together;

BUT000

BUT021_FS - join to BUT000 on PARTNER; filter on ADR_KIND = 'XXDEFAULT'

BUT020 - join to BUT021_FS on ADDRNUMBER

ADRC - join to BUT020 on ADDRNUMBER

ADR6 - join to ADRC on ADDRNUMBER

ADRU - join to ADR6 on ADDRNUMBER, CONSNUMBER, VALID_FROM and VALID_TO; filter on COMM_TYPE = 'INT' and COMM_USAGE = 'AD_DEFAULT'

If I do this I kind of get what I am looking for but there seems to be a number of data anomalies.

For example ADR6 contains lots of rows where the VALID_FROM and VALID_TO dates are empty. Is this the expected behaviour for this table?

I can get dates from some of the other tables (BUT020 - ADDR_VALID_FROM and TO or BUT021_FS - VALID_FROM and TO), but if I use these dates I sometimes get instances of overlapping dates - again is this to be expected and how the data fits together?

Is the above method overly complicated and do I even need to use the BUT021_FS table?

I tried using just the BUT000, ADR6 and ADRU tables, but using this method there were a lot of rows without VALID_FROM and TO columns populated, so surely there need to be joined to another table to establish a valid from date?

Ultimately I want to know the PARTNER, SMTP_ADDR, VALID_FROM and VALID_TO information for every BP in the system.

Thanks in advance.

[former_member27]

Hi lfletcher23,

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it. I see that you chose only one tag consider maybe there are other relevant tags that can increase the exposure of your question.

* Use the "insert code" feature when sharing your code, so members have an easier time reading.

Should you wish, you can revise your question by selecting Actions, then Edit.

Check the Welcome Corner thread with advice from our champions: https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Regards,

Dedi