SAP ABAP Table OILKOMP (IS-Oil Append)

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	OILKOMP	Table Relationship Diagram
Short Description	IS-Oil Append

Delivery and Maintenance

Pool/cluster	KOMP
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	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
2	OIC_DRCTRY	☐	OIC_DRCTRY	LAND1	CHAR	3	0	DRC country	*
3	OIC_DRCREG	☐	OIC_DRCREG	REGIO	CHAR	3	0	DRC region	*
4	OIMETIND	☐	OIC_METIND	OIC_METIND	CHAR	4	0	Metropolitan indicator	*
5	OIWAP	☐	OIC_WAP	OIC_WAP	CHAR	3	0	Wide-area pricing zone	*
6	OISLF	☐	OIC_SLF	OIC_SLF	CHAR	3	0	State license fee zone	*
7	OIPSDRC	☐	OIC_PSDRC	OIC_DRC	CHAR	5	0	Pricing DRC (grouping customers by DRC for pricing)	*
8	OIFEETOT	☐	OIA_FEETOT	OIA_FEETOT	CURR	13	2	Fee total
9	OIMATPST	☐	OIA_MATPST	OIA_MATPST	CHAR	1	0	Posting rules for material
10	OIFEEPST	☐	OIA_FEEPST	OIA_FEEPST	CHAR	1	0	Posting rules for fees
11	OIFEEDT	☐	OIA_FEEDT	DATUM	DATS	8	0	Fee pricing condition date
12	OIFEEOK	☐	PRSOK	XFELD	CHAR	1	0	Pricing is OK
13	OIFEEMSG	☐	MSGNR	MSGNR	CHAR	3	0	Message number	*
14	OIFEERCI	☐	OIA_FEERCI	XFELD	CHAR	1	0	Fee recalculation ind.
15	OIRULECI	☐	OIA_RULECI	XFELD	CHAR	1	0	Fee recalculation according to copy rules
16	OIGPKNUM	☐	OIA_GPKNUM	KNUMV	CHAR	10	0	Reference to fee conditions for group delivery processing
17	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
18	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
19	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	OIH4
20	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
21	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
22	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
23	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	OIH4
24	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
25	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
26	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	*
27	OIH_FOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
28	OIEBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
29	OIEBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
30	OIVGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
31	OIVGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
32	OIDATFM1	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
33	OIDATTO1	☐	OIH_DATTO1	DATUM	DATS	8	0	Valid to date for excise duty tax certificate
34	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	*
35	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
56	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
57	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
58	GZOLX	☐	GZOLX	GZOLX	CHAR	4	0	Preference zone	*
59	OIGNRULE	☐	OIC_GNRULE	GRPNO	NUMC	3	0	Gross/net pricing rule	*
60	OIVATBASE	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
61	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
62	OIA_IPMVAT	☐	OIA_IPMVAT	OIA_IPMVAT	CHAR	1	0	VAT on internally-posted material
63	.INCLUDE	☐				0	0	Invoice cycle active flag 1-n (grouped)
73	OINETWRAC	☐	OIA_NETWRA	WERTV8	CURR	15	2	Net price if all cycles are active
74	OIMWSBPAC	☐	OIA_MWSBPA	WERTV7	CURR	13	2	Tax value if all cycles are active
75	OIINVCYACT	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
76	OIFPBL	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
77	OIFWE	☐	OIF_KUNWE	KUNNR	CHAR	10	0	Ship-to party (IS-Oil MRN)	*
78	OIFBPR	☐	OIF_PARFN	OIF_PARFN	CHAR	4	0	MRN business partner role / relation type	*
79	.INCLUDE	☐				0	0	Invoice cycle status 1-n (grouped)
89	OIC_FCODE	☐	OIC_FCODE	OKCODE	CHAR	20	0	Fcode calling pricing dialog (differential invoice)	*
90	DDATTO	☐	OIC_DDATTO	DATUM	DATS	8	0	'Date to' determined for fixation period
91	OIPFLIC	☐	OIH_PFLIC	PARVW	CHAR	2	0	IS-OIL partner function for tax exemption license	*
92	OIFORMUPD	☐	OIC_FORMUP	UPDKZ	CHAR	1	0	Formula changed
93	OIRI_FEE	☐	OIRI_FEEBASE	WERTV7	CURR	13	2	Base for fee calculation
94	.INCLUDE	☐				0	0	TD-F Enhancement to KOM(K,P,G) to shipm. cost. for vehicles
100	.INCLUDE	☐				0	0	TD-F Enhancement to KOM(K,P,G) to shipm. cost. for documents
103	.INCLUDE	☐				0	0	TD-F Enhancement to KOM(K,P) to shimpm. cost for ASTM mat.
108	.INCLUDE	☐				0	0	TD-F Enhancement to KOM(K,P,G) to shipm. cost. for stages
113	OIC_POQTY	☐	OIC_POQTY	MENG13	QUAN	13	3	Purchase order quantity at time of goods receipt
114	.INCLUDE	☐				0	0	SSR KOMP fields
125	.INCLUDE	☐				0	0	Brazil Oil Enhancement to KOMP
129	.INCLUDE	☐				0	0	Excise Tax Enhancements to KOMP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OILKOMP	OIC_DCITYC	T005G	CITYC
2	OILKOMP	OIC_DCOUNC	T005E	COUNC
3	OILKOMP	OIC_DLAND1	T005	LAND1
4	OILKOMP	OIC_DREGIO	T005S	BLAND
5	OILKOMP	OIC_LIFNR	LFA1	LIFNR
6	OILKOMP	OIC_MOT	TVTR	VKTRA
7	OILKOMP	OIC_OCITYC	T005G	CITYC
8	OILKOMP	OIC_OCOUNC	T005E	COUNC
9	OILKOMP	OIC_OLAND1	T005	LAND1
10	OILKOMP	OIC_OREGIO	T005S	BLAND
11	OILKOMP	OIGGROUP	TOIGVCLGR	CLASS_GRP
12	OILKOMP	OIGKNOTD	TVKN	KNOTE
13	OILKOMP	OIGKNOTL	TVKN	KNOTE
14	OILKOMP	OIGROUTEV	TVRO	ROUTE
15	OILKOMP	OIGVEHICLE	OIGV	VEHICLE	KEY	1	CN
16	OILKOMP	OIGVEH_TYP	TOIGV	VEH_TYPE
17	OILKOMP	OIHCGROUP	OIH2C_J1B	OIHCTXGR
18	OILKOMP	OIHMTXGRP	OIH2M_J1B	OIHMTXGR	KEY	1	CN
19	OILKOMP	OIHVGROUP	OIH2V_J1B	OIHVTXGR
20	OILKOMP	OIH_ETAX_GROUP	OIH_ETAX_GRP	TAX_GROUP
21	OILKOMP	OITAXFROM	OIH4	TAXKEY
22	OILKOMP	OITAXGRP	OIH2	TAXGRP
23	OILKOMP	OITAXTO	OIH4	TAXKEY

History

Last changed by/on	SAP	20050223
SAP Release Created in