SAP ABAP Table E3OILO2 (RO item OIL extension)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
     ⤷ OIK (Package) TAS/TPI Common Objects

Basic Data

Table Category	INTTAB	Structure
Structure	E3OILO2	Table Relationship Diagram
Short Description	RO item OIL extension

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
2	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
3	OIPLANTD	☐	OID_PLANTD	OI0_XFELD	CHAR	1	0	Plant determination active or not active
4	OIBYPASS	☐	OID_BYPASS	OI0_SELKZ	CHAR	1	0	IS-Oil plant determination indicator: x=yes blank=no
5	OIEDOK	☐	OIH_EDOK	X	CHAR	1	0	Excise duty validation indicator
6	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
7	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
8	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
9	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
10	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
11	OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
12	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
13	OIEDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
14	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
15	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
16	OIEDBALM	☐	OIH_EDBALM	OIH_EDBALM	CHAR	1	0	Excise duty balancing method indicator
17	OIDRC	☐	OIC_DRC	OIC_DRC	CHAR	5	0	Differential Reference Code (DRC)	*
18	OIC_DRCTRY	☐	OIC_DRCTRY	LAND1	CHAR	3	0	DRC country	*
19	OIC_DRCREG	☐	OIC_DRCREG	REGIO	CHAR	3	0	DRC region	*
20	OIMETIND	☐	OIC_METIND	OIC_METIND	CHAR	4	0	Metropolitan indicator	*
21	OIWAP	☐	OIC_WAP	OIC_WAP	CHAR	3	0	Wide-area pricing zone	*
22	OISLF	☐	OIC_SLF	OIC_SLF	CHAR	3	0	State license fee zone	*
23	OIPSDRC	☐	OIC_PSDRC	OIC_DRC	CHAR	5	0	Pricing DRC (grouping customers by DRC for pricing)	*
24	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
25	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
26	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	*
27	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	*
28	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	*
29	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	*
30	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	*
31	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	*
32	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	*
33	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	*
34	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
35	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
36	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
37	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
38	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	*
39	OIC_AORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
40	OIC_ADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
41	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
42	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
43	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
44	OIEXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	*
45	OIFEETOT	☐	OIA_FEETOT	OIA_FEETOT	CURR	13	2	Fee total
46	OIFEEDT	☐	OIA_FEEDT	DATUM	DATS	8	0	Fee pricing condition date
47	OINETCYC	☐	OIA_NETCYC	ZAHLS	CHAR	1	0	Netting cycle (FI blocking indicator)	*
48	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	*
49	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
50	OIFEECH	☐	OIA_FEECH	OIA_FEECH	CHAR	1	0	Fee edit control
51	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
52	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
53	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	*
54	OIH_FOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
55	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
56	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
57	OIDMSG_PRD	☐	OIDMSG_PRD	OIDMSG_PRD	CHAR	1	0	Message type for product with contract restrictions
58	OIDMSG_QTY	☐	OIDMSG_QTY	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions quantity
59	OIDMSG_UOM	☐	OIDMSG_UOM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions unit of measure
60	OIDMSG_DAT	☐	OIDMSG_DAT	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions validity period
61	OIDMSG_TRM	☐	OIDMSG_TRM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions payment terms
62	OIDMSG_SHP	☐	OIDMSG_SHP	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions ship-to party
63	OIGNRULE	☐	OIC_GNRULE	GRPNO	NUMC	3	0	Gross/net pricing rule	*
64	OID_SHIP	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*

History

Last changed by/on	SAP	20110901
SAP Release Created in