BUT_ADRP_SRC - Source Records Of OTC 147, Table ADRP
Source Records Of OTC 147, Table ADRP information is stored in SAP table BUT_ADRP_SRC.
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".
It is part of development package MDC_BP_MODEL in software component CA-MDG-CMP-BP. This development package consists of objects that can be grouped under "Master Data Consolidation: Business Partner Data Model".
Fields for table BUT_ADRP_SRC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
CLIENT | Client | X | MANDT | CLNT | 6 | |
.INCLUDE | SOURCE_KEY | X | MDC_SOURCE_KEY | 0 | ||
SOURCE_SYSTEM | Source System | X | MDC_BUSINESS_SYSTEM | CHAR | 120 | |
SOURCE_ID | Master Data Consolidation: ID of a Source Objects | X | MDC_SOURCE_ID | CHAR | 120 | |
.INCLUDE | TABLE_KEY | X | MDC_ADRP_KEY | 0 | ||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | X | AD_DATE_FR | DATS | 16 | |
NATION | Version ID for International Addresses | X | AD_NATION | CHAR | 2 | |
.INCLUDE | TABLE_ATTRIBUTES | MDC_ADRP_ATTRIBUTES | 0 | |||
PERSNUMBER | Person Number | AD_PERSNUM | CHAR | 20 | ||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 16 | ||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 8 | ||
NAME_FIRST | First name | AD_NAMEFIR | CHAR | 80 | ||
NAME_LAST | Last name | AD_NAMELAS | CHAR | 80 | ||
NAME2 | Name of person at birth | AD_NAME2_P | CHAR | 80 | ||
NAMEMIDDLE | Middle name or second forename of a person | AD_NAMEMID | CHAR | 80 | ||
NAME_LAST2 | Other Last Name of a Person | AD_NAMLAS2 | CHAR | 80 | ||
NAME_TEXT | Full Name of Person | AD_NAMTEXT | CHAR | 160 | ||
CONVERTED | Status of Field 'Full Name' NAME_TEXT | AD_NAMCONV | CHAR | 2 | ||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 8 | ||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 8 | ||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 8 | ||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 8 | ||
TITLE_SPPL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 8 | ||
NICKNAME | Nickname or name used | AD_NICKNAM | CHAR | 80 | ||
INITIALS | "Middle Initial" or personal initials | AD_INITS | CHAR | 20 | ||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 4 | ||
NAMCOUNTRY | Country/Region for Name Format Rule | AD_NAMCTRY | CHAR | 6 | ||
PROFESSION | Profession | AD_PROFESS | CHAR | 80 | ||
SEX | Gender key | AD_SEX | CHAR | 2 | * | |
LANGU | Language Key | SPRAS | LANG | 2 | ||
PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | CHAR | 8 | ||
FLAGGROUPS | Flag: There are other person group assignments | AD_FLGGP_P | CHAR | 2 | ||
SORT1 | Search Term 1 | AD_SORT1 | CHAR | 40 | ||
SORT2 | Search Term 2 | AD_SORT2 | CHAR | 40 | ||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 40 | ||
ADDR_COMP | (not used) | AD_ADDRCOM | CHAR | 20 | * | |
ADDR_PERS | (not used) | AD_ADDRPER | CHAR | 20 | * | |
FLPERSTEL | Flag: person has personal telephone numbers | AD_FLPTEL | CHAR | 2 | ||
FLPERSCOMM | Flag: Person has personal comm. numbers (apart from Tel.) | AD_FLPCOMM | CHAR | 2 | ||
PERSORIGIN | Personal data source (key) | AD_ORIGINP | CHAR | 8 | ||
MC_NAMEFIR | First Name in Uppercase for Search Help | AD_MC_NMFI | CHAR | 50 | ||
MC_NAMELAS | Last Name in Uppercase for Search Help | AD_MC_NMLA | CHAR | 50 | ||
MC_NAME2 | Field NAME2 in Uppercase for Matchcode | AD_MC_NAM2 | CHAR | 50 | ||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 2 | * | |
ADRP_UUID | UUID Used in the Address | AD_UUID | RAW | 16 | ||
UUID_BELATED | Indicator: UUID created later | AD_UUID_BELATED | CHAR | 2 | ||
ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | CHAR | 2 | ||
ADRP_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | CHAR | 2 | ||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 | ||
SOURCE_RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC | 8 |