SAP ABAP Table OILKOMG (IS-Oil append to KOMG)

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	OILKOMG	Table Relationship Diagram
Short Description	IS-Oil append to KOMG

Delivery and Maintenance

Pool/cluster	KOMG
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	OIC_DRCTRY	☐	OIC_DRCTRY	LAND1	CHAR	3	0	DRC country	T005
2	OIC_DRCREG	☐	OIC_DRCREG	REGIO	CHAR	3	0	DRC region	T005S
3	OIMETIND	☐	OIC_METIND	OIC_METIND	CHAR	4	0	Metropolitan indicator	OICMI
4	OIWAP	☐	OIC_WAP	OIC_WAP	CHAR	3	0	Wide-area pricing zone	OICWA
5	OISLF	☐	OIC_SLF	OIC_SLF	CHAR	3	0	State license fee zone	OICSL
6	OIPSDRC	☐	OIC_PSDRC	OIC_DRC	CHAR	5	0	Pricing DRC (grouping customers by DRC for pricing)	OICDC
7	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
8	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
9	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	OIH16
10	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	VBUK
11	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
12	OICHEADOFF	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
13	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
34	OIC_TIME	☐	OIC_TIME	OIC_TIME	TIMS	6	0	Time for time-pricing
35	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
36	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
37	OIFPBL	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
38	OIFWE	☐	OIF_KUNWE	KUNNR	CHAR	10	0	Ship-to party (IS-Oil MRN)	*
39	OIFBPR	☐	OIF_PARFN	OIF_PARFN	CHAR	4	0	MRN business partner role / relation type	*
40	.INCLUDE	☐				0	0	TD-F Enhancement to KOM(K,P,G) to shipm. cost. for shipment
42	.INCLUDE	☐				0	0	TD-F Enhancement to KOM(K,P,G) to shipm. cost. for vehicles
48	.INCLUDE	☐				0	0	TD-F Enhancement to KOM(K,P,G) to shipm. cost. for documents
51	.INCLUDE	☐				0	0	SSR Fields in Header Pricing
55	.INCLUDE	☐				0	0	SSR KOMP fields
66	.INCLUDE	☐				0	0	Brazil Oil Enhancement to KOMG
70	.INCLUDE	☐				0	0	Excise Tax Enhancements to KOMG

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OILKOMG	MVGR2	TVM2	MVGR2
2	OILKOMG	OICHEADOFF	KNA1	KUNNR
3	OILKOMG	OICONTNR	VBUK	VBELN
4	OILKOMG	OIC_DCITYC	T005G	CITYC
5	OILKOMG	OIC_DCOUNC	T005E	COUNC
6	OILKOMG	OIC_DLAND1	T005	LAND1
7	OILKOMG	OIC_DRCREG	T005S	BLAND
8	OILKOMG	OIC_DRCTRY	T005	LAND1
9	OILKOMG	OIC_DREGIO	T005S	BLAND
10	OILKOMG	OIC_LIFNR	LFA1	LIFNR
11	OILKOMG	OIC_MOT	TVTR	VKTRA
12	OILKOMG	OIC_OCITYC	T005G	CITYC
13	OILKOMG	OIC_OCOUNC	T005E	COUNC
14	OILKOMG	OIC_OLAND1	T005	LAND1
15	OILKOMG	OIC_OREGIO	T005S	BLAND
16	OILKOMG	OIGGROUP	TOIGVCLGR	CLASS_GRP
17	OILKOMG	OIGKNOTD	TVKN	KNOTE
18	OILKOMG	OIGKNOTL	TVKN	KNOTE
19	OILKOMG	OIGROUTEV	TVRO	ROUTE
20	OILKOMG	OIGSHTYPE	TOIGS	SHTYP
21	OILKOMG	OIGVEHICLE	OIGV	VEHICLE	KEY	1	CN
22	OILKOMG	OIGVEH_TYP	TOIGV	VEH_TYPE
23	OILKOMG	OIHANTYP	OIH5	HANTYP
24	OILKOMG	OIHCGROUP	OIH2C_J1B	OIHCTXGR
25	OILKOMG	OIHMTXGRP	OIH2M_J1B	OIHMTXGR
26	OILKOMG	OIHVGROUP	OIH2V_J1B	OIHVTXGR
27	OILKOMG	OIH_ETAX_GROUP	OIH_ETAX_GRP	TAX_GROUP
28	OILKOMG	OIH_ETAX_TYPE	OIH_ETAX_GRP	TAX_TYPE
29	OILKOMG	OIINEX	OIH16	INEX
30	OILKOMG	OIMETIND	OICMI	OIMETIND
31	OILKOMG	OIPSDRC	OICDC	OIDRC
32	OILKOMG	OISLF	OICSL	OISLF
33	OILKOMG	OITAXGRP	OIH2	TAXGRP
34	OILKOMG	OIWAP	OICWA	OIWAP

History

Last changed by/on	SAP	20050223
SAP Release Created in