SAP table SODM (SAPoffice: distribution list contents)

SAP table SODM has 7 primary key fields being MANDT,DLITP,DLIYR,DLINO,MEMTP,MEMYR,MEMNO.

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
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 * SO_DLI_NO
MEMTP Object in distribution list: Object type from ID CHAR 3 0 TSOTD SO_MEM_TP
MEMYR Object in distribution list: year from the ID CHAR 2 0 SO_MEM_YR
MEMNO Object in distribution list: number from the ID CHAR 12 0 * SO_MEM_NO
SNDDAY Send in ... days RAW 2 0 SO_SND_DAY
SNDART Output device CHAR 8 0 TDDEVICE
MAIL Mail
PRINTER Printer
SCREEN Screen
TELEFAX Fax Number
RECLAN Country/Region Key CHAR 3 0 T005 LAND1
RECTEL Telecommunications partner CHAR 30 0 SKTELNR
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
ACTDAY ToDo in ... days RAW 2 0 SO_ACT_DAY
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
REPDAY Reply within ... days RAW 2 0 SO_REP_DAY
OBJRR A reply must be sent for this object CHAR 1 0 SO_OBJ_RR
OBJRN A reply cannot be sent to the object CHAR 1 0 SO_OBJ_RN
REPTP Recipient of reply: Object type from ID CHAR 3 0 TSOTD SO_REP_TP
REPYR Recipient of reply: year from the ID CHAR 2 0 SO_REP_YR
REPNO Recipient of reply: number from the ID CHAR 12 0 * SO_REP_NO
COMART SAPoffice: Communication method CHAR 3 0 SO_COM_ART
LFDNR Addresses: Sequence number CHAR 3 0 SO_LFDNR
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
MAILSTATUS Status of external send in which a mail was sent CHAR 1 0 SO_MLSTAT

SODM foreign key relationships

Table Field Check Table Check Field
0 SODM DLITP TSOTD Valid Object Types OBJTP
1 SODM MEMTP TSOTD Valid Object Types OBJTP
0 SODM RECLAN T005 Countries MANDT
0 SODM RECLAN T005 Countries LAND1
1 SODM REPTP TSOTD Valid Object Types OBJTP