SAP ABAP Table CCMSEARCH_STRUCT (Search and Display Component - All Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CRM_CIC_COMPONENTS (Package) Interaction Center components

Basic Data

Table Category	INTTAB	Structure
Structure	CCMSEARCH_STRUCT	Table Relationship Diagram
Short Description	Search and Display Component - All Fields

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	BP1 structure
2	BP1_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	BP1_MCNAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
4	BP1_MCNAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
5	BP1_SRCHTREM1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
6	BP1_SRCHTERM2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
7	BP1_ORIGIN	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types	*
8	BP1_TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
9	BP1_ARCHMARKR	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
10	BP1_CENTRALBLOCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
11	BP1_AUTHGROUP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	*
12	BP1_TITLELETTER	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
13	BP1_PARTNLANGUAGE	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	*
14	BP1_LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
15	BP1_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
16	BP1_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
17	BP1_NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
18	BP1_NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
19	BP1_LEGALFORM	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
20	BP1_INDUSTRYSECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
21	BP1_FOUNDDAT	☐	BU_FOUND_DAT_DI	CHAR8	CHAR	8	0	Date organization founded (direct input)
22	BP1_LIQUIDDAT	☐	BU_LIQUID_DAT_DI	CHAR8	CHAR	8	0	Date of liquidation of organization (direct input)
23	BP1_LEGALORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
24	BP1_LOCATION1	☐	BU_BBBNR_DI	CHAR7	CHAR	7	0	International location number (part 1, direct input)
25	BP1_LOCATION2	☐	BU_BBSNR_DI	CHAR5	CHAR	5	0	International location number (part 2, direct input)
26	BP1_LOCATION3	☐	BU_BUBKZ_DI	CHAR1	CHAR	1	0	Check digit for international location number (direct input)
27	BP1_NAMELAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
28	BP1_NAMEFIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
29	BP1_NAMELST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
30	BP1_NAMELAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
31	BP1_NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
32	BP1_TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
33	BP1_TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
34	BP1_TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
35	BP1_PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	*
36	BP1_PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
37	BP1_NAME1TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
38	BP1_NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
39	BP1_INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
40	BP1_NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	*
41	BP1_NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	*
42	BP1_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
43	BP1_MALE	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
44	BP1_FEMALE	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
45	BP1_BIRTHPLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
46	BP1_PERSNO	☐	BU_PERNO_DI	CHAR8	CHAR	8	0	Personnel number of business partner (direct input)
47	BP1_MARITSTAT	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	*
48	BP1_EMPLOYER	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
49	BP1_JOBGR	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	*
50	BP1_NATIONALITY	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
51	BP1_NATION_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
52	BP1_TAX_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
53	BP1_CTRYORIG	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	*
54	BP1_CTRYORIGISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
55	BP1_PERS_NO	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
56	BP1_XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
57	BP1_BIRTHDATE	☐	BU_BIRTHDT_DI	CHAR8	CHAR	8	0	Date of birth of business partner (direct input)
58	BP1_DEATHDT	☐	BU_DEATHDT_DI	CHAR8	CHAR	8	0	Date of death of business partner (direct input)
59	BP1_CHILDREN	☐	BU_CHILDREN_DI	CHAR2	CHAR	2	0	Number of children
60	BP1_MEMHOUSE	☐	BU_MEM_HOUSE_DI	CHAR2	CHAR	2	0	Number of People Living in the Household
61	BP1_PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	*
62	BP1_NAMEGRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
63	BP1_NAMEGRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
64	BP1_LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
65	BP1_FUNCT	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
66	.INCLUDE	☐				0	0	BP2 structure
67	BP2_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
68	BP2_MCNAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
69	BP2_MCNAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
70	BP2_SRCHTREM1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
71	BP2_SRCHTERM2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
72	BP2_ORIGIN	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types	*
73	BP2_TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
74	BP2_ARCHMARKR	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
75	BP2_CENTRALBLOCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
76	BP2_AUTHGROUP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	*
77	BP2_TITLELETTER	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
78	BP2_PARTNLANGUAGE	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	*
79	BP2_LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
80	BP2_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
81	BP2_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
82	BP2_NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
83	BP2_NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
84	BP2_LEGALFORM	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
85	BP2_INDUSTRYSECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
86	BP2_FOUNDDAT	☐	BU_FOUND_DAT_DI	CHAR8	CHAR	8	0	Date organization founded (direct input)
87	BP2_LIQUIDDAT	☐	BU_LIQUID_DAT_DI	CHAR8	CHAR	8	0	Date of liquidation of organization (direct input)
88	BP2_LEGALORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
89	BP2_LOCATION1	☐	BU_BBBNR_DI	CHAR7	CHAR	7	0	International location number (part 1, direct input)
90	BP2_LOCATION2	☐	BU_BBSNR_DI	CHAR5	CHAR	5	0	International location number (part 2, direct input)
91	BP2_LOCATION3	☐	BU_BUBKZ_DI	CHAR1	CHAR	1	0	Check digit for international location number (direct input)
92	BP2_NAMELAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
93	BP2_NAMEFIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
94	BP2_NAMELST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
95	BP2_NAMELAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
96	BP2_NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
97	BP2_TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
98	BP2_TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
99	BP2_TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
100	BP2_PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	*
101	BP2_PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
102	BP2_NAME1TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
103	BP2_NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
104	BP2_INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
105	BP2_NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	*
106	BP2_NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	*
107	BP2_COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
108	BP2_MALE	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
109	BP2_FEMALE	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
110	BP2_BIRTHPLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
111	BP2_PERSNO	☐	BU_PERNO_DI	CHAR8	CHAR	8	0	Personnel number of business partner (direct input)
112	BP2_MARITSTAT	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	*
113	BP2_EMPLOYER	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
114	BP2_JOBGR	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	*
115	BP2_NATIONALITY	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
116	BP2_NATION_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
117	BP2_TAX_COUNTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
118	BP2_CTRYORIG	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	*
119	BP2_CTRYORIGISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
120	BP2_PERS_NO	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
121	BP2_XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
122	BP2_BIRTHDATE	☐	BU_BIRTHDT_DI	CHAR8	CHAR	8	0	Date of birth of business partner (direct input)
123	BP2_DEATHDT	☐	BU_DEATHDT_DI	CHAR8	CHAR	8	0	Date of death of business partner (direct input)
124	BP2_CHILDREN	☐	BU_CHILDREN_DI	CHAR2	CHAR	2	0	Number of children
125	BP2_MEMHOUSE	☐	BU_MEM_HOUSE_DI	CHAR2	CHAR	2	0	Number of People Living in the Household
126	BP2_PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	*
127	BP2_NAMEGRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
128	BP2_NAMEGRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
129	BP2_LOG_SYSTEM	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
130	BP2_FUNCT	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
131	.INCLUDE	☐				0	0	Structure for Address Data
132	ADRTYP	☐	CCMADRTYP	CCMADRTYP	CHAR	4	0	Address Type (BP1/BP2/BLDG/....)
133	.INCLUDE	☐				0	0	Address return structure
134	.INCLUDE	☐				0	0	Address selection parameter
135	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
136	ADDRHANDLE	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
137	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
138	DATE	☐	AD_DATE	DATUM	DATS	8	0	Date referred to
139	.INCLUDE	☐				0	0	Address transfer structure
140	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
141	DATE_TO	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
142	.INCLUDE	☐				0	0	Include structure with name attributes of the ADRC address
143	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
144	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
145	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
146	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
147	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
148	NAME_TXT	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
149	.INCLUDE	☐				0	0	Include structure with ADRC attributes without name fields
150	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
151	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
152	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
153	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
154	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
155	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
156	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	ADRCITY
157	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
158	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
159	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
160	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
161	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
162	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
163	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
164	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
165	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
166	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	TSAD12
167	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
168	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
169	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	ADRCITY
170	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
171	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
172	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
173	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
174	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
175	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	TSAD12
176	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
177	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
178	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
179	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
180	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
181	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
182	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
183	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
184	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
185	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
186	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
187	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
188	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
189	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
190	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
191	SORT1	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
192	SORT2	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
193	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
194	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)	TSAD6
195	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
196	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
197	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	*
198	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
199	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
200	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
201	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
202	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
203	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	ADDRC_DELI_SERV
204	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
205	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	ADRCOUNTY
206	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
207	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	ADRTOWNSHIP
208	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
209	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
210	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
211	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
212	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
213	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
214	ADDR_GROUP	☐	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)	*
215	.INCLUDE	☐				0	0	Fields with Communication info
216	TEL_STD	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
217	TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
218	TEL_EXT	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
219	TEL_CALLER	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
220	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
221	FAX_NO	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
222	FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
223	FAX_EXT	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
224	PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
225	TEL_HOME	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
226	.INCLUDE	☐				0	0	Structure for IBase Component Data
227	DEVICEID	☐	IB_DEVICEID	IB_DEVICEID	CHAR	40	0	IB: Identification
228	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
229	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
230	DESCR	☐	IB_INST_DESCR	TEXT40	CHAR	40	0	IB: Component Description
231	IBASE	☐	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
232	GUID_COMP	☐	IB_RECNO_16	SYSUUID	RAW	16	0	IBase: Record Number 16 Characters
233	GUID_COMPC	☐	IB_RECNO_16	SYSUUID	RAW	16	0	IBase: Record Number 16 Characters
234	INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
235	OBJECT_ID	☐	COMT_PRODUCT_OBJECT_ID	COM_PRODUCT_ID	CHAR	40	0	Object ID
236	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
237	.INCLUDE	☐				0	0	Search Parameter for IS-U Data Finder in R/3
238	C_BUPART	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
239	C_MC_NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
240	C_MC_NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
241	C_CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
242	C_CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
243	C_POST_CO1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
244	C_POST_CO2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
245	C_POST_CO3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
246	C_PO_BOX_L	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
247	C_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
248	C_HOUSE_N1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
249	C_HOUSE_N2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
250	C_HOUSE_N3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
251	C_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
252	C_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
253	C_SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
254	C_SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
255	C_SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
256	C_ADDRNUM	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
257	C_TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
258	C_SOC_SECURE	☐	ECRM_ISU_SOC_SECU	ECRM_ISU_SOC_SECU	CHAR	12	0	Social Insurance Number
259	C_DR_LICENSE	☐	ECRM_ISU_DR_LICENSE	ECRM_ISU_DR_LICENSE	CHAR	20	0	Driver's License Number
260	C_WELFARE	☐	ECRM_ISU_WELFARE	ECRM_ISU_WELFARE	CHAR	9	0	Welfare Office
261	C_BANK_ACCOUNT	☐	BANKN	BANKN	CHAR	18	0	Bank account number
262	C_BANK_NUMBER	☐	BANKL	BANKL	CHAR	15	0	Bank number
263	C_BANK_COUNTRY	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
264	C_TAXTYPE	☐	BPTAXTYPE	BPTAXTYPE	CHAR	4	0	Tax Number Category
265	C_TAXNUM	☐	BPTAXNUM	BPTAXNUM	CHAR	20	0	Business Partner Tax Number
266	A_VKONT	☐	ECRM_ISU_VKONT_KK	ECRM_ISU_VKONT_KK	CHAR	12	0	Contract Account Number
267	A_ABWRE	☐	ECRM_ISU_ABWRE_KK	BU_PARTNER	CHAR	10	0	Alternative Payer	*
268	A_ABWRA	☐	ECRM_ISU_ABWRA_KK	BU_PARTNER	CHAR	10	0	Different Payment Recipient	*
269	A_ABWRH	☐	ECRM_ISU_ABWRH_KK	BU_PARTNER	CHAR	10	0	Alternative Bill Recipient	*
270	A_ABWMA	☐	ECRM_ISU_ABWMA_KK	BU_PARTNER	CHAR	10	0	Alternative Dunning Recipient	*
271	A_ABWVK	☐	ECRM_ISU_ABWVK_KK	ECRM_ISU_VKONT_KK	CHAR	12	0	Alternative Contract Account for Collective Bills
272	A_VKONV	☐	ECRM_ISU_VKONV_KK	ECRM_ISU_VKONT_KK	CHAR	12	0	Contract Account Used for Payment Transactions
273	V_VERTRAG	☐	ECRM_ISU_VERTRAG	ECRM_ISU_VERTRAG	CHAR	10	0	Contract
274	V_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
275	V_SPARTE	☐	CRM_ISU_SPARTE	CRM_ISU_SPART	CHAR	2	0	Division
276	V_DATE	☐	ECRM_ISU_ECF_DATE	DATUM	DATS	8	0	Date Used in Finding Object
277	C_OPBEL	☐	ECRM_ISU_ABPLANNR	ECRM_ISU_ABPLANNR	CHAR	12	0	Budget Billing Plan
278	U_DATE	☐	ECRM_ISU_ECF_DATE	DATUM	DATS	8	0	Date Used in Finding Object
279	O_HAUS	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
280	O_CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
281	O_CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
282	O_POST_CO1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
283	O_POST_CO2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
284	O_POST_CO3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
285	O_PO_BOX_L	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
286	O_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
287	O_HOUSE_N1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
288	O_HOUSE_N2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
289	O_HOUSE_N3	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
290	O_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
291	O_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
292	O_SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
293	O_SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
294	O_SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
295	O_ADDRNUM	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
296	P_VSTELLE	☐	ECRM_ISU_VSTELLE	ECRM_ISU_VSTELLE	CHAR	10	0	Premise
297	P_HAUS_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
298	P_STR_ERG2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
299	P_STR_ERG4	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
300	P_FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
301	P_ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
302	P_EIGENT	☐	ECRM_ISU_GPARTNER	BU_PARTNER	CHAR	10	0	Owner	*
303	I_ANLAGE	☐	ECRM_ISU_ANLAGE	ECRM_ISU_ANLAGE	CHAR	10	0	Installation
304	I_SPARTE	☐	CRM_ISU_SPARTE	CRM_ISU_SPART	CHAR	2	0	Division
305	I_AKLASSE	☐	ECRM_ISU_AKLASSE	ECRM_ISU_AKLASSE	CHAR	4	0	Billing Class
306	I_DATE	☐	ECRM_ISU_ECF_DATE	DATUM	DATS	8	0	Date Used in Finding Object
307	I_POD	☐	ECRM_ISU_EXT_UI	ECRM_ISU_EXT_UI	CHAR	50	0	Point of Delivery ID
308	I_POD_DATE	☐	ECRM_ISU_ECF_DATE	DATUM	DATS	8	0	Date Used in Finding Object
309	L_DEVLOC	☐	ECRM_ISU_DEVLOC	TPLNR	CHAR	30	0	Device Location	*
310	L_STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	*
311	D_EQUNR	☐	CRM_ISU_EQUNR	CRM_ISU_EQUNR	CHAR	18	0	Equipment Number
312	D_GERAET	☐	CRM_ISU_GERNR	CRM_ISU_GERNR	CHAR	18	0	Serial Number
313	D_SPARTE	☐	CRM_ISU_SPARTE	CRM_ISU_SPART	CHAR	2	0	Division
314	D_DATE	☐	ECRM_ISU_ECF_DATE	DATUM	DATS	8	0	Date Used in Finding Object
315	R_OPBEL	☐	ECRM_ISU_OPBEL_KK	ECRM_ISU_OPBEL_KK	CHAR	12	0	Contract Accounts Receivable and Payable Document Number
316	R_DATE	☐	ECRM_ISU_BUDAT_KK	DATUM	DATS	8	0	Posting Date in the Document
317	S_AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
318	S_ASTNR	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	*
319	S_AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
320	S_AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
321	S_QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
322	M_AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
323	M_ASTNR	☐	AUFASTNR	AUFSTNR	NUMC	2	0	Order status	*
324	M_QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
325	M_AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
326	X_DATE	☐	ECRM_ISU_ECF_DATE	DATUM	DATS	8	0	Date Used in Finding Object
327	X_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
328	X_SPARTE	☐	CRM_ISU_SPARTE	CRM_ISU_SPART	CHAR	2	0	Division
329	L_BY_DEVIC	☐	ECRM_ISU_ECF_BY_DEV	CHAR1	CHAR	1	0	Search for Device Location via Device
330	KEEPSEL	☐	ECRM_ISU_ECF_KEEP	CHAR1	CHAR	1	0	Data Finder: Keep Selection
331	SEARCHSTRING	☐	ECRM_ISU_SEARCHSTRING	TEXT132	CHAR	132	0	Generic Search String in From of a User-Defined Field
332	C_BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
333	C_BIRTHPL	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
334	C_EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
335	V_DATE_TO	☐			DATS	8	0
336	SD_PONUMBER	☐	BSTKD_M	CHAR35	CHAR	35	0	Customer PO number as matchcode field
337	SD_VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
338	SD_VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
339	SD_AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
340	X_ALL_NATIONS	☐			CHAR	1	0
341	X_NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
342	J_DISCPROCV	☐			CHAR	4	0
343	J_DISCREASON	☐	CRM_ISU_DISCREASON	CRM_ISU_DISCREASON	CHAR	2	0	Disconnection Reason
344	J_STATUS	☐	CRM_ISU_EDCDOCSTAT	CRM_ISU_EDCDOCSTAT	NUMC	2	0	Status of Disconnection Document
345	J_ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
346	J_DISCNO	☐	CRM_ISU_DISCNO	CRM_ISU_DISCNO	CHAR	12	0	Disconnection Document Number
347	C_BANK_IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
348	C_ID_TYPE	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
349	C_ID_NUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
350	R_TOBRELEASD	☐			CHAR	1	0
351	.INCLUDE	☐				0	0	Vehicle Parameters for Business Partner Search
352	VIN	☐	ISAM_VIN	ISAM_VIN	CHAR	35	0	Vehicle Identification Number
353	LPNO	☐	ISAM_LICENSEPLATE_NO	ISAM_LICENSEPLATE_NO	CHAR	15	0	Vehicle Licence Plate Number
354	LP_COUNTRY	☐	ISAM_LIPLATE_COUNTRY	LAND1	CHAR	3	0	Vehicle Licence Plate Country	*
355	LP_REGION	☐	ISAM_LIPLATE_REGION	REGIO	CHAR	3	0	Vehicle Licence Plate Region/State	*
356	EXT_VEH_NO	☐	ISAM_EXTERNAL_VEH_NO	ISAM_EXTERNAL_VEH_NO	CHAR	35	0	External Vehicle Number
357	INT_VEH_NO	☐	ISAM_INTERNAL_VEH_NO	ISAM_INTERNAL_VEH_NO	CHAR	10	0	Internal Vehicle Number
358	ALT_VEH_NO	☐	ISAM_ALTERNATIVE_NO	ISAM_ALTERNATIVE_NO	CHAR	35	0	Alternative Identifier for Vehicle
359	.INCLUDE	☐				0	0	IS-M: Business Partner - Search Criteria
360	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
361	ORDER_NO_MAM	☐			CHAR	10	0
362	ORDER_NO_MSD	☐			CHAR	10	0
363	INVOICE_NO_MAM	☐			CHAR	10	0
364	INVOICE_NO_MSD	☐			CHAR	10	0
365	BOX_NO_MAM	☐			CHAR	10	0
366	REF_DOC_NO_MSD	☐			CHAR	20	0
367	PUBLICATION	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
368	.INCLUDE	☐				0	0	ISHT: Entitlement parameters for BuPa search
369	LID	☐	ISHT_SERIAL_NUMBER	ISHT_SERIAL_NUMBER	CHAR	18	0	License ID Number
370	.INCLUDE	☐				0	0	Employee Search Components - Employee-specific fields
371	IDENTIFICATION	☐	CCM_IC_IDENT_EMP	CHAR120	CHAR	120	0	IC Employee Search Identificator
372	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
373	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
374	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
375	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
376	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
377	VDSK1	☐	VDSK1	VDSK1	CHAR	14	0	Organizational Key	*
378	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
379	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
380	JUPER	☐	JUPER	JUPER	CHAR	4	0	Legal Person
381	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	*
382	ANSVH	☐	ANSVH	ANSVH	CHAR	2	0	Work Contract	*
383	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
384	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	*
385	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	*
386	STELL	☐	STELL	STELL	NUMC	8	0	Job	*
387	MSTBR	☐	MSTBR	MSTBR	CHAR	8	0	Supervisor Area
388	SACHA	☐	SACHA	SACHA	CHAR	3	0	Payroll Administrator
389	SACHP	☐	SACHP	SACHA	CHAR	3	0	Administrator for HR Master Data
390	SACHZ	☐	SACHZ	SACHA	CHAR	3	0	Administrator for Time Recording
391	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
392	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
393	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
394	SBMOD	☐	SBMOD	CHAR4	CHAR	4	0	Administrator Group
395	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
396	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
397	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
398	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
399	GRANT_NBR	☐	BBP_GRANT_NBR	CHAR020	CHAR	20	0	EBP: Grant
400	GRPVL	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
401	INITS	☐	INITS	TEXT10	CHAR	10	0	Initials
402	NACHN	☐	NACHN	NACHN	CHAR	25	0	Last Name
403	NAME2_P0002	☐	NACH2	NACHN	CHAR	25	0	Second Name / Name at Birth
404	VORNA	☐	VORNA	VORNM	CHAR	25	0	First Name
405	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	*
406	TITL2	☐	TITL2	TITEL	CHAR	15	0	Second Title	*
407	NAMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	*
408	VORSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	*
409	VORS2	☐	VORS2	TITEL	CHAR	15	0	Second Name Prefix	*
410	RUFNM	☐	RUFNM	VORNM	CHAR	25	0	Nickname
411	KNZNM	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
412	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	*
413	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
414	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
415	GBLND	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
416	GBDEP	☐	GBDEP	REGIO	CHAR	3	0	State	*
417	GBORT	☐	GBORT	TEXT25	CHAR	25	0	Birthplace
418	NATIO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
419	NATI2	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
420	NATI3	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
421	SPRSL	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
422	KONFE	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	*
423	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
424	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
425	ANZKD	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
426	NACON	☐	NACON	CHAR1	CHAR	1	0	Name Connection
427	PERMO	☐	PIDMO	CHAR2	CHAR	2	0	Modifier for Personnel Identifier
428	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
429	GBPAS	☐	GBPAS	DATUM	DATS	8	0	Date of Birth According to Passport
430	FNAMK	☐	P22J_FNAMK	P22J_NAME	CHAR	24	0	First name (Katakana)
431	LNAMK	☐	P22J_LNAMK	P22J_NAME	CHAR	24	0	Last Name (Katakana)
432	FNAMR	☐	P22J_FNAMR	P22J_NAME	CHAR	24	0	First name (Romaji)
433	LNAMR	☐	P22J_LNAMR	P22J_NAME	CHAR	24	0	Last name (Romaji)
434	NABIK	☐	P22J_NABIK	P22J_NAME	CHAR	24	0	Name of Birth (Katakana)
435	NABIR	☐	P22J_NABIR	P22J_NAME	CHAR	24	0	Name of Birth (Romaji)
436	NICKK	☐	P22J_NICKK	P22J_NAME	CHAR	24	0	Nickname (Katakana)
437	NICKR	☐	P22J_NICKR	P22J_NAME	CHAR	24	0	Nickname (Romaji)
438	GBJHR	☐	GBJHR	GJAHR	NUMC	4	0	Year of Birth
439	GBMON	☐	GBMON	NUM2	NUMC	2	0	Month of Birth
440	GBTAG	☐	GBTAG	NUM2	NUMC	2	0	Birth Date (to Month/Year)
441	NCHMC	☐	NACHNMC	CHAR25	CHAR	25	0	Last Name (Field for Search Help)
442	VNAMC	☐	VORNAMC	CHAR25	CHAR	25	0	First Name (Field for Search Help)
443	SPRSL_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
444	NACHN_40	☐	NAME_LAST	TEXT40	CHAR	40	0	Last name
445	NAME2_40	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
446	NACH2	☐	NAME_LAST2	TEXT40	CHAR	40	0	Second family name
447	VORNA_40	☐	NAME_FIRST	TEXT40	CHAR	40	0	First name
448	CNAME_40	☐	CC_NAME	CC_NAME	CHAR	40	0	Control Composite: Name
449	RUFNM_40	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
450	MIDNM	☐	NAMEMIDDLE	TEXT40	CHAR	40	0	Middle name or second forename
451	GBORT_40	☐	GBORT	TEXT25	CHAR	25	0	Birthplace
452	ANSSA	☐	ANSSA	SUBTY_591A	CHAR	4	0	Address Record Type	*
453	NAME2_P0006	☐	CONAM	NACHN	CHAR	25	0	C/O Name
454	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
455	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
456	ORT02	☐	ORT02	TEXT25	CHAR	25	0	District
457	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
458	LAND1	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
459	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
460	ENTKM	☐	ENTKM5	CHAR5	CHAR	5	0	Distance in Kilometers (5 Characters for IDoc)
461	WKWNG	☐	WKWNG	CHAR1	CHAR	1	0	Company Housing
462	BUSRT	☐	BUSRT	CHAR3	CHAR	3	0	Bus Route
463	LOCAT	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
464	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
465	HSNMR	☐	HSNMR	NUMC6	NUMC	6	0	House Number
466	POSTA	☐	POSTA	TEXT6	CHAR	6	0	Identification of an Apartment in a Building
467	STRDS	☐	STRDS	STRDS	CHAR	2	0	Street Abbreviation	*
468	ENTK2	☐	CHAR5	CHAR5	CHAR	5	0	R/2 table
469	COM01	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
470	NUM01	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
471	COM02	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
472	NUM02	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
473	COM03	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
474	NUM03	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
475	COM04	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
476	NUM04	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
477	COM05	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
478	NUM05	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
479	COM06	☐	COMKY	COMKY	CHAR	4	0	Communication Type	*
480	NUM06	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
481	INDRL	☐	P22J_INDRL	AUSPR	CHAR	2	0	Indicator for relationship (specification code)	*
482	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
483	RCTVC	☐	P22J_RCTVC	P22J_RCTVC	CHAR	6	0	Municipal city code	*
484	OR2KK	☐	P22J_OR2KK	CHAR30	CHAR	30	0	City/District (Katakana)
485	CONKK	☐	P22J_CONKK	P22J_NAME	CHAR	24	0	Contact Person (Katakana) (Japan)
486	OR1KK	☐	P22J_OR1KK	CHAR30	CHAR	30	0	City Katakana (Japan)
487	RAILW	☐	RAILW	RAILW	NUMC	1	0	Social Subscription Railway
488	NAME2_40_P0006	☐	NAME2_PERS	CHAR40	CHAR	40	0	Name at Birth
489	STRAS_40	☐	STRAS	TEXT30	CHAR	30	0	House number and street
490	ORT01_40	☐	PAD_ORT01	PAD_ORT01	CHAR	40	0	City
491	ORT02_40	☐	PAD_ORT02	PAD_ORT01	CHAR	40	0	District
492	LOCAT_40	☐	PAD_LOCAT	PAD_LOCAT	CHAR	40	0	2nd address line
493	ADR03	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
494	ADR04	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
495	HSNMR_40	☐	PAD_HSNMR	PAD_HSNMR	CHAR	10	0	House Number
496	POSTA_40	☐	PAD_POSTA	PAD_HSNMR	CHAR	10	0	Identification of an apartment in a building
497	BLDNG	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
498	FLOOR_P0006	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
499	OR2KK_45	☐	P22J_OR2KK	CHAR30	CHAR	30	0	City/District (Katakana)
500	CONKK_45	☐	P22J_CONKK	P22J_NAME	CHAR	24	0	Contact Person (Katakana) (Japan)
501	OR1KK_45	☐	P22J_OR1KK	CHAR30	CHAR	30	0	City Katakana (Japan)
502	GRPVL_P0006	☐	CHAR04	CHAR4	CHAR	4	0	Data Type 4 Characters
503	PERSGT	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
504	PERSKT	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
505	WERKST	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
506	KOSTLT	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
507	PLANST	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
508	ORGEHT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
509	BTRTLT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCMSEARCH_STRUCT	ADDRORIGIN	TSAD6	ORIGIN	REF	C	CN
2	CCMSEARCH_STRUCT	CITYH_CODE	ADRCITY	CITY_CODE	REF	C	CN
3	CCMSEARCH_STRUCT	CITYP_CODE	ADRCITYPRT	CITYP_CODE	REF	C	CN
4	CCMSEARCH_STRUCT	CITY_CODE	ADRCITY	CITY_CODE	REF	C	CN
5	CCMSEARCH_STRUCT	CITY_CODE2	ADRCITY	CITY_CODE	REF	C	CN
6	CCMSEARCH_STRUCT	COUNTY_CODE	ADRCOUNTY	COUNTY_CODE	REF	C	CN
7	CCMSEARCH_STRUCT	DEFLT_COMM	TSAC	COMM_TYPE	REF	C	CN
8	CCMSEARCH_STRUCT	DELI_SERV_TYPE	ADDRC_DELI_SERV	DELI_SERV_TYPE		1	CN
9	CCMSEARCH_STRUCT	DONT_USE_P	TSAD12	UNDELIVER	KEY	C	CN
10	CCMSEARCH_STRUCT	DONT_USE_S	TSAD12	UNDELIVER	REF	C	CN
11	CCMSEARCH_STRUCT	LANGU	T002	SPRAS	REF	C	CN
12	CCMSEARCH_STRUCT	LANGU_CREA	T002	SPRAS	REF	C	CN
13	CCMSEARCH_STRUCT	PO_BOX_CTY	T005	LAND1	REF	C	CN
14	CCMSEARCH_STRUCT	STREETABBR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
15	CCMSEARCH_STRUCT	STREETCODE	ADRSTREET	STRT_CODE	REF	C	CN
16	CCMSEARCH_STRUCT	TITLE	TSAD3	TITLE	REF	C	CN
17	CCMSEARCH_STRUCT	TOWNSHIP_CODE	ADRTOWNSHIP	TOWNSHIP_CODE	REF	C	CN
18	CCMSEARCH_STRUCT	TRANSPZONE	TZONE	ZONE1	REF	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in	30A