on 08-31-2007 7:12 PM
Dear SRMers,
System Information : SRM 5.0, ECC 6.0
I am looking for the following SRM metrics information in the system:
1. The number of users with ability to access the SRM System
2. The actual users accessing the system(Creating Shopping carts etc).
Please let me know where I can find this metrics nformation in SRM.
Thanks in advance.
Points will be rewarded.
Best Regards,
Bob
Hi
<u>Have you tried using Standard SAP transactions - <b>SM04</b> and <b>PPOMA_BBP</b> in this case ?</u>
<b>You will get both the required details in this case.</b>
1. The number of users with ability to access the SRM System
(All users created in Organizational plan using <b>PPOMA_BBP</b> transaction)
2. The actual users accessing the system(Creating Shopping carts etc).
(using SM04 transaction, all the users using SRM will be using transaction names starting with BBPSC* (like BBPSc01, BBPSC02, BBPSC03, BBPSC04, BBP_MON_SC, BBPBWSP, etc...)
Hope this will definitely help.
Do let me know.
Regards
- Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bob ,
To get active SRM users in a month use tabel CRMD_ORDERADM_H . Give date range(posting date) as the month and process type as SHC.
this would give you details of all shopping cart created in the month . extract this and filter it based on created by which would give you the list of user active for the month .
for the total number of SRM users it is exactly the number of user in the org structure, however it would be difficult to get the count. when creating user in SU01 if you would have used the user group field to identify all ORG user then you could extract those user from tcode SUIM. anyway TCODE could be useful to find total number of SRM users depending if you could use criteria such as role , group to identify them.
Please reward points for useful answers.
Cheers
Iftekhar Alam
Hi Iftekhar,
Thanks for your suggestion. I tried what you said, but I am not able to filter out the unique active users from the CRMD_ORDERADM_H table. Please let me know how to do that . Actually I would to get a count of the active users in a month.
Also I would like to get the count of the number of shoppings carts approved in a given month. I tried getting the approved list from the monitor shopping cart but the list is more than 5000 and the system is hanging.
Please let me know if there is any table that I can query to find out.
Points will be awarded for answers
Thanks,
Bob
Hi Bob,
What i meant was to download the shopping cart list form CRMD_ORDERADM_H into an excel sheet and then filter the unique list in excel base don created by. that would give you the active user in month.
to get the number of shooping cart approved in the month use table CRM_JEST. currently i am not in front of system however that table would help u get the shopping carts with status approved.
Please reward points for useful answers.
Cheers
Iftekhar Alam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.