BUT_ADRC_SRC - Master Data Consolidation: Source Table for ADRC

Master Data Consolidation: Source Table for ADRC information is stored in SAP table BUT_ADRC_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".

Fields for table BUT_ADRC_SRC

Field Name	Description	Is Key	Data Element	Data Type	Length
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
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
NATION	Version ID for International Addresses	X	AD_NATION	CHAR	2
ADDRNUMBER	Address Number		AD_ADDRNUM	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
NAME1	Name 1		AD_NAME1	CHAR	80
NAME2	Name 2		AD_NAME2	CHAR	80
NAME3	Name 3		AD_NAME3	CHAR	80
NAME4	Name 4		AD_NAME4	CHAR	80
NAME_TEXT	Converted name field (with form of address)		AD_NAMETXT	CHAR	100
NAME_CO	c/o name		AD_NAME_CO	CHAR	80
CITY1	City		AD_CITY1	CHAR	80
CITY2	District		AD_CITY2	CHAR	80
CITY_CODE	City code for city/street file		AD_CITYNUM	CHAR	24
CITYP_CODE	District code for City and Street file		AD_CITYPNM	CHAR	16
HOME_CITY	City (different from postal city)		AD_CITY3	CHAR	80
CITYH_CODE	Different city for city/street file		AD_CITYHNM	CHAR	24
CHCKSTATUS	City file test status		AD_CHECKST	CHAR	2
REGIOGROUP	Regional structure grouping		REGIOGROUP	CHAR	16
POST_CODE1	City postal code		AD_PSTCD1	CHAR	20
POST_CODE2	PO Box Postal Code		AD_PSTCD2	CHAR	20
POST_CODE3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code		AD_PST1XT	CHAR	20
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension		AD_PST2XT	CHAR	20
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension		AD_PST3XT	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
DONT_USE_P	PO Box Address Undeliverable Flag		AD_NO_USEP	CHAR	8
PO_BOX_NUM	Flag: PO Box Without Number		AD_POBXNUM	CHAR	2
PO_BOX_LOC	PO Box city		AD_POBXLOC	CHAR	80
CITY_CODE2	City PO box code (City file)		AD_CIT2NUM	CHAR	24
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	6
PO_BOX_CTY	PO Box of Country/Region		AD_POBXCTY	CHAR	6
POSTALAREA	(Not Supported) Post Delivery District		AD_PSTLAR	CHAR	30
TRANSPZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20
STREET	Street		AD_STREET	CHAR	120
DONT_USE_S	Street Address Undeliverable Flag		AD_NO_USES	CHAR	8
STREETCODE	Street Number for City/Street File		AD_STRNUM	CHAR	24
STREETABBR	(Not Supported) Abbreviation of Street Name		AD_STRABBR	CHAR	4
HOUSE_NUM1	House Number		AD_HSNM1	CHAR	20
HOUSE_NUM2	House number supplement		AD_HSNM2	CHAR	20
HOUSE_NUM3	(Not supported) House Number Range		AD_HSNM3	CHAR	20
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	80
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	80
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	80
LOCATION	Street 5		AD_LCTN	CHAR	80
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	40
FLOOR	Floor in building		AD_FLOOR	CHAR	20
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	20
COUNTRY	Country/Region Key		LAND1	CHAR	6
LANGU	Language Key		SPRAS	LANG	2
REGION	Region (State, Province, County)		REGIO	CHAR	6
ADDR_GROUP	Address Group (Key) (Business Address Services)		AD_GROUP	CHAR	8
FLAGGROUPS	Flag: There are more address group assignments		AD_FLGGP	CHAR	2
PERS_ADDR	Flag: This is a personal address		AD_PRSADDR	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
DEFLT_COMM	Communication Method (Key) (Business Address Services)		AD_COMM	CHAR	6
TEL_NUMBER	First telephone no.: dialling code+number		AD_TLNMBR1	CHAR	60
TEL_EXTENS	First Telephone No.: Extension		AD_TLXTNS1	CHAR	20
FAX_NUMBER	First Fax No.: Area Code + Number		AD_FXNMBR1	CHAR	60
FAX_EXTENS	First fax no.: extension		AD_FXXTNS1	CHAR	20
FLAGCOMM2	Flag: Telephone number(s) defined		AD_FLGCM02	CHAR	2
FLAGCOMM3	Flag: Fax number(s) defined		AD_FLGCM03	CHAR	2
FLAGCOMM4	Flag: Teletex number(s) defined		AD_FLGCM04	CHAR	2
FLAGCOMM5	Flag: Telex number(s) defined		AD_FLGCM05	CHAR	2
FLAGCOMM6	Flag: E-mail address(es) defined		AD_FLGCM06	CHAR	2
FLAGCOMM7	Flag: RML (remote mail) addresse(s) defined		AD_FLGCM07	CHAR	2
FLAGCOMM8	Flag: X.400 addresse(s) defined		AD_FLGCM08	CHAR	2
FLAGCOMM9	Flag: RFC destination(s) defined		AD_FLGCM09	CHAR	2
FLAGCOMM10	Flag: Printer defined		AD_FLGCM10	CHAR	2
FLAGCOMM11	Flag: SSF defined		AD_FLGCM11	CHAR	2
FLAGCOMM12	Flag: URI/FTP address defined		AD_FLGCM12	CHAR	2
FLAGCOMM13	Flag: Pager address defined		AD_FLGCM13	CHAR	2
ADDRORIGIN	(Not Supported) Address Data Source (Key)		AD_ORIGINA	CHAR	8
MC_NAME1	Name (Field NAME1) in Uppercase for Search Help		AD_MC_NAME	CHAR	50
MC_CITY1	City name in Uppercase for Search Help		AD_MC_CITY	CHAR	50
MC_STREET	Street Name in Uppercase for Search Help		AD_MC_STRT	CHAR	50
EXTENSION1	Extension (only for data conversion) (e.g. data line)		AD_EXTENS1	CHAR	80
EXTENSION2	Extension (only for data conversion) (e.g. telebox)		AD_EXTENS2	CHAR	80
TIME_ZONE	Address time zone		AD_TZONE	CHAR	12
TAXJURCODE	Tax Jurisdiction		AD_TXJCD	CHAR	30
ADDRESS_ID	(Not supported) Physical address ID		AD_ADDR_ID	CHAR	20
LANGU_CREA	Address record creation original language		AD_LANGUCR	LANG	2
ADRC_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
ADRC_ERR_STATUS	Error Status of Address		AD_ERR_STATUS	CHAR	2
PO_BOX_LOBBY	PO Box Lobby		AD_PO_BOX_LBY	CHAR	80
DELI_SERV_TYPE	Type of Delivery Service		AD_DELIVERY_SERVICE_TYPE	CHAR	8
DELI_SERV_NUMBER	Number of Delivery Service		AD_DELIVERY_SERVICE_NUMBER	CHAR	20
COUNTY_CODE	County code for county		AD_CNTYNUM	CHAR	16
COUNTY	County		AD_COUNTY	CHAR	80
TOWNSHIP_CODE	Township code for Township		AD_TWSHPNUM	CHAR	16
TOWNSHIP	Township		AD_TOWNSHIP	CHAR	80
MC_COUNTY	County name in upper case for search help		AD_MC_COUNTY	CHAR	50
MC_TOWNSHIP	Township name in upper case for search help		AD_MC_TWSHP	CHAR	50
XPCPT	Business Purpose Completed Flag		AD_XPCPT	CHAR	2
SOURCE_RECENCY	Master Data Consolidation: Recency		MDC_RECENCY	DEC	8
.INCLU--AP				MDC_SAPHT_RN_SADRC_DUNSSRC	0
DUNS	Dun & Bradstreet number (DUNS)		/SAPHT/RN_DUNS	CHAR	18
DUNSP4	DUNS+4 number (the last four digit)		/SAPHT/RN_DUNSP4	CHAR	8