Calculation view - Expression is not working
I have developed Calacualtion view on Billing.
Date - Fiscal period : input parameter
Sales orgn :
If I execute the view ..Data is displaying properly...
Filtering also working fine.for any sales orgn
but I put a filter in expression ( down ) as per requirement is BillingType = Z1A or Z2 or...and BillingDivision = A or F
in(("BillingType",'Z1A','Z2','Z3','Z4','Z5')) and (in ("BillingDivision",'A','F'))
after executing the the data is displaying as raw data but filtering is not working properly except one salesorgn ' NJ' only.
Means If i give the sales orgn = 'NJ' then data is coming correct, If i give the any other sales orgn then getting the below error
Error: SAP DBTech JDBC: : fatal error: Error in the generated plan. See error trace for details.
In BO also getting the same error.
Please suggest me..