Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

matrix users and roles

former_member435013
Active Participant
0 Likes
744

Hi,

is there any sap standard functionality to get a matrix of users and roles like this:

-


Z_ACCOUNTING_ROLE-Z_BASIC_ROLE-Z_SALES_ROLE---Z_TREASURY_ROLE

MEYER---X


X--


SMITH--


X
X
--


JACKSONX


X--


X

Regards

Walter Habich

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
677

report S_BCE_68001400

for so far I know there isn't but when you run the standard report S_BCE_68001400 which shows all the rolles of all the users (click on button roll when you have the list of users) it is quite simple to export it to excel. make a crosstable with the rolles in the top and the usernames at the left. and in the middle count the rolles (which is always 1)

copy all with ctrl a

make a new workspace

and paste special with only values

replace all the 1 in the crosstable data section with X

select the row with all the rolles and turn the text 90%

make the colum width fit to maximum

and you have a splendid crosstable

kind regards

arthur de smidt

Edited by: A. de Smidt on Jul 2, 2008 4:56 PM

Edited by: A. de Smidt on Jul 2, 2008 4:58 PM

Hi,

is there any sap standard functionality to get a matrix of users and roles like this:

-


Z_ACCOUNTING_ROLE-Z_BASIC_ROLE-Z_SALES_ROLE---Z_TREASURY_ROLE

MEYER---X


X--


SMITH--


X
X
--


JACKSONX


X--


X

Regards

Walter Habich

1 REPLY 1
Read only

Former Member
0 Likes
678

report S_BCE_68001400

for so far I know there isn't but when you run the standard report S_BCE_68001400 which shows all the rolles of all the users (click on button roll when you have the list of users) it is quite simple to export it to excel. make a crosstable with the rolles in the top and the usernames at the left. and in the middle count the rolles (which is always 1)

copy all with ctrl a

make a new workspace

and paste special with only values

replace all the 1 in the crosstable data section with X

select the row with all the rolles and turn the text 90%

make the colum width fit to maximum

and you have a splendid crosstable

kind regards

arthur de smidt

Edited by: A. de Smidt on Jul 2, 2008 4:56 PM

Edited by: A. de Smidt on Jul 2, 2008 4:58 PM