The BUT_ADRP_SRC table in SAP ERP or S/4HANA stores Source Records Of OTC 147, Table ADRP data. There are total 47 fields in BUT_ADRP_SRC table. The Source Records Of OTC 147, Table ADRP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BUT_ADRP_SRC table. It is in Master Data Consolidation: Business Partner Data Model (MDC_BP_MODEL) ABAP package and is part of the Business Partner. (CA-MDG-CMP-BP) module.
SAP BUT_ADRP_SRC Table Fields
Following is the list of fields that are available in SAP BUT_ADRP_SRC table. The primary key fields of the table are CLIENT (Client), SOURCE_SYSTEM (Source System), SOURCE_ID (Master Data Consolidation: ID of a Source Objects), DATE_FROM (Valid-from date – in current Release only 00010101 possible), NATION (Version ID for International Addresses).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| SOURCE_SYSTEM | Source System | MDC_BUSINESS_SYSTEM | CHAR (60) | |
| SOURCE_ID | Master Data Consolidation: ID of a Source Objects | MDC_SOURCE_ID | CHAR (60) | |
| 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) | |
| PERSNUMBER | Person Number | AD_PERSNUM | CHAR (10) | |
| 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) | |
| 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 | Other Last Name 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) | |
| TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR (4) | |
| PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR (4) | |
| PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR (4) | |
| TITLE_SPPL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR (4) | |
| 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) | |
| NAMCOUNTRY | Country for Name Format Rule | AD_NAMCTRY | CHAR (3) | |
| PROFESSION | Profession | AD_PROFESS | CHAR (40) | |
| SEX | Gender key | AD_SEX | * | CHAR (1) |
| LANGU | Language Key | SPRAS | LANG (1) | |
| PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | CHAR (4) | |
| 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) | |
| MC_NAMEFIR | First Name in Uppercase for Search Help | AD_MC_NMFI | CHAR (25) | |
| MC_NAMELAS | Last Name in Uppercase for Search Help | AD_MC_NMLA | CHAR (25) | |
| MC_NAME2 | Field NAME2 in Uppercase 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 created 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) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) | |
| SOURCE_RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC (15) |
