I_PrepaymentCityCodeText

City Code Text | view: IPPACITYCODETXT | TEXT | Extraction: Not supported | Component: Prepayment agreements
Tables used: T005H
Column Name Description
Region FK Region (State, Province, County)
Country FK Country/Region Key
CityCode FK City Code
Language FK Language Key
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CityCodeName Description TEXT20
Master Data Relations Join Conditions
City Code
  • Client
  • City Code
  • Region (State, Province, County)
  • Country/Region Key
  • I_PREPAYMENTCITYCODETEXT.MANDT == T005G.MANDT
  • I_PREPAYMENTCITYCODETEXT.CITYCODE == T005G.CITYC
  • I_PREPAYMENTCITYCODETEXT.REGION == T005G.REGIO
  • I_PREPAYMENTCITYCODETEXT.COUNTRY == T005G.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • I_PREPAYMENTCITYCODETEXT.MANDT == T005.MANDT
  • I_PREPAYMENTCITYCODETEXT.COUNTRY == T005.LAND1
Language Key I_PREPAYMENTCITYCODETEXT.LANGUAGE == T002.SPRAS
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_PREPAYMENTCITYCODETEXT.MANDT == T005S.MANDT
  • I_PREPAYMENTCITYCODETEXT.REGION == T005S.BLAND
  • I_PREPAYMENTCITYCODETEXT.COUNTRY == T005S.LAND1