smartform

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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]

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