Identify account by domain part of E-Mail address

[Former Member]

Hi All,

We are using IC Web client with ERMS.

When for an inbound E-mail the sender address exists in

a contact relation between an organization and person both account and contact are identified.

sometimes sender address are not in the system (contact person is not known or it is a general address like sdn@sap.com) we want the system to identify the account just based on the domain part and show all the contact persons.

like when receiving an e-mail from sdn@sap.com it should display SAP as the account and all maintained contact person and not responding that this e-mail is unknown.

any suggestions?

Thanks, Eyal.

[gregorw]

Hello Eyal,

you could directly call ADDR_COMM_FIND_KEY with this parameters:

COMM_TYPE INT

SEARCH_STRING *@sap.com

CASE_SENSITIVE_SMTP

USE_WILDCARDS X

But be careful the search is done with this select:

 SELECT * FROM adr6
          INTO CORRESPONDING FIELDS OF TABLE i_adr_tab
          WHERE smtp_srch LIKE m_search_string ESCAPE '#'
          AND   NOT addrnumber                     "*999i
                BETWEEN gv_nrrange10_fromnumber    "*999i
                AND gv_nrrange10_tonumber.         "*999i

SMTP_SRCH is only a CHAR 20 field and so it can happen that the E-Mail Adress is not found because it has more than 20 Characters. You could build your own function Module which directly searches on field SMTP_ADDR.

Regards

Gregor