SAP ABAP Table COMT_BSP_BP_SEAREQ_EMPLOYEE (Search structure for the employees)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-PCU-BP (Application Component) Dialog People-Centric UI for Business Partner
     ⤷ COM_BSP_MODEL_IL_BP (Package) Central Parts of BP from the BSP Development

Basic Data

Table Category	INTTAB	Structure
Structure	COMT_BSP_BP_SEAREQ_EMPLOYEE	Table Relationship Diagram
Short Description	Search structure for the employees

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	☐	COMT_BSP_BP_EMPLOYEE_ID	BU_PARTNER	CHAR	10	0	Employee ID	*
2	.INCLUDE	☐				0	0	Search parameter for person with private address
3	NAME_FIRST	☐	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
4	NAME_LAST	☐	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
5	SORT1_P	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
6	SORT2_P	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
7	CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
8	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
9	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
10	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
11	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
12	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
13	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
14	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
15	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
16	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
17	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
18	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
19	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
20	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
21	NAME_F_LNG	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
22	NAME_L_LNG	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
23	CITY1_LNG	☐	AD_CITY1	TEXT40	CHAR	40	0	City
24	STREET_LNG	☐	AD_STREET	TEXT60	CHAR	60	0	Street
25	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
26	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	*
27	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
28	COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
29	TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
30	COUNTY_LNG	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
31	TOWNSHIP_LNG	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
32	.INCLUDE	☐				0	0	Business Partner: Search Criteria for Communication
33	CONSNO_TEL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
34	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
35	TEL1_EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
36	TELEPHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
37	CONSNO_FAX	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
38	FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
39	FAX_EXT	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
40	FAX_NO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
41	CONSNO_EMAIL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
42	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
43	CONSNO_URL	☐	AD_CONSNUM	NUMC3	NUMC	3	0	Sequence Number
44	URL	☐	BSP_AD_URISCR	AD_URISCR	CHAR	132	0	URL, for Example, Homepage or ftp Address
45	HITS	☐	COMT_BSP_BP_MAXHITS	COMT_BSP_BP_MAXHITS	NUMC	4	0	Maximum Number of Hits
46	ORG_UNIT	☐	COMT_BSP_BP_ORGN_UNIT	NUM08	NUMC	8	0	Organizational Unit
47	.INCLUDE	☐				0	0	Data of central person
48	PARTNER_TYPE	☐	COMT_BSP_BU_TYPE	BU_TYPE	CHAR	1	0	Business Partner Category
49	PERSON_ID	☐	PERSONID	PERSONID	NUMC	8	0	Technical Person Number
50	PERNR	☐	PERSONAL_NUMBER	PERSONAL_NUMBER	NUMC	8	0	Personnel Number
51	USERNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
52	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for BP Roles
53	PARTNERROLE	☐	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role	*
54	DIFFTYPEVALUE	☐	BU_DFVAL	CHAR20	CHAR	20	0	BP: Differentiation type value
55	PARTNERROLECATEGORY	☐	BU_PARTNERROLECAT	BU_ROLECAT	CHAR	6	0	BP Role Category	*
56	VALID_FROM	☐	BU_VALID_FROM_DATS	DATUM	DATS	8	0	Valid From
57	VALID_TO	☐	BU_VALID_TO_DATS	DATUM	DATS	8	0	Valid To
58	.INCLUDE	☐				0	0	Search Parameter for a Person's Address in the Company
59	REL_CALLER_NO	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
60	REL_MOBIL_PHONE	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
61	REL_EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
62	REL_CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
63	REL_POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
64	REL_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
65	REL_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
66	REL_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
67	REL_HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
68	REL_COUNTRY_FOR_TEL	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
69	REL_FAXNUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
70	REL_DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
71	REL_PAFKT	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	*
72	REL_ABTNR	☐	BU_ABTNR	BU_ABTNR	CHAR	4	0	Department	*
73	REL_ROOMNUM_C	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
74	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
75	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
76	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	COMT_BSP_BP_SEAREQ_EMPLOYEE	COUNTRY	T005	LAND1	REF	C	CN
2	COMT_BSP_BP_SEAREQ_EMPLOYEE	REGION	T005S	BLAND	REF	C	CN
3	COMT_BSP_BP_SEAREQ_EMPLOYEE	REL_COUNTRY	T005	LAND1	REF	1	CN
4	COMT_BSP_BP_SEAREQ_EMPLOYEE	REL_REGION	T005S	BLAND	REF	C	CN

History

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