Skip to Content
avatar image
Former Member

Calculation view - Expression is not working


Hi ,

I have developed Calacualtion view on Billing.

Selection screen:

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: [3]: fatal error: Error in the generated plan. See error trace for details.

In BO also getting the same error.

Please suggest me..

Regards,

Kamruz

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • May 19, 2015 at 01:13 PM

    Hi Kamruz,

    Please check if the below expression works for you.

    ("BillingType" in ('Z1A','Z2','Z3','Z4','Z5') and "BillingDivision" in ('A','F'))

    Regards,

    Varma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 19, 2015 at 11:56 PM

    Hi Kamruz,

    after executing the the data is displaying as raw data but filtering is not working properly except one salesorgn ' NJ' only.

    When you say this, is select * on your calculation view working fine? If you are able to see entire without filters, then it can not be issue with filters?

    can you try to run select statement in sql console on your calculation view and try to run the same select statement with different sales org filters and see what error you get?

    try to look at trace file and see if you can find more information.

    Regards,

    Venkat N.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thanks for the reply.

      This thing happend after the recent upgradation.... I have created a new calculation view ( local package) adding the same join / projection / expression as earlier and resolved...Did'nt get any clue about the issue..

      So I deleted the old view and refactor new view to move main package..

      Finally the view is working fine now..no issue BO also

      (in ("BillingType" ,'Z1A','Z2','Z3','Z4','Z5')) AND (in ( "BillingDivision" in ('A','F'))