OIH22

Interstate excise table | #other | Component: Tariffs, Duties and Permits
Column Name Description
MANDT FK Client
KSCHL FK Condition Type
LAND1 FK Country/Region Key
REGIO FK Region (State, Province, County)
COUNC FK County Code
CITYC FK City Code
Column Name Description
Column Name Description
Column Name Description
DATAB Valid-From Date
DATBI Valid To Date
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • OIH22.REGIO == T005G.REGIO
  • OIH22.CITYC == T005G.CITYC
  • OIH22.MANDT == T005G.MANDT
  • OIH22.LAND1 == T005G.LAND1
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • OIH22.MANDT == T005E.MANDT
  • OIH22.COUNC == T005E.COUNC
  • OIH22.LAND1 == T005E.LAND1
  • OIH22.REGIO == T005E.REGIO
Condition Type
  • Condition Type
  • Client
  • ?
  • ?
  • OIH22.KSCHL == T685.KSCHL
  • OIH22.MANDT == T685.MANDT
  • OIH22.[column in domain "KVEWE"] == T685.KVEWE
  • OIH22.[column in domain "KAPPL"] == T685.KAPPL
Country/Region Key
  • Country/Region Key
  • Client
  • OIH22.LAND1 == T005.LAND1
  • OIH22.MANDT == T005.MANDT
Client OIH22.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • OIH22.MANDT == T005S.MANDT
  • OIH22.LAND1 == T005S.LAND1
  • OIH22.REGIO == T005S.BLAND