on 06-01-2011 5:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
It is ADR6 table where you can get email id and telephone no.
thanks
Hemant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can take/retrieve it from table KNA1
Kapil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.