I_TertiaryRegionText

Description of Tertiary Region | view: ITERTIARYRGNTXT | TEXT | Extraction: Not supported | Component: Address Management/Business Address
Tables used: ADRTOWNSHIPT
Column Name Description
Language FK Language Key
Country FK Country/Region Key
Region FK Region (State, Province, County)
SecondaryRegion FK County code for county
TertiaryRegion FK Township code for Township
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
TertiaryRegionName Township TEXT40
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • I_TERTIARYREGIONTEXT.COUNTRY == T005.LAND1
  • I_TERTIARYREGIONTEXT.MANDT == T005.MANDT
Language Key I_TERTIARYREGIONTEXT.LANGUAGE == T002.SPRAS
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_TERTIARYREGIONTEXT.COUNTRY == T005S.LAND1
  • I_TERTIARYREGIONTEXT.MANDT == T005S.MANDT
  • I_TERTIARYREGIONTEXT.REGION == T005S.BLAND
County code for county
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • County code for county
  • I_TERTIARYREGIONTEXT.COUNTRY == ADRCOUNTY.COUNTRY
  • I_TERTIARYREGIONTEXT.MANDT == ADRCOUNTY.CLIENT
  • I_TERTIARYREGIONTEXT.REGION == ADRCOUNTY.REGION
  • I_TERTIARYREGIONTEXT.SECONDARYREGION == ADRCOUNTY.COUNTY_CODE
Township code for Township
  • Country/Region Key
  • Township code for Township
  • Client
  • Region (State, Province, County)
  • County code for county
  • I_TERTIARYREGIONTEXT.COUNTRY == ADRTOWNSHIP.COUNTRY
  • I_TERTIARYREGIONTEXT.TERTIARYREGION == ADRTOWNSHIP.TOWNSHIP_CODE
  • I_TERTIARYREGIONTEXT.MANDT == ADRTOWNSHIP.CLIENT
  • I_TERTIARYREGIONTEXT.REGION == ADRTOWNSHIP.REGION
  • I_TERTIARYREGIONTEXT.SECONDARYREGION == ADRTOWNSHIP.COUNTY_CODE