OIHL - License Master Data
License Master Data information is stored in SAP table OIHL.
It is part of development package OIH in software component IS-OIL-DS-TDP. This development package consists of objects that can be grouped under "TDP Tariffs, Duties and Permits".
It is part of development package OIH in software component IS-OIL-DS-TDP. This development package consists of objects that can be grouped under "TDP Tariffs, Duties and Permits".
Fields for table OIHL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| LICIN | Excise tax internal license number | X | OIH_LICIN | CHAR | 20 | |
| LICTP | License type | X | OIH_LICTP | CHAR | 8 | OIH20 |
| CERTF1 | Excise tax external license number | OIH_CERTF1 | CHAR | 30 | ||
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| LCTXT | License text | OIH_LCTXT | CHAR | 80 | ||
| KUNNR | Customer Number | KUNNR | CHAR | 20 | KNA1 | |
| KVGR1 | Customer Group 1 | KVGR1 | CHAR | 6 | TVV1 | |
| MVGR2 | Material Group 2 | MVGR2 | CHAR | 6 | TVM2 | |
| MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
| AUART | Sales Document Type | AUART | CHAR | 8 | TVAK | |
| LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | LFA1 | |
| LCOMP | Company-owned license | OIH_LCOMP | CHAR | 2 | ||
| LCUST | Customer license | OIH_LCUST | CHAR | 2 | ||
| LCJUR | Jurisdiction vendor number | OIH_LCJUR | CHAR | 20 | LFA1 | |
| LICIA | License inactive | OIH_LICIA | CHAR | 2 | ||
| DATAB | Valid-From Date | DATAB | DATS | 16 | ||
| DATBI | Valid To Date | DATBI | DATS | 16 | ||
| LICMQ | Maximum quantity for license | OIH_LICMQ | QUAN | 7 | ||
| LQUSE | License: Quantity used | OIH_LQUSE | QUAN | 7 | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| LCMOT | Mode of transport | OIH_LCMOT | CHAR | 4 | TVTR | |
| LAND1 | Country/Region Key | LAND1 | CHAR | 6 | T005 | |
| REGIO | Region (State, Province, County) | REGIO | CHAR | 6 | T005S | |
| COUNC | County Code | COUNC | CHAR | 6 | T005E | |
| CITYC | City Code | CITYC | CHAR | 8 | T005G | |
| ALTLC | Tax origin | OIC_PORGIN | CHAR | 30 | ||
| HANTP | Excise Duty Handling Type | OIH_HANTYP | CHAR | 4 | OIH5 | |
| LCFOL | Follow-on license for quantity license | OIH_LCFOL | CHAR | 20 | OIHL | |
| LTOPQ | Top-up quantity | OIH_LTOPQ | QUAN | 7 | ||
| ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
| ERTIM | Time of creation | OI0_ERTIM | TIMS | 12 | ||
| UPNAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
| UPDAT | Last Changed On | AEDAT | DATS | 16 | ||
| UPTIM | Time of day the record was changed | OI0_AETIM | TIMS | 12 | ||
| EXEMP | Exemption license | OIH_EXEMP | CHAR | 2 | ||
| DEFER | Deferred payment (radio button) | OIH_DEFER | CHAR | 2 | ||
| REFLT | Reference license type | OIH_REFLT | CHAR | 8 | ||
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| UMWRK | Receiving plant/issuing plant | UMWRK | CHAR | 8 | T001W |