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