Skip to main content

Hello everybody,

 

I´m trying to create a quickFilter for one of my views.

Problem as follows. I created a Filter in the KM and tried to generate multiple Filters.

I tried multiple FILTER-Statements; seperated with a comma (,).

I tried to combine the filter with AND expressions.

I always see now results and, yes there should be results.

 

Currently, it looks like this:

 

FILTER

        KPI(FORMULA_PO_ITEMS_OVERDUE_ORDERS_WO_GR) = 1 AND

        "EKKO"."BUKRS" = '1000' AND

        "EKPO"."KNTTP" = 'Q' AND

        "EKPO"."KNTTP" = 'K' AND

        "EKPO"."KNTTP" = 'P' AND

        "EKPO"."KNTTP" = 'F' AND

        "EKPO"."KNTTP" = 'E' AND

        "EKPO"."LOEKZ" != 'L' AND

        "EKPO"."MGWS_NONMGWS" = 'Ja - Direkt'

 

Would be great if someome, can help.

 

Thank you.

 

Regards

Daniel

I can't see any errors in the syntaxes,... if I were you I'd try to check each condition alone, then incrementally the combination (i.e. first try KPI(FORMULA_PO_ITEMS_OVERDUE_ORDERS_WO_GR) = 1, then KPI(FORMULA_PO_ITEMS_OVERDUE_ORDERS_WO_GR) = 1 AND 

    "EKKO"."BUKRS" = '1000', and so on... to find the offending clause (or the combination that returns no records)

 

HTH


Have you tried to separate them with a (;)?

 

FILTER KPI(FORMULA_PO_ITEMS_OVERDUE_ORDERS_WO_GR) = 1;

FILTER "EKKO"."BUKRS" = '1000';

FILTER  "EKPO"."KNTTP" = 'Q';

 

etc.

 

 

 

 


Reply