Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 09, 2011 at 01:19 PM

    Hi,

    Pl refer to following thread

    Thanks and regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2011 at 01:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2011 at 03:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi All,

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

      Thanks & Best Regards,

      - Shashi