Question:
Hi,
We currently use tran s_bce_68001429 to extract the list of transactions that a user has access to. Unfortunately this only works for one user at a time. Does anyone know if it is possible to extract this list for many users?
Thanks,
Prash
Answer:
That's kind of a tricky one because SAP does not keep transactions per user but by roles (AGR_TCODES). One method that works for me is to donwnload the 2 tables, one for Users and Roles (AGR_USERS) and one for tcodes to roles (AGR_TCODES) and use a database to join the 2 tables on the role field and you can get the USER to Tcode that way. There is one problem that you have to be aware of and that is that AGR_TCODES only list t-codes assigned via menu so if you have manually inserted t-codes in S_TCODE or t-code ranges, they will not show up. The other alternative is to use table AGR_1251 and report on S_TCODE only. Guess you have to play with it and see which one will satisfy your requirements but AGR-1251 is more accurate since it shows all t-codes which is what auditors need to know.
Regards,
m.r.