| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | DLITP | Distribution list type from ID | nvarchar | 3 | 0 | CHAR | (N' ') | No | TSOTD | SO_DLI_TP | Allow NULL? |
| 3 | DLIYR | Distribution list year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SO_DLI_YR | Allow NULL? |
| 4 | DLINO | Distribution list: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | SO_DLI_NO | Allow NULL? |
| 5 | MEMTP | Object in distribution list: Object type from ID | nvarchar | 3 | 0 | CHAR | (N' ') | No | TSOTD | SO_MEM_TP | Allow NULL? |
| 6 | MEMYR | Object in distribution list: year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SO_MEM_YR | Allow NULL? |
| 7 | MEMNO | Object in distribution list: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | SO_MEM_NO | Allow NULL? |
| 8 | SNDDAY | Send in ... days | varbinary | 2 | 0 | RAW | | Yes | | SO_SND_DAY | |
| 9 | SNDART | Output device | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | TDDEVICE | Allow NULL? |
| 10 | RECLAN | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 11 | RECTEL | Telecommunications partner | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SKTELNR | Allow NULL? |
| 12 | SNDEX | Send express | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_SND_EX | Allow NULL? |
| 13 | SNDCP | Send: As copy | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_SND_CP | Allow NULL? |
| 14 | SNDBC | Send as a blind copy | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_SND_BC | Allow NULL? |
| 15 | FORFB | You cannot forward this message | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_FORFB | Allow NULL? |
| 16 | PRIFB | Object cannot be printed | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_PRIFB | Allow NULL? |
| 17 | SNDPRI | Send: Priority | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_SND_PRI | Allow NULL? |
| 18 | ACTDAY | ToDo in ... days | varbinary | 2 | 0 | RAW | | Yes | | SO_ACT_DAY | |
| 19 | ACALL | ToDo by all recipients | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_ACALL | Allow NULL? |
| 20 | ACONE | ToDo by one of the recipients in the group | varbinary | 1 | 0 | RAW | | Yes | | SO_ACONE | |
| 21 | REPDAY | Reply within ... days | varbinary | 2 | 0 | RAW | | Yes | | SO_REP_DAY | |
| 22 | OBJRR | A reply must be sent for this object | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_RR | Allow NULL? |
| 23 | OBJRN | A reply cannot be sent to the object | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_RN | Allow NULL? |
| 24 | REPTP | Recipient of reply: Object type from ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_REP_TP | Allow NULL? |
| 25 | REPYR | Recipient of reply: year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_REP_YR | Allow NULL? |
| 26 | REPNO | Recipient of reply: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_REP_NO | Allow NULL? |
| 27 | COMART | SAPoffice: Communication method | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SO_COM_ART | Allow NULL? |
| 28 | LFDNR | Addresses: Sequence number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SO_LFDNR | Allow NULL? |
| 29 | DELIVER | Acknowledgment of receipt expected | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_NF_DELI | Allow NULL? |
| 30 | NOT_DELI | Acknowledgment of receipt expected | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_NOTDELI | Allow NULL? |
| 31 | READ_NOTIF | Read acknowledgment expected | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_NOTREC | Allow NULL? |
| 32 | MAILSTATUS | Status of external send in which a mail was sent | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_MLSTAT | Allow NULL? |
