ADRPS is a standard SAP table in SAP ECC (or) S/4HANA which stores Shadow Table: Persons (Business Address Services) data. There are total 44 fields in ADRPS table.This blog post provides key technical details of SAP table ADRPS, including its availability across SAP S/4HANA versions and the list of CDS views for ADRPS table in SAP.
SAP HANA Table Type | Column Store |
---|---|
Buffering Permission | Buffering not allowed |
Buffering Type | No buffering |
Package | SAP Technology – Business Services: Address Management (SZAD) |
Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRPS Table Fields
The following is the list of fields that are available in SAP ADRPS table. The key fields of the table are highlighted in color.
Field | Description | Data Element | Domain | Check Table | Data Type |
---|---|---|---|---|---|
CLIENT | Client | MANDT | MANDT | T000 | CLNT (3) |
TRKORR | Request/Task | TRKORR | TRKORR | CHAR (20) | |
PERSNUMBER | Person Number | AD_PERSNUM | AD_PERSNUM | CHAR (10) | |
DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATUM | DATS (8) | |
NATION | Version ID for International Addresses | AD_NATION | AD_NATION | TSADV | CHAR (1) |
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATUM | DATS (8) | |
TITLE | Form-of-Address Key | AD_TITLE | AD_TITLE | TSAD3 | CHAR (4) |
NAME_FIRST | First name | AD_NAMEFIR | TEXT40 | CHAR (40) | |
NAME_LAST | Last name | AD_NAMELAS | TEXT40 | CHAR (40) | |
NAME2 | Name of person at birth | AD_NAME2_P | TEXT40 | CHAR (40) | |
NAMEMIDDLE | Middle name or second forename of a person | AD_NAMEMID | TEXT40 | CHAR (40) | |
NAME_LAST2 | Other Last Name of a Person | AD_NAMLAS2 | TEXT40 | CHAR (40) | |
NAME_TEXT | Full Name of Person | AD_NAMTEXT | TEXT80 | CHAR (80) | |
CONVERTED | Status of Field ‘Full Name’ NAME_TEXT | AD_NAMCONV | AD_NAMCONV | CHAR (1) | |
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | AD_TITLE1 | TSAD2 | CHAR (4) |
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | AD_TITLE1 | TSAD2 | CHAR (4) |
PREFIX1 | Name Prefix (Key) | AD_PREFIX | AD_PREFIX | TSAD4 | CHAR (4) |
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | AD_PREFIX | TSAD4 | CHAR (4) |
TITLE_SPPL | Name supplement, e.g. noble title (key) | AD_TITLES | AD_TITLES | TSAD5 | CHAR (4) |
NICKNAME | Nickname or name used | AD_NICKNAM | TEXT40 | CHAR (40) | |
INITIALS | Middle Initial or personal initials | AD_INITS | CHAR10 | CHAR (10) | |
NAMEFORMAT | Name format | AD_FORMAT | AD_NAMFORM | T005N | CHAR (2) |
NAMCOUNTRY | Country for Name Format Rule | AD_NAMCTRY | LAND1 | T005 | CHAR (3) |
PROFESSION | Profession | AD_PROFESS | TEXT40 | CHAR (40) | |
SEX | Gender key | AD_SEX | AD_SEX | TSAD15 | CHAR (1) |
LANGU | Language Key | SPRAS | SPRAS | T002 | LANG (1) |
PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | AD_GROUP_P | TSAD8 | CHAR (4) |
FLAGGROUPS | Flag: There are other person group assignments | AD_FLGGP_P | XFELD | CHAR (1) | |
SORT1 | Search Term 1 | AD_SORT1 | CHAR20 | CHAR (20) | |
SORT2 | Search Term 2 | AD_SORT2 | CHAR20 | CHAR (20) | |
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR20 | CHAR (20) | |
ADDR_COMP | (not used) | AD_ADDRCOM | AD_ADDRNUM | CHAR (10) | |
ADDR_PERS | (not used) | AD_ADDRPER | AD_ADDRNUM | CHAR (10) | |
FLPERSTEL | Flag: person has personal telephone numbers | AD_FLPTEL | XFELD | CHAR (1) | |
FLPERSCOMM | Flag: Person has personal comm. numbers (apart from Tel.) | AD_FLPCOMM | XFELD | CHAR (1) | |
PERSORIGIN | Personal data source (key) | AD_ORIGINP | AD_ORIGIN | TSAD6 | CHAR (4) |
MC_NAMEFIR | First Name in Uppercase for Search Help | AD_MC_NMFI | CHAR25 | CHAR (25) | |
MC_NAMELAS | Last Name in Uppercase for Search Help | AD_MC_NMLA | CHAR25 | CHAR (25) | |
MC_NAME2 | Field NAME2 in Uppercase for Matchcode | AD_MC_NAM2 | CHAR25 | CHAR (25) | |
LANGU_CREA | Address record creation original language | AD_LANGUCR | SPRAS | LANG (1) | |
ADRP_UUID | UUID Used in the Address | AD_UUID | SYSUUID | RAW (16) | |
UUID_BELATED | Indicator: UUID created later | AD_UUID_BELATED | AD_UUID_BELATED | CHAR (1) | |
ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | AD_ID_CATEGORY | CHAR (1) | |
ADRP_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | AD_ERR_STATUS | CHAR (1) |
Availability
The SAP table ADRPS is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
SAP S/4HANA Version | Available? |
---|---|
1909 | Yes |
2020 | Yes |
2021 | Yes |
2022 | Yes |
2023 | Yes |
CDS Views for ADRPS table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.