SAP ABAP Table CRMT_TERRMAN_LOCA_SEARCH (Search Fields in Locator)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-TM (Application Component) Territory Management
     ⤷ CRM_TERRMAN (Package) Territory Management

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_TERRMAN_LOCA_SEARCH	Table Relationship Diagram
Short Description	Search Fields in Locator

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	CRMC_TERRLEVEL
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	T005
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)	T005S
16	BP_NODE	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_TERRMAN_LOCA_SEARCH	BP_COUNTRY	T005	LAND1	REF	1	CN
2	CRMT_TERRMAN_LOCA_SEARCH	BP_REGION	T005S	BLAND	KEY	C	CN
3	CRMT_TERRMAN_LOCA_SEARCH	LEVEL_ID	CRMC_TERRLEVEL	LEVEL_ID	KEY

History

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