SAP ADRCOUNTYT Table – County (long texts)

The ADRCOUNTYT table in SAP ERP or S/4HANA stores County (long texts) data. There are total 9 fields in ADRCOUNTYT table. The County (long texts) 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 ADRCOUNTYT 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 ADRCOUNTYT Table Fields

Following is the list of fields that are available in SAP ADRCOUNTYT table. The primary key fields of the table are CLIENT (Client), LANGU (Language Key), COUNTRY (Country/Region Key), REGION (Region (State, Province, County)), COUNTY_CODE (County code for county).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT T000 CLNT (3)
LANGU Language Key LANGU T002 LANG (1)
COUNTRY Country/Region Key LAND1 T005 CHAR (3)
REGION Region (State, Province, County) REGIO T005S CHAR (3)
COUNTY_CODE County code for county CNTY_CODE ADRCOUNTY CHAR (8)
COUNTY County AD_COUNTY CHAR (40)
MC_COUNTY County name in upper case for search help AD_MC_COUNTY CHAR (25)
COUNTY_SHORT Long abbreviation of the county name (24 chars) COUNTY_SHORT CHAR (24)
COUNTY_SH10 Short abbreviation of the county name (10 chars) COUNTY_SH10 CHAR (10)