SAP ADRPS (Shadow Table: Persons (Business Address Services)) Table & Fields

ADRPS is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of ADRPS.
  • Table description : Shadow Table: Persons (Business Address Services)
  • Module : BC-SRV-ADR
  • Parent Module : BC
  • Package : SZAD
  • Software Component : SAP_BASIS

ADRPS hierarchy

SAP_BASISBCBC-SRV-ADRADRPS

ADRPS Fields structure

FieldNoteData ElementDomain
CLIENTClientMANDTMANDT
TRKORRRequest/TaskTRKORRTRKORR
PERSNUMBERPerson numberAD_PERSNUMAD_PERSNUM
DATE_FROMValid-from date - in current Release only 00010101 possibleAD_DATE_FRDATUM
NATIONVersion ID for International AddressesAD_NATIONAD_NATION
DATE_TOValid-to date in current Release only 99991231 possibleAD_DATE_TODATUM
TITLEForm-of-Address KeyAD_TITLEAD_TITLE
NAME_FIRSTFirst nameAD_NAMEFIRTEXT40
NAME_LASTLast nameAD_NAMELASTEXT40
NAME2Name of person at birthAD_NAME2_PTEXT40
NAMEMIDDLEMiddle name or second forename of a personAD_NAMEMIDTEXT40
NAME_LAST2Second surname of a personAD_NAMLAS2TEXT40
NAME_TEXTFull Name of PersonAD_NAMTEXTTEXT80
CONVERTEDStatus of Field 'Full Name' NAME_TEXTAD_NAMCONVAD_NAMCONV
TITLE_ACA1Academic Title: KeyAD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key)AD_TITLE2AD_TITLE1
PREFIX1Name Prefix (Key)AD_PREFIXAD_PREFIX
PREFIX22nd name prefix (key)AD_PREFIX2AD_PREFIX
TITLE_SPPLName supplement, e.g. noble title (key)AD_TITLESAD_TITLES
NICKNAMENickname or name usedAD_NICKNAMTEXT40
INITIALS"Middle Initial" or personal initialsAD_INITSCHAR10
NAMEFORMATName formatAD_FORMATAD_NAMFORM
NAMCOUNTRYCountry for name format ruleAD_NAMCTRYLAND1
PROFESSIONProfessionAD_PROFESSTEXT40
SEXGender keyAD_SEXAD_SEX
LANGULanguage KeySPRASSPRAS
PERS_GROUPPerson Group (Key) (Business Address Services)AD_GROUP_PAD_GROUP_P
FLAGGROUPSFlag: There are other person group assignmentsAD_FLGGP_PXFELD
SORT1Search Term 1AD_SORT1CHAR20
SORT2Search Term 2AD_SORT2CHAR20
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR20
ADDR_COMP(not used)AD_ADDRCOMAD_ADDRNUM
ADDR_PERS(not used)AD_ADDRPERAD_ADDRNUM
FLPERSTELFlag: person has personal telephone numbersAD_FLPTELXFELD
FLPERSCOMMFlag: Person has personal comm. numbers (apart from Tel.)AD_FLPCOMMXFELD
PERSORIGINPersonal data source (key)AD_ORIGINPAD_ORIGIN
MC_NAMEFIRFirst name in upper case for search helpAD_MC_NMFICHAR25
MC_NAMELASLast name in upper-case for search helpAD_MC_NMLACHAR25
MC_NAME2NAME2 field in upper case for matchcodeAD_MC_NAM2CHAR25
LANGU_CREAAddress record creation original languageAD_LANGUCRSPRAS
ADRP_UUIDUUID Used in the AddressAD_UUIDSYSUUID
UUID_BELATEDIndicator: UUID was generated laterAD_UUID_BELATEDAD_UUID_BELATED
ID_CATEGORYCategory of an Address IDAD_ID_CATEGORYAD_ID_CATEGORY
ADRP_ERR_STATUSError Status of AddressAD_ERR_STATUSAD_ERR_STATUS