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

Overview

ADRCS2 is a standard SAP S/4HANA table that stores Shadow Table 2: Addresses (Business Address Services) data. There are total 97 fields in the ADRCS2 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ADRCS2 belongs to Address Management/Business Address (BC-SRV-ADR) module and is located in the package SAP Technology - Business Services: Address Management (SZAD).

In addition, following links provide an overview of foreign key relationships, if any, that link ADRCS2 to other SAP tables and standard CDS views available based on ADRCS2 table in S/4HANA 2020.

Techincal Settings of ADRCS2

Below are technical details of the table ADRCS2

Buffering not allowed
No buffering
Storage type is Column Store

List of ADRCS2 Fields

The following table gives you an overview of the fields available in ADRCS2

Field	Description	Data Element	Check Table	Data Type	Length
CLIENT	Client	MANDT	T000	CLNT	3
TABLENAME	Application table logical name (address management)	AD_APPLTAB		CHAR	10
FIELDNAME	Application table address where-used list logical field name	AD_APPLFLD		CHAR	10
OBJKEY	Address owner object ID	AD_OBJKEY		CHAR	70
DATE_FROM	Valid-from date - in current Release only 00010101 possible	AD_DATE_FR		DATS	8
NATION	Version ID for International Addresses	AD_NATION	TSADV	CHAR	1
DATE_TO	Valid-to date in current Release only 99991231 possible	AD_DATE_TO		DATS	8
TITLE	Form-of-Address Key	AD_TITLE	TSAD3	CHAR	4
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	ADRCITY	CHAR	12
CITYP_CODE	District code for City and Street file	AD_CITYPNM	ADRCITYPRT	CHAR	8
HOME_CITY	City (different from postal city)	AD_CITY3		CHAR	40
CITYH_CODE	Different city for city/street file	AD_CITYHNM	ADRCITY	CHAR	12
CHCKSTATUS	City file test status	AD_CHECKST		CHAR	1
REGIOGROUP	Regional structure grouping	REGIOGROUP	ADRREGGRP	CHAR	8
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	TSAD12	CHAR	4
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	ADRCITY	CHAR	12
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)	AD_POBXREG	T005S	CHAR	3
PO_BOX_CTY	PO box country	AD_POBXCTY	T005	CHAR	3
POSTALAREA	(Not Supported) Post Delivery District	AD_PSTLAR		CHAR	15
TRANSPZONE	Transportation zone to or from which the goods are delivered	LZONE	TZONE	CHAR	10
STREET	Street	AD_STREET		CHAR	60
DONT_USE_S	Street Address Undeliverable Flag	AD_NO_USES	TSAD12	CHAR	4
STREETCODE	Street Number for City/Street File	AD_STRNUM	ADRSTREET	CHAR	12
STREETABBR	(Not Supported) Abbreviation of Street Name	AD_STRABBR	ADRSTRTYPE	CHAR	2
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	T005	CHAR	3
LANGU	Language Key	SPRAS	T002	LANG	1
REGION	Region (State, Province, County)	REGIO	T005S	CHAR	3
ADDR_GROUP	Address Group (Key) (Business Address Services)	AD_GROUP	TSAD7	CHAR	4
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	TSAC	CHAR	3
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	TSAD6	CHAR	4
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	TTZZ	CHAR	6
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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADRCS2

Table Name	Field	Cardinality	Check Table
ADRCS2	ADDRORIGIN	C: CN	TSAD6
ADRCS2	ADDR_GROUP	C: CN	TSAD7
ADRCS2	CITYH_CODE	C: CN	ADRCITY
ADRCS2	CITYP_CODE	C: CN	ADRCITYPRT
ADRCS2	CITY_CODE	C: CN	ADRCITY
ADRCS2	CITY_CODE2	C: CN	ADRCITY
ADRCS2	CLIENT	1: CN	T000
ADRCS2	COUNTRY	1: CN	T005
ADRCS2	DEFLT_COMM	C: CN	TSAC
ADRCS2	DONT_USE_P	C: CN	TSAD12
ADRCS2	DONT_USE_S	C: CN	TSAD12
ADRCS2	LANGU	C: CN	T002
ADRCS2	NATION	1: CN	TSADV
ADRCS2	PO_BOX_CTY	C: CN	T005
ADRCS2	PO_BOX_REG	C: CN	T005S
ADRCS2	REGIOGROUP	C: CN	ADRREGGRP
ADRCS2	REGION	C: CN	T005S
ADRCS2	STREETABBR	C: CN	ADRSTRTYPE
ADRCS2	STREETCODE	C: CN	ADRSTREET
ADRCS2	TIME_ZONE	C: CN	TTZZ
ADRCS2	TITLE	C: CN	TSAD3
ADRCS2	TRANSPZONE	C: CN	TZONE

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

Overview

Techincal Settings of ADRCS2

List of ADRCS2 Fields

Foreign Key Relationships

Other References