SAP ABAP Table CRMST_TMIL_SEARCH (Territory structure for search query)

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_SEARCH	Table Relationship Diagram
Short Description	Territory structure for search query

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	TERRITORY_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
2	DESCRIPTION	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
3	EMPLOYEE	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	LEVEL_ID	☐	CRMT_TERRITORY_LEVEL	CRM_TERRITORY_LEVEL	NUMC	2	0	Territory Level
5	VALID	☐	DATUM	DATUM	DATS	8	0	Date
6	BP_BRICK	☐	CRMPHAT_BRICK_NUMBER	CRMPHA_BRICK_NUMBER	CHAR	10	0	CRM Pharma. BP : Market Segmentation
7	BP_GROUP	☐	CRMPHAT_BP_GROUP	CRMPHA_BP_GROUP	CHAR	4	0	Group
8	BP_SUBGROUP	☐	CRMPHAT_BP_SUBGROUP	CRMPHA_BP_SUBGROUP	CHAR	4	0	Subgroup
9	BP_MAIN_SPEC	☐	CRMPHAT_BP_SPEC_KEY	CRMPHA_BP_SPEC_KEY	CHAR	5	0	CRM Pharma/Healthcare BP: Qualification Key	*
10	BP_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
11	BP_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	BP_ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
13	PM_CATEGORY	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
14	BP_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
15	BP_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
16	BP_NODE	☐	CRMC_IC_STRING	CRMC_IC_STRING	STRG	0	0	String
17	ONLY_UNASSIGNED	☐	CRMT_TERRITORY_WITHOUT_EMP	CHAR1	CHAR	1	0	Checkbox Territories Without Employees
18	PARTNER_INDIRECT	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
19	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
20	SEARCH_BY_ID	☐	BU_LOCATOR_DIALOG_SEARCH_ID		NUMC	2	0	Selection of Search Characteristics
21	MAX_ROWS	☐			INT4	10	0
22	PM_SALE_CATEGORY	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID

History

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