cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Query change information

Former Member
0 Kudos

Hi All,

Is it possible to know the change log history for any bex query? I can check the last changed from query properties. But is it anyway possible to check who changed it before that and when? Do we have any standard table that creates an entry whenever any bex query is modified by someone?

Thanks,

Indrashis

Accepted Solutions (0)

Answers (2)

Answers (2)

RamanKorrapati
Active Contributor
0 Kudos

Hi Bose,

At RSA1, select meta data repository, click on activated objects in system, including queries. find your query and double click on it. you may see the required information.

look at the these tables also - RSRREPDIR,RSRREPDIR ,RSZCOMPDIR

Thanks

Former Member
0 Kudos

Hi,

From meta data repository , only last changed information is available. I have already checked those tables and we have only last changed information. But I want to know who modified the report and when for the last one year.

Indrashis

Former Member
0 Kudos

Hi Indrashis,

Such information is not available as per my knowledge. However you can store the history from now on to make it available for use after a year or in future.

You can make datasources based on the Tables and extract this data to a dso.

Use the below link for tables.

http://wiki.sdn.sap.com/wiki/display/BI/Tables+in+SAP+BW+which+give+information+related+to+Queries,+...

Regards,

Sujit.

Former Member
0 Kudos

Hi Bose,

Try this table RSZCOMPDIR.