How to check the last execution times of Bex Analyzer workbooks

[Former Member]

Hi Gurus,

In my system there are 618 workbooks. I need to check the last execution details of those. Its a finance system. So please help me on this.

Thanks in advance,

Pragyanand

[Loed]

Hi,

Check this:

Regards,

Loed

[sapna_jgurudutt]

Hi Pragyanand,

Can you please check the following tables by going to transaction SE16 in the relevant BW Backend system and check whether it helps you:

RSRWBINDEX

RSRWBINDEXT

RSRWORKBOOK

RSRREPDIR

RSZCOMPDIR

Thanks & Regards,

Sapna

[Former Member]

Hi,

Thanks for the reply but I have already checked these tables but can't find the "Last Used" log for the workbooks.

Thanks & Regards,

Pragyanand

[former_member225306]

Hi,

I dont think you can directly find the last used timestamp. You can instead used join the below tables and derive the data. Tables involved: RSRWORKBOOK,RSRREPDIR,RSZCOMPDIR Keys and steps: 1. RSRWORKBOOK =  2. RSREPDIR- GENUNIID = RSRWORKBOOK-GENUNIID 3. RSZCOMPDIR-COMPUID = RSREPDIR- COMPUID 4. RSZCOMPDIR-LASTUSED will give the last used of the query, which will indicate the last used of workbook Hope this helps

[Loed]

Hi,

You may see the detail in one of the tables here:

Tables in SAP BW which give information related to Queries, Work Books and Web Templates - SAP NetWe...

Regards,

Loed

[Former Member]

Hi,

Thanks for the prompt revert. This list proved quite helpful.

Thanks & Regards,

Pragyanand