1. Home
  2. Resources
  3. SAP Tables
  4. OIH01 - Excise Duty Rates Table

SAP Table OIH01

Excise Duty Rates Table

OIH01 (Excise Duty Rates Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIH01 to other SAP tables.

Source: OIH01 (Excise Duty Rates Table)

OIH01 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
WERKS Plant WERKS_D T001W CHAR 4 0
TAXGRP Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0
HANTYP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
DATUV Excise duty rate valid from date OIH_DATFRO CHAR 8 0
TAXRT Excise duty tax rate OIH_TAXRT CURR 10 2
EDBASE Base quantity for excise duty rate OIH_EDBASE DEC 6 0
QTYUT Quantity unit of measure (liters, tons, kilos, etc.) OIH_QTYUT T006 UNIT 3 0
TAXRT1 Excise duty tax rate: element 1 OIH_TAXRT1 CURR 9 2
TAXRT2 Excise duty tax rate: element 2 OIH_TAXRT2 CURR 9 2
TAXRT3 Excise duty tax rate: element 3 OIH_TAXRT3 CURR 9 2
TAXRT4 Excise duty tax rate: element 4 OIH_TAXRT4 CURR 9 2
TAXRT5 Excise duty tax rate: element 5 OIH_TAXRT5 CURR 9 2
TAXRT6 Excise duty tax rate: element 6 OIH_TAXRT6 CURR 9 2
WAERS Currency Key WAERS TCURC CUKY 5 0

OIH01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIH01 BUKRS OIH01 MANDT T001 Company Codes MANDT
OIH01 BUKRS OIH01 BUKRS T001 Company Codes BUKRS
OIH01 HANTYP OIH01 MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
OIH01 HANTYP OIH01 HANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
OIH01 MANDT OIH01 MANDT T000 Clients MANDT
OIH01 QTYUT OIH01 MANDT T006 Units of Measurement MANDT
OIH01 QTYUT OIH01 QTYUT T006 Units of Measurement MSEHI
OIH01 TAXGRP OIH01 MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
OIH01 TAXGRP OIH01 TAXGRP OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
OIH01 WAERS OIH01 MANDT TCURC Currency Codes MANDT
OIH01 WAERS OIH01 WAERS TCURC Currency Codes WAERS
OIH01 WERKS OIH01 MANDT T001W Plants/Branches MANDT
OIH01 WERKS OIH01 WERKS T001W Plants/Branches WERKS