SOSU SAP (SAPoffice: Substitute for a user) Table details
Dictionary Type: Table
Description: SAPoffice: Substitute for a user
Description: SAPoffice: Substitute for a user
Table field list including key, data, relationships and ABAP select examples
SOSU is a standard SAP Table which is used to store SAPoffice: Substitute for a user data and is available within R/3 SAP systems depending on the version and release level.
The SOSU table consists of various fields, each holding specific information or linking keys about SAPoffice: Substitute for a user data available in SAP. These include USRTP (User type from ID), USRYR (User year from the ID), USRNO (User number from the ID), SUBTP (Substitute type from ID).. 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: Not classified
SAP SOSU 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 | T000 | MANDT | |||
USRTP | User type from ID | SO_USR_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
USRYR | User year from the ID | SO_USR_YR | CHAR | 2 | SO_OBJ_YR | ||||
USRNO | User number from the ID | SO_USR_NO | CHAR | 12 | Assigned to domain | SO_USR_NO | |||
SUBTP | Substitute type from ID | SO_SUB_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
SUBYR | Substitute year from the ID | SO_SUB_YR | CHAR | 2 | SO_OBJ_YR | ||||
SUBNO | Substitute: Number from ID | SO_SUB_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
SUCNT | Counter for active periods of a substitute | SO_SUCNT | NUMC | 2 | SO_COUNT1 | ||||
SBDAT | Start date for substitution or automatic forwarding | SO_DAT_SB | DATS | 8 | DATUM | ||||
SBTIM | Time at which substitution or forwarding begins | SO_TIM_SB | TIMS | 6 | UZEIT | ||||
SEDAT | End date for substitution or automatic forwarding | SO_DAT_SE | DATS | 8 | DATUM | ||||
SETIM | Time at which substitution or automatic forwarding ends | SO_TIM_SE | TIMS | 6 | UZEIT | ||||
PSTHR1 | Functional substitute: Forward and delete | SO_PSTHR1 | CHAR | 1 | SO_FLAG | ||||
PSTHR2 | Automatic forwarding without deletion | SO_PSTHR2 | CHAR | 1 | SO_FLAG | ||||
AUTINT | Authorization: send internally | SO_AUT_INT | CHAR | 1 | SO_FLAG | ||||
AUTEXT | Authorization to send externally | SO_AUT_EXT | CHAR | 1 | SO_I_FLAG | ||||
AUSER | Substitute can maintain user | SO_AUSER | CHAR | 1 | SO_FLAG | ||||
PUBDL | Substitute: Maintain shared distribution lists | SO_PUBDL | CHAR | 1 | SO_FLAG | ||||
BCOPY | Substitute can access blind copies | SO_BCOPY | CHAR | 1 | SO_FLAG | ||||
OBJAPR | Substitute can access private objects | SO_OBJA_PR | CHAR | 1 | SO_OBJ_AUT | ||||
OBJACO | Substitute can access confidential objects | SO_OBJA_CO | CHAR | 1 | SO_OBJ_AUT | ||||
OBJACC | Substitute can access company confidential objects | SO_OBJA_CC | CHAR | 1 | SO_OBJ_AUT | ||||
OBJAFC | Substitute can access functional objects | SO_OBJA_FC | CHAR | 1 | SO_OBJ_AUT | ||||
AUANS | Substitute can access automatic replies | SO_AUANS | CHAR | 1 | SO_OBJ_AUT | ||||
RESUB | Substitute can access resubmissions | SO_RESUB | CHAR | 1 | SO_OBJ_AUT | ||||
AUSSL | Substitute can access subscription list | SO_AUSSL | CHAR | 1 | SO_OBJ_AUT | ||||
PUFOL | Authorization: Shared folders | SO_PUFOL | CHAR | 1 | SO_FLAG | ||||
PROTI | Substitute can access the inbox | SO_PROTI | CHAR | 1 | SO_FLAG | ||||
PROTO | Substitute can access the outbox | SO_PROTO | CHAR | 1 | SO_FLAG | ||||
PROT1 | Substitute can access class 1 folders | SO_PROT1 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT2 | Substitute can access class 2 folders | SO_PROT2 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT3 | Substitute can access class 3 folders | SO_PROT3 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT4 | Substitute can access class 4 folders | SO_PROT4 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT5 | Substitute can access class 5 folders | SO_PROT5 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT6 | Substitute can access class 6 folders | SO_PROT6 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT7 | Substitute can access class 7 folders | SO_PROT7 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT8 | Substitute can access class 8 folders | SO_PROT8 | CHAR | 1 | SO_OBJ_AUT | ||||
PROT9 | Substitute can access class 9 folders | SO_PROT9 | CHAR | 1 | SO_OBJ_AUT | ||||
OBJTP1 | Substitute: Additional folder auth. - object type from ID | SO_SUTP1 | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
OBJYR1 | Substitute: Additional folder auth. - year from ID | SO_SUYR1 | CHAR | 2 | SO_OBJ_YR | ||||
OBJNO1 | Substitute: Additional folder auth. - number from the ID | SO_SUNO1 | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
OBJTP2 | Substitute: Note - object type from ID | SO_SUTP2 | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
OBJYR2 | Substitute: Note - year from ID | SO_SUYR2 | CHAR | 2 | SO_OBJ_YR | ||||
OBJNO2 | Substitute: Note number from the ID | SO_SUNO2 | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
OBJTP3 | Substitute: Alternative object type from ID | SO_SUTP3 | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
OBJYR3 | Substitute: Alternative year from ID | SO_SUYR3 | CHAR | 2 | SO_OBJ_YR | ||||
OBJNO3 | Substitute: Alternative number from ID | SO_SUNO3 | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
FLAG0 | Authorization for private folders | SO_SUFLAG0 | CHAR | 1 | SO_FLAG | ||||
FLAG1 | Forward all documents automatically | SO_SUFLAG1 | CHAR | 1 | SO_FLAG | ||||
FLAG2 | Substitute: Flag 2 | SO_SUFLAG2 | CHAR | 1 | SO_FLAG | ||||
FLAG3 | Substitute: Flag 3 | SO_SUFLAG3 | CHAR | 1 | SO_FLAG | ||||
FLAG4 | Substitute: Flag 4 | SO_SUFLAG4 | CHAR | 1 | SO_FLAG | ||||
FLAG5 | Substitute: Flag 5 | SO_SUFLAG5 | CHAR | 1 | SO_FLAG | ||||
FLAG6 | Substitute: Flag 6 | SO_SUFLAG6 | CHAR | 1 | SO_FLAG | ||||
FLAG7 | Substitute: Flag 7 | SO_SUFLAG7 | CHAR | 1 | SO_FLAG | ||||
FLAG8 | Substitute: Flag 8 | SO_SUFLAG8 | CHAR | 1 | SO_FLAG | ||||
FLAG9 | Substitute: Flag 9 | SO_SUFLAG9 | CHAR | 1 | SO_FLAG | ||||
AUTFW | SAPoffice: Automatic forwarding | SO_AUTFOR | CHAR | 1 | SO_FLAG | ||||
AUTFW1 | SAPoffice: Automatic forwarding and deletion in inbox | SO_AUTFOR1 | CHAR | 1 | SO_FLAG | ||||
COMART | SAPoffice: Communication method | SO_COM_ART | CHAR | 3 | SO_COM_ART | ||||
LFDNR | Addresses: Sequence number | SO_LFDNR | CHAR | 3 | SO_TEXT003 |
Key field | Non-key field |
How do I retrieve data from SAP table SOSU using ABAP code
The following ABAP code Example will allow you to do a basic selection on SOSU to SELECT all data from the tableDATA: WA_SOSU TYPE SOSU.
SELECT SINGLE *
FROM SOSU
INTO CORRESPONDING FIELDS OF WA_SOSU
WHERE...
How to access SAP table SOSU
Within an ECC or HANA version of SAP you can also view further information about SOSU 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