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 | Possible values | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
LCUST
Customer license
|
OIH_LCUST |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
LCJUR
Jurisdiction vendor number
|
OIH_LCJUR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||
|
LICIA
License inactive
|
OIH_LICIA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
DEFER
Deferred payment (radio button)
|
OIH_DEFER |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
REFLT
Reference license type
|
OIH_REFLT |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
|
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 |