SAP table SOOD (SAPoffice: Object definition)

SAP table SOOD has 4 primary key fields being MANDT,OBJTP,OBJYR,OBJNO.

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
OBJTP Code for document class CHAR 3 0 TSOTD SO_OBJ_TP
OBJYR Object: Year from ID CHAR 2 0 SO_OBJ_YR
OBJNO Object: Number from ID CHAR 12 0 SO_OBJ_NO
OBJLA Language in Which Document Is Created LANG 1 0 T002 SO_OBJ_LA
OBJSRT Sort field CHAR 10 0 SO_OBJ_SRT
OBJNAM Name of document, folder or distribution list CHAR 12 0 SO_OBJ_NAM
OBJDES Short description of contents CHAR 50 0 SO_OBJ_DES
OWNTP Owner type from ID CHAR 3 0 TSOTD SO_OWN_TP
OWNYR Owner year from the ID CHAR 2 0 SO_OWN_YR
OWNNO Owner number from the ID CHAR 12 0 * SO_OWN_NO
OWNNAM Name of document owner CHAR 12 0 SO_OWN_NAM
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
NOTTP Default setting of document class CHAR 3 0 TSOTD SO_NOT_TP
NOTYR Object note: year from the ID CHAR 2 0 SO_NOT_YR
NOTNO Object note: number from the ID CHAR 12 0 * SO_NOT_NO
OBJAPP Application object CHAR 1 0 SO_OBJ_APP
OBJFIL Object from SAPfile CHAR 1 0 SO_OBJ_FIL
FOLRG Folder: Area (private, shared folders) CHAR 1 0 SO_FOL_RG
I Inbox
O Outbox
P Private folder
Q Shared folder
S System-wide trash
T Private trash
Y Workflow folder
NOTES Flag for an attachment CHAR 1 0 SO_NOTES
UHCNT Counts how many users have this object in HOLD status RAW 2 0 SO_UHCNT
ENCCNT Number of attachments for the object RAW 2 0 SO_ENC_CNT
PTFOL Number of folders which contain the object RAW 2 0 SO_PTFOL
PTENC Number of objects for which this object is an attachment RAW 2 0 SO_PTENC
PTHYP Number of hyperlinks to this object RAW 2 0 SO_PTHYP
PTNOT Number of objects, in which this object is a note RAW 2 0 SO_PTNOT
PTMBO Number of MBO objects which contain this object RAW 2 0 SO_PTMBO
PAFOL Number of folders, in which object is stored and archived RAW 2 0 SO_PAFOL
PAENC No.of archived objects f. which this object is an attachment RAW 2 0 SO_PAENC
PAHYP Number of archived hyperlinks to this object RAW 2 0 SO_PAHYP
PANOT Number of archived objects in which this object is a note RAW 2 0 SO_PANOT
PAMBO Number of archived MBO objects which contain this object RAW 2 0 SO_PAMBO
ARCHI The document is stored in archive CHAR 1 0 SO_ARCHI
LADAT Date of last access DATS 8 0 SO_DAT_LA
DLDAT Document Expiration Date DATS 8 0 SO_DAT_DL
DLTIM Expiry time of object TIMS 6 0 SO_TIM_DL
OBJPRI Document priority CHAR 1 0 SO_OBJ_PRI
1 Highest priority
2
3
4
5
6
7
8
9 Lowest priority
OBJSNS Object: Sensitivity (private, functional, ...) CHAR 1 0 SO_OBJ_SNS
E Private
F Functional
G Business
O Standard
P Confidential
OBJENC Object: coded CHAR 1 0 SO_OBJ_ENC
OBJSND Object was already sent CHAR 1 0 SO_OBJ_SND
SDDAT Date On Which Object Was Sent DATS 8 0 SO_DAT_SD
SDTIM Time at Which The Object Was Sent TIMS 6 0 SO_TIM_SD
RECCNT Number of recipients of the object RAW 2 0 SO_RECCNT
RRDCNT Number of Recipients Who Have Read Object RAW 2 0 SO_RRDCNT
RRRCNT Number of recipients who must reply to the object RAW 2 0 SO_RRRCNT
RRPCNT Number of recipients who have sent required reply RAW 2 0 SO_RRPCNT
RARCNT Number of recipients who must take action RAW 2 0 SO_RARCNT
RAPCNT Number of recipients processing the object RAW 2 0 SO_RAPCNT
RATCNT Number of recipients who have taken action RAW 2 0 SO_RATCNT
REXCNT Number of recipients of the express message RAW 2 0 SO_REXCNT
RCPCNT Number of recipients of a copy RAW 2 0 SO_RCPCNT
RBCCNT Number of recipients of a blind copy RAW 2 0 SO_RBCCNT
ACONE ToDo by one of the recipients in the group RAW 1 0 SO_ACONE
ACOUT ToDo: To Be Completed Outside SAPoffice CHAR 1 0 SO_ACOUT
FROUT Object is to be forwarded outside of SAPoffice CHAR 1 0 SO_FROUT
VMTYP Execute: Type (Report, Dialog Module, ...) CHAR 1 0 TSOVM SO_VM_TYP
SKIPS Execute: Process First Screen in Background CHAR 1 0 SO_SKIPS
ACNAM Execute: Name of Report, FM, DB, TCode CHAR 54 0 SO_ACNAM
ACMEM Process: memory ID CHAR 32 0 SO_ACMEM
HYPTP Hypertext pointer: Object type CHAR 3 0 TSOTD SO_HYP_TP
HYPYR Hypertext pointer: year CHAR 2 0 SO_HYP_YR
HYPNO Hypertext pointer: number CHAR 12 0 * SO_HYP_NO
AUTTP Authorization list: Type from ID CHAR 3 0 TSOTD SO_AUT_TP
AUTYR Authorization list: year from the ID CHAR 2 0 SO_AUT_YR
AUTNO Authorization list: number from the ID CHAR 12 0 * SO_AUT_NO
PCTRL SAPoffice: object can be deleted in external inbox CHAR 1 0 SO_PCTRL
CCOTP Change copy: object type from the ID CHAR 3 0 TSOTD SO_CCO_TP
CCOYR Change copy: year from the ID CHAR 2 0 SO_CCO_YR
CCONO Change copy: number from the ID CHAR 12 0 * SO_CCO_NO
OBJCP Document cannot be changed CHAR 1 0 SO_OBJ_CP
PRTCT Document title modifiable CHAR 1 0 SO_PRTCT
FIXED Check-in/check-out flag CHAR 1 0 SO_FIXED
EXTHD Object-specific header is stored externally CHAR 1 0 SO_EXTHD
EXTCT Object contents are stored externally CHAR 1 0 SO_EXTCT
FILE_EXT File extension for PC application CHAR 3 0 SO_FILEEXT
OBJLEN Size of Document Content CHAR 12 0 SO_OBJ_LEN
OBJDBLEN Size of Document Content CHAR 12 0 SO_OBJ_LEN
CREATOR Creator for MacIntosh-based files CHAR 4 0 SO_CREATOR
ATTLEN Total size of all attachments to a document CHAR 12 0 SO_ATT_LEN
IF_DOC_BCS Globally Unique Identifier RAW 16 0 OS_GUID
IF_DOC_CLS Globally Unique Identifier RAW 16 0 OS_GUID

SOOD foreign key relationships

Table Field Check Table Check Field
0 SOOD AUTTP TSOTD Valid Object Types OBJTP
1 SOOD CCOTP TSOTD Valid Object Types OBJTP
0 SOOD CHOTP TSOTD Valid Object Types OBJTP
1 SOOD CROTP TSOTD Valid Object Types OBJTP
0 SOOD HYPTP TSOTD Valid Object Types OBJTP
1 SOOD NOTTP TSOTD Valid Object Types OBJTP
0 SOOD OBJLA T002 Language Keys (Component BC-I18) SPRAS
1 SOOD OBJTP TSOTD Valid Object Types OBJTP
0 SOOD OWNTP TSOTD Valid Object Types OBJTP
1 SOOD VMTYP TSOVM SAPoffice: valid processing types VMTYP