SAP ABAP Table SMOE_DEPSITSTR (Structure for Assigned Sites)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MW-ADM (Application Component) Administration Console
     ⤷ SMOE (Package) AdminConsole

Basic Data

Table Category	INTTAB	Structure
Structure	SMOE_DEPSITSTR	Table Relationship Diagram
Short Description	Structure for Assigned Sites

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	Structure for sites
2	.INCLUDE	☐				0	0	Site IDs
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	SITE_ID	☐	SMO_SITEID	SMO_SITEID	CHAR	32	0	Site ID	*
5	SITE_NAME	☐	SMO_NAME	SMOE_SITNAM	CHAR	32	0	Site Name
6	SITE_DESCR	☐	SMOE_INFO	SMOE_INFO	CHAR	255	0	Site Description
7	SFACONGRP	☐	SMOE_CONGRP	SMO_GUID	CHAR	32	0	Mobile Client Site Attribute (Connection Group Key)
8	SFATRNGRP	☐	SMOE_TRNGRP	SMO_GUID	CHAR	32	0	Mobile Client Site Attribute (Transfer Group Key)
9	DBID	☐	SMOE_SMW1ATTR	SMOE_SMW1ATTR	CHAR	120	0	Mobile Client Site Attribute (Assignment to Client)
10	DBPASSWORD	☐	SMOE_SMW1ATTR	SMOE_SMW1ATTR	CHAR	120	0	Mobile Client Site Attribute (Assignment to Client)
11	DBUSER	☐	SMOE_SMW1ATTR	SMOE_SMW1ATTR	CHAR	120	0	Mobile Client Site Attribute (Assignment to Client)
12	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
13	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
14	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
15	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
16	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
17	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
18	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
19	SITETYPEID	☐	SMW1STID	SMW1STID	CHAR	32	0	Site Type ID	SMW1SPRVDR
20	PARENT	☐	SMOE_PAR_SITE	SMO_SITEID	CHAR	32	0	Parent SiteID	*
21	INITSTATE	☐	SMO_INISTA	SMO_INISTA	CHAR	1	0	Site in Initial State
22	INACTIVE	☐	SMO_SITINA	SMO_SITINA	CHAR	1	0	Inactive Flag for Site
23	COM_ACCESS	☐	SMOE_COMACC	TZNTSTMPS	DEC	15	0	Last Access of a Site via Conntrans
24	CNGP_NAM	☐	SMO_CNGPNM	SMO_TXT40	CHAR	40	0	Connection Group Name
25	TRSV_GRP	☐	SMO_TRSVGP	SMO_TXT40	CHAR	40	0	Transfer group
26	Q_NAME	☐	TRFCQNAM	TRFCQNAM	CHAR	24	0	Name of tRFC Queue
27	DEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
28	RW	☐	SMO_Q_TYPE	SMO_Q_TYPE	CHAR	1	0	Queue Type
29	PRIO	☐	SMOE_Q_PRIO	SMOE_Q_PRIO	INT4	10	0	Inbound/Outbound Queue Priority
30	.INCLUDE	☐				0	0	Site Type Data
31	SITETYPE	☐	SMW1STN	SMW1STN	CHAR	30	0	Site type
32	NAMESPACE	☐	SMW1NSPACE	NAMESPACE	CHAR	10	0	Reserved for Name Space	*
33	DELFLAG	☐	SMW1DELFLG	SMW1FLAG	CHAR	1	0	Marked for Deletion Flag
34	SITEINFQRY	☐	SMW1INFQRY	FUNCNAME	CHAR	30	0	Query function Site Information	*
35	OUTBADPQRY	☐	SMW1OUTQRY	FUNCNAME	CHAR	30	0	Query function outbound adapter	*
36	NEEDSCDB	☐	SMW1CDB	X	CHAR	1	0	Site Type needs Consolidated Data Base
37	RECGR	☐	SMWRECGRD	SMWRECGRD	CHAR	3	0	Receiver Group
38	.INCLUDE	☐				0	0	Structure for feedback informations
39	ACTION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
40	FEEDBACK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
41	PROTECTED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
42	AC_LINECOLOR	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
43	PAR_SIT_NAM	☐	SMO_PAR_SIT_NAME	SMOE_SITNAM	CHAR	32	0	Copy of Site [Site Name of Parent Site]
44	ASSIGNEDBY	☐	SMOEGENNAM	CHAR32	CHAR	32	0	Name of header record for a subscription generator
45	RELFLAG	☐	SMOE_SITREL	SMOE_SITREL	CHAR	1	0	Site Relation Type
46	RELATIONSHIP	☐	SMOE_SITRELSHIP	SMOE_SITRELSHIP	CHAR	30	0	Relationship
47	ASSIGNM_STATUS	☐	SMOJ_ASSTA	SMOJ_ASSTA	CHAR	1	0	Assignment Status
48	EXTRMODE	☐	SMOJ_EXTRMODE	SMOJ_EXTRMODE	CHAR	1	0	Data Collector Extract Mode
49	EXTRMODE_ICON	☐	SMOJ_EXTRMODE_IC	ICON	CHAR	4	0	Icon: Data Collection On/Off	*
50	STATETXT	☐	SMOJ_STATETXT	SMOJ_STATETXT	CHAR	32	0	State Text for Display

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMOE_DEPSITSTR	SITETYPEID	SMW1SPRVDR	SITETYPEID	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	100