/XLSO/USER_COMP SAP (XLSO Table to store the assignment of Company and User) Table details
Dictionary Type: Table
Description: XLSO Table to store the assignment of Company and User
Description: XLSO Table to store the assignment of Company and User
ABAP Code to SELECT data from /XLSO/USER_COMP
Related tables to /XLSO/USER_COMP
Access table /XLSO/USER_COMP
Related tables to /XLSO/USER_COMP
Access table /XLSO/USER_COMP
Table field list including key, data, relationships and ABAP select examples
/XLSO/USER_COMP is a standard SAP Table which is used to store XLSO Table to store the assignment of Company and User data and is available within R/3 SAP systems depending on the version and release level.
The /XLSO/USER_COMP table consists of various fields, each holding specific information or linking keys about XLSO Table to store the assignment of Company and User data available in SAP. These include CUSTOMER_ID (Customer Numbers), COMPANY_ID (Customer Numbers), DEPARTMENT (Department number), FUNCTION (Contact person function).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /XLSO/USER_COMP table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| CUSTOMER_ID | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
| COMPANY_ID | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
| DEPARTMENT | Department number | ABTNR | CHAR | 4 | Assigned to domain | ABTNR | |||
| FUNCTION | Contact person function | PAFKT | CHAR | 2 | Assigned to domain | PAFKT | |||
| WF_TASKID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
| STATUS | User and Company Mapping Status | /XLSO/E_USR_COMP_STAT | CHAR | 1 | /XLSO/D_USR_COMP_STAT | ||||
| START_TIME | Time Stamp in XLSO Namespace That Has a Change Document | /XLSO/E_TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
| END_TIME | Time Stamp in XLSO Namespace That Has a Change Document | /XLSO/E_TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
| APPR_REJ_REASON | Approval or Rejection Reason | /XLSO/E_APPROVAL_REJ_REASON | CHAR | 40 | TEXT40 | ||||
| CREATED_AT | Created Time in User Time Zone | /XLSO/E_CREATED_AT | DEC | 15 | TSTLC | COM_TSTMP | |||
| CREATED_BY | Transaction Created By | /XLSO/E_CREATED_BY | CHAR | 12 | UNAME | ||||
| CHANGED_AT | Changed Time in User Time Zone | /XLSO/E_CHANGED_AT | DEC | 15 | TSTLC | COM_TSTMP | |||
| CHANGED_BY | Transaction Last Changed By | /XLSO/E_CHANGED_BY | CHAR | 12 | UNAME |
| Key field | Non-key field |
How do I retrieve data from SAP table /XLSO/USER_COMP using ABAP code
The following ABAP code Example will allow you to do a basic selection on /XLSO/USER_COMP to SELECT all data from the tableDATA: WA_/XLSO/USER_COMP TYPE /XLSO/USER_COMP.
SELECT SINGLE *
FROM /XLSO/USER_COMP
INTO CORRESPONDING FIELDS OF WA_/XLSO/USER_COMP
WHERE...
How to access SAP table /XLSO/USER_COMP
Within an ECC or HANA version of SAP you can also view further information about /XLSO/USER_COMP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects