SAP Table ADRSTREET (Streets)

SAP table ADRSTREET has 3 primary key fields being CLIENT,COUNTRY,STRT_CODE.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
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

ADRSTREET foreign key relationships

Table Field Check Table Check Field
0 ADRSTREET CITYP_CODE ADRCITYPRT Postal districts CLIENT
0 ADRSTREET CITYP_CODE ADRCITYPRT Postal districts COUNTRY
0 ADRSTREET CITYP_CODE ADRCITYPRT Postal districts CITY_CODE
1 ADRSTREET CITY_CODE ADRCITY Postal cities COUNTRY
1 ADRSTREET CITY_CODE ADRCITY Postal cities CITY_CODE
0 ADRSTREET CLIENT T000 Clients MANDT
1 ADRSTREET COUNTRY T005 Countries MANDT
1 ADRSTREET COUNTRY T005 Countries LAND1
0 ADRSTREET REGIOGROUP ADRREGGRP Regional structure grouping CLIENT
1 ADRSTREET STRTYPEAB ADRSTRTYPE Street type CLIENT
1 ADRSTREET STRTYPEAB ADRSTRTYPE Street type COUNTRY