ADRCITYKON

Franch. Contracts for City | #other | Component: Regional structure
Column Name Description
CLIENT FK Client
COUNTRY FK Country/Region Key
CITY_CODE FK City Code for City/Street File
BUKRS FK Company Code
SPARTE FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • ADRCITYKON.CLIENT == T001.MANDT
  • ADRCITYKON.BUKRS == T001.BUKRS
City Code for City/Street File
  • Country/Region Key
  • Client
  • City Code for City/Street File
  • ADRCITYKON.COUNTRY == ADRCITY.COUNTRY
  • ADRCITYKON.CLIENT == ADRCITY.CLIENT
  • ADRCITYKON.CITY_CODE == ADRCITY.CITY_CODE
Client ADRCITYKON.CLIENT == T000.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • ADRCITYKON.COUNTRY == T005.LAND1
  • ADRCITYKON.CLIENT == T005.MANDT
Franchise contract
  • ADRCITYKON.CLIENT == EKON.MANDT
  • ADRCITYKON.KONZVER == EKON.KONZVER
Division
  • ADRCITYKON.CLIENT == TSPA.MANDT
  • ADRCITYKON.SPARTE == TSPA.SPART