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