topic How to insert update standard table AGR_USERS? in Application Development and Automation Discussions

How to insert update standard table AGR_USERS?

suityan98 — Thu, 28 Jul 2022 03:18:49 GMT

Hi, currently my company create a program to upload roles in txt file to insert and delete roles of a user, however, I am facing a problem which is the program unable to add new roles for the new user in sap ABAP. This is because the new user without any role will not available in the standard table agr_users, any recommended ways to insert roles to the new users using any function module or bapi? Thank you.

Re: How to insert update standard table AGR_USERS?

Colleen — Thu, 28 Jul 2022 03:35:12 GMT

are you calling the BAPIS? I think they are: BAPI_USER_ACTGROUPS_ASSIGN and BAPI_USER_ACTGROUPS_DELETE

Re: How to insert update standard table AGR_USERS?

suityan98 — Thu, 28 Jul 2022 05:10:35 GMT

yes nothing change

LOOP AT GT_FILE_USER.
      "CHECK CURRENT ROLE TO AVOID DELETE LAST ROLE INSERTED
      CALL FUNCTION 'SUSR_USER_AGR_ACTIVITYGR_GET'
        EXPORTING
          USER_NAME                 = GT_FILE_USER-USRID
*         WITH_TEXT                 = ' '
        TABLES
          USER_ACTIVITYGROUPS       = LT_CURRENT_ROLES
       EXCEPTIONS
         USER_NAME_NOT_EXIST       = 1
         OTHERS                    = 2.

      APPEND LINES OF lt_CURRENT_ROLES TO LT_ROLES.


      CALL FUNCTION 'BAPI_USER_ACTGROUPS_ASSIGN'
        EXPORTING
          USERNAME             = GT_FILE_USER-USRID
        TABLES
          ACTIVITYGROUPS       = LT_ROLES
          RETURN               = LT_RET .

Re: How to insert update standard table AGR_USERS?

Former Member — Thu, 28 Jul 2022 05:47:21 GMT

suityan98

What message(s) does the BAPI return?

Re: How to insert update standard table AGR_USERS?

Sandra_Rossi — Thu, 28 Jul 2022 07:31:52 GMT

suityan98 Did you commit the changes? (BAPI_TRANSACTION_COMMIT)

Re: How to insert update standard table AGR_USERS?

Former Member — Thu, 28 Jul 2022 08:41:44 GMT

sandra.rossi AFAIK security related BAPI's contain their own commit.