SAP Table ADRP - Persons (Business Address Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
PERSNUMBER X AD_PERSNUM CHAR 3 10 0 ADRP Person number
DATE_FROM X AD_DATE_FR DATS 13 8 0 Valid-from date - in current Release only 00010101 possible
NATION X AD_NATION CHAR 21 1 0 TSADV International address version ID
DATE_TO AD_DATE_TO DATS 22 8 0 Valid-to date in current Release only 99991231 possible
TITLE AD_TITLE CHAR 30 4 0 TSAD3 Form-of-Address Key
NAME_FIRST AD_NAMEFIR CHAR 34 40 0 First name
NAME_LAST AD_NAMELAS CHAR 74 40 0 Last name
NAME2 AD_NAME2_P CHAR 114 40 0 Name of person at birth
NAMEMIDDLE AD_NAMEMID CHAR 154 40 0 Middle name or second forename of a person
NAME_LAST2 AD_NAMLAS2 CHAR 194 40 0 Second surname of a person
NAME_TEXT AD_NAMTEXT CHAR 234 80 0 Full Name of Person
CONVERTED AD_NAMCONV CHAR 314 1 0 Status of Field 'Full Name' NAME_TEXT
TITLE_ACA1 AD_TITLE1 CHAR 315 4 0 Academic Title: Key
TITLE_ACA2 AD_TITLE2 CHAR 319 4 0 Second academic title (key)
PREFIX1 AD_PREFIX CHAR 323 4 0 Name Prefix (Key)
PREFIX2 AD_PREFIX2 CHAR 327 4 0 2nd name prefix (key)
TITLE_SPPL AD_TITLES CHAR 331 4 0 Name supplement, e.g. noble title (key)
NICKNAME AD_NICKNAM CHAR 335 40 0 Nickname or name used
INITIALS AD_INITS CHAR 375 10 0 "Middle Initial" or personal initials
NAMEFORMAT AD_FORMAT CHAR 385 2 0 T005N Name format
NAMCOUNTRY AD_NAMCTRY CHAR 387 3 0 T005 Country for name format rule
PROFESSION AD_PROFESS CHAR 390 40 0 Profession
SEX AD_SEX CHAR 430 1 0 Gender key
LANGU SPRAS LANG 431 1 0 T002 Language Key
PERS_GROUP AD_GROUP_P CHAR 432 4 0 Person Group (Key) (Business Address Services)
FLAGGROUPS AD_FLGGP_P CHAR 436 1 0 Flag: There are other person group assignments
SORT1 AD_SORT1 CHAR 437 20 0 Search Term 1
SORT2 AD_SORT2 CHAR 457 20 0 Search Term 2
SORT_PHN AD_SRTPHN CHAR 477 20 0 (Not Supported) Phonetic Search Sort Field
ADDR_COMP AD_ADDRCOM CHAR 497 10 0 (not used)
ADDR_PERS AD_ADDRPER CHAR 507 10 0 (not used)
FLPERSTEL AD_FLPTEL CHAR 517 1 0 Flag: person has personal telephone numbers
FLPERSCOMM AD_FLPCOMM CHAR 518 1 0 Flag: Person has personal comm. numbers (apart from Tel.)
PERSORIGIN AD_ORIGINP CHAR 519 4 0 Personal data source (key)
MC_NAMEFIR AD_MC_NMFI CHAR 523 25 0 First name in upper case for search help
MC_NAMELAS AD_MC_NMLA CHAR 548 25 0 Last name in upper-case for search help
MC_NAME2 AD_MC_NAM2 CHAR 573 25 0 NAME2 field in upper case for matchcode
LANGU_CREA AD_LANGUCR LANG 598 1 0 T002 Address record creation original language

1024253Matchcode regeneration in Unicode systems
785802PPOMA_BBP: 'Defective' users in EBP
672835Textflags could cause problems during Unicode conversion
634839Text language for address versions
1050478Deleting direct addresses with phantom references
712619Unicode conversion: Language key in ADRP table
536414CRM 3.0/3.1 SAP Composite Note: Middleware reorganization
680695Unicode conversion in tables LFA1, KNA1 and KNVK
673941Unicode conversion for address tables (ADRC, ADRP)
559302index for BPs without an address
694481Name change is not transferred to short text
550226CC-ADMIN: Copying the Customizing takes a long time
384462Master data and addresses
525673 Indexes on address tables
450322Indexes in the tables of the Business Address Services
166833IS-U/CCS: Notes on inst. & prod. system operation