SAP ABAP Table CRMS_AHN_TERRID_ADVSEARCH (GENIL structure for search help)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL (Application Component) Marketing Planner
     ⤷ CRM_MKTGS_IL_AHN (Package) Package For Search Help for AHN with terr_id

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_AHN_TERRID_ADVSEARCH	Table Relationship Diagram
Short Description	GENIL structure for search help

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	TREE_SEARCH_TERM	☐	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
2	TREE_DESCRIPTION	☐	BU_TREE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of Hierarchy Tree
3	TREE	☐	BU_TREE_SEARCH_TERM		CHAR	20	0	Hierarchy Tree ID
4	HIERARCHY_TYPE	☐	BU_HIERARCHY_TYPE		CHAR	2	0	Hierarchy Category of BP Group Hierarchy
5	NODE_SEARCH_TERM	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
6	NODE_DESCRIPTION	☐	BU_NODE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of a Hierarchy Node
7	NODE	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
8	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
9	CUSTOMER	☐	CRMT_BU_MAP_CUSTOMER_NUMBER	KUNNR	CHAR	10	0	ERP Customer Number of a Business Partner	*
10	.INCLUDE	☐				0	0	Internal Structure for Sales and Distribution Area
11	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
12	CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
13	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
14	VALID_TIME	☐	BU_KEY_DATE		DATS	8	0	Key Date
15	VALID_FROM	☐	BU_VALID_FROM	DATUM	DATS	8	0	Valid From
16	VALID_TO	☐	BU_VALID_TO	DATUM	DATS	8	0	Valid To
17	TREE_GUID	☐	BU_TREE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Tree
18	ERP_CUSTOMER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
19	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
20	MC_NAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)

History

Last changed by/on	SAP	20140802
SAP Release Created in	700