SOOD_WI SAP (Sood for Archiving of WI Attachments) Structure details
Description: Sood for Archiving of WI Attachments
Structure field list including key, data, relationships and ABAP select examples
SOOD_WI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Sood for Archiving of WI Attachments" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_SOOD_WI TYPE SOOD_WI.
The SOOD_WI table consists of various fields, each holding specific information or linking keys about Sood for Archiving of WI Attachments data available in SAP. These include SOFM_KEY (Object key), MANDT (Client), OBJTP (Code for document class), OBJYR (Object: Year from ID).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SOOD_WI structure 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 |
WI_ID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
SOFM_KEY | Object key | SWO_TYPEID | CHAR | 70 | SWO_TYPEID | ||||
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 | Assigned to domain | 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 structure SOOD_WI using ABAP code?
As SOOD_WI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SOOD_WI as there is no data to select.How to access SAP table SOOD_WI
Within an ECC or HANA version of SAP you can also view further information about SOOD_WI 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