1. Home
  2. Resources
  3. SAP Tables
  4. SOOD - SAPoffice: Object definition

SAP Table SOOD

SAPoffice: Object definition

SOOD (SAPoffice: Object definition) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SOOD to other SAP tables.

SOOD table fields

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

SOOD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SOOD AUTTP SOOD AUTTP TSOTD Valid Object Types OBJTP
SOOD CCOTP SOOD CCOTP TSOTD Valid Object Types OBJTP
SOOD CHOTP SOOD CHOTP TSOTD Valid Object Types OBJTP
SOOD CROTP SOOD CROTP TSOTD Valid Object Types OBJTP
SOOD HYPTP SOOD HYPTP TSOTD Valid Object Types OBJTP
SOOD MANDT SOOD MANDT T000 Clients MANDT
SOOD NOTTP SOOD NOTTP TSOTD Valid Object Types OBJTP
SOOD OBJLA SOOD OBJLA T002 Language Keys (Component BC-I18) SPRAS
SOOD OBJTP SOOD OBJTP TSOTD Valid Object Types OBJTP
SOOD OWNTP SOOD OWNTP TSOTD Valid Object Types OBJTP
SOOD VMTYP SOOD VMTYP TSOVM SAPoffice: valid processing types VMTYP