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 |
Possible values
|
||||||||||||||||||||||||
| LCUST | Customer license | OIH_LCUST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| LCJUR | Jurisdiction vendor number | OIH_LCJUR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||
| LICIA | License inactive | OIH_LICIA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||
| DEFER | Deferred payment (radio button) | OIH_DEFER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| REFLT | Reference license type | OIH_REFLT | CHAR | 4 | 0 |
Possible values
|
||||||||||||||||||||||||
| 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 | MANDT | TVAK | Sales Document Types | MANDT |
| OIHL | AUART | OIHL | AUART | TVAK | Sales Document Types | AUART |
| OIHL | BUKRS | OIHL | MANDT | T001 | Company Codes | MANDT |
| OIHL | BUKRS | OIHL | BUKRS | T001 | Company Codes | BUKRS |
| OIHL | CITYC | OIHL | CITYC | T005G | City | CITYC |
| OIHL | CITYC | OIHL | MANDT | T005G | City | MANDT |
| OIHL | CITYC | OIHL | LAND1 | T005G | City | LAND1 |
| OIHL | CITYC | OIHL | REGIO | T005G | City | REGIO |
| OIHL | COUNC | OIHL | REGIO | T005E | County | REGIO |
| OIHL | COUNC | OIHL | COUNC | T005E | County | COUNC |
| OIHL | COUNC | OIHL | MANDT | T005E | County | MANDT |
| OIHL | COUNC | OIHL | LAND1 | T005E | County | LAND1 |
| OIHL | HANTP | OIHL | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
| OIHL | HANTP | OIHL | HANTP | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
| 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 | LCMOT | TVTR | Routes: Modes of Transport | VKTRA |
| OIHL | LCMOT | OIHL | MANDT | TVTR | Routes: Modes of Transport | MANDT |
| 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 | MEINS | T006 | Units of Measurement | MSEHI |
| OIHL | MEINS | OIHL | MANDT | T006 | Units of Measurement | MANDT |
| 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 |
