SAP ABAP Table CRMST_EMP_SEARCH_BUIL (IL: Structure of Search Object 'BuilEmpSearch')

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUIL (Package) Interaction Layer for Business Partner (Until 5.0)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_EMP_SEARCH_BUIL	Table Relationship Diagram
Short Description	IL: Structure of Search Object 'BuilEmpSearch'

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	Emp Search: criteria for SEARCH_BY_BP_GENERAL (serv. class)
2	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	MC_NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
4	MC_NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
5	SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
6	SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
7	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
8	.INCLUDE	☐				0	0	BP Emp Search: search by Roles
9	ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
10	ROLECATEGORY	☐	BU_PARTNERROLECAT	BU_ROLECAT	CHAR	6	0	BP Role Category	*
11	.INCLUDE	☐				0	0	Search Structure for Communication Data (BP Header Search)
12	TELEPHONE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
13	COUNTRY_FOR_TEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
14	FAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
15	COUNTRY_FOR_FAX	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
16	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
17	URL	☐	AD_URI2	CHAR50	CHAR	50	0	URI address search field
18	.INCLUDE	☐				0	0	Structure for Search for BP address in CRM (lowercase)
19	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
20	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
21	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
22	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
23	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
24	REGION_IN_COUNTRY	☐	CRMT_BU_REGION_IN_COUNTRY	CHAR7	CHAR	7	0	Region by Country (for account address search)
25	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
26	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
27	STDADDR_ONLY	☐	CRMT_BUPA_IL_FLAG_SET	CRM_BUPA_IL_FLAG_SET	CHAR	1	0	Specifies whether a flag is set or not set
28	.INCLUDE	☐				0	0	Structure for Turkey Localization fields
29	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
30	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
31	MAX_HIT	☐	BU_MAXSEL		INT4	10	0	Maximum number of selected entries
32	NO_TREX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
33	FUZZY_SEARCH	☐	CRMT_BUPA_IL_FLAG_SET	CRM_BUPA_IL_FLAG_SET	CHAR	1	0	Specifies whether a flag is set or not set
34	CATEGORY	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
35	ALL_ADDRESS_VERSION	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
36	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
37	USERNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
38	ALSO_INVALID	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
39	.INCLUDE	☐				0	0	Search attributes for chm responsibility attributes
40	CRITERIA1	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
41	CRIT_VALUE1	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
42	CRITERIA2	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
43	CRIT_VALUE2	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
44	CRITERIA3	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
45	CRIT_VALUE3	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
46	CRITERIA4	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
47	CRIT_VALUE4	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
48	CRITERIA5	☐	CRMT_CHM_RESP_CRIT	ATNAM	CHAR	30	0	Responsibility Criterion ID
49	CRIT_VALUE5	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
50	.INCLUDE	☐				0	0	Search Filter Key / Value Entries
51	FILTER_KEY	☐	CRMT_BUPA_IL_FILTER_KEY	CHAR4	CHAR	4	0	Key value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH
52	FILTER_VALUE	☐	CRMT_BUPA_IL_FILTER_VALUE	SYSUUID_C	CHAR	32	0	Filter value for the BADI Interface IF_EX_CRM_BUPA_IL_SEARCH
53	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
54	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
55	.INCLUDE	☐				0	0
56	.INCLUDE	☐				0	0	AXT Extension for BuilHeader search structure
57	BP_AXT_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

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

History

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