SAP ABAP Table CRMST_TMIL_EMP_RESULT (Territory structure for employee result)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-TM (Application Component) Territory Management
     ⤷ CRM_TMIL (Package) Package for territory mgmt GENIL model

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_TMIL_EMP_RESULT	Table Relationship Diagram
Short Description	Territory structure for employee result

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	TO_BE_DELETED	☐	FLAG	FLAG	CHAR	1	0	General Flag
2	NEW_EMPLOYEE	☐	CRMT_EMPLOYEE	BU_PARTNER	CHAR	10	0	Business Partner: Employee	*
3	EMPLOYEE	☐	CRMT_EMPLOYEE	BU_PARTNER	CHAR	10	0	Business Partner: Employee	*
4	EMP_NAME	☐	NAME30		CHAR	30	0	Name
5	VBEGDA	☐	CRMT_TERRITORY_POS_DATE_FROM		DATS	8	0	Assignment of Territory to Position: Date From
6	VENDDA	☐	CRMT_TERRITORY_POS_DATE_TO		DATS	8	0	Assignment of Position to Territory: To Date
7	POS_NAME	☐	CRMT_TERRITORY_POSITION	TEXT12	CHAR	12	0	Position of Employee
8	POS_CODE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
9	PERCENTAGE	☐	PROZT	DEC3_2	DEC	5	2	Weighting Percentage
10	EMP_VBEGDA	☐	CRMT_TERRITORY_EMP_DATE_FROM		DATS	8	0	Employee Assignment to Position: Date From
11	EMP_VENDDA	☐	CRMT_TERRITORY_EMP_DATE_TO		DATS	8	0	Employee Assignment to Position: Date To
12	.INCLUDE	☐				0	0	Territories
13	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID	CRMM_V_TERR_ID
14	PARTNER_FUNCTION	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
15	MAIN_POSITION	☐	CRMT_TERRITORY_MAIN_POSITION	FLAG	CHAR	1	0	Main Position of Territory
16	DEFAULT_TERR	☐	CRMT_TERRITORY_DEFAULT_TERR	FLAG	CHAR	1	0	Default Territory for the Employees (Position)
17	DATA1	☐	CRMT_TERRITORY_AFT_DATA1	CHAR10	CHAR	10	0	Data Field 1: Territory Assignment Function Category
18	DATA2	☐	CRMT_TERRITORY_AFT_DATA2	CHAR5	CHAR	5	0	Data Field 1: Territory Assignment Function Category
19	FLAG1	☐	CRMT_TERRITORY_AFT_FLAG1	CHAR1	CHAR	1	0	Flag 1: Territory Assignment Function Category
20	FLAG2	☐	CRMT_TERRITORY_AFT_FLAG2	CHAR1	CHAR	1	0	Flag 2: Territory Assignment Function Category
21	GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
22	TERRITORY_V_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
23	PATH_GUID	☐	CRMT_TERRITORY_PATH_GUID	SYSUUID	RAW	16	0	Territory Path GUID
24	STATE	☐	CRMT_TERRITORY_STATE	CRM_TERRITORY_STATE	CHAR	1	0	Territory Status
25	LANGU	☐	CRMT_LANGUAGE	SPRAS	LANG	1	0	Language Key of Description	*
26	DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
27	OBJ_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
28	VALID_FROM_DATE	☐	CRMT_TERRITORY_VALID		DATS	8	0	Validity Date
29	VALID_TO_DATE	☐	CRMT_TERRITORY_VALID		DATS	8	0	Validity Date
30	VALID_FROM	☐	CRMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Time Dependency: Validity Start Date
31	VALID_TO	☐	CRMT_VALID_TO	BCOS_TSTMP	DEC	15	0	Time Dependency: Validity End Date
32	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
33	LEVEL_ID	☐	CRMT_TERRITORY_LEVEL	CRM_TERRITORY_LEVEL	NUMC	2	0	Territory Level

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMST_TMIL_EMP_RESULT	PATH_ID	CRMM_V_TERR_ID	PATH_ID	KEY	1	CN

History

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