SAP ABAP Table OILVBAP (IS-Oil Append for Sales document items)

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	OILVBAP	Table Relationship Diagram
Short Description	IS-Oil Append for Sales document items

Delivery and Maintenance

Pool/cluster	VBAP
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	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	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
14	OIEDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
15	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
16	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	OIH16
17	OIEDBALM	☐	OIH_EDBALM	OIH_EDBALM	CHAR	1	0	Excise duty balancing method indicator
18	OIDRC	☐	OIC_DRC	OIC_DRC	CHAR	5	0	Differential Reference Code (DRC)	OICDC
19	OIC_DRCTRY	☐	OIC_DRCTRY	LAND1	CHAR	3	0	DRC country	*
20	OIC_DRCREG	☐	OIC_DRCREG	REGIO	CHAR	3	0	DRC region	*
21	OIMETIND	☐	OIC_METIND	OIC_METIND	CHAR	4	0	Metropolitan indicator	*
22	OIWAP	☐	OIC_WAP	OIC_WAP	CHAR	3	0	Wide-area pricing zone	*
23	OISLF	☐	OIC_SLF	OIC_SLF	CHAR	3	0	State license fee zone	*
24	OIPSDRC	☐	OIC_PSDRC	OIC_DRC	CHAR	5	0	Pricing DRC (grouping customers by DRC for pricing)	*
25	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
46	.INCLUDE	☐				0	0	Exchanges structure to be included in Core tables
52	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	*
53	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
54	OIFEECH	☐	OIA_FEECH	OIA_FEECH	CHAR	1	0	Fee edit control
55	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
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	OIHL
58	OIH_FOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
59	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
60	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
61	OIDMSG_PRD	☐	OIDMSG_PRD	OIDMSG_PRD	CHAR	1	0	Message type for product with contract restrictions
62	OIDMSG_QTY	☐	OIDMSG_QTY	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions quantity
63	OIDMSG_UOM	☐	OIDMSG_UOM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions unit of measure
64	OIDMSG_DAT	☐	OIDMSG_DAT	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions validity period
65	OIDMSG_TRM	☐	OIDMSG_TRM	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions payment terms
66	OIDMSG_SHP	☐	OIDMSG_SHP	OIDMSG_PRD	CHAR	1	0	Message type for contract restrictions ship-to party
67	OIGNRULE	☐	OIC_GNRULE	GRPNO	NUMC	3	0	Gross/net pricing rule	*
68	OID_SHIP	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*

Foreign Keys

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

History

Last changed by/on	SAP	20050223
SAP Release Created in