SAP ABAP Table OIH_HTYPE (Import/Export to OIH_VAL_DEF_HANTYP)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIH (Package) TDP Tariffs, Duties and Permits

Basic Data

Table Category	INTTAB	Structure
Structure	OIH_HTYPE	Table Relationship Diagram
Short Description	Import/Export to OIH_VAL_DEF_HANTYP

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	AKTYP	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
2	HTSRC	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
3	IESRC	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
4	APPL	☐	PAPPL_D	PAPPL	CHAR	1	0	Applications programs, function modules, logical databases	*
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
8	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
9	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
10	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
11	AUFART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
12	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
13	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
14	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
15	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
16	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
17	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
18	OIH_TXR	☐	OIH_TXR	KUNNR	CHAR	10	0	Tax recipient	KNA1
19	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
20	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
21	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
22	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
23	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
24	PRSDT	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
25	HANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
26	TAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
27	TAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
28	TAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
29	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
30	SPLITVAL	☐	OAX	X	CHAR	1	0	Yes/No (X/ )
31	CERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
32	LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
33	LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
34	LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	*
35	DATFM1	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
36	DATTO1	☐	OIH_DATTO1	DATUM	DATS	8	0	Valid to date for excise duty tax certificate
37	VDSEQ	☐	OIH_EDDFLT	OIH_EDDFLT	CHAR	1	0	Excise duty default sequence indicator for SD documents
38	EDOK	☐	OIH_EDOK	X	CHAR	1	0	Excise duty validation indicator
39	ERRON	☐	OAX	X	CHAR	1	0	Yes/No (X/ )
40	ERRNO	☐	MESSAGE_D	CHAR4	CHAR	4	0	Error message
41	EDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
42	EDBALM	☐	OIH_EDBALM	OIH_EDBALM	CHAR	1	0	Excise duty balancing method indicator
43	INEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
44	PRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
45	VBAKINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
46	INEXSD	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
47	TABIX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
48	COMPLICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
49	ORDQTY	☐	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
50	BASEUOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
51	BASENUM	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
52	BASEDEN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
53	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
54	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
55	LICIN_DEL	☐	OAX	X	CHAR	1	0	Yes/No (X/ )
56	OIUMBAR	☐	OIH_UMBAR	BWTAR	CHAR	10	0	Valuation type of issuing location for two-step transfer	*
57	OIH_CHK_DATE	☐	OIH_DATF	DATUM_INV	CHAR	8	0	Date from which the tax rule is valid
58	.INCLUDE	☐				0	0	Region information
59	OIH_LAND1	☐	OIH_LAND1	LAND1	CHAR	3	0	Country	T005
60	OIH_REGIO	☐	OIH_REGIO	REGIO	CHAR	3	0	Region	T005S
61	OIH_COUNC	☐	OIH_COUNC	COUNC	CHAR	3	0	County Code	T005E
62	OIH_CITYC	☐	OIH_CITYC	CITYC	CHAR	4	0	City code	T005G

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIH_HTYPE	OIH_CITYC	T005G	CITYC
2	OIH_HTYPE	OIH_COUNC	T005E	COUNC
3	OIH_HTYPE	OIH_LAND1	T005	LAND1
4	OIH_HTYPE	OIH_REGIO	T005S	BLAND
5	OIH_HTYPE	OIH_TXR	KNA1	KUNNR

History

Last changed by/on	SAP	20130529
SAP Release Created in