SAP ABAP Table V_SOID (Generated Table for View V_SOID)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SOID	Table Relationship Diagram
Short Description	Generated Table for View V_SOID

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	OWNTP	☑	SO_OWN_TP	SO_OBJ_TP	CHAR	3	0	Owner type from ID	TSOTD
3	OWNYR	☑	SO_OWN_YR	SO_OBJ_YR	CHAR	2	0	Owner year from the ID
4	OWNNO	☑	SO_OWN_NO	SO_OBJ_NO	CHAR	12	0	Owner number from the ID
5	OBJNAM	☑	SO_OBJ_NAM	SO_OBJ_NAM	CHAR	12	0	Name of document, folder or distribution list
6	DLITP	☐	SO_DLI_TP	SO_OBJ_TP	CHAR	3	0	Distribution list type from ID	TSOTD
7	DLIYR	☐	SO_DLI_YR	SO_OBJ_YR	CHAR	2	0	Distribution list year from the ID
8	DLINO	☐	SO_DLI_NO	SO_OBJ_NO	CHAR	12	0	Distribution list: number from the ID	SOOD
9	DLIFRE	☐	SO_DLI_FRE	SO_FLAG	CHAR	1	0	Subscription list
10	FOLTP	☐	SO_FOL_TP	SO_OBJ_TP	CHAR	3	0	Object folder: Object type from ID	TSOTD
11	FOLYR	☐	SO_FOL_YR	SO_OBJ_YR	CHAR	2	0	Object folder: Year from ID
12	FOLNO	☐	SO_FOL_NO	SO_OBJ_NO	CHAR	12	0	Object folder: Number from ID	SOFD
13	OBJDES	☐	SO_OBJ_DES	SO_OBJ_DES	CHAR	50	0	Short description of contents
14	OBJSNS	☐	SO_OBJ_SNS	SO_OBJ_SNS	CHAR	1	0	Object: Sensitivity (private, functional, ...)
15	CROTP	☐	SO_CRO_TP	SO_OBJ_TP	CHAR	3	0	User who created object: Object type from ID	TSOTD
16	CROYR	☐	SO_CRO_YR	SO_OBJ_YR	CHAR	2	0	User that created object: year from the ID
17	CRONO	☐	SO_CRO_NO	SO_OBJ_NO	CHAR	12	0	User that created object: number from the ID
18	FOLNAM	☐	SO_OBJ_NAM	SO_OBJ_NAM	CHAR	12	0	Name of document, folder or distribution list
19	FOLRG	☐	SO_FOL_RG	SO_FOL_RG	CHAR	1	0	Folder: Area (private, shared folders)
20	FOLSNS	☐	SO_OBJ_SNS	SO_OBJ_SNS	CHAR	1	0	Object: Sensitivity (private, functional, ...)
21	FOLSEC	☐	SO_FOL_SEC	SO_FOL_SEC	CHAR	1	0	Folder area (private, client, group, ...)
22	CRFTP	☐	SO_CRO_TP	SO_OBJ_TP	CHAR	3	0	User who created object: Object type from ID	TSOTD
23	CRFYR	☐	SO_CRO_YR	SO_OBJ_YR	CHAR	2	0	User that created object: year from the ID
24	CRFNO	☐	SO_CRO_NO	SO_OBJ_NO	CHAR	12	0	User that created object: number from the ID	SOOD

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SOID	CRFNO	SOOD	OBJNO	REF	C	CN
2	V_SOID	CRFTP	TSOTD	OBJTP	REF	C	CN
3	V_SOID	CROTP	TSOTD	OBJTP	REF	1	1
4	V_SOID	DLINO	SOOD	OBJNO	KEY	1	1
5	V_SOID	DLITP	TSOTD	OBJTP	REF	1	1
6	V_SOID	FOLNO	SOFD	FOLNO	REF	1	CN
7	V_SOID	FOLTP	TSOTD	OBJTP	KEY	1	1
8	V_SOID	MANDT	T000	MANDT	KEY	1	1
9	V_SOID	OWNTP	TSOTD	OBJTP	KEY	1	1

History

Last changed by/on	SAP	20010619
SAP Release Created in