on 05-16-2008 6:40 AM
In which table I can get Vendor email ID?
Hi
use LFA1 and ADR6 table combination to get vendor email
Extract both tables in excel
with reference to address number ( which is common in both tables ) put simple
v look up formula so that u will get email address in LFA1 excel sheet
also u can create query using SQVI
( Note that address number is common link betn two tables )
some usefull info i found on SDN about creating query
check if usefull
User T-code: SQVI
Enter your "query name" and press"create"
Enter title
In Data source " select Table join"
select basis mode and press continue.
Press Insert table and give the tabes one by one.
Drag the parameter and drop in another table to establish link and link all the tables.
Press check to check whether your link is correct, then press back
You will be able to see the tables and fields on left hand side.
Select the appropriate parameters for selection fields and list fields
Selection fields- For selection of data, the initial screen of report.
List fields are nothing but output.
Execute the report.
You will find the initial screen of report.
Give your parameters for output and execute again.
You will receive the desired output.
You can down load the output in spread sheet/ in the format desired.
At last save your query before coming out of transaction
Vishal...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
Please check with ADR6.
Reward if helpful.
Thanks and regards,
Naveen Dasari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Friend
You will not get directly from LFA1 or LFB1.
From LFA1 table Pick value against to field ADRNR.
supply this value in ADRC table against to feild ADDRNUMBER to find email maintained against to feild "SMTP_ADDR"
ENJOY SAP
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Vendor Code is LIFNR..once you get that code, put the same in LFA1 table and you will find the vendor's mobile no and e-mail id there.
See get the Address number from LAF1,
now go to ADR6 get the email address.
Go to ADR2 and get the phone details.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
u will get details for vendor email adress in table SZA1_D0100
regards
srinivas kona
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
97 | |
10 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.