1
CLIENT
ADRP
CLIENT
MANDT
Client
2
BNAME
USR21
BNAME
XUBNAME
User Name in User Master Record
3
PERSNUMBER
ADRP
PERSNUMBER
AD_PERSNUM
Person number
4
ADDRNUMBER
ADRC
ADDRNUMBER
AD_ADDRNUM
Address number
5
NATION
ADRP
NATION
AD_NATION
Version ID for International Addresses
6
DATE_FROM
ADRP
DATE_FROM
AD_DATE_FR
Valid-from date - in current Release only 00010101 possible
7
IDADTYPE
USR21
IDADTYPE
SUIDADTYPE
Address Type of the Identity
8
DATE_TO
ADCP
DATE_TO
AD_DATE_TO
Valid-to date in current Release only 99991231 possible
9
SO_KEY
ADCP
SO_KEY
AD_SO_KEY
SAP-Office key
10
DEPARTMENT
ADCP
DEPARTMENT
AD_DPRTMNT
Department
11
FUNCTION
ADCP
FUNCTION
AD_FNCTN
Function
12
BUILDING_C
ADCP
BUILDING
AD_BLDNG_P
Building (number or code)
13
FLOOR_C
ADCP
FLOOR
AD_FLOOR
Floor in building
14
ROOMNUM_C
ADCP
ROOMNUMBER
AD_ROOMNUM
Room or Appartment Number
15
ID_CODE
ADCP
ID_CODE
AD_ID_CODE
Short name for correspondence
16
IH_MAIL
ADCP
IH_MAIL
AD_IH_MAIL
Int. mail postal code
17
SORT1_C
ADCP
SORT1
AD_SORTOLD
(Not Supported) Search Term
18
SORT2_C
ADCP
SORT2
AD_SORTOLD
(Not Supported) Search Term
19
SORT_PHN_C
ADCP
SORT_PHN
AD_SRTPHN
(Not Supported) Phonetic Search Sort Field
20
TITLE_P
ADRP
TITLE
AD_TITLE
Form-of-Address Key
21
NAME_FIRST
ADRP
NAME_FIRST
AD_NAMEFIR
First name
22
NAME_LAST
ADRP
NAME_LAST
AD_NAMELAS
Last name
23
NAME2_P
ADRP
NAME2
AD_NAME2_P
Name of person at birth
24
NAMEMIDDLE
ADRP
NAMEMIDDLE
AD_NAMEMID
Middle name or second forename of a person
25
NAME_LAST2
ADRP
NAME_LAST2
AD_NAMLAS2
Second surname of a person
26
NAME_TEXT
ADRP
NAME_TEXT
AD_NAMTEXT
Full Name of Person
27
CONVERTED
ADRP
CONVERTED
AD_NAMCONV
Status of Field 'Full Name' NAME_TEXT
28
TITLE_ACA1
ADRP
TITLE_ACA1
AD_TITLE1
Academic Title: Key
29
TITLE_ACA2
ADRP
TITLE_ACA2
AD_TITLE2
Second academic title (key)
30
PREFIX1
ADRP
PREFIX1
AD_PREFIX
Name Prefix (Key)
31
PREFIX2
ADRP
PREFIX2
AD_PREFIX2
2nd name prefix (key)
32
TITLE_SPPL
ADRP
TITLE_SPPL
AD_TITLES
Name supplement, e.g. noble title (key)
33
NICKNAME
ADRP
NICKNAME
AD_NICKNAM
Nickname or name used
34
INITIALS
ADRP
INITIALS
AD_INITS
"Middle Initial" or personal initials
35
NAMEFORMAT
ADRP
NAMEFORMAT
AD_FORMAT
Name format
36
NAMCOUNTRY
ADRP
NAMCOUNTRY
AD_NAMCTRY
Country for name format rule
37
PROFESSION
ADRP
PROFESSION
AD_PROFESS
Profession
38
SEX
ADRP
SEX
AD_SEX
Gender key
39
LANGU_P
ADRP
LANGU
SPRAS
Language Key
40
SORT1_P
ADRP
SORT1
AD_SORT1
Search Term 1
41
SORT2_P
ADRP
SORT2
AD_SORT2
Search Term 2
42
SORT_PHN_P
ADRP
SORT_PHN
AD_SRTPHN
(Not Supported) Phonetic Search Sort Field
43
PERSORIGIN
ADRP
PERSORIGIN
AD_ORIGINP
Personal data source (key)
44
LANGU_CR_P
ADRP
LANGU_CREA
AD_LANGUCR
Address record creation original language
45
DEFLT_COMM
ADCP
DEFLT_COMM
AD_COMM
Communication Method (Key) (Business Address Services)
46
ADDR_COMP
ADRP
ADDR_COMP
AD_ADDRCOM
(not used)
47
TITLE
ADRC
TITLE
AD_TITLE
Form-of-Address Key
48
NAME1
ADRC
NAME1
AD_NAME1
Name 1
49
NAME2
ADRC
NAME2
AD_NAME2
Name 2
50
NAME3
ADRC
NAME3
AD_NAME3
Name 3
51
NAME4
ADRC
NAME4
AD_NAME4
Name 4
52
NAME_TXT
ADRC
NAME_TEXT
AD_NAMETXT
Converted name field (with form of address)
53
NAME_CO
ADRC
NAME_CO
AD_NAME_CO
c/o name
54
CITY1
ADRC
CITY1
AD_CITY1
City
55
CITY2
ADRC
CITY2
AD_CITY2
District
56
CITY_CODE
ADRC
CITY_CODE
AD_CITYNUM
City code for city/street file
57
CITYP_CODE
ADRC
CITYP_CODE
AD_CITYPNM
District code for City and Street file
58
HOME_CITY
ADRC
HOME_CITY
AD_CITY3
City (different from postal city)
59
CITYH_CODE
ADRC
CITYH_CODE
AD_CITYHNM
Different city for city/street file
60
CHCKSTATUS
ADRC
CHCKSTATUS
AD_CHECKST
City file test status
61
REGIOGROUP
ADRC
REGIOGROUP
REGIOGROUP
Regional structure grouping
62
POST_CODE1
ADRC
POST_CODE1
AD_PSTCD1
City postal code
63
POST_CODE2
ADRC
POST_CODE2
AD_PSTCD2
PO Box postal code
64
POST_CODE3
ADRC
POST_CODE3
AD_PSTCD3
Company postal code (for large customers)
65
PCODE1_EXT
ADRC
PCODE1_EXT
AD_PST1XT
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
66
PCODE2_EXT
ADRC
PCODE2_EXT
AD_PST2XT
(Not Supported) PO Box Postal Code Extension
67
PCODE3_EXT
ADRC
PCODE3_EXT
AD_PST3XT
(Not Supported) Major Customer Postal Code Extension
68
PO_BOX
ADRC
PO_BOX
AD_POBX
PO Box
69
PO_BOX_NUM
ADRC
PO_BOX_NUM
AD_POBXNUM
Flag: PO Box without number
70
PO_BOX_LOC
ADRC
PO_BOX_LOC
AD_POBXLOC
PO Box city
71
CITY_CODE2
ADRC
CITY_CODE2
AD_CIT2NUM
City PO box code (City file)
72
PO_BOX_REG
ADRC
PO_BOX_REG
AD_POBXREG
Region for PO Box (Country, State, Province, ...)
73
PO_BOX_CTY
ADRC
PO_BOX_CTY
AD_POBXCTY
PO box country
74
POSTALAREA
ADRC
POSTALAREA
AD_PSTLAR
(Not Supported) Post Delivery District
75
TRANSPZONE
ADRC
TRANSPZONE
LZONE
Transportation zone to or from which the goods are delivered
76
STREET
ADRC
STREET
AD_STREET
Street
77
STREETCODE
ADRC
STREETCODE
AD_STRNUM
Street Number for City/Street File
78
STREETABBR
ADRC
STREETABBR
AD_STRABBR
(Not Supported) Abbreviation of Street Name
79
HOUSE_NUM1
ADRC
HOUSE_NUM1
AD_HSNM1
House Number
80
HOUSE_NUM2
ADRC
HOUSE_NUM2
AD_HSNM2
House number supplement
81
HOUSE_NUM3
ADRC
HOUSE_NUM3
AD_HSNM3
(Not supported) House Number Range
82
STR_SUPPL1
ADRC
STR_SUPPL1
AD_STRSPP1
Street 2
83
STR_SUPPL2
ADRC
STR_SUPPL2
AD_STRSPP2
Street 3
84
STR_SUPPL3
ADRC
STR_SUPPL3
AD_STRSPP3
Street 4
85
LOCATION
ADRC
LOCATION
AD_LCTN
Street 5
86
BUILDING
ADRC
BUILDING
AD_BLDNG
Building (Number or Code)
87
FLOOR
ADRC
FLOOR
AD_FLOOR
Floor in building
88
ROOMNUMBER
ADRC
ROOMNUMBER
AD_ROOMNUM
Room or Appartment Number
89
COUNTRY
ADRC
COUNTRY
LAND1
Country Key
90
LANGU
ADRC
LANGU
SPRAS
Language Key
91
REGION
ADRC
REGION
REGIO
Region (State, Province, County)
92
ADDR_GROUP
ADRC
ADDR_GROUP
AD_GROUP
Address Group (Key) (Business Address Services)
93
SORT1
ADRC
SORT1
AD_SORT1
Search Term 1
94
SORT2
ADRC
SORT2
AD_SORT2
Search Term 2
95
SORT_PHN
ADRC
SORT_PHN
AD_SRTPHN
(Not Supported) Phonetic Search Sort Field
96
ADDRORIGIN
ADRC
ADDRORIGIN
AD_ORIGINA
(Not Supported) Address Data Source (Key)
97
EXTENSION1
ADRC
EXTENSION1
AD_EXTENS1
Extension (only for data conversion) (e.g. data line)
98
EXTENSION2
ADRC
EXTENSION2
AD_EXTENS2
Extension (only for data conversion) (e.g. telebox)
99
TIME_ZONE
ADRC
TIME_ZONE
AD_TZONE
Address time zone
100
TAXJURCODE
ADRC
TAXJURCODE
AD_TXJCD
Tax Jurisdiction
101
ADDRESS_ID
ADRC
ADDRESS_ID
AD_ADDR_ID
(Not supported) Physical address ID
102
LANGU_CREA
ADRC
LANGU_CREA
AD_LANGUCR
Address record creation original language
103
TEL_NUMBER
ADCP
TEL_NUMBER
AD_TLNMBR1
First telephone no.: dialling code+number
104
TEL_EXTENS
ADCP
TEL_EXTENS
AD_TLXTNS1
First Telephone No.: Extension
105
FAX_NUMBER
ADCP
FAX_NUMBER
AD_FXNMBR1
First fax no.: dialling code+number
106
FAX_EXTENS
ADCP
FAX_EXTENS
AD_FXXTNS1
First fax no.: extension
107
TEL_NUMCMP
ADRC
TEL_NUMBER
AD_TLNMBR1
First telephone no.: dialling code+number
108
TEL_EXTCMP
ADRC
TEL_EXTENS
AD_TLXTNS1
First Telephone No.: Extension
109
FAX_NUMCMP
ADRC
FAX_NUMBER
AD_FXNMBR1
First fax no.: dialling code+number
110
FAX_EXTCMP
ADRC
FAX_EXTENS
AD_FXXTNS1
First fax no.: extension
111
PERS_GROUP
ADRP
PERS_GROUP
AD_GROUP_P
Person Group (Key) (Business Address Services)