Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Vendor Details : Need Clarification

Hi all,

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.

Thanks

Balaji

Former Member
Former Member replied

Hi Balaji,

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 soucetable 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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question