ADRSTRTKON

Franchise Contracts for Street | #other | Component: Regional structure
Column Name Description
CLIENT FK Client
COUNTRY FK Country/Region Key
STRT_CODE FK Street Number for City/Street File
HOUSENUM_H House number - upper limit of an interval
HSN_SUPP_H House number supplement - upper limit of an interval
HOUSENUM_L Haouse number - lower limit of an interval
HSN_SUPP_L House number supplement - lower limit of an interval
HSN_IND House number ID (even/odd/all) Show values
BUKRS FK Company Code
SPARTE FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
HSN_IND House number ID (even/odd/all) Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • ADRSTRTKON.CLIENT == T001.MANDT
  • ADRSTRTKON.BUKRS == T001.BUKRS
Client ADRSTRTKON.CLIENT == T000.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • ADRSTRTKON.COUNTRY == T005.LAND1
  • ADRSTRTKON.CLIENT == T005.MANDT
Franchise contract
  • ADRSTRTKON.CLIENT == EKON.MANDT
  • ADRSTRTKON.KONZVER == EKON.KONZVER
Division
  • ADRSTRTKON.CLIENT == TSPA.MANDT
  • ADRSTRTKON.SPARTE == TSPA.SPART
Street Number for City/Street File
  • Country/Region Key
  • Street Number for City/Street File