SAP ABAP Table OIL_IMSEG (IS-Oil Downstream fields of structure IMSEG)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_COMMON (Package) Common obj. in IS-Oil Downstream

Basic Data

Table Category	INTTAB	Structure
Structure	OIL_IMSEG	Table Relationship Diagram
Short Description	IS-Oil Downstream fields of structure IMSEG

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	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
2	OILFKNUM	☐	OIA_LFKNUM	KNUMV	CHAR	10	0	Delivery note reference for fee doc. conditions
3	OILFPOS	☐	OIA_LFPOS	POSNR	NUMC	6	0	Reference delivery note item	*
4	OIMATREF	☐	OIA_MATREF	OIA_MATREF	CHAR	20	0	Material group reference for exchange balance reporting
5	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
6	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
7	OIBOMHEAD	☐	OIA_BOMHM	MATNR	CHAR	18	0	BoM header material number	*
8	OINETCYC	☐	OIA_NETCYC	ZAHLS	CHAR	1	0	Netting cycle (FI blocking indicator)	*
9	OIA_ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
10	OITRKNR	☐	OIH_TRKNR	OIH_TRKNR	CHAR	10	0	Tracking number
11	OITRKJR	☐	OIH_TRKJR	NUMC4	NUMC	4	0	Tracking number year
12	OIEXTNR	☐	OIH_EXTNR	OIH_EXTNR	CHAR	18	0	External tracking number
13	OIITMNR	☐	OIH_ITMNR	OIH_ITMNR	NUMC	5	0	Tracking number item line
14	OIFTIND	☐	OIH_FTIND	OIH_FTIND	CHAR	1	0	Final transfer indicator
15	OIPRIOP	☐	OIH_PRIOP	OIH_PRIOP	CHAR	1	0	Price options for gain calculation
16	OITRIND	☐	OIH_TRIND	OIH_TRIND	CHAR	1	0	Transfer sign for plant-to-plant transfers
17	OIGHNDL	☐	OIH_GHNDL	OIH_GHNDL	CHAR	1	0	Gain handling
18	OIUMBAR	☐	OIH_UMBAR	BWTAR	CHAR	10	0	Valuation type of issuing location for two-step transfer	T149D
19	OIB_ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
20	OIB_ZEILE_CHECK	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
21	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
22	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
23	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	T005G
24	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	T005E
25	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	T005S
26	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	T005
27	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	T005G
28	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	T005E
29	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	T005S
30	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	T005
31	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
32	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
33	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
34	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
35	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
36	OIC_AORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
37	OIC_ADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
38	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
39	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
40	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
41	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
42	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
43	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
44	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
45	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
46	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
47	OIFULTAX	☐	OIH_FULTAX	OIH_TXVAL	CURR	13	2	Excise duty tax value at the full rate
48	OITXVAL0	☐	OIH_TXVAL0	OIH_TXVAL	CURR	13	2	Excise duty tax value 0
49	OITXVAL1	☐	OIH_TXVAL1	OIH_TXVAL	CURR	13	2	Excise duty tax value 1
50	OITXVAL2	☐	OIH_TXVAL2	OIH_TXVAL	CURR	13	2	Excise duty tax value 2
51	OITXVAL3	☐	OIH_TXVAL3	OIH_TXVAL	CURR	13	2	Excise duty tax value 3
52	OITXVAL4	☐	OIH_TXVAL4	OIH_TXVAL	CURR	13	2	Excise duty tax value 4
53	OITXVAL5	☐	OIH_TXVAL5	OIH_TXVAL	CURR	13	2	Excise duty tax value 5
54	OITXVAL6	☐	OIH_TXVAL6	OIH_TXVAL	CURR	13	2	Excise duty tax value 6
55	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
56	OITAXCON	☐	OIH_TAXCON	OIH_TAXCON	CURR	13	2	Excise duty tax from pricing conditions
57	OITAXVAL	☐	OIH_TAXVAL	OIH_TXVAL	CURR	13	2	Excise duty value in material inventory account
58	OIOILCON2	☐	OIH_OILCN2	OIH_OILCON	DEC	5	2	Oil content of a material as a percentage (2)
59	OIUOMQT	☐	OIH_UOMQT	MEINS	UNIT	3	0	Base quantity for excise duty rate (e.g.per 1 or 100 UoM)	*
60	OITAXQT	☐	OIH_TAXQT	MENGE	QUAN	13	3	Excise duty tax quantity in STBME
61	OIFUTQT	☐	OIH_FUTQT	MENGE	QUAN	13	3	Future tax quantity
62	OIFUTTX	☐	OIH_FUTTX	OIH_TXVAL	CURR	13	2	Future tax value
63	OIFUTDT	☐	OIH_FUTDT	DATUM	DATS	8	0	Future tax date
64	OIFUTQT2	☐	OIH_FUTQT2	MENGE	QUAN	13	3	Future tax quantity 2
65	OIFUTTX2	☐	OIH_FUTTX2	OIH_TXVAL	CURR	13	2	Future tax value 2
66	OIFUTDT2	☐	OIH_FUTDT2	DATUM	DATS	8	0	Future tax date 2
67	OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
68	OIDATFM1	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
69	OIDATTO1	☐	OIH_DATTO1	DATUM	DATS	8	0	Valid to date for excise duty tax certificate
70	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
71	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	OIHL
72	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	OIHL
73	OIH_FOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIL_IMSEG	OIC_DCITYC	T005G	CITYC
2	OIL_IMSEG	OIC_DCOUNC	T005E	COUNC
3	OIL_IMSEG	OIC_DLAND1	T005	LAND1
4	OIL_IMSEG	OIC_DREGIO	T005S	BLAND
5	OIL_IMSEG	OIC_LIFNR	LFA1	LIFNR
6	OIL_IMSEG	OIC_MOT	TVTR	VKTRA
7	OIL_IMSEG	OIC_OCITYC	T005G	CITYC
8	OIL_IMSEG	OIC_OCOUNC	T005E	COUNC
9	OIL_IMSEG	OIC_OLAND1	T005	LAND1
10	OIL_IMSEG	OIC_OREGIO	T005S	BLAND
11	OIL_IMSEG	OIH_LCFOL	OIHL	LICIN
12	OIL_IMSEG	OIH_LICIN	OIHL	LICIN
13	OIL_IMSEG	OIH_LICTP	OIH20	LICTP
14	OIL_IMSEG	OIUMBAR	T149D	BWTAR

History

Last changed by/on	SAP	20110901
SAP Release Created in	600