SAP ABAP Table SMORELTER2 (Assignments of employees to territories)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA-TER (Application Component) Territory Management
     ⤷ MW_TERRITORY (Package) DDIC Objects for territory CDB tables

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMORELTER2	Table Relationship Diagram
Short Description	Assignments of employees to territories

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFARELTER2	☑	SMO_SFART	SMO_GUID	CHAR	32	0	SFA Key of Territory Relations
3	SFAMITABT	☐	SMO_SFAMIT	SMO_GUID	CHAR	32	0	Employee Key
4	R3KEY	☐	SMO_OLTPKY	SMO_OLTPKY	CHAR	12	0	Key of ERP (OLTP) system
5	SFATERR	☐	SMO_SFATR	SMO_GUID	CHAR	32	0	SFA Key of Territories
6	TERRID	☐	SMO_TERR	SMO_TERR	CHAR	12	0	Territory Key
7	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
8	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
9	ADDFIELD	☐	ADDFIELD	ADDFIELD	CHAR	32	0	Additional Fields for later enhancement
10	ADDFIELD2	☐	ADDFIELD	ADDFIELD	CHAR	32	0	Additional Fields for later enhancement
11	ADDFIELD3	☐	ADDFIELD	ADDFIELD	CHAR	32	0	Additional Fields for later enhancement
12	ADDFIELD4	☐	ADDFIELD	ADDFIELD	CHAR	32	0	Additional Fields for later enhancement
13	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
14	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
15	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
16	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
17	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
18	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
19	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
20	SUBSCR_MAIN	☐	FLAG	FLAG	CHAR	1	0	General Flag
21	TERRDFLT	☐	FLAG	FLAG	CHAR	1	0	General Flag
22	NTERRID	☐	NTERRID	CHAR_30	CHAR	30	0	Territory ID 30 Character length
23	SUBSCR_HIER	☐	SUBSCR_HIER	CHAR1	CHAR	1	0	Hierarchy Subscription for an Employee
24	PARTNER_FCT	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
25	MAINRESPONSIBLE	☐	SMO_FLAG1	SMO_TEXT1	CHAR	1	0	Flag

History

Last changed by/on	SAP	20130604
SAP Release Created in	20C