E2OILK0 SAP (IS-OIL/TAS: document header data) Structure details

Dictionary Type: Structure
Description: IS-OIL/TAS: document header data




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




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

E2OILK0 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/TAS: document header data" 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_E2OILK0 TYPE E2OILK0.

The E2OILK0 table consists of various fields, each holding specific information or linking keys about IS-OIL/TAS: document header data 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 E2OILK0 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
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
OICHEADOFFHead 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_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
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
OICFKARTDIDifferential invoice billing type proposal OICFKARTDICHAR4Assigned to domainFKART
OIAEVGTYPEEvergreen type OIA_EVTYPECHAR1OIA_EVTYPE
OIC_TIMETime for time-pricing OIC_TIMETIMS6OIC_TIME
OITITLELocation of title transfer for Incoterms purposes OIC_TITLECHAR1OIC_TITLE
OIPTRM1Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM2Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM3Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM4Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM5Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM6Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM7Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM8Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPTRM9Payment terms for invoice cycle X OIA_PTRMCHAR4ZTERM
OIPFLICIS-OIL partner function for tax exemption license OIH_PFLICCHAR2Assigned to domainPARVWPARVW

Key field Non-key field



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

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

How to access SAP table E2OILK0

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