BEX large amount of filter values

[Former Member]

We have BEX Reports within webtemplates for the users. They want to filter a large amount of values (about 100)for e.g. the materialnumber. The materialnumbers for the filter differ from day to day.

Does anybody know how it is possible to add so many values in the filter or in the variable screen without typing them one after another?

Is it possible to add the filter values via an excel sheet?

Thanks for tips.

Eva

[Former Member]

Two options:

User Exit variable: Read a table that is maintained in the variable.

Hierarchy Node: Maintain a hierarchy and filter the query on a node in the hierarchy.

You should condier the performance and maintenance impact of such a requirement.

[Former Member]

Hi,

just some addition.

Filling a variable (a select-option table) with lots of values (like you want maybe 100 entries) may lead to a short dump 'SQL STATEMENT TOO LARGE'.

In that case, if this selection is not too dynamic, I would recommend to use hierarchies and do the restriction on hierarchy nodes instead of single entries.

Siggi