cancel
Showing results for 
Search instead for 
Did you mean: 

EMAILID AND TELEPHONE NO

bijuthomas5
Explorer
0 Kudos

Dear Gurus,

From sap R/3 how can i retrive the emaild and the telephone no from the customer master?from which table i can get these information.

kindly help.

Best regards

BIJU

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

You have to table join KNA1, ADR2 (for telephone) and ADR6 (for email) in SQVI where the link between these two is field name ADRNR

thanks

G. Lakshmipathi

Edited by: Lakshmipathi on Jun 1, 2011 10:45 AM

bijuthomas5
Explorer
0 Kudos

Thanks for the reply.

Best regards

Biju

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi ,

It is ADR6 table where you can get email id and telephone no.

thanks

Hemant

Former Member
0 Kudos

Hi,

You can take/retrieve it from table KNA1

Kapil