Skip to Content
avatar image
Former Member

Tables for Bex Queries

Dear All,

Is there any way to know in which SAP BW table the technical name, description, creation data of reports created using Bex Analyzer is stored?

Please help me with this.

Regards,

Rita

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 05, 2012 at 04:40 AM

    Hi Rita,

    If you want to know such details,while you are opening a particular query, press properties button you will get the details.

    You will find information about technical names and description about queries in the following tables. Directory of all reports (Table RSRREPDIR), Directory of the reporting component elements (Table RSZELTDIR) for workbooks and the connections to queries check Where- used list for reports in workbooks (Table RSRWORKBOOK) Titles of Excel Workbooks in InfoCatalog (Table RSRWBINDEXT).

    Regards,

    Prerna

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2012 at 06:31 AM
    RSZELTDIR
    Directory of the reporting component elements
    RSZELTTXT Texts of reporting component elements RSZELTXREF Directory of query element references .
    To get a list of query elements built on that cube.filter by: OBJVERS = 'A', INFOCUBE= [stage:cubename] RSRREPDIR
    Directory of all reports (Query GENUNIID) .
    To get all queries of a cube.filter by: OBJVERS = 'A', INFOCUBE= [stage:cubename] RSZCOMPDIR Directory of reporting components.
    To get query change status (version, last changed by, owner) of a cube. RSZRANGE Selection specification for an element RSZSELECT
    Selection properties of an element
    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
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 05, 2012 at 08:22 AM

    hi,

         you can know all details from RSA1 -> Metadata Repository.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2016 at 09:43 AM

    Hi Friends ,

      we are doing SAP BI implementation project. business blueprint documents given cube/dso name and table description. how to find out technical name In ECC side.

    Can please guide to me

    regards

    nuthan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      As you started the discussion in the thread which was already answered, you are not able to close it.

      Please start a new thread.

      Regards,

      Ash 😊