SAP ABAP Table SMOTOURITEMS (Tour Items)

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	SMOTOURITEMS	Table Relationship Diagram
Short Description	Tour Items

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	SFATOURITEMS	☑	SMO_SFATOURITEMS	SMO_GUID	CHAR	32	0	SFA Key for Tour Items
3	SFATOUR	☐	SMO_SFATOUR	SMO_GUID	CHAR	32	0	SFA Key of Tour Header (SMOTOUR)
4	ACTCATEGORY	☐	SMO_ACTCATEGORY	CHAR3	CHAR	3	0	Activity Category
5	TOURDURATION	☐	SMO_TPDURATION	CDB_TOUR_DURATION	NUMC	5	0	Duration/Preparation
6	TOURDURATIONUNIT	☐	SMO_TPDURATIONUNITS	CDB_TOUR_UNITS	CHAR	1	0	Unit for Duration/Preparation
7	TOURPREPTIME	☐	SMO_TPDURATION	CDB_TOUR_DURATION	NUMC	5	0	Duration/Preparation
8	TOURPREPTIMEUNIT	☐	SMO_TPDURATIONUNITS	CDB_TOUR_UNITS	CHAR	1	0	Unit for Duration/Preparation
9	DAYNUMBERFROM	☐	SMO_DAYWEEKNUMBER	NUMC3	NUMC	3	0	Number of the Day/Week
10	DAYNUMBERTO	☐	SMO_DAYWEEKNUMBER	NUMC3	NUMC	3	0	Number of the Day/Week
11	WEEKNUMBERFROM	☐	SMO_DAYWEEKNUMBER	NUMC3	NUMC	3	0	Number of the Day/Week
12	WEEKNUMBERTO	☐	SMO_DAYWEEKNUMBER	NUMC3	NUMC	3	0	Number of the Day/Week
13	WEEKDAYFROM	☐	SMO_WEEKDA	SMO_LOGICL	CHAR	1	0	weekday
14	BPGUID	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
15	BPPARTNERNUM	☐	SMO3KUNNR	SMO3KUNNR	CHAR	10	0	Customer number
16	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
17	POSTCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
18	TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
19	VISITFREQUENCY	☐	SMO_VISITFREQUENCY	SMO_TXT4	CHAR	4	0	Visit Frequency of Business Partners
20	CPGUID	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
21	CPPARTNERNUM	☐	SMO3KUNNR	SMO3KUNNR	CHAR	10	0	Customer number
22	ACTTEMPLATEGUID	☐	SMO_ACTTEMPLATEGUID	SMO_GUID	CHAR	32	0	Activity Template GUID
23	PROCESS_TYPE	☐	SMO_TRANSACTIONTYPE	SMO_TXT4	CHAR	4	0	Transaction Type
24	ACTOBJECTTYPE	☐	SMO_OBJECTTYPE	SMO_TXT10	CHAR	10	0	Object Type
25	NOTIFICATIONTYPE	☐	SMO_NOTIFICATIONTYPE	SMO_TEXT1	CHAR	1	0	Notification Type
26	SEQNUM	☐	SMO_TPSEQNUM	SMO_CHAR10	CHAR	10	0	Tour Item Sequence Number
27	PARTNERSTARTTIME	☐	SMO_BPTIME	SMO_TIM	TIMS	6	0	Business Partner Start Time
28	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
29	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
30	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
31	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
32	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
33	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
34	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
35	BPADDRESSGUID	☐	SMO_SFAADC	SMO_GUID	CHAR	32	0	SFA Key of Address
36	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
37	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
38	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
39	PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
40	CPADDRESSGUID	☐	SMO_SFAADC	SMO_GUID	CHAR	32	0	SFA Key of Address
41	THSOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
42	TISOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
43	WEEKDAYTO	☐	SMO_WEEKDA	SMO_LOGICL	CHAR	1	0	weekday
44	BPSOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
45	CPSOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
46	PARTNERFRMSRC	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
47	PARTNERFRMSRCKEY	☐	SMO_SFAAOJ	SMO_GUID	CHAR	32	0	SFA key for related Object/Opportunity
48	ALLDAYFLAG	☐	SMO_ALLDAYFLAG	CDB_TOUR_ALLDAYFLAG	CHAR	1	0	All Day Flag
49	CLASS	☐	CRMT_ACTIVITY_CLASS	CRM_ACTIVITY_CLASS	CHAR	1	0	Activity Class

History

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