1. Home
  2. Resources
  3. SAP Tables
  4. E3OILP0 - IS/OIL-TAS: Doc.item data

SAP Table E3OILP0

IS/OIL-TAS: Doc.item data

E3OILP0 (IS/OIL-TAS: Doc.item data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link E3OILP0 to other SAP tables.

E3OILP0 table fields

Field Data element Checktable Datatype Length Decimals
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OIPLANTD Plant determination active or not active OID_PLANTD CHAR 1 0
X Yes
NULL No
OIBYPASS IS-Oil plant determination indicator: x=yes blank=no OID_BYPASS CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
OIEDOK Excise duty validation indicator OIH_EDOK CHAR 1 0
X Yes
NULL No
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIEDBAL Excise duty balancing is required (indicator) OIH_EDBAL CHAR 1 0
X Yes
NULL No
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIINEX Code for internal or external excise duty rate determination OIH_INEX CHAR 2 0
OIEDBALM Excise duty balancing method indicator OIH_EDBALM CHAR 1 0
0 Transport & Distribution (TD) is not Active
1 Loading with Vehicle's Status
2 Loading with Customer's Status
OIDRC Differential Reference Code (DRC) OIC_DRC CHAR 5 0
OIC_DRCTRY DRC country OIC_DRCTRY CHAR 3 0
OIC_DRCREG DRC region OIC_DRCREG CHAR 3 0
OIMETIND Metropolitan indicator OIC_METIND CHAR 4 0
OIWAP Wide-area pricing zone OIC_WAP CHAR 3 0
OISLF State license fee zone OIC_SLF CHAR 3 0
OIPSDRC Pricing DRC (grouping customers by DRC for pricing) OIC_PSDRC CHAR 5 0
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIC_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
OIC_DCITYC Destination city code OIC_DCITYC CHAR 4 0
OIC_DCOUNC Destination county code OIC_DCOUNC CHAR 3 0
OIC_DREGIO Destination region OIC_DREGIO CHAR 3 0
OIC_DLAND1 Destination country OIC_DLAND1 CHAR 3 0
OIC_OCITYC Origin city code OIC_OCITYC CHAR 4 0
OIC_OCOUNC Origin county code OIC_OCOUNC CHAR 3 0
OIC_OREGIO Origin region OIC_OREGIO CHAR 3 0
OIC_OLAND1 Origin country OIC_OLAND1 CHAR 3 0
OIC_PORGIN Tax origin OIC_PORGIN CHAR 15 0
OIC_PDESTN Tax destination OIC_PDESTN CHAR 15 0
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16 0
OIC_PBATCH Pipeline operator�s external batch number OIC_PBATCH CHAR 16 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT CHAR 2 0
OIC_AORGIN Alternate origin OIC_AORGIN CHAR 15 0
OIC_ADESTN Alternate destination OIC_ADESTN CHAR 15 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIFEETOT Fee total OIA_FEETOT CURR 13 2
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OICONTNR Outline agreement: contract OIC_CONTNR CHAR 10 0
OIC_KMPOS Reference contract line item number OIC_KMPOS NUMC 6 0
OIFEECH Fee edit control OIA_FEECH CHAR 1 0
1 Add, delete, change, reprice abilities active
2 Change, reprice only
3 Display only active
OIH_LICTP License type OIH_LICTP CHAR 4 0
OIH_LICIN Excise tax internal license number OIH_LICIN CHAR 10 0
OIH_LCFOL Follow-on license for quantity license OIH_LCFOL CHAR 10 0
OIH_FOLQTY Excise Tax Follow-On License Quantity OIH_FOLQTY QUAN 13 3
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
OIDMSG_PRD Message type for product with contract restrictions OIDMSG_PRD CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_QTY Message type for contract restrictions quantity OIDMSG_QTY CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_UOM Message type for contract restrictions unit of measure OIDMSG_UOM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_DAT Message type for contract restrictions validity period OIDMSG_DAT CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_TRM Message type for contract restrictions payment terms OIDMSG_TRM CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIDMSG_SHP Message type for contract restrictions ship-to party OIDMSG_SHP CHAR 1 0
NULL No message
W Warning
E Error
I Information
OIGNRULE Gross/net pricing rule OIC_GNRULE NUMC 3 0
OID_SHIP Ship-to party KUNWE CHAR 10 0
OIC_TIME Time for time-pricing OIC_TIME TIMS 6 0
OITITLE Location of title transfer for Incoterms purposes OIC_TITLE CHAR 1 0
NULL Title passes at plant
1 Title passes at Ship-to
OIPTRM1 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM2 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM3 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM4 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM5 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM6 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM7 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM8 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPTRM9 Payment terms for invoice cycle X OIA_PTRM CHAR 4 0
OIPFLIC IS-OIL partner function for tax exemption license OIH_PFLIC CHAR 2 0