SAP table OIHL (License Master Data)

SAP table OIHL has 3 primary key fields being MANDT,LICIN,LICTP.

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
LICIN Excise tax internal license number CHAR 10 0 OIH_LICIN
LICTP License type CHAR 4 0 OIH20 OIH_LICTP
CERTF1 Excise tax external license number CHAR 15 0 OIH_CERTF1
BUKRS Company Code CHAR 4 0 T001 BUKRS
LCTXT License text CHAR 40 0 OIH_LCTXT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
KVGR1 Customer Group 1 CHAR 3 0 TVV1 KVGR1
MVGR2 Material Group 2 CHAR 3 0 TVM2 MVGR2
MATNR Material Number CHAR 40 0 MARA MATNR
AUART Sales Document Type CHAR 4 0 TVAK AUART
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LCOMP Company-owned license CHAR 1 0 OIH_LCOMP
LCUST Customer license CHAR 1 0 OIH_LCUST
LCJUR Jurisdiction vendor number CHAR 10 0 LFA1 OIH_LCJUR
LICIA License inactive CHAR 1 0 OIH_LICIA
DATAB Valid-From Date DATS 8 0 DATAB
DATBI Valid To Date DATS 8 0 DATBI
LICMQ Maximum quantity for license QUAN 13 3 OIH_LICMQ
LQUSE License: Quantity used QUAN 13 3 OIH_LQUSE
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
LCMOT Mode of transport CHAR 2 0 TVTR OIH_LCMOT
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
COUNC County Code CHAR 3 0 T005E COUNC
CITYC City Code CHAR 4 0 T005G CITYC
ALTLC Tax origin CHAR 15 0 OIC_PORGIN
HANTP Excise Duty Handling Type CHAR 2 0 OIH5 OIH_HANTYP
LCFOL Follow-on license for quantity license CHAR 10 0 OIHL OIH_LCFOL
LTOPQ Top-up quantity QUAN 13 3 OIH_LTOPQ
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERTIM Time of creation TIMS 6 0 OI0_ERTIM
UPNAM Name of Person Who Changed Object CHAR 12 0 AENAM
UPDAT Last Changed On DATS 8 0 AEDAT
UPTIM Time of day the record was changed TIMS 6 0 OI0_AETIM
EXEMP Exemption license CHAR 1 0 OIH_EXEMP
DEFER Deferred payment (radio button) CHAR 1 0 OIH_DEFER
REFLT Reference license type CHAR 4 0 OIH_REFLT
0001 Excise duty
0002 Federal excise tax
0003 State excise tax
0004 County excise tax
0005 City excise tax
0006 Other North American tax
0007 Vendor licence
0008 Pre-paid permit
0009 Duty-free permit
0010 Excise duty license enhanced
0011 Excise duty region based
WERKS Plant CHAR 4 0 T001W WERKS_D
UMWRK Receiving plant/issuing plant CHAR 4 0 T001W UMWRK

OIHL foreign key relationships

Table Field Check Table Check Field
0 OIHL AUART TVAK Sales Document Types MANDT
0 OIHL AUART TVAK Sales Document Types AUART
1 OIHL BUKRS T001 Company Codes BUKRS
0 OIHL CITYC T005G City MANDT
0 OIHL CITYC T005G City LAND1
0 OIHL CITYC T005G City REGIO
0 OIHL CITYC T005G City CITYC
1 OIHL COUNC T005E County MANDT
1 OIHL COUNC T005E County LAND1
1 OIHL COUNC T005E County REGIO
1 OIHL COUNC T005E County COUNC
0 OIHL HANTP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
0 OIHL HANTP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
1 OIHL KUNNR KNA1 General Data in Customer Master MANDT
1 OIHL KUNNR KNA1 General Data in Customer Master KUNNR
0 OIHL KVGR1 TVV1 Customer Group 1 MANDT
0 OIHL KVGR1 TVV1 Customer Group 1 KVGR1
1 OIHL LAND1 T005 Countries MANDT
1 OIHL LAND1 T005 Countries LAND1
0 OIHL LCFOL OIHL License Master Data LICIN
0 OIHL LCFOL OIHL License Master Data LICTP
1 OIHL LCJUR LFA1 Supplier Master (General Section) MANDT
1 OIHL LCJUR LFA1 Supplier Master (General Section) LIFNR
0 OIHL LCMOT TVTR Routes: Modes of Transport MANDT
0 OIHL LCMOT TVTR Routes: Modes of Transport VKTRA
1 OIHL LICTP OIH20 License types MANDT
0 OIHL LIFNR LFA1 Supplier Master (General Section) MANDT
0 OIHL LIFNR LFA1 Supplier Master (General Section) LIFNR
1 OIHL MANDT T000 Clients MANDT
0 OIHL MATNR MARA General Material Data MANDT
0 OIHL MATNR MARA General Material Data MATNR
1 OIHL MEINS T006 Units of Measurement MANDT
1 OIHL MEINS T006 Units of Measurement MSEHI
0 OIHL MVGR2 TVM2 Material Pricing Group 2 MVGR2
1 OIHL REGIO T005S Taxes: Region (Province) Key LAND1
0 OIHL UMWRK T001W Plants/Branches WERKS
1 OIHL WERKS T001W Plants/Branches MANDT
1 OIHL WERKS T001W Plants/Branches WERKS