BUT_ADRP_ACT

Master Data Consolidation: Best Record Table for ADRP | #masterdata | #language | Component: Business Partner.
Column Name Description
CLIENT Client
PARTNER Business Partner Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
DATE_TO Valid-to date in current Release only 99991231 possible
Column Name Description
CONVERTED Status of Field 'Full Name' NAME_TEXT Show values
FLAGGROUPS Flag: There are other person group assignments Show values
FLPERSTEL Flag: person has personal telephone numbers Show values
FLPERSCOMM Flag: Person has personal comm. numbers (apart from Tel.) Show values
UUID_BELATED Indicator: UUID created later Show values
ID_CATEGORY Category of an Address ID Show values
ADRP_ERR_STATUS Error Status of Address Show values
Column Name Description Domain name
TITLE Form-of-Address Key AD_TITLE
NAME_FIRST First name TEXT40
NAME_LAST Last name TEXT40
NAME2 Name of person at birth TEXT40
NAMEMIDDLE Middle name or second forename of a person TEXT40
NAME_LAST2 Other Last Name of a Person TEXT40
NAME_TEXT Full Name of Person TEXT80
TITLE_ACA1 Academic Title: Key AD_TITLE1
TITLE_ACA2 Second academic title (key) AD_TITLE1
PREFIX1 Name Prefix (Key) AD_PREFIX
PREFIX2 2nd name prefix (key) AD_PREFIX
TITLE_SPPL Name supplement, e.g. noble title (key) AD_TITLES
NICKNAME Nickname or name used TEXT40
INITIALS "Middle Initial" or personal initials CHAR10
NAMEFORMAT Name format AD_NAMFORM
NAMCOUNTRY Country/Region for Name Format Rule LAND1
PROFESSION Profession TEXT40
SEX Gender key AD_SEX
LANGU Language Key SPRAS
PERS_GROUP Person Group (Key) (Business Address Services) AD_GROUP_P
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
ADDR_COMP (not used) AD_ADDRNUM
ADDR_PERS (not used) AD_ADDRNUM
PERSORIGIN Personal data source (key) AD_ORIGIN
MC_NAMEFIR First Name in Uppercase for Search Help CHAR25
MC_NAMELAS Last Name in Uppercase for Search Help CHAR25
MC_NAME2 Field NAME2 in Uppercase for Matchcode CHAR25
LANGU_CREA Address record creation original language SPRAS
ADRP_UUID UUID Used in the Address SYSUUID
RECENCY Master Data Consolidation: Recency TZNTSTMPS
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS