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