paper

sap table query user group assignment

TutorialKart

Sap assignmentusergroup tables, top sap tables.

  • ABAP Snippets
  • Top SAP Courses
  • Top SAP Books

SAP and ABAP Free Tutorials

SAP Users Tables (for Personal, Logon, and Address Data)

SAP Users Tables

SAP user tables will cover the most important standard Tables in SAP storing all the data for SAP User.

First, we will start with the most used SAP users Tables, then you will get the full list of the tables for users.

In the middle, we will set a useful scenario to retrieve address data for SAP users.

Table of Contents

The Most User SAP Users Tables

Let’s start this part with the Main SAP Users Tables name :

Find the source of the following tables’ list.

SAP User Data and Address from Table

Link between sap user master tables and sap user address.

The Link between SAP Users Tables and its Address including SAP userName, SAP user Last Name, email, telephone … starts with the SAP user Table USR21.

The main Keys for USR21 is BNAME (Username in User Master Record). The USR21 links the SURNAME and :

Username in User Master Record

  • PERSNUMBER: Person number
  • ADDRNUMBER: Address number

Once you go the SAP User’s Personal Number and the Address Number, the next step is to retrieve Master Data and Address Data.

Main SAP Address Tables

The main list of SAP Address Tables are:

Check also SAP Address : Important Tables and BAPI

Retrieve SAP username for SAP Users Tables

For example, if you want to retrieve the SAP username, use the table ADRP .

The ADRP-NAME_FIRST and ADRP-NAME_LAST store the first name and the last name of the SAP user. Hence, T=the full SAP username can be found in the ADRP-NAME_TEXT.

So SAP username Tables and Fields are:

  • ADRP-NAME_FIRST: First name
  • ADRP-NAME_LAST: Last Name
  • ADRP-NAME_TEXT : Full SAP username

Alternatively, you can check this standard BAPI BAPI_USER_GET_DETAIL to retrieve the SAP username from the user id

SAP User Email Table

In order to retrieve SAP User Email, get the personal number and the Address number from SAP User Table USR21.

Then with both of these keys, make a select on table ADR6 . The SAP User Email field is ADR6-SMTP_ADDR.

An alternative is to use the SAP Function Module to get user email address: HR_FBN_GET_USER_EMAIL_ADDRESS

Check also Full ABAP Program How to Delete Customer Address in SAP

Full list of User’s Tables in SAP

Here the list of all Related SAP Users Tables:

SAP User USR* Tables

The SAP Tables USR* stores the SAP User Data such as Address, logon …

Let’s start with the main important, the SAP user USRNN tables:

SAP USRA*, USRC*, USRD*, USRF* Tables

Some interesting data for SAP User can be found in the following tables:

USRACL Tables: store the SNC Data. In the other hand, for example the

SAP USRBF* Fast RFC Logon Tables

SAP USRBF* Tables contain the User Buffer Data or Fast RFC Logon.

SAP USRCD* Tables

The SAP USRCD* Tables store the Change Documents structures by user.

SAP USRD*, USRF* Tables

Here the list of SAP Users Tables starting with USRA*, USRD* and USRF*

SAP Users Tables USREL*

In you are looking for some User Administration Data and Relationship, check USREL Tables:

Other USR* SAP Users Tables

Here the missing part of SAP User Tables:

SAP UST* Tables

SAP UST* User tables are mainly for User Masters and User Administration:

Related Posts

SAP Workflow Tables SAP Workflow Tcodes

SAP Workflow Tcodes and SAP Workflow Tables

July 12, 2018 January 21, 2020

SAP OTR, Online Text Repository OTR Tcodes Tables Function and Translation

SAP OTR Tcodes, Tables, Function and Translation

December 21, 2017 January 21, 2022

JSON and ABAP

List of The most important JSON ABAP Classes in SAP

December 19, 2017 January 21, 2020

Sap user group Table in SAP

  • SOUC Table for SAPoffice: Inverse user (SAP user) Table Type : TRANSP Package : SO Module : BC-SRV-COM
  • ACO_GROUP_HIER Table for ACO: User Groups to User Group Table Type : TRANSP Package : ACO Module : CA
  • UMM_CO003 Table for User Group User Table Type : TRANSP Package : UMM Module : FIN-SEM-CPM-MC
  • PRICAT_003 Table for PRICAT inbound: Assignment of SAP mat. group - purch. group Table Type : TRANSP Package : VPRI Module : SD-EDI
  • WRF_PRICAT_002 Table for Assign External Material Group - SAP Material Group Table Type : TRANSP Package : WRF_VPRI_IN Module : SD-EDI
  • SMI_UG_SGASSGN Table for User Group to Search Group Assignment Table Type : TRANSP Package : BS_SOMI_DATA_MODELS Module : CA-EPT-SMI
  • ADR7 Table for Remote Mail Addresses (SAP - SAP - Communication; BAS) Table Type : TRANSP Package : SZAD Module : BC-SRV-ADR
  • AGR_BUFFI3 Table for Internet links table - SAP versions of SAP roles Table Type : TRANSP Package : S_PROFGEN Module : BC-SEC-AUT-PFC
  • AGR_HIER3 Table for Menu structure information - SAP version of SAP roles Table Type : TRANSP Package : S_PROFGEN Module : BC-SEC-AUT-PFC
  • AQBWCAT_SAP Table for InfoSource Catalog (SAP Query) Used by SAP Table Type : TRANSP Package : RSUQ Module : BC-BW
  • AQBWFCAT_SAP Table for Field catalog for InfoSources (SAP Query) used by SAP Table Type : TRANSP Package : RSUQ Module : BC-BW
  • AQIF_S Table for SAP Query: Interfaces (SAP) Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • CLB2S_SRV_PTYPE Table for Service Providers connected to a SAP Application (SAP Table) Table Type : TRANSP Package : CLB2_CUST Module : CA-UI2-AR-SM
  • DD02T Table for SAP DD: SAP Table Texts Table Type : TRANSP Package : SDIC Module : BC-DWB-DIC-AC
  • FDM_ESYS_MIRROR Table for Original Systems (SAP or Non-SAP System) Table Type : TRANSP Package : FDM_AR_COLL_MIRROR Module : FIN-FSCM-COL-AR
  • T5M8F Table for SAP-PBS interface: Assign SAP PBS wage types (DK) Table Type : TRANSP Package : PC09 Module : PY-DK
  • /UI2/NWBC_CFG_GT Table for SAP GUI Tags: SAP Delivery Table Type : TRANSP Package : /UI2/NWBC_CORE Module : CA-UI2-INT-BE
  • /UI2/NWBC_S_GT_T Table for SAP GUI Tags: Texts of SAP Tags Table Type : TRANSP Package : /UI2/NWBC_CORE Module : CA-UI2-INT-BE
  • AAF_ROLES Table for SAP Authorization Assistant - User-Specific Favorites Table Type : TRANSP Package : S_PROFGEN_OBSOLETE Module : BC-SEC-AUT-PFC
  • AQGDBBG Table for SAP Query: User Groups Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • AQGDBBN Table for SAP Query: Assigning Users to User Groups Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • AQGDBBS Table for SAP Query: Assigning Functional Areas to User Groups Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • AQGTB Table for SAP Query: Texts for User Groups Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • AQTXTBS Table for SAP Query: Functional Areas and User Groups Text Table Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • AQXINTUG Table for SAP Query: Enhanced Folders - User Groups Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • BCST_SU Table for BCS: Folder for Semantic and Technical SAP User Key Table Type : TRANSP Package : SBCOMS Module : BC-SRV-COM
  • FMISPSUSER Table for Special Control Table for FMISPS per User(only SAP internal) Table Type : TRANSP Package : FMBS Module : CRM
  • FPIA_GROUP_CT Table for Text table for user groups for IoA process (SAP) Table Type : TRANSP Package : FPS_IOA Module : FI-LOC
  • FPIA_GROUP_S Table for User groups for IoA process (SAP) Table Type : TRANSP Package : FPS_IOA Module : FI-LOC
  • FPIA_GROUP_ST Table for Text table for user groups for IoA process (SAP) Table Type : TRANSP Package : FPS_IOA Module : FI-LOC
  • PSO43USER Table for Global Settings AO/FI IS-PS per USER (SAP internal only) Table Type : TRANSP Package : FMFI Module : PSM-FM-PO
  • SAPWLROLED Table for SAP Workload: Storage of User-Specific ST03N Role Table Type : TRANSP Package : SAPWL_FRONTEND Module : BC-CCM-MON
  • SAPWLROLES Table for SAP Workload: Table for User-Specific Parameters Table Type : TRANSP Package : SAPWL_FRONTEND Module : BC-CCM-MON
  • SGLWLSLIST Table for SAP Workload: User-Specific System List for Global Analysis Table Type : TRANSP Package : SAPWL_FRONTEND Module : BC-CCM-MON
  • SHLPUSRVAL Table for User Settings for SAP Library (Display) Table Type : TRANSP Package : SIWR Module : BC-DOC-HLP
  • SLIBUVAL Table for User Settings for SAP Library (Display) Table Type : TRANSP Package : SIWR Module : BC-DOC-HLP
  • STXTRCUSR Table for SAP Smart Forms: User-dependent Trace Settings Table Type : TRANSP Package : SMART Module : BC-SRV-SSF
  • SWBUSRDFLT Table for Default Values of SAP User for Prog./Trans./FMs Table Type : TRANSP Package : SWB Module : BC-BMT-WFM
  • TAQTS Table for SAP Query: Transprt of Queries, Functn. Areas and User Grps Table Type : TRANSP Package : SQUE Module : BC-SRV-QUE
  • TGSUO Table for SAP Structural Graphics: User-Specific Settings Table Type : TRANSP Package : SGRP Module : BC-FES-GRA
  • TGSUS Table for SAP Structural Graphics: User-Specific Task Sizes Table Type : TRANSP Package : SGRP Module : BC-FES-GRA
  • TGSUV Table for SAP Structural Graphics: User-Specific Settings Table Type : TRANSP Package : SGRP Module : BC-FES-GRA
  • TGSUX Table for SAP Structural Graphics: User-Specific Task Sizes Table Type : TRANSP Package : SGRP Module : BC-FES-GRA
  • THELP Table for SAP User Settings for the Help Processor Table Type : TRANSP Package : SHEL Module : BC-DOC-HLP
  • TN2USRMA Table for IS-H*MED: Assignment of SAP user ID to employee Table Type : TRANSP Package : NMED Module : CRM
  • TNE00 Table for IS-H: SAP User Exits Table Type : TRANSP Package : NBAS Module : CRM
  • TNE0T Table for IS-H: SAP User Exit - Description Table Type : TRANSP Package : NBAS Module : CRM
  • TUTYP Table for SAP System User Type Texts Table Type : TRANSP Package : SLIM Module : BC-SRV-LIM
  • TVT_CA_USR Table for Assignment Between Forwarding Agent and SAP System User Table Type : TRANSP Package : VTRC Module : CRM
  • USRSYSUTYP Table for CUA: Texts for User Types in SAP System Table Type : TRANSP Package : SLIM Module : BC-SRV-LIM
  • VFPRCC_UERATTR_S Table for Relevant attributes of pricing user exits (SAP delivery) Table Type : TRANSP Package : VF_PRC_CUSTOMIZING Module : SD-BF-PR
  • CKMOD_USER Table Data element for Normal SAP user or special user '#SAP#'
  • CKMODUSER Table Data element for Normal SAP User or Special User '#SAP#'
  • UNAME_FLAG Table Data element for Indicator: Use SAP User Name as GDS User User
  • AQS_BGNAME Table Data element for SAP Query (S): Name of a user group
  • AQ_BGNAME Table Data element for SAP Query: User group
  • HREXP_QUERY_USERGROUP Table Data element for SAP Query: User group
  • AQL_UGROUP Table Data element for SAP Query (L): Name of a user group
  • DSWPDNMUSRTYPE Table Data element for User type - System User or Business partner or external user
  • AAA_OBJ Table Data element for User or User Group
  • XUCLASS Table Data element for User group in user master maintenance
  • IE4N_USERID Table Data element for User/User Group
  • JXUCLASS Table Data element for User group from user master record

Sap user group Table in SAP

Sap user group related terms

Definitions.

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

Popular Table Searches

Latest table searches.

IMAGES

  1. List SAP User-Roles Assignments in ABAP Code

    sap table query user group assignment

  2. How to Create an SAP User Group in SAP Query?

    sap table query user group assignment

  3. How to Create an SAP User Group in SAP Query?

    sap table query user group assignment

  4. SAP Query Step by Step Guide

    sap table query user group assignment

  5. Define Customer Account Groups in SAP

    sap table query user group assignment

  6. How to Create an SAP User Group in SAP Query?

    sap table query user group assignment

VIDEO

  1. How to Create Users and Groups in Ubuntu Server

  2. 21- SAP Customer Account Group

  3. Make Table Query in Microsoft Access

  4. Microsoft Access 2010 Queries: Group and Calculate Data Fields

  5. Tableau Server Admins User Group

  6. How to Export a Particular / Specific Columns from a Table

COMMENTS

  1. Assigning Users to User Groups (SAP Library

    To assign a user to one or more user groups, proceed as follows: Enter the user name in the field User on the initial screen. Choose Assign user. In the list of user groups, select the groups to which you want to assign the user. Save the assignment. In user group lists you can revoke change authorization for queries from those user groups to ...

  2. SAP Assignment User Group Tables

    SAP Assignment User Group Tables : USGRP - User Groups Tcode, TMUSERG - User Groups Tcode, SKW_AGRPS - User Groups Tcode, GRACREQUSERGRP - User Groups Tcode, ACO_GROUP - ACO: User Groups Tcode ... SAP Query: Texts for User Groups: BC-SRV: USR21: User Name/Address Key Assignment: BC-SEC: FPCR_USER_ACC: Assignment of User to Accountant: FI-AP:

  3. User Group in SAP

    A category in user maintenance. You can assign every user to one or more user groups. These can be used to distribute users among different administrators and distribute user data, thus accelerating central user administration. SAP Query (BC-SRV-QUE) : An SAP Query object. User groups determine the queries that a user is allowed to execute or ...

  4. USGRP_USER (Assignment of Users to User Groups) Table in SAP

    USGRP_USER Fields, Structure, and DDIC. USGRP_USER is a standard User and Authorization Management Transparent Table in SAP Basis application, which stores Assignment of Users to User Groups data. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

  5. Table for sap query users group and assigned user

    Is there any table that will show me a list of users assigned to user groups instead of using transaction code SQ03. I have table AQGDBBN, but it'll only shows Global Area (Cross-client) groups and assigned users, but I need to see the groups used in Standard Area(Client-Specific) also. Thanks, Anuj jain

  6. SAP Users Tables (for Personal, Logon, and Address Data)

    SAP User Email Table. In order to retrieve SAP User Email, get the personal number and the Address number from SAP User Table USR21. Then with both of these keys, make a select on table ADR6. The SAP User Email field is ADR6-SMTP_ADDR. An alternative is to use the SAP Function Module to get user email address: HR_FBN_GET_USER_EMAIL_ADDRESS.

  7. Sap query: user group Table in SAP

    Here is a list of possible Sap query: user group related tables in SAP. You will get more details about each SAP table by clicking on the table name. AQGQCAT. Table for SAP Query: Query Catalog. Table Type : TRANSP. Package : SQUE. Module : BC-SRV-QUE. AQGQSTRUC. Table for SAP Query: Query / Structure Assignment.

  8. User Groups Tables in SAP

    Transparent Table 49 : AQGTB SAP Query: Texts for user groups: Basis - SAP Query: Transparent Table 50 : AQGDBBS SAP Query: Assigning Functional Areas to user groups: Basis - SAP Query: Transparent Table 51 : ACO_GROUP_HIER ACO: user groups to User Group Cross Application - Cross-Application Components: Transparent Table 52 : CFX_GRP_USER

  9. How to Find User Groups Accessed by Users Running SQ01 Queries

    In the AQB parameter you can fill the preferred query-usergroup. You can leave the parameters empty but thy should be there. spiceuser-fa7b5zs4 (spiceuser-fa7b5zs4) February 7, 2013, 4:11pm 3. SQ03 is used for user groups. previoustoolboxuser (previous_toolbox_user) February 7, 2013, 10:40am 4.

  10. User Groups TCodes in SAP

    user Maintenance Basis - User and Authorization Management: 2 : PFCG: Role Maintenance Basis - ABAP Authorization and Role Management: 3 : SQ03: SAP Query: Maintain user groups: Basis - SAP Query: 4 : SUGR: Maintain user groups: Basis - User and Authorization Management: 5 : SUGRD: Display user groups: Basis - User and Authorization Management

  11. Sap user group Table in SAP

    List of Sap user group tables in SAP. SOUC for SAPoffice: Inverse user (SAP user). ACO_GROUP_HIER for ACO: User Groups to User Group. UMM_CO003 for User Group <-> User. PRICAT_003 for PRICAT inbound: Assignment of SAP mat. group - purch. group.