SAP table SOID (SAPoffice: Inverse record for distribution list)
SAP table SOID has 5 primary key fields being MANDT,OWNTP,OWNYR,OWNNO,OBJNAM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| OWNTP | Owner type from ID | CHAR | 3 | 0 | TSOTD | SO_OWN_TP | |
| OWNYR | Owner year from the ID | CHAR | 2 | 0 | SO_OWN_YR | ||
| OWNNO | Owner number from the ID | CHAR | 12 | 0 | * | SO_OWN_NO | |
| OBJNAM | Name of document, folder or distribution list | CHAR | 12 | 0 | SO_OBJ_NAM | ||
| DLITP | Distribution list type from ID | CHAR | 3 | 0 | TSOTD | SO_DLI_TP | |
| DLIYR | Distribution list year from the ID | CHAR | 2 | 0 | SO_DLI_YR | ||
| DLINO | Distribution list: number from the ID | CHAR | 12 | 0 | SOOD | SO_DLI_NO | |
| DLIFRE | Subscription list | CHAR | 1 | 0 | SO_DLI_FRE | ||
| FOLTP | Object folder: Object type from ID | CHAR | 3 | 0 | TSOTD | SO_FOL_TP | |
| FOLYR | Object folder: Year from ID | CHAR | 2 | 0 | SO_FOL_YR | ||
| FOLNO | Object folder: Number from ID | CHAR | 12 | 0 | SOFD | SO_FOL_NO | |
| FORTP | Forwarder: Object type from ID | CHAR | 3 | 0 | TSOTD | SO_FOR_TP | |
| FORYR | Forwarder: year from the ID | CHAR | 2 | 0 | SO_FOR_YR | ||
| FORNO | Forwarder: number from the ID | CHAR | 12 | 0 | * | SO_FOR_NO | |
| ACDAT | Date of last access | DATS | 8 | 0 | SO_DAT_LA | ||
| ACCNT | SAPoffice: Type I | INT4 | 10 | 0 | SO_INT |
SOID foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 SOID | DLINO | SOOD | SAPoffice: Object definition | MANDT |
| 0 SOID | DLINO | SOOD | SAPoffice: Object definition | OBJTP |
| 0 SOID | DLINO | SOOD | SAPoffice: Object definition | OBJYR |
| 0 SOID | DLINO | SOOD | SAPoffice: Object definition | OBJNO |
| 1 SOID | DLITP | TSOTD | Valid Object Types | OBJTP |
| 0 SOID | FOLNO | SOFD | SAPoffice: Object Definition | MANDT |
| 0 SOID | FOLNO | SOFD | SAPoffice: Object Definition | FOLTP |
| 1 SOID | FOLTP | TSOTD | Valid Object Types | OBJTP |
| 0 SOID | FORTP | TSOTD | Valid Object Types | OBJTP |
| 1 SOID | OWNTP | TSOTD | Valid Object Types | OBJTP |