SAP ABAP Table SMOTOUR (Tour Header)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOTOUR	Table Relationship Diagram
Short Description	Tour Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFATOUR	☑	SMO_SFATOUR	SMO_GUID	CHAR	32	0	SFA Key of Tour Header (SMOTOUR)
3	MODIFIEDBY	☐	SMO_MODIFIEDBY	SMO_GUID	CHAR	32	0	User who modified the object
4	MODIFIEDON	☐	SMO_MODIFIEDON	SMO_DATE	DATS	8	0	Date on which modified
5	CREATEDBY	☐	SMO_CREATEDBY	SMO_GUID	CHAR	32	0	Creator of the tour
6	CREATEDON	☐	SMO_CREATEDON	SMO_DATE	DATS	8	0	Created on date
7	TOUROWNER	☐	SMO_TOUROWNER	SMO_GUID	CHAR	32	0	Owner of the Tour
8	PATHID	☐	SMO_TERRITORYID	CHAR_30	CHAR	30	0	Territory ID 30 Character length
9	TERR_V_GUID	☐	SMO_TERRITORYGUID	SMO_GUID	CHAR	32	0	SFA Key of Territories
10	TOURDESCRIPTION	☐	SMO_TOURDESCRIPTION	CDB_TXT55	CHAR	55	0	Description of the tour
11	LANGUAGE	☐	SMO_LANGUAGE	SMO_LANGU	CHAR	2	0	Language in whch the tour was created
12	TOURNUMBER	☐	SMO_TOURNUMBER	CDB_TOUR_NO	CHAR	10	0	Tour ID
13	ACTCATEGORY	☐	SMO_ACTCATEGORY	CHAR3	CHAR	3	0	Activity Category
14	VALIDFROM	☐	SMO_VALIDSTART	CDB_VALID_START	DATS	8	0	Validity Start Date of the Tour
15	VALIDTO	☐	SMO_VALIDEND	CDB_VALID_END	DATS	8	0	Validity End Date of the Tour
16	VALIDITYTIMEZONE	☐	SMO_TIMEZONE	TZNZONE	CHAR	6	0	Validity Time Zone of the Tour	*
17	TOURFREQ	☐	SMO_TOURFREQUENCY	CDB_TOUR_FREQUENCY	NUMC	5	0	Frequency of the Tour
18	TOURFREQUNIT	☐	SMO_TOURFREQUENCYUNITS	CDB_TOUR_UNITS	CHAR	1	0	Unit for Tour Frequency
19	TOURSTATUS	☐	SMO_TOURSTATUS	CDB_TOUR_STATUS	CHAR	1	0	Tour Status
20	ALLDAYFLAG	☐	SMO_ALLDAYFLAG	CDB_TOUR_ALLDAYFLAG	CHAR	1	0	All Day Flag
21	TOURDURATION	☐	SMO_TPDURATION	CDB_TOUR_DURATION	NUMC	5	0	Duration/Preparation
22	TOURDURATIONUNIT	☐	SMO_TPDURATIONUNITS	CDB_TOUR_UNITS	CHAR	1	0	Unit for Duration/Preparation
23	TOURPREPTIME	☐	SMO_TPDURATION	CDB_TOUR_DURATION	NUMC	5	0	Duration/Preparation
24	TOURPREPTIMEUNIT	☐	SMO_TPDURATIONUNITS	CDB_TOUR_UNITS	CHAR	1	0	Unit for Duration/Preparation
25	PROCESS_TYPE	☐	SMO_TRANSACTIONTYPE	SMO_TXT4	CHAR	4	0	Transaction Type
26	ACTOBJECTTYPE	☐	SMO_OBJECTTYPE	SMO_TXT10	CHAR	10	0	Object Type
27	ACTTEMPLATEGUID	☐	SMO_ACTTEMPLATEGUID	SMO_GUID	CHAR	32	0	Activity Template GUID
28	NOTIFICATIONTYPE	☐	SMO_NOTIFICATIONTYPE	SMO_TEXT1	CHAR	1	0	Notification Type
29	USEWEEKDAY	☐	SMO_USEWEEKDAY	SMO_TEXT1	CHAR	1	0	Use Week Day
30	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
31	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
32	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
33	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
34	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
35	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
36	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
37	THSOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
38	CLASS	☐	CRMT_ACTIVITY_CLASS	CRM_ACTIVITY_CLASS	CHAR	1	0	Activity Class

History

Last changed by/on	SAP	20110908
SAP Release Created in	400