OIHL

License Master Data | #masterdata | Component: Tariffs, Duties and Permits
Column Name Description
MANDT FK Client
LICIN Excise tax internal license number
LICTP FK License type
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
LICMQ Maximum quantity for license
LQUSE License: Quantity used
LTOPQ Top-up quantity
Column Name Description
DATAB Valid-From Date
DATBI Valid To Date
ERDAT Date on which the record was created
ERTIM Time of creation
UPDAT Last Changed On
UPTIM Time of day the record was changed
Column Name Description
LCOMP Company-owned license Show values
LCUST Customer license Show values
LICIA License inactive Show values
EXEMP Exemption license Show values
DEFER Deferred payment (radio button) Show values
REFLT Reference license type Show values
Column Name Description Domain name
CERTF1 Excise tax external license number OIH_CERTF1
LCTXT License text OIH_LCTXT
ALTLC Tax origin OIC_PORGIN
ERNAM Name of Person Responsible for Creating the Object USNAM
UPNAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Sales Document Type
  • OIHL.MANDT == TVAK.MANDT
  • OIHL.AUART == TVAK.AUART
Company Code
  • OIHL.MANDT == T001.MANDT
  • OIHL.BUKRS == T001.BUKRS
City Code
  • Region (State, Province, County)
  • City Code
  • Client
  • Country/Region Key
  • OIHL.REGIO == T005G.REGIO
  • OIHL.CITYC == T005G.CITYC
  • OIHL.MANDT == T005G.MANDT
  • OIHL.LAND1 == T005G.LAND1
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • OIHL.MANDT == T005E.MANDT
  • OIHL.COUNC == T005E.COUNC
  • OIHL.LAND1 == T005E.LAND1
  • OIHL.REGIO == T005E.REGIO
Excise Duty Handling Type
  • Excise Duty Handling Type
  • Client
  • OIHL.HANTP == OIH5.HANTYP
  • OIHL.MANDT == OIH5.MANDT
Customer Number
  • OIHL.MANDT == KNA1.MANDT
  • OIHL.KUNNR == KNA1.KUNNR
Customer Group 1
  • OIHL.MANDT == TVV1.MANDT
  • OIHL.KVGR1 == TVV1.KVGR1
Country/Region Key
  • Country/Region Key
  • Client
  • OIHL.LAND1 == T005.LAND1
  • OIHL.MANDT == T005.MANDT
Follow-on license for quantity license
  • License type
  • Follow-on license for quantity license
  • OIHL.MANDT == OIHL.MANDT
  • OIHL.LICTP == OIHL.LICTP
  • OIHL.LCFOL == OIHL.LICIN
Jurisdiction vendor number
  • OIHL.MANDT == LFA1.MANDT
  • OIHL.LCJUR == LFA1.LIFNR
Mode of transport
  • OIHL.MANDT == TVTR.MANDT
  • OIHL.LCMOT == TVTR.VKTRA
License type
  • OIHL.MANDT == OIH20.MANDT
  • OIHL.LICTP == OIH20.LICTP
Account Number of Supplier
  • OIHL.MANDT == LFA1.MANDT
  • OIHL.LIFNR == LFA1.LIFNR
Client OIHL.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIHL.MATNR == MARA.MATNR
  • OIHL.MANDT == MARA.MANDT
Base Unit of Measure
  • OIHL.MANDT == T006.MANDT
  • OIHL.MEINS == T006.MSEHI
Material Group 2
  • Material Group 2
  • Client
  • OIHL.MVGR2 == TVM2.MVGR2
  • OIHL.MANDT == TVM2.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • OIHL.MANDT == T005S.MANDT
  • OIHL.LAND1 == T005S.LAND1
  • OIHL.REGIO == T005S.BLAND
Receiving plant/issuing plant
  • OIHL.MANDT == T001W.MANDT
  • OIHL.UMWRK == T001W.WERKS
Plant
  • OIHL.MANDT == T001W.MANDT
  • OIHL.WERKS == T001W.WERKS