SAP Table OIHL

License Master Data

OIHL (License Master Data) 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 OIHL to other SAP tables.

OIHL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LICIN Excise tax internal license number OIH_LICIN CHAR 10 0
LICTP License type OIH_LICTP OIH20 CHAR 4 0
CERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
BUKRS Company Code BUKRS T001 CHAR 4 0
LCTXT License text OIH_LCTXT CHAR 40 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
KVGR1 Customer group 1 KVGR1 TVV1 CHAR 3 0
MVGR2 Material group 2 MVGR2 TVM2 CHAR 3 0
MATNR Material Number MATNR MARA CHAR 18 0
AUART Sales Document Type AUART TVAK CHAR 4 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
LCOMP Company-owned license OIH_LCOMP CHAR 1 0
X Yes
NULL No
LCUST Customer license OIH_LCUST CHAR 1 0
X Yes
NULL No
LCJUR Jurisdiction vendor number OIH_LCJUR LFA1 CHAR 10 0
LICIA License inactive OIH_LICIA CHAR 1 0
X Yes
NULL No
DATAB Valid-From Date DATAB DATS 8 0
DATBI Valid To Date DATBI DATS 8 0
LICMQ Maximum quantity for license OIH_LICMQ QUAN 13 3
LQUSE License: Quantity used OIH_LQUSE QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
LCMOT Mode of transport OIH_LCMOT TVTR CHAR 2 0
LAND1 Country Key LAND1 T005 CHAR 3 0
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
COUNC County Code COUNC T005E CHAR 3 0
CITYC City Code CITYC T005G CHAR 4 0
ALTLC Tax origin OIC_PORGIN CHAR 15 0
HANTP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
LCFOL Follow-on license for quantity license OIH_LCFOL OIHL CHAR 10 0
LTOPQ Top-up quantity OIH_LTOPQ QUAN 13 3
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERTIM Time of creation OI0_ERTIM TIMS 6 0
UPNAM Name of Person Who Changed Object AENAM CHAR 12 0
UPDAT Changed On AEDAT DATS 8 0
UPTIM Time of day the record was changed OI0_AETIM TIMS 6 0
EXEMP Exemption license OIH_EXEMP CHAR 1 0
X Yes
NULL No
DEFER Deferred payment (radio button) OIH_DEFER CHAR 1 0
X Yes
NULL No
REFLT Reference license type OIH_REFLT CHAR 4 0
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 WERKS_D T001W CHAR 4 0
UMWRK Receiving/Issuing Plant UMWRK T001W CHAR 4 0

OIHL foreign key relationships

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