OIH01A

Excise Duty Rates Table | #masterdata | Component: Tariffs, Duties and Permits
Column Name Description
MANDT FK Client
BUKRS FK Company Code
OIH_LAND1 FK Country/Region
OIH_REGIO FK Region
OIH_COUNC FK County Code
OIH_CITYC FK City code
TAXGRP FK Excise Duty Group
HANTYP FK Excise Duty Handling Type
DATUV Excise duty rate valid from date
Column Name Description
💲 Currency Key (WAERS):
TAXRT Excise duty tax rate
TAXRT1 Excise duty tax rate: element 1
TAXRT2 Excise duty tax rate: element 2
TAXRT3 Excise duty tax rate: element 3
TAXRT4 Excise duty tax rate: element 4
TAXRT5 Excise duty tax rate: element 5
TAXRT6 Excise duty tax rate: element 6
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
EDBASE Base quantity for excise duty rate DEC6
Master Data Relations Join Conditions
Company Code
  • OIH01A.MANDT == T001.MANDT
  • OIH01A.BUKRS == T001.BUKRS
Excise Duty Handling Type
  • Excise Duty Handling Type
  • Client
  • OIH01A.HANTYP == OIH5.HANTYP
  • OIH01A.MANDT == OIH5.MANDT
Client OIH01A.MANDT == T000.MANDT
City code
  • Region
  • City code
  • Client
  • Country/Region
  • OIH01A.OIH_REGIO == T005G.REGIO
  • OIH01A.OIH_CITYC == T005G.CITYC
  • OIH01A.MANDT == T005G.MANDT
  • OIH01A.OIH_LAND1 == T005G.LAND1
County Code
  • County Code
  • Country/Region
  • Region
  • OIH01A.MANDT == T005E.MANDT
  • OIH01A.OIH_COUNC == T005E.COUNC
  • OIH01A.OIH_LAND1 == T005E.LAND1
  • OIH01A.OIH_REGIO == T005E.REGIO
Country/Region
  • Country/Region
  • Client
  • OIH01A.OIH_LAND1 == T005.LAND1
  • OIH01A.MANDT == T005.MANDT
Region
  • Country/Region
  • Region
  • OIH01A.MANDT == T005S.MANDT
  • OIH01A.OIH_LAND1 == T005S.LAND1
  • OIH01A.OIH_REGIO == T005S.BLAND
Quantity unit of measure (liters, tons, kilos, etc.)
  • OIH01A.MANDT == T006.MANDT
  • OIH01A.QTYUT == T006.MSEHI
Excise Duty Group
  • OIH01A.MANDT == OIH2.MANDT
  • OIH01A.TAXGRP == OIH2.TAXGRP
Currency Key
  • OIH01A.MANDT == TCURC.MANDT
  • OIH01A.WAERS == TCURC.WAERS