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