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.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
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 |
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ADRSTREET | CITYP_CODE | ADRSTREET | CITYP_CODE |
ADRCITYPRT
Postal districts
|
CITYP_CODE |
| 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 | 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 | CLIENT |
T005
Countries
|
MANDT |
| ADRSTREET | COUNTRY | ADRSTREET | COUNTRY |
T005
Countries
|
LAND1 |
| ADRSTREET | REGIOGROUP | ADRSTREET | CLIENT |
ADRREGGRP
Regional structure grouping
|
CLIENT |
| ADRSTREET | REGIOGROUP | ADRSTREET | REGIOGROUP |
ADRREGGRP
Regional structure grouping
|
REGIOGROUP |
| ADRSTREET | STRTYPEAB | ADRSTREET | STRTYPEAB |
ADRSTRTYPE
Street type
|
STRTYPEAB |
| ADRSTREET | STRTYPEAB | ADRSTREET | CLIENT |
ADRSTRTYPE
Street type
|
CLIENT |
| ADRSTREET | STRTYPEAB | ADRSTREET | COUNTRY |
ADRSTRTYPE
Street type
|
COUNTRY |