BUT_ADRP_ACT - Master Data Consolidation: Best Record Table for ADRP

Master Data Consolidation: Best Record Table for ADRP information is stored in SAP table BUT_ADRP_ACT.
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_ACT

Field Name	Description	Is Key	Data Element	Data Type	Length
CLIENT	Client	X	MANDT	CLNT	6
PARTNER	Business Partner Number	X	BU_PARTNER	CHAR	20
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
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
RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
SOURCE_RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8