SAP ABAP Table M_OIHLH (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_OIHLH	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LICTP	☑	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
3	REFLT	☑	OIH_REFLT	OIH_REFLT	CHAR	4	0	Reference license type
4	LICIN	☑	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number
5	CERTF1	☑	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
6	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
8	KVGR1	☑	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
9	DATAB	☑	DATAB	DATUM	DATS	8	0	Valid-From Date
10	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
11	MVGR2	☑	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
12	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
13	HANTP	☑	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
14	LCFOL	☑	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	OIHL
15	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	UMWRK	☑	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
17	WERKS0008	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	M_OIHLH	BUKRS	T001	BUKRS
2	M_OIHLH	HANTP	OIH5	HANTYP
3	M_OIHLH	KUNNR	KNA1	KUNNR
4	M_OIHLH	KVGR1	TVV1	KVGR1
5	M_OIHLH	LCFOL	OIHL	LICIN
6	M_OIHLH	LICTP	OIH20	LICTP
7	M_OIHLH	MANDT	T000	MANDT
8	M_OIHLH	MATNR	MARA	MATNR
9	M_OIHLH	MVGR2	TVM2	MVGR2
10	M_OIHLH	UMWRK	T001W	WERKS
11	M_OIHLH	WERKS	T001W	WERKS
12	M_OIHLH	WERKS0008	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in