Workbooks and Menu Roles

[Former Member]

Hi ,

There is some transaction or SAP table where I can check all workbooks with its assigned menu roles?

I mean the whole list of Workbooks - MenuRoles relationship.

Any idea , suggestion will be appreciated.

Regards

FedeX

[fredrik_borlie]

PFCG?

The names of workbooks get stored in the menu of the role.

Regards

Fredrik

[Former Member]

Hi,

Check the tables starting with RSRWB* in BI system.

For your information, below are the tables:

Queries

RSZELTDIR Directory of the reporting component elements

RSZELTTXT Texts of reporting component elements

RSZELTXREF Directory of query element references

RSRREPDIR Directory of all reports (Query GENUNIID)

RSZCOMPDIR Directory of reporting components

Workbooks

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 'Where-used list' for reports in workbooks

Web templates

RSZWOBJ Storage of the Web Objects

RSZWOBJTXT Texts for Templates/Items/Views

RSZWOBJXREF Structure of the BW Objects in a Template

RSZWTEMPLATE Header Table for BW HTML Templates

Rgds,

Raghu Boddu

SAP Certified Security Professional

[Former Member]

Hi,

Have a look at AGR_HIER and AGR_HIERT tables.

Cheers !!

Zaheer

[Former Member]

Hello,

Please check the views in the pfcg. Select Inheritence Hierarchy.

Thanks,

Gowrinadh C