ADRP - Persons (Business Address Services)

Persons (Business Address Services) information is stored in SAP table ADRP.
It is part of development package SZAD in software component BC-SRV-ADR. This development package consists of objects that can be grouped under "SAP Technology - Business Services: Address Management".

Fields for table ADRP

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
CLIENTClientXMANDTCLNT6T000
PERSNUMBERPerson NumberXAD_PERSNUMCHAR20
DATE_FROMValid-from date - in current Release only 00010101 possibleXAD_DATE_FRDATS16
NATIONVersion ID for International AddressesXAD_NATIONCHAR2TSADV
DATE_TOValid-to date in current Release only 99991231 possibleAD_DATE_TODATS16
TITLEForm-of-Address KeyAD_TITLECHAR8TSAD3
NAME_FIRSTFirst nameAD_NAMEFIRCHAR80
NAME_LASTLast nameAD_NAMELASCHAR80
NAME2Name of person at birthAD_NAME2_PCHAR80
NAMEMIDDLEMiddle name or second forename of a personAD_NAMEMIDCHAR80
NAME_LAST2Other Last Name of a PersonAD_NAMLAS2CHAR80
NAME_TEXTFull Name of PersonAD_NAMTEXTCHAR160
CONVERTEDStatus of Field 'Full Name' NAME_TEXTAD_NAMCONVCHAR2
TITLE_ACA1Academic Title: KeyAD_TITLE1CHAR8TSAD2
TITLE_ACA2Second academic title (key)AD_TITLE2CHAR8TSAD2
PREFIX1Name Prefix (Key)AD_PREFIXCHAR8TSAD4
PREFIX22nd name prefix (key)AD_PREFIX2CHAR8TSAD4
TITLE_SPPLName supplement, e.g. noble title (key)AD_TITLESCHAR8TSAD5
NICKNAMENickname or name usedAD_NICKNAMCHAR80
INITIALS"Middle Initial" or personal initialsAD_INITSCHAR20
NAMEFORMATName formatAD_FORMATCHAR4T005N
NAMCOUNTRYCountry/Region for Name Format RuleAD_NAMCTRYCHAR6T005
PROFESSIONProfessionAD_PROFESSCHAR80
SEXGender keyAD_SEXCHAR2TSAD15
LANGULanguage KeySPRASLANG2T002
PERS_GROUPPerson Group (Key) (Business Address Services)AD_GROUP_PCHAR8TSAD8
FLAGGROUPSFlag: There are other person group assignmentsAD_FLGGP_PCHAR2
SORT1Search Term 1AD_SORT1CHAR40
SORT2Search Term 2AD_SORT2CHAR40
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR40
ADDR_COMP(not used)AD_ADDRCOMCHAR20
ADDR_PERS(not used)AD_ADDRPERCHAR20
FLPERSTELFlag: person has personal telephone numbersAD_FLPTELCHAR2
FLPERSCOMMFlag: Person has personal comm. numbers (apart from Tel.)AD_FLPCOMMCHAR2
PERSORIGINPersonal data source (key)AD_ORIGINPCHAR8TSAD6
MC_NAMEFIRFirst Name in Uppercase for Search HelpAD_MC_NMFICHAR50
MC_NAMELASLast Name in Uppercase for Search HelpAD_MC_NMLACHAR50
MC_NAME2Field NAME2 in Uppercase for MatchcodeAD_MC_NAM2CHAR50
LANGU_CREAAddress record creation original languageAD_LANGUCRLANG2
ADRP_UUIDUUID Used in the AddressAD_UUIDRAW16
UUID_BELATEDIndicator: UUID created laterAD_UUID_BELATEDCHAR2
ID_CATEGORYCategory of an Address IDAD_ID_CATEGORYCHAR2
ADRP_ERR_STATUSError Status of AddressAD_ERR_STATUSCHAR2
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS16
Privacy Policy