SAP ABAP Table OIHL (License Master Data)

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	TRANSP	Transparent table
Transparent table	OIHL	Table Relationship Diagram
Short Description	License Master Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	LICIN	☑	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number
3	LICTP	☑	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
4	CERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	LCTXT	☐	OIH_LCTXT	OIH_LCTXT	CHAR	40	0	License text
7	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
8	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
9	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
12	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
13	LCOMP	☐	OIH_LCOMP	X	CHAR	1	0	Company-owned license
14	LCUST	☐	OIH_LCUST	X	CHAR	1	0	Customer license
15	LCJUR	☐	OIH_LCJUR	LIFNR	CHAR	10	0	Jurisdiction vendor number	LFA1
16	LICIA	☐	OIH_LICIA	X	CHAR	1	0	License inactive
17	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
18	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
19	LICMQ	☐	OIH_LICMQ	MENG13	QUAN	13	3	Maximum quantity for license
20	LQUSE	☐	OIH_LQUSE	MENG13	QUAN	13	3	License: Quantity used
21	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
22	LCMOT	☐	OIH_LCMOT	VKTRA	CHAR	2	0	Mode of transport	TVTR
23	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
24	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
26	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
27	ALTLC	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
28	HANTP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
29	LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	OIHL
30	LTOPQ	☐	OIH_LTOPQ	MENG13	QUAN	13	3	Top-up quantity
31	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
32	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
33	ERTIM	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
34	UPNAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
35	UPDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
36	UPTIM	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
37	EXEMP	☐	OIH_EXEMP	X	CHAR	1	0	Exemption license
38	DEFER	☐	OIH_DEFER	X	CHAR	1	0	Deferred payment (radio button)
39	REFLT	☐	OIH_REFLT	OIH_REFLT	CHAR	4	0	Reference license type
40	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
41	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIHL	AUART	TVAK	AUART
2	OIHL	BUKRS	T001	BUKRS
3	OIHL	CITYC	T005G	CITYC
4	OIHL	COUNC	T005E	COUNC
5	OIHL	HANTP	OIH5	HANTYP
6	OIHL	KUNNR	KNA1	KUNNR
7	OIHL	KVGR1	TVV1	KVGR1
8	OIHL	LAND1	T005	LAND1
9	OIHL	LCFOL	OIHL	LICIN
10	OIHL	LCJUR	LFA1	LIFNR
11	OIHL	LCMOT	TVTR	VKTRA
12	OIHL	LICTP	OIH20	LICTP
13	OIHL	LIFNR	LFA1	LIFNR
14	OIHL	MANDT	T000	MANDT
15	OIHL	MATNR	MARA	MATNR
16	OIHL	MEINS	T006	MSEHI
17	OIHL	MVGR2	TVM2	MVGR2
18	OIHL	REGIO	T005S	BLAND
19	OIHL	UMWRK	T001W	WERKS
20	OIHL	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in