Sunday, May 19, 2024

SAP Table ADRTOWNSHIPT – Township (long texts)

ADRTOWNSHIPT is a standard SAP table in SAP ECC (or) S/4HANA which stores Township (long texts) data. There are total 10 fields in ADRTOWNSHIPT table.This blog post provides key technical details of SAP table ADRTOWNSHIPT, including its availability across SAP S/4HANA versions and the list of CDS views for ADRTOWNSHIPT 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 ADRTOWNSHIPT Table Fields

The following is the list of fields that are available in SAP ADRTOWNSHIPT 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)
TOWNSHIP_CODE Township code for Township TWSHP_CODE TWSHP_CODE ADRTOWNSHIP CHAR (8)
TOWNSHIP Township AD_TOWNSHIP TEXT40 CHAR (40)
MC_TOWNSHIP Township name in upper case for search help AD_MC_TWSHP CHAR25 CHAR (25)
TWSHIP_SHORT Long abbreviation of the Township name (24 chars) TOWNSHIP_SHORT TEXT24 CHAR (24)
TWSHIP_SH15 Short abbreviation of Township name (15 chars) TOWNSHIP_SH15 TEXT15 CHAR (15)

Availability

The SAP table ADRTOWNSHIPT 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 ADRTOWNSHIPT table

The following is the list of ADRTOWNSHIPT CDS views, which can also be used instead of ADRTOWNSHIPT table based on your business requirements.

CDS View CDS View Type Description
I_TOWNSHIPCODETEXT BASIC Township Code Text