SAP ABAP Table OI0_BWLIPS (Oil fields for BW (S261,..) based on OILLIPS (delivery item))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)

Basic Data

Table Category	INTTAB	Structure
Structure	OI0_BWLIPS	Table Relationship Diagram
Short Description	Oil fields for BW (S261,..) based on OILLIPS (delivery item)

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	.INCLUDE	☐				0	0	External Bill of Lading and Misc. Deliv. No
2	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
3	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
4	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
5	OIC_LIFNR	☐	OI0BW_LIFNR	LIFNR	CHAR	10	0	Account number of the vendor or creditor	LFA1
6	.INCLUDE	☐				0	0	Destination/Origin City+County (part of OIC_DEST_ORIG incl.)
7	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	*
8	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	*
9	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	*
10	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	*
11	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
12	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
13	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
14	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
15	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
16	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
17	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
18	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
19	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
20	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
21	OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
22	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
23	OIEDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
24	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
25	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
26	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	*
27	OIC_DATE	☐	OIC_LFDAT	OIC_DATE	DATS	8	0	Date for time pricing
28	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
29	OIEXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	TOIA2
30	OIFEEDT	☐	OIA_FEEDT	DATUM	DATS	8	0	Fee pricing condition date
31	OINETCYC	☐	OIA_NETCYC	ZAHLS	CHAR	1	0	Netting cycle (FI blocking indicator)	T008
32	OIMATREF	☐	OIA_MATREF	OIA_MATREF	CHAR	20	0	Material group reference for exchange balance reporting
33	OIFINAL	☐	OID_FINAL	OI0_SELKZ	CHAR	1	0	Final Delivery Indicator
34	OIC_WADAT	☐	OIC_WADAT	OIC_DATE	DATS	8	0	Goods issue date (for time pricing)
35	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
36	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
37	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	*
38	OITRKNR	☐	OIH_TRKNR	OIH_TRKNR	CHAR	10	0	Tracking number
39	OITRKJR	☐	OIH_TRKJR	NUMC4	NUMC	4	0	Tracking number year
40	OIEXTNR	☐	OIH_EXTNR	OIH_EXTNR	CHAR	18	0	External tracking number
41	OIFTIND	☐	OIH_FTIND	OIH_FTIND	CHAR	1	0	Final transfer indicator
42	OIPRIOP	☐	OIH_PRIOP	OIH_PRIOP	CHAR	1	0	Price options for gain calculation
43	OITRIND	☐	OIH_TRIND	OIH_TRIND	CHAR	1	0	Transfer sign for plant-to-plant transfers
44	OIGHNDL	☐	OIH_GHNDL	OIH_GHNDL	CHAR	1	0	Gain handling
45	OIUMBAR	☐	OIH_UMBAR	BWTAR	CHAR	10	0	Valuation type of issuing location for two-step transfer	T149D
46	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
47	OIA_FFTYP	☐	OIA_FFTYP	OIA_FFTYP	CHAR	1	0	Fulfillment indicator for exchange assignments

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OI0_BWLIPS	OIC_LIFNR	LFA1	LIFNR
2	OI0_BWLIPS	OIC_MOT	TVTR	VKTRA
3	OI0_BWLIPS	OIEXGTYP	TOIA2	EXGTYP
4	OI0_BWLIPS	OINETCYC	T008	ZAHLS
5	OI0_BWLIPS	OIUMBAR	T149D	BWTAR

History

Last changed by/on	SAP	20110901
SAP Release Created in