Skip to Content

BEx translated sql from Hana view for Material Stock

Jul 12, 2017 at 03:12 PM


avatar image
Former Member

Hallo experts,

i have created a Script Calculation view to get the material stock and i have mapped it to an Open ODS view. Upon this Open ODS i have created an Bex querry. When i run it for 1 material it runs fast, but when i run it for multiple materials it takes forever. In the Hana sql server i can see the sql that takes for ever to run and its an sql without any material filter. The problem is the way bex querry is translated to sql, since the same amount of information is easy to get with an sql directly on the same Calcualtion view.

Any thoughts?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers