Automate

Hello,

I'm trying to create a query according to LFB1 and then join table BSAK/BSIK.

I need the result from both BSAK/BSIK (even if it's empty in one table for respective vendor)

In the criteria (snapshot attached) I need an "OR" instead of "AND".

Is this possible? And when not may somebody has another solution for me?

Many thanks in advance.

------------------------------
Claudia Nordhorn
Master Data Governance
HAVI Logistics Business Services GmbH
Duisburg
------------------------------

Hi Claudia

We cannot put conditions between fields - it's always an and in Query.  I would suggest submitting a request in the Ideas portal for this feature, if it's not there already - and if so, you can vote for it.

Not 100% sure on your scenario, but have you tried a left outer join?  It may help.

Best Regards,

Sigrid

------------------------------
Sigrid Kok
*Precisely Software Inc.
------------------------------