SAP ABAP Table OILKOMDLGN (IS-OIL extensions)

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	APPEND	Append structure
Append structure	OILKOMDLGN	Table Relationship Diagram
Short Description	IS-OIL extensions

Delivery and Maintenance

Pool/cluster	KOMDLGN
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	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
2	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	OIH4
3	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	OIH4
4	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
5	.INCLUDE	☐				0	0	TRACKING FIELDS FOR 2 STEP TRANSFERS
15	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
36	OIHPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
37	OICHLIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
38	OICHDCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
39	OICHDCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
40	OICHDREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	*
41	OICHDLAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
42	OICHOCITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
43	OICHOCOUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
44	OICHOREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	*
45	OICHOLAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
46	OICHPORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
47	OICHPDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
48	OICHPTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
49	OICHPBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
50	OICHMOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	*
51	OICHAORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
52	OICHADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
53	OICHTRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
54	OIDHEXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
55	OIDHMISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
56	.INCLUDE	☐				0	0	External Bill of Lading and Misc. Deliv. No
59	OIMBPOS	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
60	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
61	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
62	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OILKOMDLGN	OIC_DCITYC	T005G	CITYC
2	OILKOMDLGN	OIC_DCOUNC	T005E	COUNC
3	OILKOMDLGN	OIC_DLAND1	T005	LAND1
4	OILKOMDLGN	OIC_DREGIO	T005S	BLAND
5	OILKOMDLGN	OIC_LIFNR	LFA1	LIFNR
6	OILKOMDLGN	OIC_MOT	TVTR	VKTRA
7	OILKOMDLGN	OIC_OCITYC	T005G	CITYC
8	OILKOMDLGN	OIC_OCOUNC	T005E	COUNC
9	OILKOMDLGN	OIC_OLAND1	T005	LAND1
10	OILKOMDLGN	OIC_OREGIO	T005S	BLAND
11	OILKOMDLGN	OIHANTYP	OIH5	HANTYP
12	OILKOMDLGN	OITAXFROM	OIH4	TAXKEY
13	OILKOMDLGN	OITAXGRP	OIH2	TAXGRP
14	OILKOMDLGN	OITAXTO	OIH4	TAXKEY
15	OILKOMDLGN	OIUMBAR	T149D	BWTAR

History

Last changed by/on	SAP	20050223
SAP Release Created in