Automate

We created a query on Winshuttle with table LFA1 and EKKO. The idea is to list all the vendors on LFA1 with their relevant SAP Agreement number on EKKO, if there is any. If there is no SAP Agreement, but there is a purchase order, the vendor will not be listed. However, if there is a SAP or no SAP Agreement and no Purchase Order, the vendor will be listed on the report. Please assist.

------------------------------
Willie Nel |
------------------------------

It sounds like you need at least 2 queries that can generate your required output in the same sheet. You can chain them if you like. 
My colleague Tammy Lake did a neat WUGinar on Query best practices with a similar use case pulling vendor information using a few chained queries which will give you some ideas. 

https://www.winshuttle.com/assets/webinar-wuginar-query-best-practices/

Hope that helps
Jayasri

------------------------------
Jayasri Varyani | Solutions Engineer
Winshuttle North America |
------------------------------

Original Message:
Sent: 02-27-2019 08:03
From: Willie Nel
Subject: Winshuttle Query (LFA1/EKKO)

We created a query on Winshuttle with table LFA1 and EKKO. The idea is to list all the vendors on LFA1 with their relevant SAP Agreement number on EKKO, if there is any. If there is no SAP Agreement, but there is a purchase order, the vendor will not be listed. However, if there is a SAP or no SAP Agreement and no Purchase Order, the vendor will be listed on the report. Please assist.

------------------------------
Willie Nel |
------------------------------