1. Home
  2. Resources
  3. SAP Tables
  4. ADRP - Persons (Business Address Services)

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
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
NULL Generated from the parts of the name
X Converted from the previous release
M Maintained manually
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
NULL Gender not known
1 Male
2 Female
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
X Yes
NULL No
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
X Yes
NULL No
FLPERSCOMM Flag: Person has personal comm. numbers (apart from Tel.) AD_FLPCOMM CHAR 1 0
X Yes
NULL No
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
NULL UUID was generated during creation of address
X UUID was generated later
ID_CATEGORY Category of an Address ID AD_ID_CATEGORY CHAR 1 0
NULL Normal AddressID
I Internal AddressID of Instance Sharing Address
ADRP_ERR_STATUS Error Status of Address AD_ERR_STATUS CHAR 1 0
NULL Address is consistent
E Address contains incorrect data
W Address contains data that leads to warnings

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 CLIENT T005N Name formats MANDT
ADRP NAMEFORMAT ADRP NAMCOUNTRY T005N Name formats LAND1
ADRP NAMEFORMAT ADRP NAMEFORMAT T005N Name formats NAMEFORMAT
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 CLIENT TSAD4 Name Prefixes (Business Address Services) CLIENT
ADRP PREFIX2 ADRP PREFIX2 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
ADRP TITLE ADRP TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
ADRP TITLE ADRP CLIENT TSAD3 Forms of Address (Key) (Business Address Services) CLIENT
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 TITLE_SPPL TSAD5 Name Suffixes/Title (Key) (Business Address Services) TITLE_KEY
ADRP TITLE_SPPL ADRP CLIENT TSAD5 Name Suffixes/Title (Key) (Business Address Services) CLIENT