ADRSTREET is a standard SAP table in SAP ECC (or) S/4HANA which stores Streets data. There are total 9 fields in ADRSTREET table.This blog post provides key technical details of SAP table ADRSTREET, including its availability across SAP S/4HANA versions and the list of CDS views for ADRSTREET 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 ADRSTREET Table Fields
The following is the list of fields that are available in SAP ADRSTREET 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) |
COUNTRY | Country/Region Key | LAND1 | LAND1 | T005 | CHAR (3) |
STRT_CODE | Street Number for City/Street File | STRT_CODE | STRT_CODE | CHAR (12) | |
CITY_CODE | City Code for City/Street File | CITY_CODE | CITY_CODE | ADRCITY | CHAR (12) |
CITYP_CODE | District code for city and street file | CITYP_CODE | CITYP_CODE | ADRCITYPRT | CHAR (8) |
STRTYPEAB | Street type abbreviation | STRTYPEAB | STRTYPEAB | ADRSTRTYPE | CHAR (2) |
COMMU_CODE | Municipality key | COMMU_CODE | COMMU_CODE | CHAR (15) | |
REGIOGROUP | Regional structure grouping | REGIOGROUP | REGIOGROUP | ADRREGGRP | CHAR (8) |
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | AD_TXJCD | CHAR (15) |
Availability
The SAP table ADRSTREET 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 ADRSTREET table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.