Like the title says, I'm trying to filter a BSEG extraction as follows:

(KOART = 'K' OR BUZID = 'Z' OR EBELN IS NOT NULL)

AND

(AUGDT >= <%=startDate%> OR AUGDT IS NULL)

In English:

One or more of the following 3 must be true:

• Account Type (KOART) = 'K'
• Line ID (BUZID) = 'Z'
• PO Number (EBELN) IS NOT NULL

AND, One of the following 2 must be true:

• Clearing Date (AUGDT)>= 2021.01.01 (startDate parameter)
• Clearing Date (AUGDT) IS NULL

Screenshot:

However, when looking at the data, I'm not getting any cases where Clearing Date (AUGDT) is null

Whereas, in a previous extraction that omitted AUGDT as a filter field, we have 50K+ Cases with a NULL AUGDT Field, and adhering to the other Filtering Conditions:

Therefore I can only assume that there is something wrong with the way that the filtering works.....that OR should always include cases with a NULL AUGDT.

Not being able to use AUGDT as a filter is causing me to have to extract a gigantic amount of superfluous data (50 Million + Lines)

Any help is much appreciated!

Best Regards,