SAP table SOUD (SAPoffice: user definition)

SAP table SOUD has 4 primary key fields being MANDT,USRTP,USRYR,USRNO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
USRTP User type from ID CHAR 3 0 TSOTD SO_USR_TP
USRYR User year from the ID CHAR 2 0 SO_USR_YR
USRNO User number from the ID CHAR 12 0 SO_USR_NO
CROTP User who created object: Object type from ID CHAR 3 0 TSOTD SO_CRO_TP
CROYR User that created object: year from the ID CHAR 2 0 SO_CRO_YR
CRONO User that created object: number from the ID CHAR 12 0 * SO_CRO_NO
CRONAM Created By CHAR 12 0 SO_CRO_NAM
CRDAT Date created DATS 8 0 SO_DAT_CR
CRTIM Created At TIMS 6 0 SO_TIM_CR
CHOTP User that changed the object: Object type from ID CHAR 3 0 TSOTD SO_CHO_TP
CHOYR User that changed the object: year from the ID CHAR 2 0 SO_CHO_YR
CHONO User that changed the object: number from the ID CHAR 12 0 * SO_CHO_NO
CHONAM Changed by CHAR 12 0 SO_CHO_NAM
CHDAT Last Changed On DATS 8 0 SO_DAT_CH
CHTIM Time of Last Change TIMS 6 0 SO_TIM_CH
SAPNAM SAP name of a SAPoffice user CHAR 12 0 SO_SAP_NAM
USRNAM SAPoffice user name CHAR 12 0 SO_USR_NAM
LOADAT Last access to SAPoffice by user DATS 8 0 SO_DAT_LOA
EXMAX Maximum number of express messages allowed per send RAW 2 0 SO_EXMAX
RCMAX Maximum number of recipients allowed per send RAW 2 0 SO_RCMAX
INMAX Maximum number of documents allowed in the inbox RAW 2 0 SO_INMAX
USRAU Maintain user: only the administrator is authorized CHAR 1 0 SO_USRAU
CRGDL Authorization to create shared distribution lists CHAR 1 0 SO_CRGDL
CRFCL Authorization to create client folders CHAR 1 0 SO_CRFCL
CRFCC Authorization to create company-code-wide folders CHAR 1 0 SO_CRFCC
CRFPL Authorization to create plant-wide folders CHAR 1 0 SO_CRFPL
CRFDP Authorization to create department-wide folders CHAR 1 0 SO_CRFDP
CRFAD Authorization to create cost-center-wide folders CHAR 1 0 SO_CRFAD
CRFGR Authorization to create group folders CHAR 1 0 SO_CRFGR
HOMAX Max. no. of documents a user can protect from archiving RAW 1 0 SO_HOMAX
HOCNT Number of documents that are not archived RAW 1 0 SO_HOCNT
GLMAX Maximum size of the access lists of a user RAW 1 0 SO_GLMAX
GFMAX Max. number of group folders which a user can create RAW 1 0 SO_GFMAX
GFCNT Number of group folders created by a user RAW 1 0 SO_GFCNT
AUTEXT Authorization to send externally CHAR 1 0 SO_AUT_EXT
NOTTP Default setting of document class CHAR 3 0 TSOTD SO_NOT_TP
CALEN Day on which the week begins CHAR 1 0 SO_CALEN
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday
7 Sunday
OUTFL Documents are copied to the outbox when sent CHAR 1 0 SO_OUTFL
SQWIN Switch confirmation prompt on or off when deleting CHAR 1 0 SO_SQWIN
SYUSR Your user view is set when you start SAPoffice CHAR 1 0 SO_SYUSR
SYUSRINB Inbox filter (unviewed documents only) CHAR 1 0 SO_SYUSRIN
SYUSROUT User view of outbox CHAR 1 0 SO_SYUSROU
ADREXT The user has an active external address. CHAR 1 0 SO_ADR_EXT
PRWYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
PRWNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
PUWYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
PUWNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
INBYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
INBNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
OUTYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
OUTNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
WSTYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
WSTNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
PFRYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
PFRNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
PDLYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
PDLNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
VORYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
VORNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
NOTYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
NOTNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
DELETED SAPoffice: Office user was deleted CHAR 1 0 SO_USR_DEL
RSWORKDAY Resubmission on workdays only CHAR 1 0 SO_RSWD
RSFACID Factory calendar identification code for the resubmission CHAR 2 0 TFACD SO_RSFACID
USRADR SAP-Office key CHAR 10 0 AD_SO_KEY
LFDNR Addresses: Sequence number CHAR 3 0 SO_LFDNR
SNDART Text field length 3: for use as required CHAR 3 0 SO_TEXT003
FLAG1 Text field length 1 CHAR 1 0 SO_TEXT001
FLAG2 Preserve Initial Document for Full Session CHAR 1 0 SO_STORE_I
FLAG3 Text field length 1 CHAR 1 0 SO_TEXT001
NATIO SAPoffice: international code for character set CHAR 1 0 * SO_NATIO
LADAT Default for last access date (last changed) NUMC 3 0 SO_DEF_LAD
VLADAT Second last access of user to SAPoffice DATS 8 0 SO_DAT_VLA
LASDAT Last access to SAPoffice by substitute DATS 8 0 SO_DAT_LAS
EXTTELE Authorization to send using telematic services CHAR 1 0 SO_EXTTELE
EXTSMTP Authorization to send across Internet CHAR 1 0 SO_EXTSMTP
EXTX400 Authorization to send using X.400 CHAR 1 0 SO_EXTX400
EXTSAP Authorization to send within SAP system group CHAR 1 0 SO_EXTSAP
AREPYR Automatic reply: year from the ID CHAR 2 0 SO_AAN_YR
AREPNO Automatic reply: number from the ID CHAR 12 0 * SO_AAN_NO
AREPABDAT Date from when the automatic reply is active DATS 8 0 SO_DAT_AB
AREPAEDAT Date up to which automatic reply is active DATS 8 0 SO_DAT_AE
FAXFORM SAPoffice: User layout set name for faxing CHAR 16 0 SO_FAXFORM
SCRFORM SAPoffice: User-defined standard SAPscript layout set CHAR 16 0 SO_SCRFORM
CHATSEND Change options for document after sending CHAR 1 0 SO_CHATSEN
NOARSDEX Send automatic reply externally CHAR 1 0 SO_NOARSDE
PRPARCHG Default settings for calling print parameters CHAR 1 0 SO_PRPARCH
PRPARNDH Default settings for printing of document header CHAR 1 0 SO_PRPANDH
PRPARRCL Default settings for printing of recipient list CHAR 1 0 SO_PRPARRL
PRPARNOP Default settings for printing of notes CHAR 1 0 SO_PRPARNP
DELFORIB Delete document from inbox after forwarding CHAR 1 0 SO_DELFOIB
GHRAWDOC Display of Document Header Text in Continuous Text Editor CHAR 1 0 SO_GHRAWDO
FOLDSORT Setting for sorting folders subscribed to CHAR 1 0 SO_FOLSORT
DELTRASH No. of calendar days after which doc. is deleted from trash CHAR 3 0 SO_DELTRSH
RSDOCFOR Resubmission date of forwarded document DATS 8 0 SO_DAT_RDF
FOLASDYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
FOLASDNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
FOLLINYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
FOLLINNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
FOLCRDYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
FOLCRDNO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
LINKDOYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
LINKDONO Object: Number from ID CHAR 12 0 * SO_OBJ_NO
NORTFEDIT Continuous Text Editor for SAP Editor Documents CHAR 1 0 SO_NRTFEDT
PCOLE Start PC application in SAP window CHAR 1 0 SO_PCOLE

SOUD foreign key relationships

Table Field Check Table Check Field
0 SOUD CHOTP TSOTD Valid Object Types OBJTP
1 SOUD CROTP TSOTD Valid Object Types OBJTP
0 SOUD NOTTP TSOTD Valid Object Types OBJTP
1 SOUD USRTP TSOTD Valid Object Types OBJTP