Hello Team, is there any way to extract user/user group in single master list. I tried below approaches
In qb, unable to get it in single query due to no possibility of inner query.
Also tried with cms repo universe reporting, no luck.
Hence please suggest if any sap authorised macro or some other ways to get this done. Thanks.
You can use the CMS System Database universe.
If you want just a list of all users and groups, Grab your id’s and name, filter on kind inlist User; UserGroup
If you’re looking for a list of users in a group or the groups a user belongs to, then you need to pull your user (or group) objects from the main classes, then use the user-to-groups (or groups to members) object from Relationship to L1 and the id’s and name objects from other L1 classes.
