BUT_ADR3_ACT - Master Data Consolidation: Best Record Table for ADR3

Master Data Consolidation: Best Record Table for ADR3 information is stored in SAP table BUT_ADR3_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_ADR3_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
SOURCE_ADDRNUMBER	Address Number	X	AD_ADDRNUM	CHAR	20
DATE_FROM	Valid-from date - in current Release only 00010101 possible	X	AD_DATE_FR	DATS	16
CONSNUMBER	Sequence Number	X	AD_CONSNUM	NUMC	6
COUNTRY	Country/Region for Telephone/Fax Number		AD_COMCTRY	CHAR	6
FLGDEFAULT	Standard Sender Address in this Communication Type		AD_FLGDFNR	CHAR	2
FLG_NOUSE	Flag: This Communication Number is Not Used		AD_FLNOUSE	CHAR	2
HOME_FLAG	Recipient address in this communication type (mail sys.grp)		AD_FLGHOME	CHAR	2
FAX_NUMBER	Fax number: dialling code+number		AD_FXNMBR	CHAR	60
FAX_EXTENS	Fax no.: Extension		AD_FXXTNS	CHAR	20
FAXNR_LONG	Complete number: dialling code+number+extension		AD_FXNRLNG	CHAR	60
FAXNR_CALL	Fax number for finding sender		AD_FAXNRCL	CHAR	60
FAX_GROUP	Fax group (G3, G4, ...)		AD_FXGRP	CHAR	2
DFT_RECEIV	Flag: Recipient is standard recipient for this number		AD_DFTRCNR	CHAR	2
R3_USER	Flag: Connected to an SAP System		AD_R3_USER	CHAR	2
VALID_FROM	Communication Data: Valid From (YYYYMMDDHHMMSS)		AD_VALFROM	CHAR	28
VALID_TO	Communication Data: Valid To (YYYYMMDDHHMMSS)		AD_VALTO	CHAR	28
RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
SOURCE_RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8