SAP table SOODD (SAPoffice: definition of an object (data division))

Field Description Data Type Length Decimals Checktable Data Element
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 * 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
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

SOODD foreign key relationships

Table Field Check Table Check Field
0 SOODD AUTTP TSOTD Valid Object Types OBJTP
1 SOODD CCOTP TSOTD Valid Object Types OBJTP
0 SOODD CHOTP TSOTD Valid Object Types OBJTP
1 SOODD CROTP TSOTD Valid Object Types OBJTP
0 SOODD HYPTP TSOTD Valid Object Types OBJTP
1 SOODD NOTTP TSOTD Valid Object Types OBJTP
0 SOODD OBJLA T002 Language Keys (Component BC-I18) SPRAS
1 SOODD OWNTP TSOTD Valid Object Types OBJTP