OILVBAP SAP (IS-Oil Append for Sales document items) Append Structure details
Description: IS-Oil Append for Sales document items
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_EXTBOL | External bill of lading | OID_EXTBOL | CHAR | 16 | OID_EXTBOL | ||||
OID_MISCDL | Miscellaneous delivery number | OID_MISCDL | CHAR | 16 | OID_MISCDL | ||||
OIPLANTD | Plant determination active or not active | OID_PLANTD | CHAR | 1 | OI0_XFELD | ||||
OIBYPASS | IS-Oil plant determination indicator: x=yes blank=no | OID_BYPASS | CHAR | 1 | OI0_SELKZ | ||||
OIEDOK | Excise duty validation indicator | OIH_EDOK | CHAR | 1 | X | ||||
CMETH | Quantity Conversion Method | OIB_CMETH | CHAR | 1 | OIB_CMETH | ||||
OITAXFROM | Excise duty tax key for 'from' location | OIH_TAXFRO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | CHAR | 2 | OIH5 | OIH_HANTYP | |||
OITAXGRP | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | OIH2 | OIH_TAXGRP | |||
OITAXTO | Excise duty tax key for 'to' location | OIH_TAXTO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OICERTF1 | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | OIH_CERTF1 | ||||
OIOILCON | Oil content in a material as a percentage | OIH_OILCON | DEC | 5(2) | OIH_OILCON | ||||
OIEDBAL | Excise duty balancing is required (indicator) | OIH_EDBAL | CHAR | 1 | X | ||||
OIPRICIE | ED pricing: external (indicator) | OIH_PRICIE | CHAR | 1 | X | ||||
OIINEX | Code for internal or external excise duty rate determination | OIH_INEX | CHAR | 2 | OIH16 | OIH_INEX | |||
OIEDBALM | Excise duty balancing method indicator | OIH_EDBALM | CHAR | 1 | OIH_EDBALM | ||||
OIDRC | Differential Reference Code (DRC) | OIC_DRC | CHAR | 5 | OICDC | NUMCV | OIC_DRC | ||
OIC_DRCTRY | DRC country | OIC_DRCTRY | CHAR | 3 | Assigned to domain | LAND1 | |||
OIC_DRCREG | DRC region | OIC_DRCREG | CHAR | 3 | Assigned to domain | REGIO | |||
OIMETIND | Metropolitan indicator | OIC_METIND | CHAR | 4 | Assigned to domain | NUMCV | OIC_METIND | ||
OIWAP | Wide-area pricing zone | OIC_WAP | CHAR | 3 | Assigned to domain | NUMCV | OIC_WAP | ||
OISLF | State license fee zone | OIC_SLF | CHAR | 3 | Assigned to domain | NUMCV | OIC_SLF | ||
OIPSDRC | Pricing DRC (grouping customers by DRC for pricing) | OIC_PSDRC | CHAR | 5 | Assigned to domain | NUMCV | OIC_DRC | OIQ | |
OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | OID_PIPEV | CHAR | 1 | X | ||||
OIC_LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
OIC_DCITYC | Destination city code | OIC_DCITYC | CHAR | 4 | T005G | CITYC | |||
OIC_DCOUNC | Destination county code | OIC_DCOUNC | CHAR | 3 | T005E | COUNC | |||
OIC_DREGIO | Destination region | OIC_DREGIO | CHAR | 3 | T005S | REGIO | |||
OIC_DLAND1 | Destination country | OIC_DLAND1 | CHAR | 3 | T005 | LAND1 | |||
OIC_OCITYC | Origin city code | OIC_OCITYC | CHAR | 4 | T005G | CITYC | |||
OIC_OCOUNC | Origin county code | OIC_OCOUNC | CHAR | 3 | T005E | COUNC | |||
OIC_OREGIO | Origin region | OIC_OREGIO | CHAR | 3 | T005S | REGIO | |||
OIC_OLAND1 | Origin country | OIC_OLAND1 | CHAR | 3 | T005 | LAND1 | |||
OIC_PORGIN | Tax origin | OIC_PORGIN | CHAR | 15 | OIC_PORGIN | ||||
OIC_PDESTN | Tax destination | OIC_PDESTN | CHAR | 15 | OIC_PDESTN | ||||
OIC_PTRIP | Pipeline trip number (external) | OIC_PTRIP | CHAR | 16 | OIC_PTRIP | ||||
OIC_PBATCH | Pipeline operatorĀ“s external batch number | OIC_PBATCH | CHAR | 16 | OIC_PBATCH | ||||
OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | CHAR | 2 | TVTR | VKTRA | |||
OIC_AORGIN | Alternate origin | OIC_AORGIN | CHAR | 15 | OIC_PORGIN | ||||
OIC_ADESTN | Alternate destination | OIC_ADESTN | CHAR | 15 | OIC_PDESTN | ||||
OIC_TRUCKN | Truck number | OIC_TRUCKN | CHAR | 10 | OIC_TRUCKN | ||||
OIA_BASELO | Base location | OIA_BASELO | CHAR | 15 | OIA_BASELO | ||||
OIEXGNUM | Exchange agreement number | OIA_EXGNUM | CHAR | 10 | Assigned to domain | ALPHA | OIA_EXGNUM | OI1 | OIAE |
OIEXGTYP | Exchange type | OIA_EXGTYP | CHAR | 4 | TOIA2 | OIA_EXGTYP | OI3 | ||
OIFEETOT | Fee total | OIA_FEETOT | CURR | 13(2) | OIA_FEETOT | ||||
OIFEEDT | Fee pricing condition date | OIA_FEEDT | DATS | 8 | DATUM | ||||
OINETCYC | Netting cycle (FI blocking indicator) | OIA_NETCYC | CHAR | 1 | T008 | ZAHLS | NTG | ||
OICONTNR | Outline agreement: contract | OIC_CONTNR | CHAR | 10 | Assigned to domain | ALPHA | VBELN | KTN | |
OIC_KMPOS | Reference contract line item number | OIC_KMPOS | NUMC | 6 | ALPHA | OIC_KMPOS | |||
OIFEECH | Fee edit control | OIA_FEECH | CHAR | 1 | OIA_FEECH | ||||
OIH_LICTP | License type | OIH_LICTP | CHAR | 4 | OIH20 | OIH_LICTP | OII | ||
OIH_LICIN | Excise tax internal license number | OIH_LICIN | CHAR | 10 | Assigned to domain | ALPHA | OIH_LICIN | OIH | OIHL |
OIH_LCFOL | Follow-on license for quantity license | OIH_LCFOL | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | ||
OIH_FOLQTY | Excise Tax Follow-On License Quantity | OIH_FOLQTY | QUAN | 13(3) | MENG13 | ||||
OISBREL | Sub product/ base product relevence indicator | OIA_SBREL | NUMC | 3 | OIA_SBREL | ||||
OIBASPROD | Base product number | OIA_SBMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
OIDMSG_PRD | Message type for product with contract restrictions | OIDMSG_PRD | CHAR | 1 | OIDMSG_PRD | ||||
OIDMSG_QTY | Message type for contract restrictions quantity | OIDMSG_QTY | CHAR | 1 | OIDMSG_PRD | ||||
OIDMSG_UOM | Message type for contract restrictions unit of measure | OIDMSG_UOM | CHAR | 1 | OIDMSG_PRD | ||||
OIDMSG_DAT | Message type for contract restrictions validity period | OIDMSG_DAT | CHAR | 1 | OIDMSG_PRD | ||||
OIDMSG_TRM | Message type for contract restrictions payment terms | OIDMSG_TRM | CHAR | 1 | OIDMSG_PRD | ||||
OIDMSG_SHP | Message type for contract restrictions ship-to party | OIDMSG_SHP | CHAR | 1 | OIDMSG_PRD | ||||
OIGNRULE | Gross/net pricing rule | OIC_GNRULE | NUMC | 3 | Assigned to domain | GRPNO | |||
OID_SHIP | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
OIBWTAR_IM | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
OIHANTYP_IM | Excise Duty Handling Type | OIH_HANTYP | CHAR | 2 | OIH5 | OIH_HANTYP | |||
OITAXGRP_IM | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | OIH2 | OIH_TAXGRP | |||
OITAXFROM_IM | Excise duty tax key for 'from' location | OIH_TAXFRO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OITAXTO_IM | Excise duty tax key for 'to' location | OIH_TAXTO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OIEDBAL_IM | Excise duty balancing is required (indicator) | OIH_EDBAL | CHAR | 1 | X | ||||
OIEDBALM_IM | Excise duty balancing method indicator | OIH_EDBALM | CHAR | 1 | OIH_EDBALM | ||||
OIPRICIE_IM | ED pricing: external (indicator) | OIH_PRICIE | CHAR | 1 | X | ||||
OIBWTAR_EX | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
OIHANTYP_EX | Excise Duty Handling Type | OIH_HANTYP | CHAR | 2 | OIH5 | OIH_HANTYP | |||
OITAXGRP_EX | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | OIH2 | OIH_TAXGRP | |||
OITAXFROM_EX | Excise duty tax key for 'from' location | OIH_TAXFRO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OITAXTO_EX | Excise duty tax key for 'to' location | OIH_TAXTO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OIEDBAL_EX | Excise duty balancing is required (indicator) | OIH_EDBAL | CHAR | 1 | X | ||||
OIEDBALM_EX | Excise duty balancing method indicator | OIH_EDBALM | CHAR | 1 | OIH_EDBALM | ||||
OIPRICIE_EX | ED pricing: external (indicator) | OIH_PRICIE | CHAR | 1 | X | ||||
OIINEX_EX | Code for internal or external excise duty rate determination | OIH_INEX | CHAR | 2 | OIH16 | OIH_INEX | |||
OICERTF1_EX | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | OIH_CERTF1 | ||||
OIH_LICTP_EX | License type | OIH_LICTP | CHAR | 4 | OIH20 | OIH_LICTP | OII | ||
OIH_LICIN_EX | Excise tax internal license number | OIH_LICIN | CHAR | 10 | Assigned to domain | ALPHA | OIH_LICIN | OIH | OIHL |
OIH_LCFOL_EX | Follow-on license for quantity license | OIH_LCFOL | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | ||
OIH_FOLQTY_EX | Excise Tax Follow-On License Quantity | OIH_FOLQTY | QUAN | 13(3) | MENG13 | ||||
OIHTAXRCP_EX | Tax Recipient | OIHTAXRCP | CHAR | 10 | ALPHA | KTONR | |||
OIHNOTWERKS | Cross Excise Duty Plant | OIH_SHADOWPL | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
OIHNOTLGORT | Cross Excise Duty Storage Location | OIH_SHADOWLOC | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
OIHCOTDISCH | Trigger Import Posting at Proof of Delivery Receipt | OIHCOTDISCH | CHAR | 1 | CHAR1_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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects