SAP Table OIH01A

Excise Duty Rates Table

OIH01A (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 OIH01A to other SAP tables.

OIH01A table fields

Field		Data element	Checktable	Datatype	Length	Decimals
MANDT	Client	MANDT	T000	CLNT	3	0
BUKRS	Company Code	BUKRS	T001	CHAR	4	0
OIH_LAND1	Country	OIH_LAND1	T005	CHAR	3	0
OIH_REGIO	Region	OIH_REGIO	T005S	CHAR	3	0
OIH_COUNC	County Code	OIH_COUNC	T005E	CHAR	3	0
OIH_CITYC	City code	OIH_CITYC	T005G	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

OIH01A foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
OIH01A	BUKRS	OIH01A	BUKRS	T001	Company Codes	BUKRS
OIH01A	BUKRS	OIH01A	MANDT	T001	Company Codes	MANDT
OIH01A	HANTYP	OIH01A	MANDT	OIH5	Definition of Excise Duty Handling Type (IS-OIL-TDP)	MANDT
OIH01A	HANTYP	OIH01A	HANTYP	OIH5	Definition of Excise Duty Handling Type (IS-OIL-TDP)	HANTYP
OIH01A	MANDT	OIH01A	MANDT	T000	Clients	MANDT
OIH01A	OIH_CITYC	OIH01A	OIH_CITYC	T005G	City	CITYC
OIH01A	OIH_CITYC	SYST	MANDT	T005G	City	MANDT
OIH01A	OIH_CITYC	OIH01A	OIH_LAND1	T005G	City	LAND1
OIH01A	OIH_CITYC	OIH01A	OIH_REGIO	T005G	City	REGIO
OIH01A	OIH_COUNC	OIH01A	OIH_REGIO	T005E	County	REGIO
OIH01A	OIH_COUNC	OIH01A	OIH_COUNC	T005E	County	COUNC
OIH01A	OIH_COUNC	SYST	MANDT	T005E	County	MANDT
OIH01A	OIH_COUNC	OIH01A	OIH_LAND1	T005E	County	LAND1
OIH01A	OIH_LAND1	SYST	MANDT	T005	Countries	MANDT
OIH01A	OIH_LAND1	OIH01A	OIH_LAND1	T005	Countries	LAND1
OIH01A	OIH_REGIO	SYST	MANDT	T005S	Taxes: Region (Province) Key	MANDT
OIH01A	OIH_REGIO	OIH01A	OIH_LAND1	T005S	Taxes: Region (Province) Key	LAND1
OIH01A	OIH_REGIO	OIH01A	OIH_REGIO	T005S	Taxes: Region (Province) Key	BLAND
OIH01A	QTYUT	OIH01A	MANDT	T006	Units of Measurement	MANDT
OIH01A	QTYUT	OIH01A	QTYUT	T006	Units of Measurement	MSEHI
OIH01A	TAXGRP	OIH01A	MANDT	OIH2	Excise duty tax group (IS-Oil TDP standard/core object)	MANDT
OIH01A	TAXGRP	OIH01A	TAXGRP	OIH2	Excise duty tax group (IS-Oil TDP standard/core object)	TAXGRP
OIH01A	WAERS	OIH01A	MANDT	TCURC	Currency Codes	MANDT
OIH01A	WAERS	OIH01A	WAERS	TCURC	Currency Codes	WAERS