SOFDD SAP (SAPoffice: Data of the Folder Definition SOFD) Structure details
Description: SAPoffice: Data of the Folder Definition SOFD
Structure field list including key, data, relationships and ABAP select examples
SOFDD 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 "SAPoffice: Data of the Folder Definition SOFD" 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_SOFDD TYPE SOFDD.
The SOFDD table consists of various fields, each holding specific information or linking keys about SAPoffice: Data of the Folder Definition SOFD data available in SAP. These include OWNYR (Owner year from the ID), OWNNO (Owner number from the ID), OBJLA (Language in Which Document Is Created), OBJSRT (Sort field).. 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 SOFDD 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 |
OWNTP | Owner type from ID | SO_OWN_TP | CHAR | 3 | Assigned to domain | 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 | |||
OBJLA | Language in Which Document Is Created | SO_OBJ_LA | LANG | 1 | Assigned to domain | 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 | ||||
CROTP | User who created object: Object type from ID | SO_CRO_TP | CHAR | 3 | Assigned to domain | 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 | |||
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 | Assigned to domain | 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 | |||
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 | Assigned to domain | 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 | |||
FOLRG | Folder: Area (private, shared folders) | SO_FOL_RG | CHAR | 1 | SO_FOL_RG | ||||
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 | ||||
OBJSNS | Object: Sensitivity (private, functional, ...) | SO_OBJ_SNS | CHAR | 1 | SO_OBJ_SNS | ||||
FIXED | Check-in/check-out flag | SO_FIXED | CHAR | 1 | SO_FLAG | ||||
PARTP | Parent object type from ID | SO_PAR_TP | CHAR | 3 | Assigned to domain | SO_OBJ_TP | |||
PARYR | Parent object year from the ID | SO_PAR_YR | CHAR | 2 | SO_OBJ_YR | ||||
PARNO | Parent object number from the ID | SO_PAR_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
FOLCNT | Number of documents stored in this folder | SO_FOL_SIZ | NUMC | 5 | SO_OBJ_SIZ | ||||
FOLSIZ | Number of documents stored in this folder | SO_FOL_SIZ | NUMC | 5 | SO_OBJ_SIZ | ||||
TPONLY | Only this object type can be stored in this folder | SO_TPONLY | CHAR | 3 | Assigned to domain | SO_OBJ_TP | |||
LIFSP | Retention period of documents in folder | SO_LIFSP | NUMC | 5 | SO_NUM5 | ||||
FOLINDEX | Index folder and documents contained in it | SO_INDEX | CHAR | 1 | SO_FLAG | ||||
PFLCL | Private folder class | SO_PFLCL | CHAR | 1 | SO_FOL_CL | ||||
ICLASS | Information class for indexing | SF_ICLASS | CHAR | 4 | Assigned to domain | SF_ICLASS | |||
DLITP | Distribution list type from ID | SO_DLI_TP | CHAR | 3 | Assigned to domain | SO_OBJ_TP | |||
DLIYR | Distribution list year from the ID | SO_DLI_YR | CHAR | 2 | SO_OBJ_YR | ||||
DLINO | Distribution list: number from the ID | SO_DLI_NO | CHAR | 12 | Assigned to domain | SO_OBJ_NO | |||
FOLSEC | Folder area (private, client, group, ...) | SO_FOL_SEC | CHAR | 1 | SO_FOL_SEC | ||||
FOLTYPE | SAPoffice: Folder type | SO_FOL_TY | CHAR | 4 | SO_FOL_TY | ||||
LAFDAT | Date of last access | SO_DAT_LA | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP structure SOFDD using ABAP code?
As SOFDD 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 SOFDD as there is no data to select.How to access SAP table SOFDD
Within an ECC or HANA version of SAP you can also view further information about SOFDD 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