Menu

SAP Table ADRPS

Shadow Table: Persons (Business Address Services)

The table ADRPS (Shadow Table: Persons (Business Address Services)) is a standard table in SAP ERP. It belongs to the package SZAD.

Technical Information

Table ADRPS
Short Text Shadow Table: Persons (Business Address Services)
Package SZAD
Table Type Transparent Table

Fields for Table ADRPS

Field Name Key Description Data Element Type Length Check Table
CLIENT Client MANDT CLNT 3 T000
TRKORR Request/Task TRKORR CHAR 20 *
PERSNUMBER Person number AD_PERSNUM CHAR 10 *
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8
NATION Version ID for International Addresses AD_NATION CHAR 1 TSADV
DATE_TO Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8
TITLE Form-of-Address Key AD_TITLE CHAR 4 TSAD3
NAME_FIRST First name AD_NAMEFIR CHAR 40
NAME_LAST Last name AD_NAMELAS CHAR 40
NAME2 Name of person at birth AD_NAME2_P CHAR 40
NAMEMIDDLE Middle name or second forename of a person AD_NAMEMID CHAR 40
NAME_LAST2 Second surname of a person AD_NAMLAS2 CHAR 40
NAME_TEXT Full Name of Person AD_NAMTEXT CHAR 80
CONVERTED Status of Field 'Full Name' NAME_TEXT AD_NAMCONV CHAR 1
TITLE_ACA1 Academic Title: Key AD_TITLE1 CHAR 4 TSAD2
TITLE_ACA2 Second academic title (key) AD_TITLE2 CHAR 4 TSAD2
PREFIX1 Name Prefix (Key) AD_PREFIX CHAR 4 TSAD4
PREFIX2 2nd name prefix (key) AD_PREFIX2 CHAR 4 TSAD4
TITLE_SPPL Name supplement, e.g. noble title (key) AD_TITLES CHAR 4 TSAD5
NICKNAME Nickname or name used AD_NICKNAM CHAR 40
INITIALS "Middle Initial" or personal initials AD_INITS CHAR 10
NAMEFORMAT Name format AD_FORMAT CHAR 2 T005N
NAMCOUNTRY Country for name format rule AD_NAMCTRY CHAR 3 T005
PROFESSION Profession AD_PROFESS CHAR 40
SEX Gender key AD_SEX CHAR 1
LANGU Language Key SPRAS LANG 1 T002
PERS_GROUP Person Group (Key) (Business Address Services) AD_GROUP_P CHAR 4 TSAD8
FLAGGROUPS Flag: There are other person group assignments AD_FLGGP_P CHAR 1
SORT1 Search Term 1 AD_SORT1 CHAR 20
SORT2 Search Term 2 AD_SORT2 CHAR 20
SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20
ADDR_COMP (not used) AD_ADDRCOM CHAR 10 *
ADDR_PERS (not used) AD_ADDRPER CHAR 10 *
FLPERSTEL Flag: person has personal telephone numbers AD_FLPTEL CHAR 1
FLPERSCOMM Flag: Person has personal comm. numbers (apart from Tel.) AD_FLPCOMM CHAR 1
PERSORIGIN Personal data source (key) AD_ORIGINP CHAR 4 TSAD6
MC_NAMEFIR First name in upper case for search help AD_MC_NMFI CHAR 25
MC_NAMELAS Last name in upper-case for search help AD_MC_NMLA CHAR 25
MC_NAME2 NAME2 field in upper case for matchcode AD_MC_NAM2 CHAR 25
LANGU_CREA Address record creation original language AD_LANGUCR LANG 1 *
ADRP_UUID UUID Used in the Address AD_UUID RAW 16
UUID_BELATED Indicator: UUID was generated later AD_UUID_BELATED CHAR 1
ID_CATEGORY Category of an Address ID AD_ID_CATEGORY CHAR 1
ADRP_ERR_STATUS Error Status of Address AD_ERR_STATUS CHAR 1