ADRSTREET

Streets | #masterdata | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
COUNTRY FK Country/Region Key
STRT_CODE Street Number for City/Street File
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
COMMU_CODE Municipality key COMMU_CODE
TAXJURCODE Tax Jurisdiction AD_TXJCD
Master Data Relations Join Conditions
City Code for City/Street File
  • Country/Region Key
  • Client
  • City Code for City/Street File
  • ADRSTREET.COUNTRY == ADRCITY.COUNTRY
  • ADRSTREET.CLIENT == ADRCITY.CLIENT
  • ADRSTREET.CITY_CODE == ADRCITY.CITY_CODE
Client ADRSTREET.CLIENT == T000.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • ADRSTREET.COUNTRY == T005.LAND1
  • ADRSTREET.CLIENT == T005.MANDT
Regional structure grouping
Street type abbreviation
  • Country/Region Key
  • Street type abbreviation
Other Relations | to Master Data Relations ↑ Join Conditions
District code for city and street file
  • Country/Region Key
  • City Code for City/Street File
  • District code for city and street file