OILVBAP SAP (IS-Oil Append for Sales document items) Append Structure details

Dictionary Type: Append Structure
Description: IS-Oil Append for Sales document items




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




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

OILVBAP is a standard SAP Append Structure which is used to store IS-Oil Append for Sales document items data and is available within R/3 SAP systems depending on the version and release level.

The OILVBAP table consists of various fields, each holding specific information or linking keys about IS-Oil Append for Sales document items data available in SAP. These include OID_EXTBOL (External bill of lading), OID_MISCDL (Miscellaneous delivery number), OIPLANTD (Plant determination active or not active), OIBYPASS (IS-Oil plant determination indicator: x=yes blank=no).. 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 OILVBAP append 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
OID_EXTBOLExternal bill of lading OID_EXTBOLCHAR16OID_EXTBOL
OID_MISCDLMiscellaneous delivery number OID_MISCDLCHAR16OID_MISCDL
OIPLANTDPlant determination active or not active OID_PLANTDCHAR1OI0_XFELD
OIBYPASSIS-Oil plant determination indicator: x=yes blank=no OID_BYPASSCHAR1OI0_SELKZ
OIEDOKExcise duty validation indicator OIH_EDOKCHAR1X
CMETHQuantity Conversion Method OIB_CMETHCHAR1OIB_CMETH
OITAXFROMExcise duty tax key for 'from' location OIH_TAXFROCHAR2OIH4OIH_TAXKEY
OIHANTYPExcise Duty Handling Type OIH_HANTYPCHAR2OIH5OIH_HANTYP
OITAXGRPExcise Duty Group OIH_TAXGRPCHAR2OIH2OIH_TAXGRP
OITAXTOExcise duty tax key for 'to' location OIH_TAXTOCHAR2OIH4OIH_TAXKEY
OICERTF1Excise tax external license number OIH_CERTF1CHAR15OIH_CERTF1
OIOILCONOil content in a material as a percentage OIH_OILCONDEC5(2) OIH_OILCON
OIEDBALExcise duty balancing is required (indicator) OIH_EDBALCHAR1X
OIPRICIEED pricing: external (indicator) OIH_PRICIECHAR1X
OIINEXCode for internal or external excise duty rate determination OIH_INEXCHAR2OIH16OIH_INEX
OIEDBALMExcise duty balancing method indicator OIH_EDBALMCHAR1OIH_EDBALM
OIDRCDifferential Reference Code (DRC) OIC_DRCCHAR5OICDCNUMCVOIC_DRC
OIC_DRCTRYDRC country OIC_DRCTRYCHAR3Assigned to domainLAND1
OIC_DRCREGDRC region OIC_DRCREGCHAR3Assigned to domainREGIO
OIMETINDMetropolitan indicator OIC_METINDCHAR4Assigned to domainNUMCVOIC_METIND
OIWAPWide-area pricing zone OIC_WAPCHAR3Assigned to domainNUMCVOIC_WAP
OISLFState license fee zone OIC_SLFCHAR3Assigned to domainNUMCVOIC_SLF
OIPSDRCPricing DRC (grouping customers by DRC for pricing) OIC_PSDRCCHAR5Assigned to domainNUMCVOIC_DRCOIQ
OIPIPEVALValidation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEVCHAR1X
OIC_LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
OIC_DCITYCDestination city code OIC_DCITYCCHAR4T005GCITYC
OIC_DCOUNCDestination county code OIC_DCOUNCCHAR3T005ECOUNC
OIC_DREGIODestination region OIC_DREGIOCHAR3T005SREGIO
OIC_DLAND1Destination country OIC_DLAND1CHAR3T005LAND1
OIC_OCITYCOrigin city code OIC_OCITYCCHAR4T005GCITYC
OIC_OCOUNCOrigin county code OIC_OCOUNCCHAR3T005ECOUNC
OIC_OREGIOOrigin region OIC_OREGIOCHAR3T005SREGIO
OIC_OLAND1Origin country OIC_OLAND1CHAR3T005LAND1
OIC_PORGINTax origin OIC_PORGINCHAR15OIC_PORGIN
OIC_PDESTNTax destination OIC_PDESTNCHAR15OIC_PDESTN
OIC_PTRIPPipeline trip number (external) OIC_PTRIPCHAR16OIC_PTRIP
OIC_PBATCHPipeline operatorĀ“s external batch number OIC_PBATCHCHAR16OIC_PBATCH
OIC_MOTIS-OIL MAP external details mode of transport OIC_MOTCHAR2TVTRVKTRA
OIC_AORGINAlternate origin OIC_AORGINCHAR15OIC_PORGIN
OIC_ADESTNAlternate destination OIC_ADESTNCHAR15OIC_PDESTN
OIC_TRUCKNTruck number OIC_TRUCKNCHAR10OIC_TRUCKN
OIA_BASELOBase location OIA_BASELOCHAR15OIA_BASELO
OIEXGNUMExchange agreement number OIA_EXGNUMCHAR10Assigned to domainALPHAOIA_EXGNUMOI1OIAE
OIEXGTYPExchange type OIA_EXGTYPCHAR4TOIA2OIA_EXGTYPOI3
OIFEETOTFee total OIA_FEETOTCURR13(2) OIA_FEETOT
OIFEEDTFee pricing condition date OIA_FEEDTDATS8DATUM
OINETCYCNetting cycle (FI blocking indicator) OIA_NETCYCCHAR1T008ZAHLSNTG
OICONTNROutline agreement: contract OIC_CONTNRCHAR10Assigned to domainALPHAVBELNKTN
OIC_KMPOSReference contract line item number OIC_KMPOSNUMC6ALPHAOIC_KMPOS
OIFEECHFee edit control OIA_FEECHCHAR1OIA_FEECH
OIH_LICTPLicense type OIH_LICTPCHAR4OIH20OIH_LICTPOII
OIH_LICINExcise tax internal license number OIH_LICINCHAR10Assigned to domainALPHAOIH_LICINOIHOIHL
OIH_LCFOLFollow-on license for quantity license OIH_LCFOLCHAR10OIHLALPHAOIH_LICIN
OIH_FOLQTYExcise Tax Follow-On License Quantity OIH_FOLQTYQUAN13(3) MENG13
OISBRELSub product/ base product relevence indicator OIA_SBRELNUMC3OIA_SBREL
OIBASPRODBase product number OIA_SBMATCHAR18Assigned to domainMATN1MATNR
OIDMSG_PRDMessage type for product with contract restrictions OIDMSG_PRDCHAR1OIDMSG_PRD
OIDMSG_QTYMessage type for contract restrictions quantity OIDMSG_QTYCHAR1OIDMSG_PRD
OIDMSG_UOMMessage type for contract restrictions unit of measure OIDMSG_UOMCHAR1OIDMSG_PRD
OIDMSG_DATMessage type for contract restrictions validity period OIDMSG_DATCHAR1OIDMSG_PRD
OIDMSG_TRMMessage type for contract restrictions payment terms OIDMSG_TRMCHAR1OIDMSG_PRD
OIDMSG_SHPMessage type for contract restrictions ship-to party OIDMSG_SHPCHAR1OIDMSG_PRD
OIGNRULEGross/net pricing rule OIC_GNRULENUMC3Assigned to domainGRPNO
OID_SHIPShip-to party KUNWECHAR10Assigned to domainALPHAKUNNR
OIBWTAR_IMValuation Type BWTAR_DCHAR10T149DBWTARBWT
OIHANTYP_IMExcise Duty Handling Type OIH_HANTYPCHAR2OIH5OIH_HANTYP
OITAXGRP_IMExcise Duty Group OIH_TAXGRPCHAR2OIH2OIH_TAXGRP
OITAXFROM_IMExcise duty tax key for 'from' location OIH_TAXFROCHAR2OIH4OIH_TAXKEY
OITAXTO_IMExcise duty tax key for 'to' location OIH_TAXTOCHAR2OIH4OIH_TAXKEY
OIEDBAL_IMExcise duty balancing is required (indicator) OIH_EDBALCHAR1X
OIEDBALM_IMExcise duty balancing method indicator OIH_EDBALMCHAR1OIH_EDBALM
OIPRICIE_IMED pricing: external (indicator) OIH_PRICIECHAR1X
OIBWTAR_EXValuation Type BWTAR_DCHAR10T149DBWTARBWT
OIHANTYP_EXExcise Duty Handling Type OIH_HANTYPCHAR2OIH5OIH_HANTYP
OITAXGRP_EXExcise Duty Group OIH_TAXGRPCHAR2OIH2OIH_TAXGRP
OITAXFROM_EXExcise duty tax key for 'from' location OIH_TAXFROCHAR2OIH4OIH_TAXKEY
OITAXTO_EXExcise duty tax key for 'to' location OIH_TAXTOCHAR2OIH4OIH_TAXKEY
OIEDBAL_EXExcise duty balancing is required (indicator) OIH_EDBALCHAR1X
OIEDBALM_EXExcise duty balancing method indicator OIH_EDBALMCHAR1OIH_EDBALM
OIPRICIE_EXED pricing: external (indicator) OIH_PRICIECHAR1X
OIINEX_EXCode for internal or external excise duty rate determination OIH_INEXCHAR2OIH16OIH_INEX
OICERTF1_EXExcise tax external license number OIH_CERTF1CHAR15OIH_CERTF1
OIH_LICTP_EXLicense type OIH_LICTPCHAR4OIH20OIH_LICTPOII
OIH_LICIN_EXExcise tax internal license number OIH_LICINCHAR10Assigned to domainALPHAOIH_LICINOIHOIHL
OIH_LCFOL_EXFollow-on license for quantity license OIH_LCFOLCHAR10OIHLALPHAOIH_LICIN
OIH_FOLQTY_EXExcise Tax Follow-On License Quantity OIH_FOLQTYQUAN13(3) MENG13
OIHTAXRCP_EXTax Recipient OIHTAXRCPCHAR10ALPHAKTONR
OIHNOTWERKSCross Excise Duty Plant OIH_SHADOWPLCHAR4Assigned to domainWERKSWRKH_T001W_C
OIHNOTLGORTCross Excise Duty Storage Location OIH_SHADOWLOCCHAR4Assigned to domainLGORTLAG
OIHCOTDISCHTrigger Import Posting at Proof of Delivery Receipt OIHCOTDISCHCHAR1CHAR1_X

Key field Non-key field



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

As OILVBAP 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 OILVBAP as there is no data to select. You could however select data from any tables that this append structure has been assigned too.

How to access SAP table OILVBAP

Within an ECC or HANA version of SAP you can also view further information about OILVBAP 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!