SAP ABAP Table CRMS_CLM_SQ_BUSINESS_PARTNER (Business Partner search conditions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC-CAM (Application Component) Campaign Execution
     ⤷ CRM_CIC_CLM_BO (Package) Call list management business objects

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_CLM_SQ_BUSINESS_PARTNER	Table Relationship Diagram
Short Description	Business Partner search conditions

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	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
3	SEARCH_TERM1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
4	SEARCH_TERM2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
5	TELEPHONE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
6	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
7	URL	☐	AD_URI2	CHAR50	CHAR	50	0	URI address search field
8	HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
9	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
10	CITY	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
11	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
12	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	POSTAL_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
14	CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_CLM_SQ_BUSINESS_PARTNER	COUNTRY	T005	LAND1
2	CRMS_CLM_SQ_BUSINESS_PARTNER	REGION	T005S	BLAND

History

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