ADRCOUNTYT is a standard SAP table in SAP ECC (or) S/4HANA which stores County (long texts) data. There are total 9 fields in ADRCOUNTYT table.This blog post provides key technical details of SAP table ADRCOUNTYT, including its availability across SAP S/4HANA versions and the list of CDS views for ADRCOUNTYT table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Single entries of table were buffered |
| Package | SAP Technology – Business Services: Address Management (SZAD) |
| Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRCOUNTYT Table Fields
The following is the list of fields that are available in SAP ADRCOUNTYT 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) |
| LANGU | Language Key | LANGU | SPRAS | T002 | LANG (1) |
| COUNTRY | Country/Region Key | LAND1 | LAND1 | T005 | CHAR (3) |
| REGION | Region (State, Province, County) | REGIO | REGIO | T005S | CHAR (3) |
| COUNTY_CODE | County code for county | CNTY_CODE | CNTY_CODE | ADRCOUNTY | CHAR (8) |
| COUNTY | County | AD_COUNTY | TEXT40 | CHAR (40) | |
| MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | CHAR25 | CHAR (25) | |
| COUNTY_SHORT | Long abbreviation of the county name (24 chars) | COUNTY_SHORT | TEXT24 | CHAR (24) | |
| COUNTY_SH10 | Short abbreviation of the county name (10 chars) | COUNTY_SH10 | TEXT10 | CHAR (10) |
Availability
The SAP table ADRCOUNTYT 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 ADRCOUNTYT table
The following is the list of ADRCOUNTYT CDS views, which can also be used instead of ADRCOUNTYT table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_COUNTYCODETEXT | BASIC | County Code Text |
