view master data for *EMPLOYEE* tables

[Former Member]

Hello Gurus,

1. Can anyone provide assessment on how users can view master data for EMPLOYEE tables using RSD1 or RSDMD, RSA1, SE16, and SE11

2. How can we get users who are having access to 0Employee infocube

BW system has been upgraded to BI,But still we are in BW 3.x Security. Please Assist.

Thanks,

Vijay

[former_member1351727]

Hi,

1) How employees can view user masterdata tables :

We can do this from SE16:

Give table name then we can see the data.So if we give usr02 we can see the logon data like that we have many tables where the masterdata of the users is stored.They all start with usr*

2) Seconad one employee having access to oemployee info cube...

SUIM -user--uers with complex selection should be able to help you.

Thanks.

[Former Member]

In addition to Vani's excellent answer... note that the fields BCODE and PASSCODE are the "encrypted" employee information...

BCODE is the employee secret number for accessing the systems.

I think PASSCODE is the salary and bank account...

If this answers your question, please close the thread.

Cheers,

Julius

[manohar_kappala2]

Hi,

I am guessing that you meant master data for info object 0EMPLOYEE.

You can go to RSD1--> enter 0EMPLOYEE go to display select master data texts and there u will have the details of all the tables containing the relevant master data.

Below are the tables that u can display using SE16

/BI0/MEMPLOYEE Generated Table for View /BI0/MEMPLOYEE

/BI0/OTEMPLOYEE Text SID Structure: InfoObject Employee

/BI0/QEMPLOYEE Master Data (Time-Ind.): Characteristic Employee

/BI0/REMPLOYEE Generated Table for View /BI0/REMPLOYEE

/BI0/SEMPLOYEE Master Data IDs: InfoObject Employee

/BI0/TEMPLOYEE Texts: Char. Employee

/BI0/YEMPLOYEE Attribute SID Table (Time-Dep.): InfoObject Employee

/BIC/CACB0EMPLOYEE_ATTR Transfer Structure Application 0EMPLOYEE_ATTR

/BIC/CCCB0EMPLOYEE_ATTR Transfer Struture Character 0EMPLOYEE_ATTR

/BIC/CE80EMPLOYEEM Generated Table for View /BI0/MEMPLOYEE

/BIC/CE80EMPLOYEET Texts: Char. Employee

Hope this helps

Manohar

Edited by: Manohar Kappala on Jul 11, 2008 3:41 PM

[Former Member]

Hello Manahor,

The Master Data Employee for info object

0EMPLOYEE has below tables.

/BI0/MEMPLOYEE----->View of Master Data Tables: Characteristic

/BI0/QEMPLOYEE----->Master Data (Time-Ind.): Characteristic Em

/BI0/REMPLOYEE----->View SIDs and Char. Values: Characteristic

/BI0/SEMPLOYEE----->Master Data IDs: InfoObject Employee

/BI0/TEMPLOYEE----->Texts: Char. Employee

/BI0/YEMPLOYEE----->Attribute SID Table (Time-Dep.): InfoObjec

Now for Auth Object 0Employee there is no Authorization Revlent Checked. Now each employee is able to see other Employee data. Now we have to implement the authorization for 0Employee info object for above mentioned tables. Need to give assement & how to do the authorization Part in BW. Require some detail Info on the Authorization part of how to restrict Info Object 0Employee for the above mentioned tables. If possible any detailed document will be fine. Out System is upgraded to BI But still we are in BW 3.5 Security.

Thanks,

Vijay

[manohar_kappala2]

Hi,

There is no standard funtionality to control display access to a set of records in this table. You can go to a level of group of tables (through S_TABU_DIS) or to a particular table by creating a parameter transaction.

You can probably create a custom report if need be so that each employee is able to display his own data. (for this you need to be able to tie the 0EMPLOYEE to the log onUser ID field so that you can user the present logon user's ID (SY-UNAME) for providing the input criteria for the report output.

Or else create a BI query with user exit variable doing the same thing for the query.

Hope this helps

Manohar

[Former Member]

Hello,

Thank you very much. Itu2019s a very helpful answer. But my Employees are able to see other employee data. We need to restrict the access in the below mentioned tables. How to restrict in BW. Please Provide a Detail Explanation on how to restrict the tables. Also any restriction needed at Role level.

/BI0/QEMPLOYEE -

---

>Master Data (Time-Ind.): Characteristic Em

View SIDs and Char. Values: Characteristic

/BI0/TEMPLOYEE -

---

> Texts: Char. Employee

Above mentioned are very Critical Tables.

Please explain in detail how to restrict them.

Thanks,

Vijay

[Former Member]

Sorry about my above answer. I misinterpreted your question, as I think Vani did as well...

Please ignore the first 2 posts.

Cheers,

Julius