SOWIARC SAP (Structure of Archiving of WI Attachments (SOFM)) Structure details
Dictionary Type: Structure
Description: Structure of Archiving of WI Attachments (SOFM)
Description: Structure of Archiving of WI Attachments (SOFM)
Structure field list including key, data, relationships and ABAP select examples
SOWIARC 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 "Structure of Archiving of WI Attachments (SOFM)" 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_SOWIARC TYPE SOWIARC.
The SOWIARC table consists of various fields, each holding specific information or linking keys about Structure of Archiving of WI Attachments (SOFM) data available in SAP. These include MANDT (Client), OBJTP (Code for document class), OBJYR (Object: Year from ID), OBJNO (Object: Number 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 SOWIARC 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 |
| SOOD | 0 | ||||||||
| MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
| OBJTP | Code for document class | SO_OBJ_TP | CHAR | 3 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | SO_OBJ_TP | ||||
| HYPYR | Hypertext pointer: year | SO_HYP_YR | CHAR | 2 | SO_OBJ_YR | ||||
| HYPNO | Hypertext pointer: number | SO_HYP_NO | CHAR | 12 | SO_OBJ_NO | ||||
| AUTTP | Authorization list: Type from ID | SO_AUT_TP | CHAR | 3 | 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 | 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 | 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 | 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 | ||||
| SOFM | 0 | ||||||||
| MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
| FOLTP | Object folder: Object type from ID | SO_FOL_TP | CHAR | 3 | SO_OBJ_TP | ||||
| FOLYR | Object folder: Year from ID | SO_FOL_YR | CHAR | 2 | SO_OBJ_YR | ||||
| FOLNO | Object folder: Number from ID | SO_FOL_NO | CHAR | 12 | SO_OBJ_NO | ||||
| DOCTP | Object: Object Type From ID | SO_DOC_TP | CHAR | 3 | SO_OBJ_TP | ||||
| DOCYR | Object: Year from ID | SO_DOC_YR | CHAR | 2 | SO_OBJ_YR | ||||
| DOCNO | Object: Number from ID | SO_DOC_NO | CHAR | 12 | SO_OBJ_NO | ||||
| FORTP | Forwarder: Object type from ID | SO_FOR_TP | CHAR | 3 | SO_OBJ_TP | ||||
| FORYR | Forwarder: year from the ID | SO_FOR_YR | CHAR | 2 | SO_OBJ_YR | ||||
| FORNO | Forwarder: number from the ID | SO_FOR_NO | CHAR | 12 | SO_OBJ_NO | ||||
| PERMA | SAPoffice: Object is displayed independent of selection date | SO_PERMA | CHAR | 1 | SO_FLAG | ||||
| HOLDO | The object has status HOLD | SO_HOLDO | CHAR | 1 | SO_FLAG | ||||
| ARCHI | The document is stored in archive | SO_ARCHI | CHAR | 1 | SO_FLAG | ||||
| DLDAT | Document Expiration Date | SO_DAT_DL | DATS | 8 | DATUM | ||||
| DLTIM | Expiry time of object | SO_TIM_DL | TIMS | 6 | UZEIT | ||||
| NOTTP | Default setting of document class | SO_NOT_TP | CHAR | 3 | 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 | SO_OBJ_NO | ||||
| RCDAT | Date document was received | SO_DAT_RC | DATS | 8 | DATUM | ||||
| RCTIM | Time object was received | SO_TIM_RC | TIMS | 6 | UZEIT | ||||
| SNDDR | Send: As disregard | SO_SND_DR | CHAR | 1 | SO_FLAG | ||||
| SNDEX | Send express | SO_SND_EX | CHAR | 1 | SO_FLAG | ||||
| SNDCP | Send: As copy | SO_SND_CP | CHAR | 1 | SO_FLAG | ||||
| SNDBC | Send as a blind copy | SO_SND_BC | CHAR | 1 | SO_FLAG | ||||
| OBJAC | The recipient must take action | SO_OBJ_AC | CHAR | 1 | SO_FLAG | ||||
| OBJRR | A reply must be sent for this object | SO_OBJ_RR | CHAR | 1 | SO_FLAG | ||||
| OBJRD | Object has already been viewed | SO_OBJ_RD | CHAR | 1 | SO_FLAG | ||||
| RESUB | SAPoffice: folder entry is a resubmitted object | SO_RSUBM | CHAR | 1 | SO_FELD123 | ||||
| RECPRI | Priority | SO_REC_PRI | CHAR | 1 | SO_OBJ_PRI | ||||
| FLAG1 | Search of private or shared folders | SO_FLAG | CHAR | 1 | SO_FLAG | ||||
| FLAG2 | Search of private or shared folders | SO_FLAG | CHAR | 1 | SO_FLAG | ||||
| FLAG3 | Search of private or shared folders | SO_FLAG | CHAR | 1 | SO_FLAG | ||||
| FLAG4 | Search of private or shared folders | SO_FLAG | CHAR | 1 | SO_FLAG | ||||
| FLAG5 | Search of private or shared folders | SO_FLAG | CHAR | 1 | SO_FLAG | ||||
| RBDAT | Date On Which The Object Was Resubmitted | SO_DAT_RB | DATS | 8 | DATUM | ||||
| LFOLTP | Object folder: Object type from ID | SO_FOL_TP | CHAR | 3 | SO_OBJ_TP | ||||
| LFOLYR | Object folder: Year from ID | SO_FOL_YR | CHAR | 2 | SO_OBJ_YR | ||||
| LFOLNO | Object folder: Number from ID | SO_FOL_NO | CHAR | 12 | SO_OBJ_NO | ||||
| OBJHEAD | 0 | ||||||||
| OBJCONT | 0 | ||||||||
| OBJPARA | 0 | ||||||||
| OBJPARB | 0 |
| Key field | Non-key field |
How do I retrieve data from SAP structure SOWIARC using ABAP code?
As SOWIARC 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 SOWIARC as there is no data to select.How to access SAP table SOWIARC
Within an ECC or HANA version of SAP you can also view further information about SOWIARC 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