SAP Table SOID
SAPoffice: Inverse record for distribution list
SOID (SAPoffice: Inverse record for distribution list) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SOID to other SAP tables.
SOID table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| OWNTP | Owner type from ID | SO_OWN_TP | TSOTD | CHAR | 3 | 0 | ||||||
| OWNYR | Owner year from the ID | SO_OWN_YR | CHAR | 2 | 0 | |||||||
| OWNNO | Owner number from the ID | SO_OWN_NO | CHAR | 12 | 0 | |||||||
| OBJNAM | Name of document, folder or distribution list | SO_OBJ_NAM | CHAR | 12 | 0 | |||||||
| DLITP | Distribution list type from ID | SO_DLI_TP | TSOTD | CHAR | 3 | 0 | ||||||
| DLIYR | Distribution list year from the ID | SO_DLI_YR | CHAR | 2 | 0 | |||||||
| DLINO | Distribution list: number from the ID | SO_DLI_NO | SOOD | CHAR | 12 | 0 | ||||||
| DLIFRE | Subscription list | SO_DLI_FRE | CHAR | 1 | 0 |
Possible values
|
||||||
| FOLTP | Object folder: Object type from ID | SO_FOL_TP | TSOTD | CHAR | 3 | 0 | ||||||
| FOLYR | Object folder: Year from ID | SO_FOL_YR | CHAR | 2 | 0 | |||||||
| FOLNO | Object folder: Number from ID | SO_FOL_NO | SOFD | CHAR | 12 | 0 | ||||||
| FORTP | Forwarder: Object type from ID | SO_FOR_TP | TSOTD | CHAR | 3 | 0 | ||||||
| FORYR | Forwarder: year from the ID | SO_FOR_YR | CHAR | 2 | 0 | |||||||
| FORNO | Forwarder: number from the ID | SO_FOR_NO | CHAR | 12 | 0 | |||||||
| ACDAT | Date of last access | SO_DAT_LA | DATS | 8 | 0 | |||||||
| ACCNT | SAPoffice: Type I | SO_INT | INT4 | 10 | 0 | |||||||
SOID foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SOID | DLINO | SOID | DLINO | SOOD | SAPoffice: Object definition | OBJNO |
| SOID | DLINO | SOID | MANDT | SOOD | SAPoffice: Object definition | MANDT |
| SOID | DLINO | SOID | DLITP | SOOD | SAPoffice: Object definition | OBJTP |
| SOID | DLINO | SOID | DLIYR | SOOD | SAPoffice: Object definition | OBJYR |
| SOID | DLITP | SOID | DLITP | TSOTD | Valid Object Types | OBJTP |
| SOID | FOLNO | SOID | FOLYR | SOFD | SAPoffice: Object Definition | FOLYR |
| SOID | FOLNO | SOID | FOLNO | SOFD | SAPoffice: Object Definition | FOLNO |
| SOID | FOLNO | SOID | MANDT | SOFD | SAPoffice: Object Definition | MANDT |
| SOID | FOLNO | SOID | FOLTP | SOFD | SAPoffice: Object Definition | FOLTP |
| SOID | FOLTP | SOID | FOLTP | TSOTD | Valid Object Types | OBJTP |
| SOID | FORTP | SOID | FORTP | TSOTD | Valid Object Types | OBJTP |
| SOID | MANDT | SOID | MANDT | T000 | Clients | MANDT |
| SOID | OWNTP | SOID | OWNTP | TSOTD | Valid Object Types | OBJTP |
