SAP ABAP Table OILLIPS (IS-Oil Append structure)

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

Delivery and Maintenance

Pool/cluster	LIPS
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
4	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
25	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
26	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	OIH4
27	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
28	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
29	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	OIH4
30	OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
31	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
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	OIEDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
35	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
36	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	OIH16
37	OIEDBALM	☐	OIH_EDBALM	OIH_EDBALM	CHAR	1	0	Excise duty balancing method indicator
38	OITAXLOD	☐	OIH_TAXLOD	OIH_TXVAL	CURR	13	2	Excise duty tax value for goods loading
39	OITAXISS	☐	OIH_TAXISS	OIH_TXVAL	CURR	13	2	Excise duty value for goods issue
40	OITAXINV	☐	OIH_TAXINV	OIH_TXVAL	CURR	13	2	Excise duty tax value for an invoice
41	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	*
42	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
43	OIC_TIME	☐	OIC_LFTIM	OIC_TIME	TIMS	6	0	Time for time pricing
44	OIC_DATE	☐	OIC_LFDAT	OIC_DATE	DATS	8	0	Date for time pricing
45	.INCLUDE	☐				0	0	Exchanges structure to be included in Core tables
51	OIMATREF	☐	OIA_MATREF	OIA_MATREF	CHAR	20	0	Material group reference for exchange balance reporting
52	OIFINAL	☐	OID_FINAL	OI0_SELKZ	CHAR	1	0	Final Delivery Indicator
53	OIC_WATIM	☐	OIC_WATIM	OIC_TIME	TIMS	6	0	Actual goods issue time (for time pricing)
54	OIC_WADAT	☐	OIC_WADAT	OIC_DATE	DATS	8	0	Goods issue date (for time pricing)
55	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
56	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
57	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	*
58	OIH_FOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
59	.INCLUDE	☐				0	0	TRACKING FIELDS FOR 2 STEP TRANSFERS
69	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
70	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
71	OIGNRULE	☐	OIC_GNRULE	GRPNO	NUMC	3	0	Gross/net pricing rule	*
72	OITITLE	☐	OIC_TITLE	OIC_TITLE	CHAR	1	0	Location of title transfer for Incoterms purposes
73	OIA_IPMVAT	☐	OIA_IPMVAT	OIA_IPMVAT	CHAR	1	0	VAT on internally-posted material
74	OIA_FFTYP	☐	OIA_FFTYP	OIA_FFTYP	CHAR	1	0	Fulfillment indicator for exchange assignments
75	OII_CONWK	☐	OII_CONWK	WERKS	CHAR	4	0	OIL-BDRP: Consignment stock receiving plant in delivery	*
76	OII_CONLG	☐	OII_CONLG	LGORT	CHAR	4	0	OIL-BDRP: Consignment stock receiving s/loc in delivery	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OILLIPS	OIC_DCITYC	T005G	CITYC
2	OILLIPS	OIC_DCOUNC	T005E	COUNC
3	OILLIPS	OIC_DLAND1	T005	LAND1
4	OILLIPS	OIC_DREGIO	T005S	BLAND
5	OILLIPS	OIC_LIFNR	LFA1	LIFNR
6	OILLIPS	OIC_MOT	TVTR	VKTRA
7	OILLIPS	OIC_OCITYC	T005G	CITYC
8	OILLIPS	OIC_OCOUNC	T005E	COUNC
9	OILLIPS	OIC_OLAND1	T005	LAND1
10	OILLIPS	OIC_OREGIO	T005S	BLAND
11	OILLIPS	OIEXGTYP	TOIA2	EXGTYP
12	OILLIPS	OIHANTYP	OIH5	HANTYP	KEY
13	OILLIPS	OIINEX	OIH16	INEX	KEY
14	OILLIPS	OINETCYC	T008	ZAHLS
15	OILLIPS	OITAXFROM	OIH4	TAXKEY	KEY
16	OILLIPS	OITAXGRP	OIH2	TAXGRP	KEY
17	OILLIPS	OITAXTO	OIH4	TAXKEY	KEY
18	OILLIPS	OIUMBAR	T149D	BWTAR

History

Last changed by/on	SAP	20050223
SAP Release Created in