OIHLVB SAP (IS-OIL TDP: reference structure for XOIHL) Structure details

Dictionary Type: Structure
Description: IS-OIL TDP: reference structure for XOIHL




ABAP Code to SELECT data from OIHLVB
Related tables to OIHLVB
Access table OIHLVB




Structure field list including key, data, relationships and ABAP select examples

OIHLVB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IS-OIL TDP: reference structure for XOIHL" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_OIHLVB TYPE OIHLVB.

The OIHLVB table consists of various fields, each holding specific information or linking keys about IS-OIL TDP: reference structure for XOIHL data available in SAP. These include MANDT (Client), LICIN (Excise tax internal license number), LICTP (License type), CERTF1 (Excise tax external license number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIHLVB structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LICINExcise tax internal license number OIH_LICINCHAR10Assigned to domainALPHAOIH_LICINOIHOIHL
LICTPLicense type OIH_LICTPCHAR4OIH20OIH_LICTPOII
CERTF1Excise tax external license number OIH_CERTF1CHAR15OIH_CERTF1
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
LCTXTLicense text OIH_LCTXTCHAR40OIH_LCTXT
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
KVGR1Customer group 1 KVGR1CHAR3TVV1KVGR1
MVGR2Material group 2 MVGR2CHAR3TVM2MVGR2
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
AUARTSales Document Type AUARTCHAR4TVAKAUARTAUARTAAT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
LCOMPCompany-owned license OIH_LCOMPCHAR1X
LCUSTCustomer license OIH_LCUSTCHAR1X
LCJURJurisdiction vendor number OIH_LCJURCHAR10LFA1ALPHALIFNR
LICIALicense inactive OIH_LICIACHAR1X
DATABValid-From Date DATABDATS8DATUM
DATBIValid To Date DATBIDATS8DATUM
LICMQMaximum quantity for license OIH_LICMQQUAN13(3) MENG13
LQUSELicense: Quantity used OIH_LQUSEQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
LCMOTMode of transport OIH_LCMOTCHAR2TVTRVKTRA
LAND1Country Key LAND1CHAR3T005LAND1LND
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
COUNCCounty Code COUNCCHAR3T005ECOUNC
CITYCCity Code CITYCCHAR4T005GCITYC
ALTLCTax origin OIC_PORGINCHAR15OIC_PORGIN
HANTPExcise Duty Handling Type OIH_HANTYPCHAR2OIH5OIH_HANTYP
LCFOLFollow-on license for quantity license OIH_LCFOLCHAR10OIHLALPHAOIH_LICIN
LTOPQTop-up quantity OIH_LTOPQQUAN13(3) MENG13
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERTIMTime of creation OI0_ERTIMTIMS6UZEIT
UPNAMName of Person Who Changed Object AENAMCHAR12USNAM
UPDATChanged On AEDATDATS8DATUM
UPTIMTime of day the record was changed OI0_AETIMTIMS6UZEIT
EXEMPExemption license OIH_EXEMPCHAR1X
DEFERDeferred payment (radio button) OIH_DEFERCHAR1X
REFLTReference license type OIH_REFLTCHAR4OIH_REFLT
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
UMWRKReceiving/Issuing Plant UMWRKCHAR4T001WWERKS
UPDKZUpdate indicator UPDKZ_DCHAR1UPDKZ

Key field Non-key field



How do I retrieve data from SAP structure OIHLVB using ABAP code?

As OIHLVB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on OIHLVB as there is no data to select.

How to access SAP table OIHLVB

Within an ECC or HANA version of SAP you can also view further information about OIHLVB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!