cancel
Showing results for 
Search instead for 
Did you mean: 

smartform

Former Member
0 Kudos
45

Hi folks,

can somebody tell me how do i get the vendor email id ... which table holds that data.i have to send the smartform as a pdf attachment to the vendor. but i cant find email id ...

thanks

prabhas

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You need to get the Personel and the Address number firast for that Vendor, then foto ADR6 table to get the mail address ...

Regards

Sudheer

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Use the table USR21 and ADR6 for getting the EmailID of venodr and use like this

DATA : lv_pernr LIKE adr6-persnumber,

lv_adrnr LIKE adr6-addrnumber,

lv_usrid LIKE pa0105-usrid,

lv_mail LIKE adr6-smtp_addr,

lv_sendor TYPE syuname,

lv_receiver TYPE string,

lv_header TYPE string,

lv_body TYPE string.

CLEAR: lv_pernr, lv_usrid, lv_adrnr,

lv_mail, lv_sendor, lv_receiver,

lv_header, lv_body .

lv_usrid = gv_ernam.

<b> SELECT SINGLE persnumber addrnumber FROM usr21

INTO (lv_pernr,lv_adrnr)

WHERE bname = lv_usrid.

IF sy-subrc = 0.

SELECT SINGLE smtp_addr INTO lv_mail FROM adr6

WHERE addrnumber = lv_adrnr AND

persnumber = lv_pernr.</b>use the fun modules

UWSP_SEND_MAIL_TO_WEB

SO_NEW_DOCUMENT_ATT_SEND_API1

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

Regards

Anji

former_member189629
Active Contributor
0 Kudos

Hi JM,

You will get the vendor email from the field ADR6-SMTP_ADDR

Hope this helps. If it does, do reward accordingly.

Regards,

Karthik