SAP ABAP Table SMOESITSTR (Structure for sites)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	SMOESITSTR	Table Relationship Diagram
Short Description	Structure for 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	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	CNGP_NAM	☐	SMO_CNGPNM	SMO_TXT40	CHAR	40	0	Connection Group Name
24	TRSV_GRP	☐	SMO_TRSVGP	SMO_TXT40	CHAR	40	0	Transfer group
25	Q_NAME	☐	TRFCQNAM	TRFCQNAM	CHAR	24	0	Name of tRFC Queue
26	DEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
27	RW	☐	SMO_Q_TYPE	SMO_Q_TYPE	CHAR	1	0	Queue Type
28	PRIO	☐	SMOE_Q_PRIO	SMOE_Q_PRIO	INT4	10	0	Inbound/Outbound Queue Priority
29	.INCLUDE	☐				0	0	Site Type Data
30	SITETYPE	☐	SMW1STN	SMW1STN	CHAR	30	0	Site type
31	NAMESPACE	☐	SMW1NSPACE	NAMESPACE	CHAR	10	0	Reserved for Name Space	*
32	DELFLAG	☐	SMW1DELFLG	SMW1FLAG	CHAR	1	0	Marked for Deletion Flag
33	SITEINFQRY	☐	SMW1INFQRY	FUNCNAME	CHAR	30	0	Query function Site Information	*
34	OUTBADPQRY	☐	SMW1OUTQRY	FUNCNAME	CHAR	30	0	Query function outbound adapter	*
35	NEEDSCDB	☐	SMW1CDB	X	CHAR	1	0	Site Type needs Consolidated Data Base
36	RECGR	☐	SMWRECGRD	SMWRECGRD	CHAR	3	0	Receiver Group
37	.INCLUDE	☐				0	0	Structure for feedback informations
38	ACTION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
39	FEEDBACK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
40	PROTECTED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
41	AC_LINECOLOR	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
42	PAR_SIT_NAM	☐	SMO_PAR_SIT_NAME	SMOE_SITNAM	CHAR	32	0	Copy of Site [Site Name of Parent Site]
43	ASSIGNEDBY	☐	SMOEGENNAM	CHAR32	CHAR	32	0	Name of header record for a subscription generator

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in	12A