SAP ABAP Table CRMT_BSP_SEARES_ACC_EMPLOYEE (Result structure of employee search)
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_SEARES_ACC_EMPLOYEE   Table Relationship Diagram
Short Description Result structure of employee search    
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 OBJECT_KEY CRMT_BSP_OBJECTKEY   CHAR 100   0   Object Key  
2 OBJECT_TYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
3 PARTNER1 COMT_BSP_BP_EMPLOYEE_ID BU_PARTNER CHAR 10   0   Employee ID *
4 PARTNER1_GUID BU_PARTNER_GUID_BAPI SYSUUID_C CHAR 32   0   GUID of a Business Partner in CHAR 32 Format for BAPIs  
5 ADDRESS_GUID BU_ADDRESS_GUID SYSUUID RAW 16   0   GUID of a Business Partner Address  
6 ADDRESS_NUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
7 ADR_NOTES AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
8 COUNTRY_TEXT COMT_BU_COUNTRY_DESCRIPTION TEXT50 CHAR 50   0   Country Description  
9 REGION_TEXT COMT_BU_REGION_DESCRIPTION TEXT20 CHAR 20   0   Region (State, Province, County)  
10 FURTHER_ADDRESSES COMT_BSP_FURTHER_ADDRESSES   CHAR 1   0   BSP: GIF for Further Addresses  
11 BP_NAME1 BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
12 BP_NAME2 BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
13 SEARCHTERM1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
14 SEARCHTERM2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
15 TITLE_KEY AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
16 .INCLUDE       0   0   Include Structure with ADRC Attributes and Descriptions  
17 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
18 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
19 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
20 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
21 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
22 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
23 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
24 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
25 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
26 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
27 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
28 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
29 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
30 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
31 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
32 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
33 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
34 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
35 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
36 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
37 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
38 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
39 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
40 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
41 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
42 STREET AD_STREET TEXT60 CHAR 60   0   Street  
43 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
44 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
45 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
46 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
47 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
48 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
49 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
50 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
51 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
52 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
53 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
54 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
55 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
56 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
57 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
58 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
59 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
60 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
61 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
62 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
63 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
64 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
65 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
66 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
67 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
68 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
69 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
70 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
71 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
72 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
73 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county ADRCOUNTY
74 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
75 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township ADRTOWNSHIP
76 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
77 COUNTRY_DESCRIPTION LANDX TEXT15 CHAR 15   0   Country Name  
78 REGION_DESCRIPTION BEZEI20 TEXT20 CHAR 20   0   Description  
79 TRANSPZONE_DESCRIPTION BEZEI20 TEXT20 CHAR 20   0   Description  
80 REGIOGROUP_DESCRIPTION TEXT50 TEXT50 CHAR 50   0   Text Field  
81 PO_BOX_CTY_DESCRIPTION LANDX TEXT15 CHAR 15   0   Country Name  
82 PO_BOX_REG_DESCRIPTION BEZEI20 TEXT20 CHAR 20   0   Description  
83 .INCLUDE       0   0   Business Partner: Search Criteria for Communication  
84 CONSNO_TEL AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
85 TEL1_NUMBR AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
86 TEL1_EXT AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
87 TELEPHONE AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
88 CONSNO_FAX AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
89 FAX AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
90 FAX_EXT AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
91 FAX_NO AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
92 CONSNO_EMAIL AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
93 EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
94 CONSNO_URL AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
95 URL BSP_AD_URISCR AD_URISCR CHAR 132   0   URL, for Example, Homepage or ftp Address  
96 .INCLUDE       0   0   EEW Extension of BUT000 (Contains CI)  
97 BP_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
98 .INCLUDE       0   0    
99 .INCLUDE       0   0   Data of central person  
100 .INCLUDE       0   0   Data of central person  
101 PARTNER_TYPE COMT_BSP_BU_TYPE BU_TYPE CHAR 1   0   Business Partner Category  
102 PERSON_ID PERSONID PERSONID NUMC 8   0   Technical Person Number  
103 PERNR PERSONAL_NUMBER PERSONAL_NUMBER NUMC 8   0   Personnel Number  
104 USERNAME SYUNAME SYCHAR12 CHAR 12   0   User Name  
105 .INCLUDE       0   0   HR fields of an employee  
106 PERSG PERSG PERSG CHAR 1   0   Employee Group *
107 PERSK PERSK PERSK CHAR 2   0   Employee Subgroup *
108 WERKS PERSA PERSA CHAR 4   0   Personnel Area *
109 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
110 .INCLUDE       0   0   HR fields of an employee  
111 MANAGER_ID COMT_BSP_BP_MANAGER_ID BU_PARTNER CHAR 10   0   Manager ID *
112 MANAGER_NAME_FIRST BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
113 MANAGER_NAME_LAST BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
114 .INCLUDE       0   0   Employee Relationship Data  
115 .INCLUDE       0   0   Data of Organization x  
116 RELNR BU_RELNR BU_RELNR CHAR 12   0   BP Relationship Number *
117 ORG_PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
118 ORG_NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
119 ORG_NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
120 REL_ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
121 REL_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
122 REL_POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
123 REL_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
124 REL_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
125 REL_STREET AD_STREET TEXT60 CHAR 60   0   Street  
126 REL_HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
127 REL_COUNTRY_TEXT COMT_BU_COUNTRY_DESCRIPTION TEXT50 CHAR 50   0   Country Description  
128 REL_REGION_TEXT COMT_BU_REGION_DESCRIPTION TEXT20 CHAR 20   0   Region (State, Province, County)  
129 .INCLUDE       0   0   Person Data of Relation  
130 REL_BUILDING_P AD_BLDNG_P TEXT10 CHAR 10   0   Building (number or code)  
131 REL_FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
132 REL_ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
133 REL_INITS_SIG AD_ID_CODE TEXT10 CHAR 10   0   Short name for correspondence  
134 REL_INHOUSE_ML AD_IH_MAIL TEXT10 CHAR 10   0   Int. mail postal code  
135 REL_COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
136 REL_DEPARTMENT AD_DPRTMNT TEXT40 CHAR 40   0   Department  
137 REL_FUNCTION AD_FNCTN TEXT40 CHAR 40   0   Function  
138 REL_PAFKT BU_PAFKT BU_PAFKT CHAR 4   0   Function of partner *
139 REL_ABTNR BU_ABTNR BU_ABTNR CHAR 4   0   Department *
140 REL_CALLER_NO AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
141 REL_PHONE_CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
142 REL_COUNTRY_FOR_TEL AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
143 REL_TELEPHONE AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
144 REL_PHONE_EXTENSION AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
145 REL_MOBIL_PHONE AD_MBNMBR1 CHAR30 CHAR 30   0   First Mobile Telephone No.: Dialing Code + Number  
146 REL_MOBIL_CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
147 REL_MOBIL_COUNTRY AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
148 REL_MOBILE_TELEPHONE AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
149 REL_EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
150 REL_EMAIL_CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
151 REL_FAXNUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
152 REL_FAX_CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
153 REL_FAX_COUNTRY AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
154 REL_FAX AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
155 REL_FAX_EXTENSION AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
156 .INCLUDE       0   0   Fiekds for Navigation  
157 BP_DESCRIPTION CHAR100 CHAR100 CHAR 100   0   Character 100  
158 CRM_OBJECT_TYPE CRMT_FIELDFOROTYPE OBJECTNAME CHAR 30   0   Contains Field Name for Field that Contains Object Type  
159 CRM_NAVI_METHOD CRMT_PRT_MTD CRMT_PRT_MTD CHAR 20   0   Method for Navigation *
160 NAVI_OBJECT_KEY CRMT_BSP_OBJECTKEY   CHAR 100   0   Object Key  
161 .INCLUDE       0   0   Employee BSP: Search criteria for account  
162 ACCOUNT_ID CRMT_BSP_ACCOUNT BU_PARTNER CHAR 10   0   Account ID *
163 ACCOUNT_NAME1 COMT_BSP_BP_NAME1 BU_NAME CHAR 40   0   Name 1 / Last Name (Search Help Field 1)  
164 ACCOUNT_NAME2 COMT_BSP_BP_NAME2 BU_NAME CHAR 40   0   Name 2 / First Name (Search Help Field 2)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BSP_SEARES_ACC_EMPLOYEE ADDRORIGIN TSAD6 ORIGIN REF C CN
2 CRMT_BSP_SEARES_ACC_EMPLOYEE CITYH_CODE ADRCITY CITY_CODE REF C CN
3 CRMT_BSP_SEARES_ACC_EMPLOYEE CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
4 CRMT_BSP_SEARES_ACC_EMPLOYEE CITY_CODE ADRCITY CITY_CODE REF C CN
5 CRMT_BSP_SEARES_ACC_EMPLOYEE CITY_CODE2 ADRCITY CITY_CODE REF C CN
6 CRMT_BSP_SEARES_ACC_EMPLOYEE COUNTRY T005 LAND1 REF 1 C
7 CRMT_BSP_SEARES_ACC_EMPLOYEE COUNTY_CODE ADRCOUNTY COUNTY_CODE REF C CN
8 CRMT_BSP_SEARES_ACC_EMPLOYEE DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE 1 CN
9 CRMT_BSP_SEARES_ACC_EMPLOYEE DONT_USE_P TSAD12 UNDELIVER KEY C CN
10 CRMT_BSP_SEARES_ACC_EMPLOYEE DONT_USE_S TSAD12 UNDELIVER KEY C CN
11 CRMT_BSP_SEARES_ACC_EMPLOYEE LANGU T002 SPRAS REF 1 CN
12 CRMT_BSP_SEARES_ACC_EMPLOYEE LANGU_CREA T002 SPRAS REF C CN
13 CRMT_BSP_SEARES_ACC_EMPLOYEE PO_BOX_CTY T005 LAND1 REF C CN
14 CRMT_BSP_SEARES_ACC_EMPLOYEE PO_BOX_REG T005S BLAND REF C CN
15 CRMT_BSP_SEARES_ACC_EMPLOYEE REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
16 CRMT_BSP_SEARES_ACC_EMPLOYEE REGION T005S BLAND REF 1 C
17 CRMT_BSP_SEARES_ACC_EMPLOYEE REL_COUNTRY T005 LAND1 REF C CN
18 CRMT_BSP_SEARES_ACC_EMPLOYEE REL_REGION T005S BLAND REF C CN
19 CRMT_BSP_SEARES_ACC_EMPLOYEE STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
20 CRMT_BSP_SEARES_ACC_EMPLOYEE STREETCODE ADRSTREET STRT_CODE REF C CN
21 CRMT_BSP_SEARES_ACC_EMPLOYEE TIME_ZONE TTZZ TZONE REF C CN
22 CRMT_BSP_SEARES_ACC_EMPLOYEE TOWNSHIP_CODE ADRTOWNSHIP TOWNSHIP_CODE REF C CN
23 CRMT_BSP_SEARES_ACC_EMPLOYEE TRANSPZONE TZONE ZONE1 REF C CN
History
Last changed by/on SAP  20141013 
SAP Release Created in 100