Showing results for 
Search instead for 
Did you mean: 

SQVI to display the list of vendors with the email address

Former Member
0 Kudos

Hi can any one please provide me the steps for SQVI to get the list of the vendors(LFA1) with the Email address ( ADR6 )

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

go to t-code sqvi> enter ztest or any cutom name>create>enter title>enter comments

-->slect table join asa a data source and hit enter..

-->press shiftF1 and enter table name LFA1 and again press shiftF1 and enter table ADR6..and hit


now you will get the table relation ship between the LFA1 and ADR6 ..

next go to se16 and get the value for the vendor and pass the value to adr6 ..