SAP ABAP Table CRMT_BSP_CHM_SEAREQ_CONT_CHP (CHM:Company Contact Search)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM-PAM (Application Component) Account Management for Partners
     ⤷ CRM_BSP_MODEL_IL_CHM_COP (Package) Channel Management: Contact Persons

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_CHM_SEAREQ_CONT_CHP	Table Relationship Diagram
Short Description	CHM:Company Contact Search

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	.INCLUDE	☐				0	0	CHM: Contact Person Search
2	.INCLUDE	☐				0	0	CRM BSP: Contact Partner Search (Request)
3	PARTNER1	☐	CRMT_COMPANY	BU_PARTNER	CHAR	10	0	Account ID	*
4	PARTNER2	☐	CRMT_CONTACT	BU_PARTNER	CHAR	10	0	Contact Person ID	*
5	.INCLUDE	☐				0	0	Contact Person Search: Address
6	NAME_FIRST	☐	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
7	NAME_LAST	☐	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
8	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
9	ROOMNUM_C	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
10	SORT1_P	☐	CRMT_BSP_COP_SORT1	CHAR20	CHAR	20	0	Search Term A Person
11	SORT2_P	☐	CRMT_BSP_COP_SORT2	CHAR20	CHAR	20	0	Search Term B Person
12	NAME1	☐	CRMT_BSP_NAME1	BU_NAME	CHAR	40	0	Name 1 (Search Help Field 1)
13	NAME2	☐	CRMT_BSP_NAME2	BU_NAME	CHAR	40	0	Name 2 (Search Help Field 2)
14	CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
15	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
16	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
17	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
18	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
19	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
20	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
21	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
22	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
23	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
24	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	SORT1	☐	CRMT_BSP_ACC_SORT1	CHAR20	CHAR	20	0	Search Term A
26	SORT2	☐	CRMT_BSP_ACC_SORT2	CHAR20	CHAR	20	0	Search Term B
27	PARTNER2_USER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
28	.INCLUDE	☐				0	0	CHM:Search by Qualification data
29	OBJ_ID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
30	STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
31	RATING	☐	RATING	CHARA	NUMC	4	0	Proficiency of a Quality Scale
32	RATING_TEXT	☐	PROFC_TEXT	TEXT40	CHAR	40	0	Scale Proficiency Text
33	QGROUP_ID	☐	QUALIGROUP_ID	HROBJID	NUMC	8	0	Qualification group	*
34	QGROUPTXT	☐	QUALIGROUP_TXT	TEXT40	CHAR	40	0	Qualification Group (Name)
35	.INCLUDE	☐				0	0	CHM: Context information for Qualifications
36	CHM_BP_TYPE	☐	CRMT_CHM_QUAL_ASSIGNMENT	CRMT_CHM_QUAL_ASSIGNMENT	CHAR	1	0	Assignment level
37	MAINT_REQ	☐	CRMT_CHM_QUAL_MAINT_REQ	CRM_CHM_QUAL_MAINT_REQ	CHAR	1	0	Maintenance Option
38	ERROR_FLAG	☐	CRMT_BSP_F4_CSERROR	FLAG	CHAR	1	0	Error in context sensitive data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_CHM_SEAREQ_CONT_CHP	COUNTRY	T005	LAND1	KEY	1	CN
2	CRMT_BSP_CHM_SEAREQ_CONT_CHP	REGION	T005S	BLAND	REF	1	CN

History

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