SAP ABAP Table CRMT_BSP_SEAREQ_EMPLOYEE (Employee Search Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-PCU (Application Component) People-Centric UI (Business Partner)
     ⤷ CRM_BSP_MODEL_IL_BP (Package) Model Implementation: Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_SEAREQ_EMPLOYEE	Table Relationship Diagram
Short Description	Employee Search Structure

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	PARTNER1	☐	CRMT_COMPANY	BU_PARTNER	CHAR	10	0	Account ID	*
2	PARTNER2	☐	CRMT_EMPLOYEE	BU_PARTNER	CHAR	10	0	Business Partner: Employee	*
3	.INCLUDE	☐				0	0	Contact Person Search: Address
4	NAME_FIRST	☐	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
5	NAME_LAST	☐	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
6	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
7	ROOMNUM_C	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
8	SORT1_P	☐	CRMT_BSP_COP_SORT1	CHAR20	CHAR	20	0	Search Term A Person
9	SORT2_P	☐	CRMT_BSP_COP_SORT2	CHAR20	CHAR	20	0	Search Term B Person
10	NAME1	☐	CRMT_BSP_NAME1	BU_NAME	CHAR	40	0	Name 1 (Search Help Field 1)
11	NAME2	☐	CRMT_BSP_NAME2	BU_NAME	CHAR	40	0	Name 2 (Search Help Field 2)
12	CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
13	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
14	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
15	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
16	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
17	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
18	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
19	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
20	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
21	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
22	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
23	SORT1	☐	CRMT_BSP_ACC_SORT1	CHAR20	CHAR	20	0	Search Term A
24	SORT2	☐	CRMT_BSP_ACC_SORT2	CHAR20	CHAR	20	0	Search Term B
25	.INCLUDE	☐				0	0	Business Partner: Search Criteria for Communication
26	CONSNO_TEL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
27	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
28	TEL1_EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
29	TELEPHONE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
30	CONSNO_FAX	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
31	FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
32	FAX_EXT	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
33	FAX_NO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
34	CONSNO_EMAIL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
35	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
36	CONSNO_URL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
37	URL	☐	BSP_AD_URISCR	AD_URISCR	CHAR	132	0	URL, for Example, Homepage or ftp Address
38	MY_TEAM	☐	CRMT_MY_TEAM		CHAR	1	0	Employee Search: My Team
39	PARTNER2_USER	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name

Foreign Keys

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

History

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