ADRP
Persons (Business Address Services)Explore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table ADRP.
SAP table ADRP has 4 primary key fields: CLIENT,PERSNUMBER,DATE_FROM,NATION.
ADRP fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| Key PERSNUMBER | Person Number | CHAR | 10 | 0 | AD_PERSNUM | ||||||||
| Key DATE_FROM | Valid-from date - in current Release only 00010101 possible | DATS | 8 | 0 | AD_DATE_FR | ||||||||
| Key NATION | Version ID for International Addresses | CHAR | 1 | 0 | TSADV | AD_NATION | |||||||
| DATE_TO | Valid-to date in current Release only 99991231 possible | DATS | 8 | 0 | AD_DATE_TO | ||||||||
| TITLE | Form-of-Address Key | CHAR | 4 | 0 | TSAD3 | AD_TITLE | |||||||
| NAME_FIRST | First name | CHAR | 40 | 0 | AD_NAMEFIR | ||||||||
| NAME_LAST | Last name | CHAR | 40 | 0 | AD_NAMELAS | ||||||||
| NAME2 | Name of person at birth | CHAR | 40 | 0 | AD_NAME2_P | ||||||||
| NAMEMIDDLE | Middle name or second forename of a person | CHAR | 40 | 0 | AD_NAMEMID | ||||||||
| NAME_LAST2 | Other Last Name of a Person | CHAR | 40 | 0 | AD_NAMLAS2 | ||||||||
| NAME_TEXT | Full Name of Person | CHAR | 80 | 0 | AD_NAMTEXT | ||||||||
| CONVERTED | Status of Field 'Full Name' NAME_TEXT | CHAR | 1 | 0 | AD_NAMCONV | ||||||||
| |||||||||||||
| TITLE_ACA1 | Academic Title: Key | CHAR | 4 | 0 | TSAD2 | AD_TITLE1 | |||||||
| TITLE_ACA2 | Second academic title (key) | CHAR | 4 | 0 | TSAD2 | AD_TITLE2 | |||||||
| PREFIX1 | Name Prefix (Key) | CHAR | 4 | 0 | TSAD4 | AD_PREFIX | |||||||
| PREFIX2 | 2nd name prefix (key) | CHAR | 4 | 0 | TSAD4 | AD_PREFIX2 | |||||||
| TITLE_SPPL | Name supplement, e.g. noble title (key) | CHAR | 4 | 0 | TSAD5 | AD_TITLES | |||||||
| NICKNAME | Nickname or name used | CHAR | 40 | 0 | AD_NICKNAM | ||||||||
| INITIALS | "Middle Initial" or personal initials | CHAR | 10 | 0 | AD_INITS | ||||||||
| NAMEFORMAT | Name format | CHAR | 2 | 0 | T005N | AD_FORMAT | |||||||
| NAMCOUNTRY | Country/Region for Name Format Rule | CHAR | 3 | 0 | T005 | AD_NAMCTRY | |||||||
| PROFESSION | Profession | CHAR | 40 | 0 | AD_PROFESS | ||||||||
| SEX | Gender key | CHAR | 1 | 0 | TSAD15 | AD_SEX | |||||||
| LANGU | Language Key | LANG | 1 | 0 | T002 | SPRAS | |||||||
| PERS_GROUP | Person Group (Key) (Business Address Services) | CHAR | 4 | 0 | TSAD8 | AD_GROUP_P | |||||||
| FLAGGROUPS | Flag: There are other person group assignments | CHAR | 1 | 0 | AD_FLGGP_P | ||||||||
| SORT1 | Search Term 1 | CHAR | 20 | 0 | AD_SORT1 | ||||||||
| SORT2 | Search Term 2 | CHAR | 20 | 0 | AD_SORT2 | ||||||||
| SORT_PHN | (Not Supported) Phonetic Search Sort Field | CHAR | 20 | 0 | AD_SRTPHN | ||||||||
| ADDR_COMP | (not used) | CHAR | 10 | 0 | AD_ADDRCOM | ||||||||
| ADDR_PERS | (not used) | CHAR | 10 | 0 | AD_ADDRPER | ||||||||
| FLPERSTEL | Flag: person has personal telephone numbers | CHAR | 1 | 0 | AD_FLPTEL | ||||||||
| FLPERSCOMM | Flag: Person has personal comm. numbers (apart from Tel.) | CHAR | 1 | 0 | AD_FLPCOMM | ||||||||
| PERSORIGIN | Personal data source (key) | CHAR | 4 | 0 | TSAD6 | AD_ORIGINP | |||||||
| MC_NAMEFIR | First Name in Uppercase for Search Help | CHAR | 25 | 0 | AD_MC_NMFI | ||||||||
| MC_NAMELAS | Last Name in Uppercase for Search Help | CHAR | 25 | 0 | AD_MC_NMLA | ||||||||
| MC_NAME2 | Field NAME2 in Uppercase for Matchcode | CHAR | 25 | 0 | AD_MC_NAM2 | ||||||||
| LANGU_CREA | Address record creation original language | LANG | 1 | 0 | AD_LANGUCR | ||||||||
| ADRP_UUID | UUID Used in the Address | RAW | 16 | 0 | AD_UUID | ||||||||
| UUID_BELATED | Indicator: UUID created later | CHAR | 1 | 0 | AD_UUID_BELATED | ||||||||
| |||||||||||||
| ID_CATEGORY | Category of an Address ID | CHAR | 1 | 0 | AD_ID_CATEGORY | ||||||||
| |||||||||||||
| ADRP_ERR_STATUS | Error Status of Address | CHAR | 1 | 0 | AD_ERR_STATUS | ||||||||
| |||||||||||||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE | ||||||||
ADRP relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| ADRP | CLIENT | T000 | Clients | MANDT |
| ADRP | NAMCOUNTRY | T005 | Countries | MANDT |
| ADRP | NAMCOUNTRY | T005 | Countries | LAND1 |
| ADRP | NAMEFORMAT | T005N | Name formats | MANDT |
| ADRP | NAMEFORMAT | T005N | Name formats | LAND1 |
| ADRP | NAMEFORMAT | T005N | Name formats | NAMEFORMAT |
| ADRP | PERSORIGIN | TSAD6 | Source Address or Personal Data (Business Address Services) | CLIENT |
| ADRP | PERSORIGIN | TSAD6 | Source Address or Personal Data (Business Address Services) | ORIGIN |
| ADRP | PERS_GROUP | TSAD8 | Groups of Persons (Business Address Services) | PERS_GROUP |
| ADRP | PREFIX1 | TSAD4 | Name Prefixes (Business Address Services) | CLIENT |
| ADRP | PREFIX1 | TSAD4 | Name Prefixes (Business Address Services) | PREFIX_KEY |
| ADRP | PREFIX2 | TSAD4 | Name Prefixes (Business Address Services) | CLIENT |
| ADRP | PREFIX2 | TSAD4 | Name Prefixes (Business Address Services) | PREFIX_KEY |
| ADRP | SEX | TSAD15 | Gender key (Business Address Services) | GENDER |
| ADRP | TITLE | TSAD3 | Forms of Address (Key) (Business Address Services) | TITLE |
| ADRP | TITLE_ACA1 | TSAD2 | Academic Title (Business Address Services) | CLIENT |
| ADRP | TITLE_ACA1 | TSAD2 | Academic Title (Business Address Services) | TITLE_KEY |
| ADRP | TITLE_ACA2 | TSAD2 | Academic Title (Business Address Services) | CLIENT |
| ADRP | TITLE_ACA2 | TSAD2 | Academic Title (Business Address Services) | TITLE_KEY |
| ADRP | TITLE_SPPL | TSAD5 | Name Suffixes/Title (Key) (Business Address Services) | CLIENT |
| ADRP | TITLE_SPPL | TSAD5 | Name Suffixes/Title (Key) (Business Address Services) | TITLE_KEY |