cancel
Showing results for 
Search instead for 
Did you mean: 

Tables for Bex Queries

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (3)

Answers (3)

0 Kudos

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

Former Member
0 Kudos

Hi,

For all the data source in ECC corresponding to BW will be available in the tcode RSA5 and you can find the activated datasources in RSA6.  you can search based on the application component.

Regards,
Ashok

0 Kudos

Hi ashok ,

    thank you for your  prompt ....!!!

         in implementation project given info cube and dso , same table description given know how to find out tech name that particular description and tech name

please guide me

regards

Nuthan

Former Member
0 Kudos

Hi Nuthan,

Your question is not very clear.

As per my understanding of your question,

you want to get the datasources for the infocubes/dso's given in the list. If this is what you are expecting then it would be challenging but possible. You have to design your BI infoproviders as per the datasources or based on the business requirement.

let me know are you using standard Cube's and DSO's in BI?

Regards,

Ashok

0 Kudos

Hi Ashok ,

       we are using standard cube and DSO's in BI ,we can find it datasource .but  infoobject given only description , i unable to find out technical name

for example

description             data type     technical name

time period              date            nill

in calendar days

form/to

Material group         char            nill

i think you can understand my issue know clearly. please do needful to me

regards

nuthan

Former Member
0 Kudos

Hi Nuthan,

Material group - 0MATL_GROUP

Time period in calendar days - 0CALDAY

let me know if you need any further info.

Thanks and Regards,

Ashok

0 Kudos

Hi Ashok ,

             thank you for help me . i told example to you , so many table is there we could find out technical name . any easy way to find it out technical name based on description

please let me know.

Regards ,

nuthan

Former Member
0 Kudos

Hi,

You can find the infoobjects in BI content as per the description. You can install it if its not not installed.

If the infoobjects already installed then you can find them in Se11 and put the table name RSDIOBJ and execute it. Here also u can seach the infoobject name as per your description.

Regards,

Ashok

0 Kudos

Hi Ashok ,

           Thank you so much helping me , i am new to this project , please given me mail id if anything i want mail you.

do needful to me

regards

nuthan

Former Member
0 Kudos

This message was moderated.

0 Kudos

Hi

   how can i close the thread ,i would not find any option to me here. can you please guide to me

regards

nuthan

Former Member
0 Kudos

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

Former Member
0 Kudos

hi,

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

pradeep_gupta
Active Participant
0 Kudos
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