SAP table OIH01 (Excise Duty Rates Table)

SAP table OIH01 has 6 primary key fields being MANDT,BUKRS,WERKS,TAXGRP,HANTYP,DATUV.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

OIH01 foreign key relationships

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