ADRCS is a standard SAP table in SAP ECC (or) S/4HANA which stores Shadow Table: Addresses (Business Address Services) data. There are total 99 fields in ADRCS table.This blog post provides key technical details of SAP table ADRCS, including its availability across SAP S/4HANA versions and the list of CDS views for ADRCS table in SAP.
SAP HANA Table Type | Column Store |
---|---|
Buffering Permission | Buffering not allowed |
Buffering Type | No buffering |
Package | SAP Technology – Business Services: Address Management (SZAD) |
Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRCS Table Fields
The following is the list of fields that are available in SAP ADRCS table. The key fields of the table are highlighted in color.
Field | Description | Data Element | Domain | Check Table | Data Type |
---|---|---|---|---|---|
CLIENT | Client | MANDT | MANDT | T000 | CLNT (3) |
TRKORR | Request/Task | TRKORR | TRKORR | * | CHAR (20) |
ADDRNUMBER | Address Number | AD_ADDRNUM | AD_ADDRNUM | * | CHAR (10) |
DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATUM | DATS (8) | |
NATION | Version ID for International Addresses | AD_NATION | AD_NATION | TSADV | CHAR (1) |
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATUM | DATS (8) | |
TITLE | Form-of-Address Key | AD_TITLE | AD_TITLE | TSAD3 | CHAR (4) |
NAME1 | Name 1 | AD_NAME1 | TEXT40 | CHAR (40) | |
NAME2 | Name 2 | AD_NAME2 | TEXT40 | CHAR (40) | |
NAME3 | Name 3 | AD_NAME3 | TEXT40 | CHAR (40) | |
NAME4 | Name 4 | AD_NAME4 | TEXT40 | CHAR (40) | |
NAME_TEXT | Converted name field (with form of address) | AD_NAMETXT | TEXT50 | CHAR (50) | |
NAME_CO | c/o name | AD_NAME_CO | TEXT40 | CHAR (40) | |
CITY1 | City | AD_CITY1 | TEXT40 | CHAR (40) | |
CITY2 | District | AD_CITY2 | TEXT40 | CHAR (40) | |
CITY_CODE | City code for city/street file | AD_CITYNUM | CITY_CODE | ADRCITY | CHAR (12) |
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CITYP_CODE | ADRCITYPRT | CHAR (8) |
HOME_CITY | City (different from postal city) | AD_CITY3 | TEXT40 | CHAR (40) | |
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CITY_CODE | ADRCITY | CHAR (12) |
CHCKSTATUS | City file test status | AD_CHECKST | AD_CHECKST | CHAR (1) | |
REGIOGROUP | Regional structure grouping | REGIOGROUP | REGIOGROUP | ADRREGGRP | CHAR (8) |
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR10 | CHAR (10) | |
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR10 | CHAR (10) | |
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR10 | CHAR (10) | |
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR10 | CHAR (10) | |
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR10 | CHAR (10) | |
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR10 | CHAR (10) | |
PO_BOX | PO Box | AD_POBX | CHAR10 | CHAR (10) | |
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | AD_NO_USE | TSAD12 | CHAR (4) |
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | XFELD | CHAR (1) | |
PO_BOX_LOC | PO Box city | AD_POBXLOC | TEXT40 | CHAR (40) | |
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CITY_CODE | ADRCITY | CHAR (12) |
PO_BOX_REG | Region for PO Box (Country/Region, State, Province, …) | AD_POBXREG | REGIO | T005S | CHAR (3) |
PO_BOX_CTY | PO box country | AD_POBXCTY | LAND1 | T005 | CHAR (3) |
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | TEXT15 | CHAR (15) | |
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | ZONE | TZONE | CHAR (10) |
STREET | Street | AD_STREET | TEXT60 | CHAR (60) | |
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | AD_NO_USE | TSAD12 | CHAR (4) |
STREETCODE | Street Number for City/Street File | AD_STRNUM | STRT_CODE | ADRSTREET | CHAR (12) |
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | STRTYPEAB | ADRSTRTYPE | CHAR (2) |
HOUSE_NUM1 | House Number | AD_HSNM1 | TEXT10 | CHAR (10) | |
HOUSE_NUM2 | House number supplement | AD_HSNM2 | TEXT10 | CHAR (10) | |
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | TEXT10 | CHAR (10) | |
STR_SUPPL1 | Street 2 | AD_STRSPP1 | TEXT40 | CHAR (40) | |
STR_SUPPL2 | Street 3 | AD_STRSPP2 | TEXT40 | CHAR (40) | |
STR_SUPPL3 | Street 4 | AD_STRSPP3 | TEXT40 | CHAR (40) | |
LOCATION | Street 5 | AD_LCTN | TEXT40 | CHAR (40) | |
BUILDING | Building (Number or Code) | AD_BLDNG | TEXT20 | CHAR (20) | |
FLOOR | Floor in building | AD_FLOOR | TEXT10 | CHAR (10) | |
ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | TEXT10 | CHAR (10) | |
COUNTRY | Country/Region Key | LAND1 | LAND1 | T005 | CHAR (3) |
LANGU | Language Key | SPRAS | SPRAS | T002 | LANG (1) |
REGION | Region (State, Province, County) | REGIO | REGIO | T005S | CHAR (3) |
ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | AD_GROUP | TSAD7 | CHAR (4) |
FLAGGROUPS | Flag: There are more address group assignments | AD_FLGGP | XFELD | CHAR (1) | |
PERS_ADDR | Flag: This is a personal address | AD_PRSADDR | XFELD | CHAR (1) | |
SORT1 | Search Term 1 | AD_SORT1 | CHAR20 | CHAR (20) | |
SORT2 | Search Term 2 | AD_SORT2 | CHAR20 | CHAR (20) | |
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR20 | CHAR (20) | |
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | AD_COMM | TSAC | CHAR (3) |
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR30 | CHAR (30) | |
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR10 | CHAR (10) | |
FAX_NUMBER | First Fax No.: Area Code + Number | AD_FXNMBR1 | CHAR30 | CHAR (30) | |
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR10 | CHAR (10) | |
FLAGCOMM2 | Flag: Telephone number(s) defined | AD_FLGCM02 | XFELD | CHAR (1) | |
FLAGCOMM3 | Flag: Fax number(s) defined | AD_FLGCM03 | XFELD | CHAR (1) | |
FLAGCOMM4 | Flag: Teletex number(s) defined | AD_FLGCM04 | XFELD | CHAR (1) | |
FLAGCOMM5 | Flag: Telex number(s) defined | AD_FLGCM05 | XFELD | CHAR (1) | |
FLAGCOMM6 | Flag: E-mail address(es) defined | AD_FLGCM06 | XFELD | CHAR (1) | |
FLAGCOMM7 | Flag: RML (remote mail) addresse(s) defined | AD_FLGCM07 | XFELD | CHAR (1) | |
FLAGCOMM8 | Flag: X.400 addresse(s) defined | AD_FLGCM08 | XFELD | CHAR (1) | |
FLAGCOMM9 | Flag: RFC destination(s) defined | AD_FLGCM09 | XFELD | CHAR (1) | |
FLAGCOMM10 | Flag: Printer defined | AD_FLGCM10 | XFELD | CHAR (1) | |
FLAGCOMM11 | Flag: SSF defined | AD_FLGCM11 | XFELD | CHAR (1) | |
FLAGCOMM12 | Flag: URI/FTP address defined | AD_FLGCM12 | XFELD | CHAR (1) | |
FLAGCOMM13 | Flag: Pager address defined | AD_FLGCM13 | XFELD | CHAR (1) | |
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | AD_ORIGIN | TSAD6 | CHAR (4) |
MC_NAME1 | Name (Field NAME1) in Uppercase for Search Help | AD_MC_NAME | CHAR25 | CHAR (25) | |
MC_CITY1 | City name in Uppercase for Search Help | AD_MC_CITY | CHAR25 | CHAR (25) | |
MC_STREET | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR25 | CHAR (25) | |
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | TEXT40 | CHAR (40) | |
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | TEXT40 | CHAR (40) | |
TIME_ZONE | Address time zone | AD_TZONE | TZNZONE | TTZZ | CHAR (6) |
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | AD_TXJCD | CHAR (15) | |
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | AD_ADDR_ID | CHAR (10) | |
LANGU_CREA | Address record creation original language | AD_LANGUCR | SPRAS | * | LANG (1) |
ADRC_UUID | UUID Used in the Address | AD_UUID | SYSUUID | RAW (16) | |
UUID_BELATED | Indicator: UUID created later | AD_UUID_BELATED | AD_UUID_BELATED | CHAR (1) | |
ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | AD_ID_CATEGORY | CHAR (1) | |
ADRC_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | AD_ERR_STATUS | CHAR (1) | |
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | TEXT40 | CHAR (40) | |
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | AD_DELIVERY_SERVICE_TYPE | * | CHAR (4) |
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR10 | CHAR (10) | |
COUNTY_CODE | County code for county | AD_CNTYNUM | CNTY_CODE | * | CHAR (8) |
COUNTY | County | AD_COUNTY | TEXT40 | CHAR (40) | |
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | TWSHP_CODE | * | CHAR (8) |
TOWNSHIP | Township | AD_TOWNSHIP | TEXT40 | CHAR (40) | |
MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | CHAR25 | CHAR (25) | |
MC_TOWNSHIP | Township name in upper case for search help | AD_MC_TWSHP | CHAR25 | CHAR (25) |
Availability
The SAP table ADRCS is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
SAP S/4HANA Version | Available? |
---|---|
1909 | Yes |
2020 | Yes |
2021 | Yes |
2022 | Yes |
2023 | Yes |
CDS Views for ADRCS table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.