SAP ABAP View V_SOID (SAPoffice: View of Inverse DL Tab. and Field Objects of SOOD)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
     SO (Package) SAPoffice
Basic Data
View Type D Database View 
Database View V_SOID  
Short Description SAPoffice: View of Inverse DL Tab. and Field Objects of SOOD    
Root table SOID   SAPoffice: Inverse record for distribution list 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SOID SOID
2 SOOD  
3 SOFD  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SOOD MANDT JL EQ 0 0
2 SOID MANDT JR EQ AND 0 0
3 SOOD OBJTP JL EQ 0 0
4 SOID DLITP JR EQ AND 0 0
5 SOOD OBJYR JL EQ 0 0
6 SOID DLIYR JR EQ AND 0 0
7 SOOD OBJNO JL EQ 0 0
8 SOID DLINO JR EQ AND 0 0
9 SOFD MANDT JL EQ 0 0
10 SOID MANDT JR EQ AND 0 0
11 SOFD FOLTP JL EQ 0 0
12 SOID FOLTP JR EQ AND 0 0
13 SOFD FOLYR JL EQ 0 0
14 SOID FOLYR JR EQ AND 0 0
15 SOFD FOLNO JL EQ 0 0
16 SOID FOLNO JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT SOID MANDT   MANDT Client
2 OWNTP SOID OWNTP   SO_OWN_TP Owner type from ID
3 OWNYR SOID OWNYR   SO_OWN_YR Owner year from the ID
4 OWNNO SOID OWNNO   SO_OWN_NO Owner number from the ID
5 OBJNAM SOID OBJNAM   SO_OBJ_NAM Name of document, folder or distribution list
6 DLITP SOID DLITP   SO_DLI_TP Distribution list type from ID
7 DLIYR SOID DLIYR   SO_DLI_YR Distribution list year from the ID
8 DLINO SOID DLINO   SO_DLI_NO Distribution list: number from the ID
9 DLIFRE SOID DLIFRE   SO_DLI_FRE Subscription list
10 FOLTP SOID FOLTP   SO_FOL_TP Object folder: Object type from ID
11 FOLYR SOID FOLYR   SO_FOL_YR Object folder: Year from ID
12 FOLNO SOID FOLNO   SO_FOL_NO Object folder: Number from ID
13 OBJDES SOOD OBJDES   SO_OBJ_DES Short description of contents
14 OBJSNS SOOD OBJSNS   SO_OBJ_SNS Object: Sensitivity (private, functional, ...)
15 CROTP SOOD CROTP   SO_CRO_TP User who created object: Object type from ID
16 CROYR SOOD CROYR   SO_CRO_YR User that created object: year from the ID
17 CRONO SOOD CRONO   SO_CRO_NO User that created object: number from the ID
18 FOLNAM SOFD OBJNAM   SO_OBJ_NAM Name of document, folder or distribution list
19 FOLRG SOFD FOLRG   SO_FOL_RG Folder: Area (private, shared folders)
20 FOLSNS SOFD OBJSNS   SO_OBJ_SNS Object: Sensitivity (private, functional, ...)
21 FOLSEC SOFD FOLSEC   SO_FOL_SEC Folder area (private, client, group, ...)
22 CRFTP SOFD CROTP   SO_CRO_TP User who created object: Object type from ID
23 CRFYR SOFD CROYR   SO_CRO_YR User that created object: year from the ID
24 CRFNO SOFD CRONO   SO_CRO_NO User that created object: number from the ID
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20010619 
SAP Release Created in