Bex - Query Mass Change

[Former Member]

Hello Gure,

I am in a requirement where I need to put a filter in all my Bex quires with company code.

We have almost 2000 plus quires and I need to filter them all with company code and we donu2019t have much time and resources to handle this.

So I thinking to do with ABAP. Please let me is there any way I can achieve the through ABAP coding.

I did some analysis and find out some table where the query data stored.

Like table Below

RSZCOMPDIR Query Name

RSZRANGE Range

RSZELTDIR - Technical Name

RSZELTXREF Reff Name

Please advise me .

[Former Member]

Created a program to change the Query tables.

Saleem.

[former_member241911]

Hi,

I´m just doing the same (add filter). The program changes some tables like RSZRANGE, RSZSELECT, RSZELTDIR, RSZELTXREF and RSZELTPROP.

But how do I get the queries being generated?

So far after using the programm I tried RSRT and generate the report, but then I get an error (variable not correctly used). When opening the query in Query Designer the error is mentioned, but I can save the query and all is fine, means the error is gone.

regards Arne

[dmitry_yudin]

Hello Saleem.

Are you updating tables directly or through the SAP function modules?

regrads,

dmitry