SAP ABAP Table OI0VBAP (communication structure for data transfer)

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	INTTAB	Structure
Structure	OI0VBAP	Table Relationship Diagram
Short Description	communication structure for data transfer

Delivery and Maintenance

Pool/cluster
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
2	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
3	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
4	OIPLANTD	☐	OID_PLANTD	OI0_XFELD	CHAR	1	0	Plant determination active or not active
5	OIBYPASS	☐	OID_BYPASS	OI0_SELKZ	CHAR	1	0	IS-Oil plant determination indicator: x=yes blank=no
6	OIEDOK	☐	OIH_EDOK	X	CHAR	1	0	Excise duty validation indicator
7	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
8	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	OIH4
9	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
10	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
11	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	OIH4
12	OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
13	OIEDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
14	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
15	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	OIH16
16	OIEDBALM	☐	OIH_EDBALM	OIH_EDBALM	CHAR	1	0	Excise duty balancing method indicator
17	OIDRC	☐	OIC_DRC	OIC_DRC	CHAR	5	0	Differential Reference Code (DRC)	OICDC
18	OIC_DRCTRY	☐	OIC_DRCTRY	LAND1	CHAR	3	0	DRC country	T005
19	OIC_DRCREG	☐	OIC_DRCREG	REGIO	CHAR	3	0	DRC region	T005S
20	OIMETIND	☐	OIC_METIND	OIC_METIND	CHAR	4	0	Metropolitan indicator	OICMI
21	OIWAP	☐	OIC_WAP	OIC_WAP	CHAR	3	0	Wide-area pricing zone	OICWA
22	OISLF	☐	OIC_SLF	OIC_SLF	CHAR	3	0	State license fee zone	OICSL
23	OIPSDRC	☐	OIC_PSDRC	OIC_DRC	CHAR	5	0	Pricing DRC (grouping customers by DRC for pricing)	OICDC
24	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
25	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
26	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
27	.INCLUDE	☐				0	0	Destination/Origin: City,County,Region,Country + Tax
28	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	T005G
29	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	T005E
30	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	T005S
31	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	T005
32	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	T005G
33	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	T005E
34	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	T005S
35	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	T005
36	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
37	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
38	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
39	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
40	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
41	OIC_AORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
42	OIC_ADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
43	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
44	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
45	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
46	OIEXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	TOIA2
47	OIFEEDT	☐	OIA_FEEDT	DATUM	DATS	8	0	Fee pricing condition date
48	OINETCYC	☐	OIA_NETCYC	ZAHLS	CHAR	1	0	Netting cycle (FI blocking indicator)	T008
49	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	VBUK
50	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
51	OIFEECH	☐	OIA_FEECH	OIA_FEECH	CHAR	1	0	Fee edit control
52	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
53	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	OIHL
54	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	OIHL
55	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
56	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	MARA
57	OIDMSG_PRD	☐	OIDMSG_PRD	OIDMSG_PRD	CHAR	1	0	Message type for product with contract restrictions
58	OIDMSG_QTY	☐	OIDMSG_QTY	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions quantity
59	OIDMSG_UOM	☐	OIDMSG_UOM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions unit of measure
60	OIDMSG_DAT	☐	OIDMSG_DAT	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions validity period
61	OIDMSG_TRM	☐	OIDMSG_TRM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions payment terms
62	OIDMSG_SHP	☐	OIDMSG_SHP	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions ship-to party
63	OIGNRULE	☐	OIC_GNRULE	GRPNO	NUMC	3	0	Gross/net pricing rule	TFRM
64	OID_SHIP	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
65	OIA_IPMVAT	☐	OIA_IPMVAT	OIA_IPMVAT	CHAR	1	0	VAT on internally-posted material

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OI0VBAP	OIBASPROD	MARA	MATNR
2	OI0VBAP	OICONTNR	VBUK	VBELN
3	OI0VBAP	OIC_DCITYC	T005G	CITYC
4	OI0VBAP	OIC_DCOUNC	T005E	COUNC
5	OI0VBAP	OIC_DLAND1	T005	LAND1
6	OI0VBAP	OIC_DRCREG	T005S	BLAND
7	OI0VBAP	OIC_DRCTRY	T005	LAND1
8	OI0VBAP	OIC_DREGIO	T005S	BLAND
9	OI0VBAP	OIC_LIFNR	LFA1	LIFNR
10	OI0VBAP	OIC_MOT	TVTR	VKTRA
11	OI0VBAP	OIC_OCITYC	T005G	CITYC
12	OI0VBAP	OIC_OCOUNC	T005E	COUNC
13	OI0VBAP	OIC_OLAND1	T005	LAND1
14	OI0VBAP	OIC_OREGIO	T005S	BLAND
15	OI0VBAP	OIDRC	OICDC	OIDRC
16	OI0VBAP	OID_SHIP	KNA1	KUNNR
17	OI0VBAP	OIEXGTYP	TOIA2	EXGTYP
18	OI0VBAP	OIGNRULE	TFRM	GRPNO
19	OI0VBAP	OIHANTYP	OIH5	HANTYP
20	OI0VBAP	OIH_LCFOL	OIHL	LICIN
21	OI0VBAP	OIH_LICIN	OIHL	LICIN
22	OI0VBAP	OIH_LICTP	OIH20	LICTP
23	OI0VBAP	OIINEX	OIH16	INEX
24	OI0VBAP	OIMETIND	OICMI	OIMETIND
25	OI0VBAP	OINETCYC	T008	ZAHLS
26	OI0VBAP	OIPSDRC	OICDC	OIDRC
27	OI0VBAP	OISLF	OICSL	OISLF
28	OI0VBAP	OITAXFROM	OIH4	TAXKEY
29	OI0VBAP	OITAXGRP	OIH2	TAXGRP
30	OI0VBAP	OITAXTO	OIH4	TAXKEY
31	OI0VBAP	OIWAP	OICWA	OIWAP

History

Last changed by/on	SAP	20110901
SAP Release Created in