Home > TECHNICAL > Finding Email address Customer and Vendor Master on SAP

Finding Email address Customer and Vendor Master on SAP

It’s not quite simple to find email address of Customer and Vendor Master on SAP. You need to activated SQL trace and change email on master to find where email address is stored. Here i share the result of tracing using SQL trace of email addess Customer and Vendor master.

For Customer :

select adr6-addrnumber (email) from table adr6 join table kna1 with key adr6-addrnumber = kna1-adrnr

For Vendor :

select adr6-addrnumber (email) from table adr6 join table lfa1 with key adr6-addrnumber = lfa1-adrnr

ABAP Version :

data : lv_email like adr6-addrnumber.

select addrnumber into lv_email from adr6 as a  inner join kna1 as b on a~addrnumber = b~adrnr.

About these ads
  1. December 17, 2007 at 5:40 am

    Tks for the email address tip. Good overall blog. Keep posting!

  2. September 9, 2008 at 6:58 am

    The using transation/OZSA02 movement is very good in Sale posting. But using AS02 but error oquied? give me any suggession of new version.In the programe of sale posting.? /Zsa03 using in not good. What will be manage the sale posting programme.

    Thanks Regards
    Pradeep Achuthan
    EMKE Group
    Sultanate of Oman

  3. Srikanth
    February 5, 2009 at 5:51 am

    Thanks Guys .

  4. Santosh
    June 29, 2009 at 8:45 am

    Thanks a lot !

    I have made new SQVI querry with help of this information.

    Thanks & Regards,
    Santosh

  5. Sandra
    November 23, 2009 at 8:34 am

    Thankssss…. :)
    really helpfull

  6. Sonya Banner
    February 18, 2010 at 4:30 pm

    Hi, I’m a user at my company. I’m not in IT. The challenge is progress is very slow here and I’d love to get an answer quickly.

    I have access to the Customer Master and work with someone who manages updates there. Is there a quick code that can be used to get to the field (s) OR pages where the address can be placed? I believe we’re on version 3.1 or 3.0. Also, if there is a quick code, are there other pages I need to go to to load.

    Any assistance provided is very much appreciated.

  7. Anji
    October 17, 2011 at 5:25 am

    Thanks alot……..

  8. venkat
    November 11, 2012 at 7:00 pm

    awesome, thnak you for sharing your knowledge

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: