Email address of customer in f4

[jaheer_hussain]

Hai,

I have one requirement like sending external mail to customer.

My selection screen is like this:

**selection screen*****

Parameters:p_mail like......

when I press F4 , I should get all customer email ids.

How to get this? Any standard search help????

Any tips?

WIth Regards,Jaheer.

[Former Member]

Hi

Mail ID 's are stored in ADR6 table field is (SMTP_ADDR)

Using this table you can create a search help and use

but this table doesn't have customer no only have customer address number (ADRNR)

Beteer creata Z table with fields like KUNNR,NAME (from KNA1) and this Mail id (SMTP_ADDR) and using that table create a search help and use

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

please do the below steps so that F4 help will work where ever you use this matchcode object.

Step1: Execute transaction SE11

Step2: Create new search help called 'ZSH' (must be less than 5 chars long to be used as matchcode)

Step3: Enter the following details:

<b>see the link for for screen shot of the field placed .

please place 2 fields and the table name as ADR6 .</b>

1 .ADDRNUMBER

2. SMTP_ADDR

<a href="http://">http://www.sapdevelopment.co.uk/dictionary/shelp/shelp_basic.htm</a>

Step4: Save and activate

Step5: Add following line into your program:

PARAMETER p_adrn LIKE ADR6-ADDRNUMBER  MATCHCODE OBJECT zsh.

reward points if it is usefull....

Girish