SAP ABAP Table SMOERELSITE (Site Relationships)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MW-ADM (Application Component) Administration Console
     SMOE (Package) AdminConsole
Basic Data
Table Category INTTAB    Structure 
Structure SMOERELSITE   Table Relationship Diagram
Short Description Site Relationships    
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 .INCLUDE       0   0   Site IDs  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 SITE_ID SMO_SITEID SMO_SITEID CHAR 32   0   Site ID *
4 SITE_NAME SMO_NAME SMOE_SITNAM CHAR 32   0   Site Name  
5 SITE_DESCR SMOE_INFO SMOE_INFO CHAR 255   0   Site Description  
6 SFACONGRP SMOE_CONGRP SMO_GUID CHAR 32   0   Mobile Client Site Attribute (Connection Group Key)  
7 SFATRNGRP SMOE_TRNGRP SMO_GUID CHAR 32   0   Mobile Client Site Attribute (Transfer Group Key)  
8 DBID SMOE_SMW1ATTR SMOE_SMW1ATTR CHAR 120   0   Mobile Client Site Attribute (Assignment to Client)  
9 DBPASSWORD SMOE_SMW1ATTR SMOE_SMW1ATTR CHAR 120   0   Mobile Client Site Attribute (Assignment to Client)  
10 DBUSER SMOE_SMW1ATTR SMOE_SMW1ATTR CHAR 120   0   Mobile Client Site Attribute (Assignment to Client)  
11 .INCLUDE       0   0   Communication Fields for Mobile Sales/Service  
12 TR_USER SMO_TR_USR SMO_TR_USR CHAR 32   0   Transaction User  
13 TR_ID SMO_TR_ID SMO_TR_ID CHAR 32   0   Transaction Identifier  
14 TR_STATUS SMO_TR_STS SMO_TR_STS CHAR 4   0   Status of Transaction  
15 TIMESTAMP TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
16 DELETED SMO_DELETD SMO_DELETD CHAR 1   0   Mobile Sales Deleted  
17 TR_ROOTID SMO_RTGUID SMO_GUID CHAR 32   0   Identifier of BDoc Root object  
18 SITETYPEID SMW1STID SMW1STID CHAR 32   0   Site Type ID SMW1SPRVDR
19 PARENT SMOE_PAR_SITE SMO_SITEID CHAR 32   0   Parent SiteID *
20 INITSTATE SMO_INISTA SMO_INISTA CHAR 1   0   Site in Initial State  
21 INACTIVE SMO_SITINA SMO_SITINA CHAR 1   0   Inactive Flag for Site  
22 COM_ACCESS SMOE_COMACC TZNTSTMPS DEC 15   0   Last Access of a Site via Conntrans  
23 RELFLAG SMOE_SITREL SMOE_SITREL CHAR 1   0   Site Relation Type  
24 RELATIONSHIP SMOE_SITRELSHIP SMOE_SITRELSHIP CHAR 30   0   Relationship  
25 ASSIGNM_STATUS SMOJ_ASSTA SMOJ_ASSTA CHAR 1   0   Assignment Status  
26 EXTRMODE SMOJ_EXTRMODE SMOJ_EXTRMODE CHAR 1   0   Data Collector Extract Mode  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SMOERELSITE SITETYPEID SMW1SPRVDR SITETYPEID KEY 1 CN
History
Last changed by/on SAP  20070309 
SAP Release Created in 100