matrix users and roles

former_member435013 — Wed, 02 Jul 2008 14:01:09 GMT

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--

Regards

Walter Habich

Re: matrix users and roles

Former Member — Wed, 02 Jul 2008 14:54:05 GMT

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

topic Re: matrix users and roles in Application Development and Automation Discussions

matrix users and roles

Re: matrix users and roles