SAP SOID SAPoffice: Inverse record for distribution list Table data and field list

SOID is a standard SAP Table which is used to store SAPoffice: Inverse record for distribution list data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The SOID table consists of various fields, each holding specific information or linking keys about SAPoffice: Inverse record for distribution list data available in SAP. These include OWNTP (Owner type from ID), OWNYR (Owner year from the ID), OWNNO (Owner number from the ID), OBJNAM (Name of document, folder or distribution list)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

SOID table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP SOID table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the SOID table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
OWNTP	Owner type from ID	SO_OWN_TP	CHAR	3	TSOTD		SO_OBJ_TP
OWNYR	Owner year from the ID	SO_OWN_YR	CHAR	2			SO_OBJ_YR
OWNNO	Owner number from the ID	SO_OWN_NO	CHAR	12	Assigned to domain		SO_OBJ_NO
OBJNAM	Name of document, folder or distribution list	SO_OBJ_NAM	CHAR	12			SO_OBJ_NAM
DLITP	Distribution list type from ID	SO_DLI_TP	CHAR	3	TSOTD		SO_OBJ_TP
DLIYR	Distribution list year from the ID	SO_DLI_YR	CHAR	2			SO_OBJ_YR
DLINO	Distribution list: number from the ID	SO_DLI_NO	CHAR	12	SOOD		SO_OBJ_NO
DLIFRE	Subscription list	SO_DLI_FRE	CHAR	1			SO_FLAG
FOLTP	Object folder: Object type from ID	SO_FOL_TP	CHAR	3	TSOTD		SO_OBJ_TP
FOLYR	Object folder: Year from ID	SO_FOL_YR	CHAR	2			SO_OBJ_YR
FOLNO	Object folder: Number from ID	SO_FOL_NO	CHAR	12	SOFD		SO_OBJ_NO
FORTP	Forwarder: Object type from ID	SO_FOR_TP	CHAR	3	TSOTD		SO_OBJ_TP
FORYR	Forwarder: year from the ID	SO_FOR_YR	CHAR	2			SO_OBJ_YR
FORNO	Forwarder: number from the ID	SO_FOR_NO	CHAR	12	Assigned to domain		SO_OBJ_NO
ACDAT	Date of last access	SO_DAT_LA	DATS	8			DATUM
ACCNT	SAPoffice: Type I	SO_INT	INT4	10			SO_INT

Key field

Non-key field

< SOHS - SAPoffice: DB for Home System (Shared Buffer) SOIDD - SAPoffice: inverse record for object (data division) >

How do I retrieve data from SAP table SOID using ABAP code

The following ABAP code Example will allow you to do a basic selection on SOID to SELECT all data from the table
DATA: WA_SOID TYPE SOID.

SELECT SINGLE *
FROM SOID
INTO CORRESPONDING FIELDS OF WA_SOID
WHERE...

How to access SAP table SOID

Within an ECC or HANA version of SAP you can also view further information about SOID and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).