SAP ABAP Table SOFM (SAPoffice: Folder contents)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
⤷ SO (Package) SAPoffice
⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
⤷ SO (Package) SAPoffice
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SOFM | Table Relationship Diagram |
Short Description | SAPoffice: Folder contents |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | FOLTP | SO_FOL_TP | SO_OBJ_TP | CHAR | 3 | 0 | Object folder: Object type from ID | TSOTD | |
3 | FOLYR | SO_FOL_YR | SO_OBJ_YR | CHAR | 2 | 0 | Object folder: Year from ID | ||
4 | FOLNO | SO_FOL_NO | SO_OBJ_NO | CHAR | 12 | 0 | Object folder: Number from ID | SOFD | |
5 | DOCTP | SO_DOC_TP | SO_OBJ_TP | CHAR | 3 | 0 | Object: Object Type From ID | TSOTD | |
6 | DOCYR | SO_DOC_YR | SO_OBJ_YR | CHAR | 2 | 0 | Object: Year from ID | ||
7 | DOCNO | SO_DOC_NO | SO_OBJ_NO | CHAR | 12 | 0 | Object: Number from ID | SOOD | |
8 | FORTP | SO_FOR_TP | SO_OBJ_TP | CHAR | 3 | 0 | Forwarder: Object type from ID | TSOTD | |
9 | FORYR | SO_FOR_YR | SO_OBJ_YR | CHAR | 2 | 0 | Forwarder: year from the ID | ||
10 | FORNO | SO_FOR_NO | SO_OBJ_NO | CHAR | 12 | 0 | Forwarder: number from the ID | ||
11 | PERMA | SO_PERMA | SO_FLAG | CHAR | 1 | 0 | SAPoffice: Object is displayed independent of selection date | ||
12 | HOLDO | SO_HOLDO | SO_FLAG | CHAR | 1 | 0 | The object has status HOLD | ||
13 | ARCHI | SO_ARCHI | SO_FLAG | CHAR | 1 | 0 | The document is stored in archive | ||
14 | DLDAT | SO_DAT_DL | DATUM | DATS | 8 | 0 | Document Expiration Date | ||
15 | DLTIM | SO_TIM_DL | UZEIT | TIMS | 6 | 0 | Expiry time of object | ||
16 | NOTTP | SO_NOT_TP | SO_OBJ_TP | CHAR | 3 | 0 | Default setting of document class | TSOTD | |
17 | NOTYR | SO_NOT_YR | SO_OBJ_YR | CHAR | 2 | 0 | Object note: year from the ID | ||
18 | NOTNO | SO_NOT_NO | SO_OBJ_NO | CHAR | 12 | 0 | Object note: number from the ID | ||
19 | RCDAT | SO_DAT_RC | DATUM | DATS | 8 | 0 | Date document was received | ||
20 | RCTIM | SO_TIM_RC | UZEIT | TIMS | 6 | 0 | Time object was received | ||
21 | SNDDR | SO_SND_DR | SO_FLAG | CHAR | 1 | 0 | Send: As disregard | ||
22 | SNDEX | SO_SND_EX | SO_FLAG | CHAR | 1 | 0 | Send express | ||
23 | SNDCP | SO_SND_CP | SO_FLAG | CHAR | 1 | 0 | Send: As copy | ||
24 | SNDBC | SO_SND_BC | SO_FLAG | CHAR | 1 | 0 | Send as a blind copy | ||
25 | OBJAC | SO_OBJ_AC | SO_FLAG | CHAR | 1 | 0 | The recipient must take action | ||
26 | OBJRR | SO_OBJ_RR | SO_FLAG | CHAR | 1 | 0 | A reply must be sent for this object | ||
27 | OBJRD | SO_OBJ_RD | SO_FLAG | CHAR | 1 | 0 | Object has already been viewed | ||
28 | RESUB | SO_RSUBM | SO_FELD123 | CHAR | 1 | 0 | SAPoffice: folder entry is a resubmitted object | ||
29 | RECPRI | SO_REC_PRI | SO_OBJ_PRI | CHAR | 1 | 0 | Priority | ||
30 | FLAG1 | SO_FLAG | SO_FLAG | CHAR | 1 | 0 | Search of private or shared folders | ||
31 | FLAG2 | SO_FLAG | SO_FLAG | CHAR | 1 | 0 | Search of private or shared folders | ||
32 | FLAG3 | SO_FLAG | SO_FLAG | CHAR | 1 | 0 | Search of private or shared folders | ||
33 | FLAG4 | SO_FLAG | SO_FLAG | CHAR | 1 | 0 | Search of private or shared folders | ||
34 | FLAG5 | SO_FLAG | SO_FLAG | CHAR | 1 | 0 | Search of private or shared folders | ||
35 | RBDAT | SO_DAT_RB | DATUM | DATS | 8 | 0 | Date On Which The Object Was Resubmitted | ||
36 | LFOLTP | SO_FOL_TP | SO_OBJ_TP | CHAR | 3 | 0 | Object folder: Object type from ID | ||
37 | LFOLYR | SO_FOL_YR | SO_OBJ_YR | CHAR | 2 | 0 | Object folder: Year from ID | ||
38 | LFOLNO | SO_FOL_NO | SO_OBJ_NO | CHAR | 12 | 0 | Object folder: Number from ID |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SOFM | DOCNO | SOOD | OBJNO | KEY | 1 | CN |
2 | SOFM | DOCTP | TSOTD | OBJTP | KEY | 1 | 1 |
3 | SOFM | FOLNO | SOFD | FOLNO | KEY | 1 | CN |
4 | SOFM | FOLTP | TSOTD | OBJTP | KEY | 1 | 1 |
5 | SOFM | FORTP | TSOTD | OBJTP | KEY | 1 | 1 |
6 | SOFM | MANDT | T000 | MANDT | KEY | 1 | 1 |
7 | SOFM | NOTTP | TSOTD | OBJTP | KEY | 1 | 1 |
History
Last changed by/on | SAP | 19970214 |
SAP Release Created in |