SAP ABAP Table OI0VBAK (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	OI0VBAK	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	OIDMSG_SHP	☐	OIDMSG_SHP	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions ship-to party
5	OIDSTS_SHP	☐	OIDSTS_SHP	CHAR1_X	CHAR	1	0	Status of contract restriction for ship-to party
6	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
7	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
8	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
9	.INCLUDE	☐				0	0	Destination/Origin: City,County,Region,Country + Tax
10	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	T005G
11	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	T005E
12	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	T005S
13	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	T005
14	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	T005G
15	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	T005E
16	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	T005S
17	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	T005
18	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
19	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
20	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
21	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
22	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
23	OIC_AORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
24	OIC_ADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
25	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
26	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
27	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	OIH16
28	OIISOIL	☐	OID_ISOIL	OI0_XFELD	CHAR	1	0	Sales order created by IS-Oil: X=Yes BLANK=No
29	OIPTRFNC	☐	OID_PTRFNC	PARVW	CHAR	2	0	Partner function	TPAR
30	OIPARTNR	☐	OID_PARTNR	KUNNR	CHAR	10	0	Customer name (sold-to party or ship-to party)	KNA1
31	OILASTOR	☐	OID_LASTOR	VBELN	CHAR	10	0	Last order number	VBUK
32	OIDRC	☐	OIC_DRC	OIC_DRC	CHAR	5	0	Differential Reference Code (DRC)	OICDC
33	OIEXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	OIA01
34	OIEXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	TOIA2
35	OICHEADOFF	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
36	OIPBL	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
37	OIDRESTR	☐	OIDRESTR	CHAR1_X	CHAR	1	0	Contract restrictions flag
38	OIDMSG_PRD	☐	OIDMSG_PRD	OIDMSG_PRD	CHAR	1	0	Message type for product with contract restrictions
39	OIDMSG_QTY	☐	OIDMSG_QTY	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions quantity
40	OIDMSG_UOM	☐	OIDMSG_UOM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions unit of measure
41	OIDMSG_DAT	☐	OIDMSG_DAT	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions validity period
42	OIDMSG_TRM	☐	OIDMSG_TRM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions payment terms
43	OICNTPER	☐	OID_CNTPER	OID_CNTPER	CHAR	35	0	Contact person
44	OICNTNTE	☐	OID_CNTNTE	OID_CNTNTE	CHAR	35	0	Contact note
45	OICNTPHO	☐	OID_CNTPHO	OID_CNTPHO	CHAR	16	0	Contact tel. number
46	OID_SORTL	☐	OID_SORTL	OID_SORTL	NUMC	10	0	Descending sort key for sales orders (converted date)
47	OID_SORT2	☐	OID_SORT2	OID_SORTL	NUMC	10	0	Descending sort key for sales orders (converted time)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OI0VBAK	OICHEADOFF	KNA1	KUNNR
2	OI0VBAK	OIC_DCITYC	T005G	CITYC
3	OI0VBAK	OIC_DCOUNC	T005E	COUNC
4	OI0VBAK	OIC_DLAND1	T005	LAND1
5	OI0VBAK	OIC_DREGIO	T005S	BLAND
6	OI0VBAK	OIC_LIFNR	LFA1	LIFNR
7	OI0VBAK	OIC_MOT	TVTR	VKTRA
8	OI0VBAK	OIC_OCITYC	T005G	CITYC
9	OI0VBAK	OIC_OCOUNC	T005E	COUNC
10	OI0VBAK	OIC_OLAND1	T005	LAND1
11	OI0VBAK	OIC_OREGIO	T005S	BLAND
12	OI0VBAK	OIDRC	OICDC	OIDRC
13	OI0VBAK	OIEXGNUM	OIA01	EXGNUM
14	OI0VBAK	OIEXGTYP	TOIA2	EXGTYP
15	OI0VBAK	OIINEX	OIH16	INEX
16	OI0VBAK	OILASTOR	VBUK	VBELN
17	OI0VBAK	OIPARTNR	KNA1	KUNNR
18	OI0VBAK	OIPBL	OIFSPBL	PBLNR
19	OI0VBAK	OIPTRFNC	TPAR	PARVW

History

Last changed by/on	SAP	20110901
SAP Release Created in