SAP Table ADRP
Persons (Business Address Services)
ADRP (Persons (Business Address Services)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ADRP to other SAP tables.
ADRP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CLIENT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
PERSNUMBER
Person number
|
AD_PERSNUM |
CHAR
|
10 | 0 | ||||||||||
|
DATE_FROM
Valid-from date - in current Release only 00010101 possible
|
AD_DATE_FR |
DATS
|
8 | 0 | ||||||||||
|
NATION
Version ID for International Addresses
|
AD_NATION | TSADV |
CHAR
|
1 | 0 | |||||||||
|
DATE_TO
Valid-to date in current Release only 99991231 possible
|
AD_DATE_TO |
DATS
|
8 | 0 | ||||||||||
|
TITLE
Form-of-Address Key
|
AD_TITLE | TSAD3 |
CHAR
|
4 | 0 | |||||||||
|
NAME_FIRST
First name
|
AD_NAMEFIR |
CHAR
|
40 | 0 | ||||||||||
|
NAME_LAST
Last name
|
AD_NAMELAS |
CHAR
|
40 | 0 | ||||||||||
|
NAME2
Name of person at birth
|
AD_NAME2_P |
CHAR
|
40 | 0 | ||||||||||
|
NAMEMIDDLE
Middle name or second forename of a person
|
AD_NAMEMID |
CHAR
|
40 | 0 | ||||||||||
|
NAME_LAST2
Second surname of a person
|
AD_NAMLAS2 |
CHAR
|
40 | 0 | ||||||||||
|
NAME_TEXT
Full Name of Person
|
AD_NAMTEXT |
CHAR
|
80 | 0 | ||||||||||
|
CONVERTED
Status of Field 'Full Name' NAME_TEXT
|
AD_NAMCONV |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TITLE_ACA1
Academic Title: Key
|
AD_TITLE1 | TSAD2 |
CHAR
|
4 | 0 | |||||||||
|
TITLE_ACA2
Second academic title (key)
|
AD_TITLE2 | TSAD2 |
CHAR
|
4 | 0 | |||||||||
|
PREFIX1
Name Prefix (Key)
|
AD_PREFIX | TSAD4 |
CHAR
|
4 | 0 | |||||||||
|
PREFIX2
2nd name prefix (key)
|
AD_PREFIX2 | TSAD4 |
CHAR
|
4 | 0 | |||||||||
|
TITLE_SPPL
Name supplement, e.g. noble title (key)
|
AD_TITLES | TSAD5 |
CHAR
|
4 | 0 | |||||||||
|
NICKNAME
Nickname or name used
|
AD_NICKNAM |
CHAR
|
40 | 0 | ||||||||||
|
INITIALS
"Middle Initial" or personal initials
|
AD_INITS |
CHAR
|
10 | 0 | ||||||||||
|
NAMEFORMAT
Name format
|
AD_FORMAT | T005N |
CHAR
|
2 | 0 | |||||||||
|
NAMCOUNTRY
Country for name format rule
|
AD_NAMCTRY | T005 |
CHAR
|
3 | 0 | |||||||||
|
PROFESSION
Profession
|
AD_PROFESS |
CHAR
|
40 | 0 | ||||||||||
|
SEX
Gender key
|
AD_SEX |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LANGU
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||
|
PERS_GROUP
Person Group (Key) (Business Address Services)
|
AD_GROUP_P | TSAD8 |
CHAR
|
4 | 0 | |||||||||
|
FLAGGROUPS
Flag: There are other person group assignments
|
AD_FLGGP_P |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SORT1
Search Term 1
|
AD_SORT1 |
CHAR
|
20 | 0 | ||||||||||
|
SORT2
Search Term 2
|
AD_SORT2 |
CHAR
|
20 | 0 | ||||||||||
|
SORT_PHN
(Not Supported) Phonetic Search Sort Field
|
AD_SRTPHN |
CHAR
|
20 | 0 | ||||||||||
|
ADDR_COMP
(not used)
|
AD_ADDRCOM |
CHAR
|
10 | 0 | ||||||||||
|
ADDR_PERS
(not used)
|
AD_ADDRPER |
CHAR
|
10 | 0 | ||||||||||
|
FLPERSTEL
Flag: person has personal telephone numbers
|
AD_FLPTEL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
FLPERSCOMM
Flag: Person has personal comm. numbers (apart from Tel.)
|
AD_FLPCOMM |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PERSORIGIN
Personal data source (key)
|
AD_ORIGINP | TSAD6 |
CHAR
|
4 | 0 | |||||||||
|
MC_NAMEFIR
First name in upper case for search help
|
AD_MC_NMFI |
CHAR
|
25 | 0 | ||||||||||
|
MC_NAMELAS
Last name in upper-case for search help
|
AD_MC_NMLA |
CHAR
|
25 | 0 | ||||||||||
|
MC_NAME2
NAME2 field in upper case for matchcode
|
AD_MC_NAM2 |
CHAR
|
25 | 0 | ||||||||||
|
LANGU_CREA
Address record creation original language
|
AD_LANGUCR |
LANG
|
1 | 0 | ||||||||||
|
ADRP_UUID
UUID Used in the Address
|
AD_UUID |
RAW
|
16 | 0 | ||||||||||
|
UUID_BELATED
Indicator: UUID was generated later
|
AD_UUID_BELATED |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ID_CATEGORY
Category of an Address ID
|
AD_ID_CATEGORY |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ADRP_ERR_STATUS
Error Status of Address
|
AD_ERR_STATUS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
ADRP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ADRP | CLIENT | ADRP | CLIENT |
T000
Clients
|
MANDT |
| ADRP | LANGU | ADRP | LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| ADRP | NAMCOUNTRY | ADRP | CLIENT |
T005
Countries
|
MANDT |
| ADRP | NAMCOUNTRY | ADRP | NAMCOUNTRY |
T005
Countries
|
LAND1 |
| ADRP | NAMEFORMAT | ADRP | NAMEFORMAT |
T005N
Name formats
|
NAMEFORMAT |
| ADRP | NAMEFORMAT | ADRP | CLIENT |
T005N
Name formats
|
MANDT |
| ADRP | NAMEFORMAT | ADRP | NAMCOUNTRY |
T005N
Name formats
|
LAND1 |
| ADRP | NATION | ADRP | NATION |
TSADV
International versions of addresses
|
NATION |
| ADRP | PERSORIGIN | ADRP | CLIENT |
TSAD6
Source Address or Personal Data (Business Address Services)
|
CLIENT |
| ADRP | PERSORIGIN | ADRP | PERSORIGIN |
TSAD6
Source Address or Personal Data (Business Address Services)
|
ORIGIN |
| ADRP | PERS_GROUP | ADRP | PERS_GROUP |
TSAD8
Groups of Persons (Business Address Services)
|
PERS_GROUP |
| ADRP | PREFIX1 | ADRP | CLIENT |
TSAD4
Name Prefixes (Business Address Services)
|
CLIENT |
| ADRP | PREFIX1 | ADRP | PREFIX1 |
TSAD4
Name Prefixes (Business Address Services)
|
PREFIX_KEY |
| ADRP | PREFIX2 | ADRP | PREFIX2 |
TSAD4
Name Prefixes (Business Address Services)
|
PREFIX_KEY |
| ADRP | PREFIX2 | ADRP | CLIENT |
TSAD4
Name Prefixes (Business Address Services)
|
CLIENT |
| ADRP | TITLE | ADRP | CLIENT |
TSAD3
Forms of Address (Key) (Business Address Services)
|
CLIENT |
| ADRP | TITLE | ADRP | TITLE |
TSAD3
Forms of Address (Key) (Business Address Services)
|
TITLE |
| ADRP | TITLE_ACA1 | ADRP | CLIENT |
TSAD2
Academic Title (Business Address Services)
|
CLIENT |
| ADRP | TITLE_ACA1 | ADRP | TITLE_ACA1 |
TSAD2
Academic Title (Business Address Services)
|
TITLE_KEY |
| ADRP | TITLE_ACA2 | ADRP | CLIENT |
TSAD2
Academic Title (Business Address Services)
|
CLIENT |
| ADRP | TITLE_ACA2 | ADRP | TITLE_ACA2 |
TSAD2
Academic Title (Business Address Services)
|
TITLE_KEY |
| ADRP | TITLE_SPPL | ADRP | CLIENT |
TSAD5
Name Suffixes/Title (Key) (Business Address Services)
|
CLIENT |
| ADRP | TITLE_SPPL | ADRP | TITLE_SPPL |
TSAD5
Name Suffixes/Title (Key) (Business Address Services)
|
TITLE_KEY |