2008 Jul 02 3:01 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
SMITH--
JACKSONX
X
Regards
Walter Habich
2008 Jul 02 3:54 PM
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
SMITH--
JACKSONX
X
Regards
Walter Habich
2008 Jul 02 3:54 PM
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
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |