SAP table SOMG (Table for persistence of objects MESSAGE/RECIPIENT)
SAP table SOMG has 4 primary key fields being MANDT,OBJTP,OBJYR,OBJNO.
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 | * | MANDT | |||||||||
| OBJTP | Object type | CHAR | 3 | 0 | OBJ_TP | ||||||||||
| OBJYR | Object MESSAGE/RECIPIENT: Year from ID | CHAR | 2 | 0 | OBJ_YR | ||||||||||
| OBJNO | Object MESSAGE/RECIPIENT: Number from ID | CHAR | 12 | 0 | * | OBJ_NO | |||||||||
| RCP_ID_TP | Sender type from the ID | CHAR | 3 | 0 | * | SO_SND_TP | |||||||||
| RCP_ID_YR | Sender year from the ID | CHAR | 2 | 0 | SO_SND_YR | ||||||||||
| RCP_ID_NO | Sender number from the ID | CHAR | 12 | 0 | * | SO_SND_NO | |||||||||
| RCP_SND_TP | Output device | CHAR | 8 | 0 | TDDEVICE |
|
|||||||||
| RCP_SEQ_NO | Addresses: Sequence Number of Address | CHAR | 3 | 0 | SO_LFD_NR | ||||||||||
| FOLTP | Object folder: Object type from ID | CHAR | 3 | 0 | * | SO_FOL_TP | |||||||||
| FOLYR | Object folder: Year from ID | CHAR | 2 | 0 | SO_FOL_YR | ||||||||||
| FOLNO | Object folder: Number from ID | CHAR | 12 | 0 | * | SO_FOL_NO | |||||||||
| DOCTP | Object: Object Type From ID | CHAR | 3 | 0 | * | SO_DOC_TP | |||||||||
| DOCYR | Object: Year from ID | CHAR | 2 | 0 | SO_DOC_YR | ||||||||||
| DOCNO | Object: Number from ID | CHAR | 12 | 0 | * | SO_DOC_NO | |||||||||
| FORTP | Forwarder: Object type from ID | CHAR | 3 | 0 | * | 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 | |||||||||
| USED_BY | Object ID | CHAR | 90 | 0 | SWO_OBJID | ||||||||||
| GEN_NOTTP | Note: Type from ID (only if no note to recipient) | CHAR | 3 | 0 | * | GEN_NOT_TP | |||||||||
| GEN_NOTYR | Note: Year from ID (only if no note to recipient) | CHAR | 2 | 0 | GEN_NOT_YR | ||||||||||
| GEN_NOTNO | Note: Number from ID (only if no note to recipient) | CHAR | 12 | 0 | * | GEN_NOT_NO | |||||||||
| OUTBOX | Flag: Save in outbox after sending | CHAR | 1 | 0 | SO_OUTBOX | ||||||||||
| ARC_FOLTP | Object folder: Object type from ID | CHAR | 3 | 0 | * | SO_FOL_TP | |||||||||
| ARC_FOLYR | Object folder: Year from ID | CHAR | 2 | 0 | SO_FOL_YR | ||||||||||
| ARC_FOLNO | Object folder: Number from ID | CHAR | 12 | 0 | * | SO_FOL_NO | |||||||||
| ASYNCHRON | Send document asynchronously | CHAR | 1 | 0 | SYNC | ||||||||||
| SENDER | Object ID | CHAR | 90 | 0 | SWO_OBJID | ||||||||||
| NOTTP | Default setting of document class | CHAR | 3 | 0 | * | SO_NOT_TP | |||||||||
| NOTYR | Object note: year from the ID | CHAR | 2 | 0 | SO_NOT_YR | ||||||||||
| NOTNO | Object note: number from the ID | CHAR | 12 | 0 | * | SO_NOT_NO | |||||||||
| REPLY_TO | Object ID | CHAR | 90 | 0 | SWO_OBJID | ||||||||||
| SNDEX | Send express | CHAR | 1 | 0 | SO_SND_EX | ||||||||||
| SNDCP | Send: As copy | CHAR | 1 | 0 | SO_SND_CP | ||||||||||
| SNDBC | Send as a blind copy | CHAR | 1 | 0 | SO_SND_BC | ||||||||||
| FORFB | You cannot forward this message | CHAR | 1 | 0 | SO_FORFB | ||||||||||
| PRIFB | Object cannot be printed | CHAR | 1 | 0 | SO_PRIFB | ||||||||||
| SNDPRI | Send: Priority | CHAR | 1 | 0 | SO_SND_PRI | ||||||||||
| ACALL | ToDo by all recipients | CHAR | 1 | 0 | SO_ACALL | ||||||||||
| ACONE | ToDo by one of the recipients in the group | RAW | 1 | 0 | SO_ACONE | ||||||||||
| OBJRR | A reply must be sent for this object | CHAR | 1 | 0 | SO_OBJ_RR | ||||||||||
| MAILSTATUS | Status of external send in which a mail was sent | CHAR | 1 | 0 | SO_MLSTAT | ||||||||||
| DELIVER | Acknowledgment of receipt expected | CHAR | 1 | 0 | SO_NF_DELI | ||||||||||
| NOT_DELI | Acknowledgment of receipt expected | CHAR | 1 | 0 | SO_NOTDELI | ||||||||||
| READ_NOTIF | Read acknowledgment expected | CHAR | 1 | 0 | SO_NOTREC | ||||||||||
| RESEND | SAPoffice: Object sent to recipient more than once | CHAR | 1 | 0 | SO_RESEND | ||||||||||
| OBJRN | A reply cannot be sent to the object | CHAR | 1 | 0 | SO_OBJ_RN | ||||||||||
| MSGID | Message Class | CHAR | 20 | 0 | * | SYMSGID | |||||||||
| MSGNO | Message Number | NUMC | 3 | 0 | SYMSGNO |