SAP ABAP Table OILBW_MC13VD4ITM (Oil fields)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)

Basic Data

Table Category	APPEND	Append structure
Append structure	OILBW_MC13VD4ITM	Table Relationship Diagram
Short Description	Oil fields

Delivery and Maintenance

Pool/cluster	MC13VD4ITM
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	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
2	OIA_IPMVAT	☐	OIA_IPMVAT	OIA_IPMVAT	CHAR	1	0	VAT on internally-posted material
3	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
4	OIBRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
5	OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
6	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	*
7	OIC_ADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
8	OIC_AORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
9	OIC_DATE	☐	OIC_DATE	OIC_DATE	DATS	8	0	Date for time pricing
10	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	*
11	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	*
12	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	*
13	OIC_DRCREG	☐	OIC_DRCREG	REGIO	CHAR	3	0	DRC region	*
14	OIC_DRCTRY	☐	OIC_DRCTRY	LAND1	CHAR	3	0	DRC country	*
15	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	*
16	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
17	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
18	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	*
19	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	*
20	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	*
21	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	*
22	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	*
23	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
24	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
25	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
26	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
27	OIC_TIME	☐	OIC_TIME	OIC_TIME	TIMS	6	0	Time for time-pricing
28	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
29	OIDATFM1	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
30	OIDATTO1	☐	OIH_DATTO1	DATUM	DATS	8	0	Valid to date for excise duty tax certificate
31	OIDRC	☐	OIC_DRC	OIC_DRC	CHAR	5	0	Differential Reference Code (DRC)	*
32	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
33	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
34	OIEDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
35	OIEDBALM	☐	OIH_EDBALM	OIH_EDBALM	CHAR	1	0	Excise duty balancing method indicator
36	OIEDOK	☐	OIH_EDOK	X	CHAR	1	0	Excise duty validation indicator
37	OIFEECH	☐	OIA_FEECH	OIA_FEECH	CHAR	1	0	Fee edit control
38	OIFEEDT	☐	OIA_FEEDT	DATUM	DATS	8	0	Fee pricing condition date
39	OIFEETOT	☐	OIA_FEETOT	OIA_FEETOT	CURR	13	2	Fee total
40	OIFKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
41	OIFKIMGSAV	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
42	OIFKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
43	OIGNRULE	☐	OIC_GNRULE	GRPNO	NUMC	3	0	Gross/net pricing rule	*
44	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	*
45	OIHFOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
46	OIH_FOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
47	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	*
48	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
49	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	*
50	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	*
51	OIINVCYC1	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
52	OIINVCYC2	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
53	OIINVCYC3	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
54	OIINVCYC4	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
55	OIINVCYC5	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
56	OIINVCYC6	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
57	OIINVCYC7	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
58	OIINVCYC8	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
59	OIINVCYC9	☐	OIA_INCYCA	KREUZ	CHAR	1	0	Invoice cycle indicator active (X/ )
60	OILIKWTF	☐	OIA_OLIKWT	WERTV10	CURR	19	2	Open delivery credit value transferred during billing
61	OILIMETF	☐	OIA_OLIMET	MENGV15_3	QUAN	15	3	Open delivery quantity transferred during billing
62	OILMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
63	OIMETIND	☐	OIC_METIND	OIC_METIND	CHAR	4	0	Metropolitan indicator	*
64	OINTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
65	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
66	OIPBL	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
67	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
68	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
69	OIPSDRC	☐	OIC_PSDRC	OIC_DRC	CHAR	5	0	Pricing DRC (grouping customers by DRC for pricing)	*
70	OIRELPCGROUP	☐	OIRE_LPCGROUP	OIRE_LPCGROUP	CHAR	4	0	Location Payment Card Grouping	*
71	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
72	OISLF	☐	OIC_SLF	OIC_SLF	CHAR	3	0	State license fee zone	*
73	OISMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
74	OISTYP	☐	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	*
75	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	*
76	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	*
77	OITAXINV	☐	OIH_TAXINV	OIH_TXVAL	CURR	13	2	Excise duty tax value for an invoice
78	OITAXISS	☐	OIH_TAXISS	OIH_TXVAL	CURR	13	2	Excise duty value for goods issue
79	OITAXLOD	☐	OIH_TAXLOD	OIH_TXVAL	CURR	13	2	Excise duty tax value for goods loading
80	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	*
81	OITITLE	☐	OIC_TITLE	OIC_TITLE	CHAR	1	0	Location of title transfer for Incoterms purposes

History

Last changed by/on	SAP	20050223
SAP Release Created in	46C