back to top

SAP ADRC Table – Addresses (Business Address Services)

The ADRC table in SAP ERP or S/4HANA stores Addresses (Business Address Services) data. There are total 102 fields in ADRC table. The Addresses (Business Address Services) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ADRC table. It is in SAP Technology – Business Services: Address Management (SZAD) ABAP package and is part of the Address Management/Business Address (BC-SRV-ADR) module.

SAP ADRC Table Fields

Following is the list of fields that are available in SAP ADRC table. The primary key fields of the table are CLIENT (Client), ADDRNUMBER (Address Number), DATE_FROM (Valid-from date – in current Release only 00010101 possible), NATION (Version ID for International Addresses).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT T000 CLNT (3)
ADDRNUMBER Address Number AD_ADDRNUM CHAR (10)
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_UUID UUID Used in the Address AD_UUID RAW (16)
UUID_BELATED Indicator: UUID created later AD_UUID_BELATED CHAR (1)
ID_CATEGORY Category of an Address ID AD_ID_CATEGORY CHAR (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 ADDRC_DELI_SERV 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)
XPCPT Business Purpose Completed Flag AD_XPCPT CHAR (1)
_DATAAGING Data Filter Value for Data Aging DATA_TEMPERATURE DATS (8)
DUNS Dun & Bradstreet number (DUNS) /SAPHT/RN_DUNS CHAR (9)
DUNSP4 DUNS+4 number (the last four digit) /SAPHT/RN_DUNSP4 CHAR (4)