SAP ABAP Table OILVBAK (IS-Oil append structure for sales document header table)

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	OILVBAK	Table Relationship Diagram
Short Description	IS-Oil append structure for sales document header table

Delivery and Maintenance

Pool/cluster	VBAK
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	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
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	*
30	OIPARTNR	☐	OID_PARTNR	KUNNR	CHAR	10	0	Customer name (sold-to party or ship-to party)	*
31	OILASTOR	☐	OID_LASTOR	VBELN	CHAR	10	0	Last order number	*
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)	*
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)
48	OICFKARTDI	☐	OICFKARTDI	FKART	CHAR	4	0	Differential invoice billing type proposal	*
49	OIAEVGTYPE	☐	OIA_EVTYPE	OIA_EVTYPE	CHAR	1	0	Evergreen type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OILVBAK	OIC_DCITYC	T005G	CITYC
2	OILVBAK	OIC_DCOUNC	T005E	COUNC
3	OILVBAK	OIC_DLAND1	T005	LAND1
4	OILVBAK	OIC_DREGIO	T005S	BLAND
5	OILVBAK	OIC_LIFNR	LFA1	LIFNR
6	OILVBAK	OIC_MOT	TVTR	VKTRA
7	OILVBAK	OIC_OCITYC	T005G	CITYC
8	OILVBAK	OIC_OCOUNC	T005E	COUNC
9	OILVBAK	OIC_OLAND1	T005	LAND1
10	OILVBAK	OIC_OREGIO	T005S	BLAND
11	OILVBAK	OIDRC	OICDC	OIDRC
12	OILVBAK	OIEXGNUM	OIA01	EXGNUM	KEY	1	CN
13	OILVBAK	OIEXGTYP	TOIA2	EXGTYP	KEY	1	CN
14	OILVBAK	OIINEX	OIH16	INEX
15	OILVBAK	OIPBL	OIFSPBL	PBLNR		1	CN

History

Last changed by/on	SAP	20050223
SAP Release Created in