SOOD SAP (SAPoffice: Object definition) Table details
Dictionary Type: Table
Description: SAPoffice: Object definition
Description: SAPoffice: Object definition
Table field list including key, data, relationships and ABAP select examples
SOOD is a standard SAP Table which is used to store SAPoffice: Object definition data and is available within R/3 SAP systems depending on the version and release level.
The SOOD table consists of various fields, each holding specific information or linking keys about SAPoffice: Object definition data available in SAP. These include OBJTP (Code for document class), OBJYR (Object: Year from ID), OBJNO (Object: Number from ID), OBJLA (Language in Which Document Is Created).. 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 SOOD 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 | |||
OBJTP | Code for document class | SO_OBJ_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
OBJYR | Object: Year from ID | SO_OBJ_YR | CHAR | 2 | SO_OBJ_YR | ||||
OBJNO | Object: Number from ID | SO_OBJ_NO | CHAR | 12 | SO_OBJ_NO | ||||
OBJLA | Language in Which Document Is Created | SO_OBJ_LA | LANG | 1 | T002 | ISOLA | SPRAS | ||
OBJSRT | Sort field | SO_OBJ_SRT | CHAR | 10 | SO_OBJ_SRT | ||||
OBJNAM | Name of document, folder or distribution list | SO_OBJ_NAM | CHAR | 12 | SO_OBJ_NAM | ||||
OBJDES | Short description of contents | SO_OBJ_DES | CHAR | 50 | SO_OBJ_DES | ||||
OWNTP | Owner type from ID | SO_OWN_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
OWNYR | Owner year from the ID | SO_OWN_YR | CHAR | 2 | SO_OBJ_YR | ||||
OWNNO | Owner number from the ID | SO_OWN_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
OWNNAM | Name of document owner | SO_OWN_NAM | CHAR | 12 | USERNAME | ||||
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 | ||||
NOTTP | Default setting of document class | SO_NOT_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
NOTYR | Object note: year from the ID | SO_NOT_YR | CHAR | 2 | SO_OBJ_YR | ||||
NOTNO | Object note: number from the ID | SO_NOT_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
OBJAPP | Application object | SO_OBJ_APP | CHAR | 1 | SO_FLAG | ||||
OBJFIL | Object from SAPfile | SO_OBJ_FIL | CHAR | 1 | SO_FLAG | ||||
FOLRG | Folder: Area (private, shared folders) | SO_FOL_RG | CHAR | 1 | SO_FOL_RG | ||||
NOTES | Flag for an attachment | SO_NOTES | CHAR | 1 | SO_FLAG | ||||
UHCNT | Counts how many users have this object in HOLD status | SO_UHCNT | RAW | 2 | SO_CNT2 | ||||
ENCCNT | Number of attachments for the object | SO_ENC_CNT | RAW | 2 | SO_CNT2 | ||||
PTFOL | Number of folders which contain the object | SO_PTFOL | RAW | 2 | SO_CNT2 | ||||
PTENC | Number of objects for which this object is an attachment | SO_PTENC | RAW | 2 | SO_CNT2 | ||||
PTHYP | Number of hyperlinks to this object | SO_PTHYP | RAW | 2 | SO_CNT2 | ||||
PTNOT | Number of objects, in which this object is a note | SO_PTNOT | RAW | 2 | SO_CNT2 | ||||
PTMBO | Number of MBO objects which contain this object | SO_PTMBO | RAW | 2 | SO_CNT2 | ||||
PAFOL | Number of folders, in which object is stored and archived | SO_PAFOL | RAW | 2 | SO_CNT2 | ||||
PAENC | No.of archived objects f. which this object is an attachment | SO_PAENC | RAW | 2 | SO_CNT2 | ||||
PAHYP | Number of archived hyperlinks to this object | SO_PAHYP | RAW | 2 | SO_CNT2 | ||||
PANOT | Number of archived objects in which this object is a note | SO_PANOT | RAW | 2 | SO_CNT2 | ||||
PAMBO | Number of archived MBO objects which contain this object | SO_PAMBO | RAW | 2 | SO_CNT2 | ||||
ARCHI | The document is stored in archive | SO_ARCHI | CHAR | 1 | SO_FLAG | ||||
LADAT | Date of last access | SO_DAT_LA | DATS | 8 | DATUM | ||||
DLDAT | Document Expiration Date | SO_DAT_DL | DATS | 8 | DATUM | ||||
DLTIM | Expiry time of object | SO_TIM_DL | TIMS | 6 | UZEIT | ||||
OBJPRI | Document priority | SO_OBJ_PRI | CHAR | 1 | SO_OBJ_PRI | ||||
OBJSNS | Object: Sensitivity (private, functional, ...) | SO_OBJ_SNS | CHAR | 1 | SO_OBJ_SNS | ||||
OBJENC | Object: coded | SO_OBJ_ENC | CHAR | 1 | SO_FLAG | ||||
OBJSND | Object has already been sent | SO_OBJ_SND | CHAR | 1 | SO_FLAG | ||||
SDDAT | Date On Which Object Was Sent | SO_DAT_SD | DATS | 8 | DATUM | ||||
SDTIM | Time at Which The Object Was Sent | SO_TIM_SD | TIMS | 6 | UZEIT | ||||
RECCNT | Number of recipients of the object | SO_RECCNT | RAW | 2 | SO_CNT2 | ||||
RRDCNT | Number of Recipients Who Have Read Object | SO_RRDCNT | RAW | 2 | SO_CNT2 | ||||
RRRCNT | Number of recipients who must reply to the object | SO_RRRCNT | RAW | 2 | SO_CNT2 | ||||
RRPCNT | Number of recipients who have sent required reply | SO_RRPCNT | RAW | 2 | SO_CNT2 | ||||
RARCNT | Number of recipients who must take action | SO_RARCNT | RAW | 2 | SO_CNT2 | ||||
RAPCNT | Number of recipients processing the object | SO_RAPCNT | RAW | 2 | SO_CNT2 | ||||
RATCNT | Number of recipients who have taken action | SO_RATCNT | RAW | 2 | SO_CNT2 | ||||
REXCNT | Number of recipients of the express message | SO_REXCNT | RAW | 2 | SO_CNT2 | ||||
RCPCNT | Number of recipients of a copy | SO_RCPCNT | RAW | 2 | SO_CNT2 | ||||
RBCCNT | Number of recipients of a blind copy | SO_RBCCNT | RAW | 2 | SO_CNT2 | ||||
ACONE | ToDo by one of the recipients in the group | SO_ACONE | RAW | 1 | SO_CNT1 | ||||
ACOUT | ToDo: To Be Completed Outside SAPoffice | SO_ACOUT | CHAR | 1 | SO_FLAG | ||||
FROUT | Object is to be forwarded outside of SAPoffice | SO_FROUT | CHAR | 1 | SO_FLAG | ||||
VMTYP | Execute: Type (Report, Dialog Module, ...) | SO_VM_TYP | CHAR | 1 | TSOVM | SO_VM_TYP | |||
SKIPS | Execute: Process First Screen in Background | SO_SKIPS | CHAR | 1 | SO_FLAG | ||||
ACNAM | Execute: Name of Report, FM, DB, TCode | SO_ACNAM | CHAR | 54 | SO_ACNAM | ||||
ACMEM | Process: memory ID | SO_ACMEM | CHAR | 32 | SO_ACMEM | ||||
HYPTP | Hypertext pointer: Object type | SO_HYP_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
HYPYR | Hypertext pointer: year | SO_HYP_YR | CHAR | 2 | SO_OBJ_YR | ||||
HYPNO | Hypertext pointer: number | SO_HYP_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
AUTTP | Authorization list: Type from ID | SO_AUT_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
AUTYR | Authorization list: year from the ID | SO_AUT_YR | CHAR | 2 | SO_OBJ_YR | ||||
AUTNO | Authorization list: number from the ID | SO_AUT_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
PCTRL | SAPoffice: object can be deleted in external inbox | SO_PCTRL | CHAR | 1 | SO_FLAG | ||||
CCOTP | Change copy: object type from the ID | SO_CCO_TP | CHAR | 3 | TSOTD | SO_OBJ_TP | |||
CCOYR | Change copy: year from the ID | SO_CCO_YR | CHAR | 2 | SO_OBJ_YR | ||||
CCONO | Change copy: number from the ID | SO_CCO_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
OBJCP | Document cannot be changed | SO_OBJ_CP | CHAR | 1 | SO_FLAG | ||||
PRTCT | Document title modifiable | SO_PRTCT | CHAR | 1 | SO_FLAG | ||||
FIXED | Check-in/check-out flag | SO_FIXED | CHAR | 1 | SO_FLAG | ||||
EXTHD | Object-specific header is stored externally | SO_EXTHD | CHAR | 1 | SO_FLAG | ||||
EXTCT | Object contents are stored externally | SO_EXTCT | CHAR | 1 | SO_FLAG | ||||
FILE_EXT | File extension for PC application | SO_FILEEXT | CHAR | 3 | CHAR3 | ||||
OBJLEN | Size of Document Content | SO_OBJ_LEN | CHAR | 12 | SO_OBJ_LEN | ||||
OBJDBLEN | Size of Document Content | SO_OBJ_LEN | CHAR | 12 | SO_OBJ_LEN | ||||
CREATOR | Creator for MacIntosh-based files | SO_CREATOR | CHAR | 4 | SO_TEXT004 | ||||
ATTLEN | Total size of all attachments to a document | SO_ATT_LEN | CHAR | 12 | SO_OBJ_LEN | ||||
IF_DOC_BCS | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID | ||||
IF_DOC_CLS | Globally Unique Identifier | OS_GUID | RAW | 16 | SYSUUID |
Key field | Non-key field |
How do I retrieve data from SAP table SOOD using ABAP code
The following ABAP code Example will allow you to do a basic selection on SOOD to SELECT all data from the tableDATA: WA_SOOD TYPE SOOD.
SELECT SINGLE *
FROM SOOD
INTO CORRESPONDING FIELDS OF WA_SOOD
WHERE...
How to access SAP table SOOD
Within an ECC or HANA version of SAP you can also view further information about SOOD 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