SAP table reference
ADRSTREET
StreetsExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table ADRSTREET.
SAP table ADRSTREET has 3 primary key fields: CLIENT,COUNTRY,STRT_CODE.
/ Fields
ADRSTREET fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key COUNTRY | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| Key STRT_CODE | Street Number for City/Street File | CHAR | 12 | 0 | STRT_CODE | ||
| CITY_CODE | City Code for City/Street File | CHAR | 12 | 0 | ADRCITY | CITY_CODE | |
| CITYP_CODE | District code for city and street file | CHAR | 8 | 0 | ADRCITYPRT | CITYP_CODE | |
| STRTYPEAB | Street type abbreviation | CHAR | 2 | 0 | ADRSTRTYPE | STRTYPEAB | |
| COMMU_CODE | Municipality key | CHAR | 15 | 0 | COMMU_CODE | ||
| REGIOGROUP | Regional structure grouping | CHAR | 8 | 0 | ADRREGGRP | REGIOGROUP | |
| TAXJURCODE | Tax Jurisdiction | CHAR | 15 | 0 | AD_TXJCD |
/ Relationships
ADRSTREET relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| ADRSTREET | CITYP_CODE | ADRCITYPRT | Postal districts | CLIENT |
| ADRSTREET | CITYP_CODE | ADRCITYPRT | Postal districts | COUNTRY |
| ADRSTREET | CITYP_CODE | ADRCITYPRT | Postal districts | CITY_CODE |
| ADRSTREET | CITY_CODE | ADRCITY | Postal cities | COUNTRY |
| ADRSTREET | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRSTREET | CLIENT | T000 | Clients | MANDT |
| ADRSTREET | COUNTRY | T005 | Countries | MANDT |
| ADRSTREET | COUNTRY | T005 | Countries | LAND1 |
| ADRSTREET | REGIOGROUP | ADRREGGRP | Regional structure grouping | CLIENT |
| ADRSTREET | STRTYPEAB | ADRSTRTYPE | Street type | CLIENT |
| ADRSTREET | STRTYPEAB | ADRSTRTYPE | Street type | COUNTRY |