ADRCS2 - Shadow Table 2: Addresses (Business Address Services)

Shadow Table 2: Addresses (Business Address Services) information is stored in SAP table ADRCS2.
It is part of development package SZAD in software component BC-SRV-ADR. This development package consists of objects that can be grouped under "SAP Technology - Business Services: Address Management".

Fields for table ADRCS2

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	3	T000
TABLENAME	Application table logical name (address management)	X	AD_APPLTAB	CHAR	10
FIELDNAME	Application table address where-used list logical field name	X	AD_APPLFLD	CHAR	10
OBJKEY	Address owner object ID	X	AD_OBJKEY	CHAR	70
DATE_FROM	Valid-from date - in current Release only 00010101 possible	X	AD_DATE_FR	DATS	8
NATION	Version ID for International Addresses	X	AD_NATION	CHAR	1	TSADV
DATE_TO	Valid-to date in current Release only 99991231 possible		AD_DATE_TO	DATS	8
TITLE	Form-of-Address Key		AD_TITLE	CHAR	4	TSAD3
NAME1	Name 1		AD_NAME1	CHAR	40
NAME2	Name 2		AD_NAME2	CHAR	40
NAME3	Name 3		AD_NAME3	CHAR	40
NAME4	Name 4		AD_NAME4	CHAR	40
NAME_TEXT	Converted name field (with form of address)		AD_NAMETXT	CHAR	50
NAME_CO	c/o name		AD_NAME_CO	CHAR	40
CITY1	City		AD_CITY1	CHAR	40
CITY2	District		AD_CITY2	CHAR	40
CITY_CODE	City code for city/street file		AD_CITYNUM	CHAR	12	ADRCITY
CITYP_CODE	District code for City and Street file		AD_CITYPNM	CHAR	8	ADRCITYPRT
HOME_CITY	City (different from postal city)		AD_CITY3	CHAR	40
CITYH_CODE	Different city for city/street file		AD_CITYHNM	CHAR	12	ADRCITY
CHCKSTATUS	City file test status		AD_CHECKST	CHAR	1
REGIOGROUP	Regional structure grouping		REGIOGROUP	CHAR	8	ADRREGGRP
POST_CODE1	City postal code		AD_PSTCD1	CHAR	10
POST_CODE2	PO Box Postal Code		AD_PSTCD2	CHAR	10
POST_CODE3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	10
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code		AD_PST1XT	CHAR	10
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension		AD_PST2XT	CHAR	10
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension		AD_PST3XT	CHAR	10
PO_BOX	PO Box		AD_POBX	CHAR	10
DONT_USE_P	PO Box Address Undeliverable Flag		AD_NO_USEP	CHAR	4	TSAD12
PO_BOX_NUM	Flag: PO Box Without Number		AD_POBXNUM	CHAR	1
PO_BOX_LOC	PO Box city		AD_POBXLOC	CHAR	40
CITY_CODE2	City PO box code (City file)		AD_CIT2NUM	CHAR	12	ADRCITY
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	3	T005S
PO_BOX_CTY	PO Box of Country/Region		AD_POBXCTY	CHAR	3	T005
POSTALAREA	(Not Supported) Post Delivery District		AD_PSTLAR	CHAR	15
TRANSPZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	10	TZONE
STREET	Street		AD_STREET	CHAR	60
DONT_USE_S	Street Address Undeliverable Flag		AD_NO_USES	CHAR	4	TSAD12
STREETCODE	Street Number for City/Street File		AD_STRNUM	CHAR	12	ADRSTREET
STREETABBR	(Not Supported) Abbreviation of Street Name		AD_STRABBR	CHAR	2	ADRSTRTYPE
HOUSE_NUM1	House Number		AD_HSNM1	CHAR	10
HOUSE_NUM2	House number supplement		AD_HSNM2	CHAR	10
HOUSE_NUM3	(Not supported) House Number Range		AD_HSNM3	CHAR	10
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	40
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	40
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	40
LOCATION	Street 5		AD_LCTN	CHAR	40
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	20
FLOOR	Floor in building		AD_FLOOR	CHAR	10
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	10
COUNTRY	Country/Region Key		LAND1	CHAR	3	T005
LANGU	Language Key		SPRAS	LANG	1	T002
REGION	Region (State, Province, County)		REGIO	CHAR	3	T005S
ADDR_GROUP	Address Group (Key) (Business Address Services)		AD_GROUP	CHAR	4	TSAD7
FLAGGROUPS	Flag: There are more address group assignments		AD_FLGGP	CHAR	1
PERS_ADDR	Flag: This is a personal address		AD_PRSADDR	CHAR	1
SORT1	Search Term 1		AD_SORT1	CHAR	20
SORT2	Search Term 2		AD_SORT2	CHAR	20
SORT_PHN	(Not Supported) Phonetic Search Sort Field		AD_SRTPHN	CHAR	20
DEFLT_COMM	Communication Method (Key) (Business Address Services)		AD_COMM	CHAR	3	TSAC
TEL_NUMBER	First telephone no.: dialling code+number		AD_TLNMBR1	CHAR	30
TEL_EXTENS	First Telephone No.: Extension		AD_TLXTNS1	CHAR	10
FAX_NUMBER	First Fax No.: Area Code + Number		AD_FXNMBR1	CHAR	30
FAX_EXTENS	First fax no.: extension		AD_FXXTNS1	CHAR	10
FLAGCOMM2	Flag: Telephone number(s) defined		AD_FLGCM02	CHAR	1
FLAGCOMM3	Flag: Fax number(s) defined		AD_FLGCM03	CHAR	1
FLAGCOMM4	Flag: Teletex number(s) defined		AD_FLGCM04	CHAR	1
FLAGCOMM5	Flag: Telex number(s) defined		AD_FLGCM05	CHAR	1
FLAGCOMM6	Flag: E-mail address(es) defined		AD_FLGCM06	CHAR	1
FLAGCOMM7	Flag: RML (remote mail) addresse(s) defined		AD_FLGCM07	CHAR	1
FLAGCOMM8	Flag: X.400 addresse(s) defined		AD_FLGCM08	CHAR	1
FLAGCOMM9	Flag: RFC destination(s) defined		AD_FLGCM09	CHAR	1
FLAGCOMM10	Flag: Printer defined		AD_FLGCM10	CHAR	1
FLAGCOMM11	Flag: SSF defined		AD_FLGCM11	CHAR	1
FLAGCOMM12	Flag: URI/FTP address defined		AD_FLGCM12	CHAR	1
FLAGCOMM13	Flag: Pager address defined		AD_FLGCM13	CHAR	1
ADDRORIGIN	(Not Supported) Address Data Source (Key)		AD_ORIGINA	CHAR	4	TSAD6
MC_NAME1	Name (Field NAME1) in Uppercase for Search Help		AD_MC_NAME	CHAR	25
MC_CITY1	City name in Uppercase for Search Help		AD_MC_CITY	CHAR	25
MC_STREET	Street Name in Uppercase for Search Help		AD_MC_STRT	CHAR	25
EXTENSION1	Extension (only for data conversion) (e.g. data line)		AD_EXTENS1	CHAR	40
EXTENSION2	Extension (only for data conversion) (e.g. telebox)		AD_EXTENS2	CHAR	40
TIME_ZONE	Address time zone		AD_TZONE	CHAR	6	TTZZ
TAXJURCODE	Tax Jurisdiction		AD_TXJCD	CHAR	15
ADDRESS_ID	(Not supported) Physical address ID		AD_ADDR_ID	CHAR	10
LANGU_CREA	Address record creation original language		AD_LANGUCR	LANG	1	*
ADRC_ERR_STATUS	Error Status of Address		AD_ERR_STATUS	CHAR	1
PO_BOX_LOBBY	PO Box Lobby		AD_PO_BOX_LBY	CHAR	40
DELI_SERV_TYPE	Type of Delivery Service		AD_DELIVERY_SERVICE_TYPE	CHAR	4	*
DELI_SERV_NUMBER	Number of Delivery Service		AD_DELIVERY_SERVICE_NUMBER	CHAR	10
COUNTY_CODE	County code for county		AD_CNTYNUM	CHAR	8	*
COUNTY	County		AD_COUNTY	CHAR	40
TOWNSHIP_CODE	Township code for Township		AD_TWSHPNUM	CHAR	8	*
TOWNSHIP	Township		AD_TOWNSHIP	CHAR	40
MC_COUNTY	County name in upper case for search help		AD_MC_COUNTY	CHAR	25
MC_TOWNSHIP	Township name in upper case for search help		AD_MC_TWSHP	CHAR	25