ADRSTREETT is a standard SAP table in SAP ECC (or) S/4HANA which stores Streets (long texts) data. There are total 9 fields in ADRSTREETT table.This blog post provides key technical details of SAP table ADRSTREETT, including its availability across SAP S/4HANA versions and the list of CDS views for ADRSTREETT 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: Regional Structure (SZRS) |
| Technical Component | Address Management/Business Address (BC-SRV-ADR) |
SAP ADRSTREETT Table Fields
The following is the list of fields that are available in SAP ADRSTREETT 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) |
| STRT_CODE | Street Number for City/Street File | STRT_CODE | STRT_CODE | ADRSTREET | CHAR (12) |
| CITY_CODE | City Code for City/Street File | CITY_CODE | CITY_CODE | ADRCITY | CHAR (12) |
| STREET | Street | AD_STREET | TEXT60 | CHAR (60) | |
| MC_STREET | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR25 | CHAR (25) | |
| STREET_SHR | Long abbreviation of street name (22 chars) | STREET_SHR | TEXT22 | CHAR (22) | |
| STREET_S15 | Short abbreviation of street name (15 chars) | STREET_S15 | TEXT15 | CHAR (15) |
Availability
The SAP table ADRSTREETT 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 ADRSTREETT table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
