SOUD SAP (SAPoffice: user definition) Table details
Dictionary Type: Table
Description: SAPoffice: user definition
Description: SAPoffice: user definition
Table field list including key, data, relationships and ABAP select examples
SOUD is a standard SAP Table which is used to store SAPoffice: user definition data and is available within R/3 SAP systems depending on the version and release level.
The SOUD table consists of various fields, each holding specific information or linking keys about SAPoffice: user definition data available in SAP. These include USRTP (User type from ID), USRYR (User year from the ID), USRNO (User number from the ID), CROTP (User who created object: Object 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 SOUD 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 | SO_USR_NO | ||||
CROTP | User who created object: Object type from ID | SO_CRO_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
CROYR | User that created object: year from the ID | SO_CRO_YR | CHAR | 2 | SO_OBJ_YR | ||||
CRONO | User that created object: number from the ID | SO_CRO_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
CRONAM | Creator Name | SO_CRO_NAM | CHAR | 12 | USERNAME | ||||
CRDAT | Date created | SO_DAT_CR | DATS | 8 | DATUM | ||||
CRTIM | Time created | SO_TIM_CR | TIMS | 6 | UZEIT | ||||
CHOTP | User that changed the object: Object type from ID | SO_CHO_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
CHOYR | User that changed the object: year from the ID | SO_CHO_YR | CHAR | 2 | SO_OBJ_YR | ||||
CHONO | User that changed the object: number from the ID | SO_CHO_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
CHONAM | Changed by | SO_CHO_NAM | CHAR | 12 | USERNAME | ||||
CHDAT | Date of Last Change | SO_DAT_CH | DATS | 8 | DATUM | ||||
CHTIM | Time of Last Change | SO_TIM_CH | TIMS | 6 | UZEIT | ||||
SAPNAM | SAP name of a SAPoffice user | SO_SAP_NAM | CHAR | 12 | USERNAME | ||||
USRNAM | SAPoffice user name | SO_USR_NAM | CHAR | 12 | USERNAME | ||||
LOADAT | Last access to SAPoffice by user | SO_DAT_LOA | DATS | 8 | DATUM | ||||
EXMAX | Maximum number of express messages allowed per send | SO_EXMAX | RAW | 2 | SO_CNT2 | ||||
RCMAX | Maximum number of recipients allowed per send | SO_RCMAX | RAW | 2 | SO_CNT2 | ||||
INMAX | Maximum number of documents allowed in the inbox | SO_INMAX | RAW | 2 | SO_CNT2 | ||||
USRAU | Maintain user: only the administrator is authorized | SO_USRAU | CHAR | 1 | SO_FLAG | ||||
CRGDL | Authorization to create shared distribution lists | SO_CRGDL | CHAR | 1 | SO_I_FLAG | ||||
CRFCL | Authorization to create client folders | SO_CRFCL | CHAR | 1 | SO_I_FLAG | ||||
CRFCC | Authorization to create company-code-wide folders | SO_CRFCC | CHAR | 1 | SO_I_FLAG | ||||
CRFPL | Authorization to create plant-wide folders | SO_CRFPL | CHAR | 1 | SO_I_FLAG | ||||
CRFDP | Authorization to create department-wide folders | SO_CRFDP | CHAR | 1 | SO_I_FLAG | ||||
CRFAD | Authorization to create cost-center-wide folders | SO_CRFAD | CHAR | 1 | SO_I_FLAG | ||||
CRFGR | Authorization to create group folders | SO_CRFGR | CHAR | 1 | SO_I_FLAG | ||||
HOMAX | Max. no. of documents a user can protect from archiving | SO_HOMAX | RAW | 1 | SO_CNT1 | ||||
HOCNT | Number of documents which should not be archived | SO_HOCNT | RAW | 1 | SO_CNT1 | ||||
GLMAX | Maximum size of the access lists of a user | SO_GLMAX | RAW | 1 | SO_CNT1 | ||||
GFMAX | Max. number of group folders which a user can create | SO_GFMAX | RAW | 1 | SO_CNT1 | ||||
GFCNT | Number of group folders created by a user | SO_GFCNT | RAW | 1 | SO_CNT1 | ||||
AUTEXT | Authorization to send externally | SO_AUT_EXT | CHAR | 1 | SO_I_FLAG | ||||
NOTTP | Default setting of document class | SO_NOT_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
CALEN | Day on which the week begins | SO_CALEN | CHAR | 1 | SO_CALEN | ||||
OUTFL | Documents are copied to the outbox when sent | SO_OUTFL | CHAR | 1 | SO_FLAG | ||||
SQWIN | Switch confirmation prompt on or off when deleting | SO_SQWIN | CHAR | 1 | SO_FLAG | ||||
SYUSR | Your user view is set when you start SAPoffice | SO_SYUSR | CHAR | 1 | SO_FLAG | ||||
SYUSRINB | Inbox filter (unviewed documents only) | SO_SYUSRIN | CHAR | 1 | SO_TEXT001 | ||||
SYUSROUT | User view of outbox | SO_SYUSROU | CHAR | 1 | SO_TEXT001 | ||||
ADREXT | The user has an active external address. | SO_ADR_EXT | CHAR | 1 | SO_FLAG | ||||
PRWYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
PRWNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
PUWYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
PUWNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
INBYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
INBNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
OUTYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
OUTNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
WSTYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
WSTNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
PFRYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
PFRNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
PDLYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
PDLNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
VORYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
VORNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
NOTYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
NOTNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
DELETED | SAPoffice: Office user was deleted | SO_USR_DEL | CHAR | 1 | SO_FLAG | ||||
RSWORKDAY | Resubmission on workdays only | SO_RSWD | CHAR | 1 | SO_FLAG | ||||
RSFACID | Factory calendar identification code for the resubmission | SO_RSFACID | CHAR | 2 | TFACD | WFCID | |||
USRADR | SAP-Office key | AD_SO_KEY | CHAR | 10 | ALPHA | AD_SO_KEY | ADDRESS | ||
LFDNR | Addresses: Sequence number | SO_LFDNR | CHAR | 3 | SO_TEXT003 | ||||
SNDART | Text field length 3: for use as required | SO_TEXT003 | CHAR | 3 | SO_TEXT003 | ||||
FLAG1 | Text field length 1 | SO_TEXT001 | CHAR | 1 | SO_TEXT001 | ||||
FLAG2 | Retain default document for entire session | SO_STORE_I | CHAR | 1 | SO_FLAG | ||||
FLAG3 | Text field length 1 | SO_TEXT001 | CHAR | 1 | SO_TEXT001 | ||||
NATIO | SAPoffice: international code for character set | SO_NATIO | CHAR | 1 | Assigned to domain | NATION | |||
LADAT | Default for last access date (last changed) | SO_DEF_LAD | NUMC | 3 | SO_NUM3 | ||||
VLADAT | Second last access of user to SAPoffice | SO_DAT_VLA | DATS | 8 | DATUM | ||||
LASDAT | Last access to SAPoffice by substitute | SO_DAT_LAS | DATS | 8 | DATUM | ||||
EXTTELE | Authorization to send via telematic services | SO_EXTTELE | CHAR | 1 | SO_I_FLAG | ||||
EXTSMTP | Authorization to send via the Internet | SO_EXTSMTP | CHAR | 1 | SO_I_FLAG | ||||
EXTX400 | Authorization to send via X.400 | SO_EXTX400 | CHAR | 1 | SO_I_FLAG | ||||
EXTSAP | Authorization to send within SAP system group | SO_EXTSAP | CHAR | 1 | SO_I_FLAG | ||||
AREPYR | Automatic reply: year from the ID | SO_AAN_YR | CHAR | 2 | SO_OBJ_YR | ||||
AREPNO | Automatic reply: number from the ID | SO_AAN_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
AREPABDAT | Date from when the automatic reply is active | SO_DAT_AB | DATS | 8 | DATUM | ||||
AREPAEDAT | Date up to which automatic reply is active | SO_DAT_AE | DATS | 8 | DATUM | ||||
FAXFORM | SAPoffice: User layout set name for faxing | SO_FAXFORM | CHAR | 16 | SO_FORM | ||||
SCRFORM | SAPoffice: User-defined standard SAPscript layout set | SO_SCRFORM | CHAR | 16 | SO_FORM | ||||
CHATSEND | Change options for document after sending | SO_CHATSEN | CHAR | 1 | SO_TEXT001 | ||||
NOARSDEX | Send automatic reply externally | SO_NOARSDE | CHAR | 1 | SO_FLAG | ||||
PRPARCHG | Default settings for calling print parameters | SO_PRPARCH | CHAR | 1 | SO_FLAG | ||||
PRPARNDH | Default settings for printing of document header | SO_PRPANDH | CHAR | 1 | SO_FLAG | ||||
PRPARRCL | Default settings for printing of recipient list | SO_PRPARRL | CHAR | 1 | SO_FLAG | ||||
PRPARNOP | Default settings for printing of notes | SO_PRPARNP | CHAR | 1 | SO_FLAG | ||||
DELFORIB | Delete document from inbox after forwarding | SO_DELFOIB | CHAR | 1 | SO_FLAG | ||||
GHRAWDOC | Display of document header in continuos-text editor | SO_GHRAWDO | CHAR | 1 | SO_FLAG | ||||
FOLDSORT | Setting for sorting folders subscribed to | SO_FOLSORT | CHAR | 1 | SO_TEXT001 | ||||
DELTRASH | No. of calendar days after which doc. is deleted from trash | SO_DELTRSH | CHAR | 3 | SO_TEXT003 | ||||
RSDOCFOR | Resubmission date of forwarded document | SO_DAT_RDF | DATS | 8 | DATUM | ||||
FOLASDYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
FOLASDNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
FOLLINYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
FOLLINNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
FOLCRDYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
FOLCRDNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
LINKDOYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
LINKDONO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
NORTFEDIT | Continuos-text editor for SAP editor documents | SO_NRTFEDT | CHAR | 1 | SO_TEXT001 | ||||
PCOLE | Start PC application in SAP window | SO_PCOLE | CHAR | 1 | SO_TEXT001 |
Key field | Non-key field |
How do I retrieve data from SAP table SOUD using ABAP code
The following ABAP code Example will allow you to do a basic selection on SOUD to SELECT all data from the tableDATA: WA_SOUD TYPE SOUD.
SELECT SINGLE *
FROM SOUD
INTO CORRESPONDING FIELDS OF WA_SOUD
WHERE...
How to access SAP table SOUD
Within an ECC or HANA version of SAP you can also view further information about SOUD 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