E3OILO0 SAP (Header extension for PO OIL case) Structure details

Dictionary Type: Structure
Description: Header extension for PO OIL case




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




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

E3OILO0 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 "Header extension for PO OIL case" 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_E3OILO0 TYPE E3OILO0.

The E3OILO0 table consists of various fields, each holding specific information or linking keys about Header extension for PO OIL case data available in SAP. These include OID_MISCDL (Miscellaneous delivery number), OIDMSG_SHP (Message type for contract restrictions ship-to party), OIDSTS_SHP (Status of contract restriction for ship-to party), OIPIPEVAL (Validation indicator for pipeline fields (X=ON, blank=OFF)).. 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 E3OILO0 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
OIDMSG_SHPMessage type for contract restrictions ship-to party OIDMSG_SHPCHAR1OIDMSG_PRD
OIDSTS_SHPStatus of contract restriction for ship-to party OIDSTS_SHPCHAR1CHAR1_X
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
OIINEXCode for internal or external excise duty rate determination OIH_INEXCHAR2Assigned to domainOIH_INEX
OIISOILSales order created by IS-Oil: X=Yes BLANK=No OID_ISOILCHAR1OI0_XFELD
OIPTRFNCPartner function OID_PTRFNCCHAR2Assigned to domainPARVWPARVW
OIPARTNRCustomer name (sold-to party or ship-to party) OID_PARTNRCHAR10Assigned to domainALPHAKUNNR
OILASTORLast order number OID_LASTORCHAR10Assigned to domainALPHAVBELN
OIDRCDifferential Reference Code (DRC) OIC_DRCCHAR5Assigned to domainNUMCVOIC_DRC
OIEXGNUMExchange agreement number OIA_EXGNUMCHAR10Assigned to domainALPHAOIA_EXGNUMOI1OIAE
OIEXGTYPExchange type OIA_EXGTYPCHAR4Assigned to domainOIA_EXGTYPOI3
OICHEADOFHead office account number (in branch accounts) KNRZECHAR10Assigned to domainALPHAKUNNR
OIPBLBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10Assigned to domainALPHAOIF_PBLNROI0OIFB
OIDRESTRContract restrictions flag OIDRESTRCHAR1CHAR1_X
OIDMSG_PRMessage type for product with contract restrictions OIDMSG_PRDCHAR1OIDMSG_PRD
OIDMSG_QTMessage type for contract restrictions quantity OIDMSG_QTYCHAR1OIDMSG_PRD
OIDMSG_UOMessage type for contract restrictions unit of measure OIDMSG_UOMCHAR1OIDMSG_PRD
OIDMSG_DAMessage type for contract restrictions validity period OIDMSG_DATCHAR1OIDMSG_PRD
OIDMSG_TRMessage type for contract restrictions payment terms OIDMSG_TRMCHAR1OIDMSG_PRD
OICNTPERContact person OID_CNTPERCHAR35OID_CNTPER
OICNTNTEContact note OID_CNTNTECHAR35OID_CNTNTE
OICNTPHOContact tel. number OID_CNTPHOCHAR16OID_CNTPHO
OID_SORTLDescending sort key for sales orders (converted date) OID_SORTLNUMC10OID_SORTL
OID_SORT2Descending sort key for sales orders (converted time) OID_SORT2NUMC10OID_SORTL
OICFKARTDDifferential invoice billing type proposal OICFKARTDICHAR4Assigned to domainFKART

Key field Non-key field



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

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

How to access SAP table E3OILO0

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