E3OILO2 SAP (RO item OIL extension) Structure details

Dictionary Type: Structure
Description: RO item OIL extension




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




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

E3OILO2 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 "RO item OIL extension" 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_E3OILO2 TYPE E3OILO2.

The E3OILO2 table consists of various fields, each holding specific information or linking keys about RO item OIL extension data available in SAP. These include OID_MISCDL (Miscellaneous delivery number), OIPLANTD (Plant determination active or not active), OIBYPASS (IS-Oil plant determination indicator: x=yes blank=no), OIEDOK (Excise duty validation indicator).. 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: Cannot Be Enhanced


SAP E3OILO2 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_TAXFROCHAR2Assigned to domainOIH_TAXKEY
OIHANTYPExcise Duty Handling Type OIH_HANTYPCHAR2Assigned to domainOIH_HANTYP
OITAXGRPExcise Duty Group OIH_TAXGRPCHAR2Assigned to domainOIH_TAXGRP
OITAXTOExcise duty tax key for 'to' location OIH_TAXTOCHAR2Assigned to domainOIH_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_INEXCHAR2Assigned to domainOIH_INEX
OIEDBALMExcise duty balancing method indicator OIH_EDBALMCHAR1OIH_EDBALM
OIDRCDifferential Reference Code (DRC) OIC_DRCCHAR5Assigned to domainNUMCVOIC_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 LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
OIC_DCITYCDestination city code OIC_DCITYCCHAR4Assigned to domainCITYC
OIC_DCOUNCDestination county code OIC_DCOUNCCHAR3Assigned to domainCOUNC
OIC_DREGIODestination region OIC_DREGIOCHAR3Assigned to domainREGIO
OIC_DLAND1Destination country OIC_DLAND1CHAR3Assigned to domainLAND1
OIC_OCITYCOrigin city code OIC_OCITYCCHAR4Assigned to domainCITYC
OIC_OCOUNCOrigin county code OIC_OCOUNCCHAR3Assigned to domainCOUNC
OIC_OREGIOOrigin region OIC_OREGIOCHAR3Assigned to domainREGIO
OIC_OLAND1Origin country OIC_OLAND1CHAR3Assigned to domainLAND1
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_MOTCHAR2Assigned to domainVKTRA
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_EXGTYPCHAR4Assigned to domainOIA_EXGTYPOI3
OIFEETOTFee total OIA_FEETOTCURR13(2) OIA_FEETOT
OIFEEDTFee pricing condition date OIA_FEEDTDATS8DATUM
OINETCYCNetting cycle (FI blocking indicator) OIA_NETCYCCHAR1Assigned to domainZAHLSNTG
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_LICTPCHAR4Assigned to domainOIH_LICTPOII
OIH_LICINExcise tax internal license number OIH_LICINCHAR10Assigned to domainALPHAOIH_LICINOIHOIHL
OIH_LCFOLFollow-on license for quantity license OIH_LCFOLCHAR10Assigned to domainALPHAOIH_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

Key field Non-key field



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

As E3OILO2 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 E3OILO2 as there is no data to select.

How to access SAP table E3OILO2

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