SAP Table ADRSTREET
Streets
ADRSTREET (Streets) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ADRSTREET to other SAP tables.
ADRSTREET table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||
| STRT_CODE | Street Number for City/Street File | STRT_CODE | CHAR | 12 | 0 | |||
| CITY_CODE | City Code for City/Street File | CITY_CODE | ADRCITY | CHAR | 12 | 0 | ||
| CITYP_CODE | District code for city and street file | CITYP_CODE | ADRCITYPRT | CHAR | 8 | 0 | ||
| STRTYPEAB | Street type abbreviation | STRTYPEAB | ADRSTRTYPE | CHAR | 2 | 0 | ||
| COMMU_CODE | Municipality key | COMMU_CODE | CHAR | 15 | 0 | |||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 8 | 0 | ||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | 0 | |||
ADRSTREET foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADRSTREET | CITYP_CODE | ADRSTREET | CLIENT | ADRCITYPRT | Postal districts | CLIENT |
| ADRSTREET | CITYP_CODE | ADRSTREET | COUNTRY | ADRCITYPRT | Postal districts | COUNTRY |
| ADRSTREET | CITYP_CODE | ADRSTREET | CITY_CODE | ADRCITYPRT | Postal districts | CITY_CODE |
| ADRSTREET | CITYP_CODE | ADRSTREET | CITYP_CODE | ADRCITYPRT | Postal districts | CITYP_CODE |
| ADRSTREET | CITY_CODE | ADRSTREET | CLIENT | ADRCITY | Postal cities | CLIENT |
| ADRSTREET | CITY_CODE | ADRSTREET | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADRSTREET | CITY_CODE | ADRSTREET | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADRSTREET | CLIENT | ADRSTREET | CLIENT | T000 | Clients | MANDT |
| ADRSTREET | COUNTRY | ADRSTREET | COUNTRY | T005 | Countries | LAND1 |
| ADRSTREET | COUNTRY | ADRSTREET | CLIENT | T005 | Countries | MANDT |
| ADRSTREET | REGIOGROUP | ADRSTREET | REGIOGROUP | ADRREGGRP | Regional structure grouping | REGIOGROUP |
| ADRSTREET | REGIOGROUP | ADRSTREET | CLIENT | ADRREGGRP | Regional structure grouping | CLIENT |
| ADRSTREET | STRTYPEAB | ADRSTREET | CLIENT | ADRSTRTYPE | Street type | CLIENT |
| ADRSTREET | STRTYPEAB | ADRSTREET | COUNTRY | ADRSTRTYPE | Street type | COUNTRY |
| ADRSTREET | STRTYPEAB | ADRSTREET | STRTYPEAB | ADRSTRTYPE | Street type | STRTYPEAB |
