Vendor Details : Need Clarification
I need to develop a report for vendor details with the below mentioned fields.
Vendor# Vendor Name Telephone# Fax# Email ID Payment Block Country
LFA1 will get all the fields except email id ? can i get email id from ADR6...
If so regular query using Sq01 is possible or i have to go for an Technical Development..Can any one please plz let me know.
Darwin Lo replied
You can make a simple query using SQVI, from SQ01/SQ02 just clik the quick viewer button, just create a new quick viewer, name it, select data souce
table join-basis mode.Then go toedit,insert table LFA1 and ADR6, then make sure the link join is correct and you can right click at th join, there you can find the Left outer join.Please try.