SAP Table ADRPS - Shadow Table: Persons (Business Address Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
TRKORR X TRKORR CHAR 3 20 0 Request/Task
PERSNUMBER X AD_PERSNUM CHAR 23 10 0 ADRP Person number
DATE_FROM X AD_DATE_FR DATS 33 8 0 Valid-from date - in current Release only 00010101 possible
NATION X AD_NATION CHAR 41 1 0 TSADV International address version ID
DATE_TO AD_DATE_TO DATS 42 8 0 Valid-to date in current Release only 99991231 possible
TITLE AD_TITLE CHAR 50 4 0 TSAD3 Form-of-Address Key
NAME_FIRST AD_NAMEFIR CHAR 54 40 0 First name
NAME_LAST AD_NAMELAS CHAR 94 40 0 Last name
NAME2 AD_NAME2_P CHAR 134 40 0 Name of person at birth
NAMEMIDDLE AD_NAMEMID CHAR 174 40 0 Middle name or second forename of a person
NAME_LAST2 AD_NAMLAS2 CHAR 214 40 0 Second surname of a person
NAME_TEXT AD_NAMTEXT CHAR 254 80 0 Full Name of Person
CONVERTED AD_NAMCONV CHAR 334 1 0 Status of Field 'Full Name' NAME_TEXT
TITLE_ACA1 AD_TITLE1 CHAR 335 4 0 Academic Title: Key
TITLE_ACA2 AD_TITLE2 CHAR 339 4 0 Second academic title (key)
PREFIX1 AD_PREFIX CHAR 343 4 0 Name Prefix (Key)
PREFIX2 AD_PREFIX2 CHAR 347 4 0 2nd name prefix (key)
TITLE_SPPL AD_TITLES CHAR 351 4 0 Name supplement, e.g. noble title (key)
NICKNAME AD_NICKNAM CHAR 355 40 0 Nickname or name used
INITIALS AD_INITS CHAR 395 10 0 "Middle Initial" or personal initials
NAMEFORMAT AD_FORMAT CHAR 405 2 0 T005N Name format
NAMCOUNTRY AD_NAMCTRY CHAR 407 3 0 T005 Country for name format rule
PROFESSION AD_PROFESS CHAR 410 40 0 Profession
SEX AD_SEX CHAR 450 1 0 Gender key
LANGU SPRAS LANG 451 1 0 T002 Language Key
PERS_GROUP AD_GROUP_P CHAR 452 4 0 Person Group (Key) (Business Address Services)
FLAGGROUPS AD_FLGGP_P CHAR 456 1 0 Flag: There are other person group assignments
SORT1 AD_SORT1 CHAR 457 20 0 Search Term 1
SORT2 AD_SORT2 CHAR 477 20 0 Search Term 2
SORT_PHN AD_SRTPHN CHAR 497 20 0 (Not Supported) Phonetic Search Sort Field
ADDR_COMP AD_ADDRCOM CHAR 517 10 0 (not used)
ADDR_PERS AD_ADDRPER CHAR 527 10 0 (not used)
FLPERSTEL AD_FLPTEL CHAR 537 1 0 Flag: person has personal telephone numbers
FLPERSCOMM AD_FLPCOMM CHAR 538 1 0 Flag: Person has personal comm. numbers (apart from Tel.)
PERSORIGIN AD_ORIGINP CHAR 539 4 0 Personal data source (key)
MC_NAMEFIR AD_MC_NMFI CHAR 543 25 0 First name in upper case for search help
MC_NAMELAS AD_MC_NMLA CHAR 568 25 0 Last name in upper-case for search help
MC_NAME2 AD_MC_NAM2 CHAR 593 25 0 NAME2 field in upper case for matchcode
LANGU_CREA AD_LANGUCR LANG 618 1 0 T002 Address record creation original language

673941Unicode conversion for address tables (ADRC, ADRP)