Program to get all the query elements with UIDs with EN texts of a BW query

[Former Member]

Hi All,

Need a program to get all the query elements with UIDs with EN and Other language texts, of a BW query.

We are doing a global implementation.

We are implementing Translations in French.

We need to see, the list of all UID's of a query, their EN texts and the FR texts.

Tried a bit, we are having the problem in getting the UIDs of the structure elements.

Thanks in advance,

Best Regards,

- Shashi

[former_member188080 · Accepted solution]

Hi,

Pl refer to following thread

Thanks and regards

[Former Member]

Hi,

As I know you will have to find out this information manually from following two tables,

1) Go to RSRREPDIR table and get the list of active reports in your system, you can copy all the GUID's from this table. If you know the infoprovider name then you can get the list per infoprovider.

2) After that go to table RSZELTTXT and put all the GUID's and select the required language, you will get required description of reports.

If you know any ABAPER then you can create a small program in SE38 using above two tables and use it afterwards.

Regards,

Durgesh.

[Former Member]

Hi All,

Thanks for all your inputs. Points awarded.

On Execution of the program, the selection parameters would be one or more technical names of the queries.

What I need is the data in the following format:

Query COMPID |||||||| Seq.No ||||||| Query Element UID ||||||| EN Text ||||||| FR Text

Basically, I need a table with these five fields filled.

The Seq. No, just to know the total number of elements.

FR stands for French Language. EN stands for English,

We can make the Language 1 and Language 2 as also selection parameters, so that the program is dynamic and can be used for any two lanugages at a time.

Thanks & Best Regards,

- Shashi

[Former Member]

Hi All,

The solution is achieved with the working on just three tables: RSRREPDIR, RSZELTXREF and RSZELTTXT.

Thanks & Best Regards,

- Shashi

[Former Member]

Hi ,

Below is the list of important tables related to query.

RSZELTDIR Directory of the reporting component elements

RSZELTTXT Texts of reporting component elements

RSZELTXREF Directory of query element references

RSRREPDIR Directory of all reports (Query GENUNIID)

RSZCOMPDIR Directory of reporting components

RSZRANGE Selection specification for an element

RSZSELECT Selection properties of an element

RSZELTDIR Directory of the reporting component elements

RSZCOMPIC Assignment reuseable component <-> InfoCube

RSZELTPRIO Priorities with element collisions

RSZELTPROP Element properties (settings)

RSZELTATTR Attribute selection per dimension element

RSZCALC Definition of a formula element

RSZCEL Query Designer: Directory of Cells

RSZGLOBV Global Variables in Reporting

RSZCHANGES Change history of reporting components

Hope this will help you...

Thanks,

Jitendra