cancel
Showing results for 
Search instead for 
Did you mean: 

Where SAP BW saves it's workbooks?

Former Member
0 Kudos

Hi everyone,

I'd like to know where workbooks are saved in SAP BW system (phisically). Is there any backup? My college deleted a query and whole workbook disapeared. Is this normal?

Regards,

JN

Accepted Solutions (1)

Accepted Solutions (1)

former_member194802
Active Participant
0 Kudos

Hi

Workbooks always been stored inside a Role.

If you user don't have access to any Role then also any query result from Bex Analyzer

can be stored inside Favourites.

Followings are the SAP tables which will let you know about Worbook storage in SAP BW:

RSRWBINDEX List of binary large objects (Excel workbooks)

RSRWBINDEXT Titles of binary objects (Excel workbooks)

RSRWBSTORE Storage for binary large objects (Excel workbooks)

RSRWBTEMPLATE Assignment of Excel workbooks as personal templates

RSRWORKBOOK u2018Where-used listu2019 for reports in workbooks

Regards,

Vivek Tripathi

Former Member
0 Kudos

Thank you all for your answers.

Since query got deleted (and consequently also the workbook), is there a way to restore the deleted workbook?

Regards,

JN

hai_murali_here
Advisor
Advisor
0 Kudos

Hi,

Usually whatever you see in the Tools are A versions of the objects.You will have respective D version for those objects.

You can install that D version to get the A versions which you can able to access through BEx tools.

If you have the D versions for those objects (workbooks),you will make it available by installing it under RSOR Tcode

Rgds,

Murali

Former Member
0 Kudos

Thank you very much. You saved me a week of hard work...

Regards,

JN

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Workbooks will be saved under favorites folder.

See if a query got deleted the depandant workbooks also will be delete.

for backup am not sure have to search in sdn.

Reg

Pra

Former Member
0 Kudos

Check the table RSRWORKBOOK

Get the ID of the workbook from RSRREPDIR table