SAP ABAP Table OILVBRP (IS-Oil Append for table VBRP)

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	OILVBRP	Table Relationship Diagram
Short Description	IS-Oil Append for table VBRP

Delivery and Maintenance

Pool/cluster	VBRP
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	OIEDOK	☐	OIH_EDOK	X	CHAR	1	0	Excise duty validation indicator
2	.INCLUDE	☐				0	0	External Bill of Lading and Misc. Deliv. No
5	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
26	CMETH	☐	OIB_CMETH	OIB_CMETH	CHAR	1	0	Quantity Conversion Method
27	OITAXFROM	☐	OIH_TAXFRO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'from' location	OIH4
28	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
29	OITAXGRP	☐	OIH_TAXGRP	OIH_TAXGRP	CHAR	2	0	Excise Duty Group	OIH2
30	OITAXTO	☐	OIH_TAXTO	OIH_TAXKEY	CHAR	2	0	Excise duty tax key for 'to' location	OIH4
31	OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
32	OIOILCON	☐	OIH_OILCON	OIH_OILCON	DEC	5	2	Oil content in a material as a percentage
33	OIDATFM1	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
34	OIDATTO1	☐	OIH_DATTO1	DATUM	DATS	8	0	Valid to date for excise duty tax certificate
35	OIEDBAL	☐	OIH_EDBAL	X	CHAR	1	0	Excise duty balancing is required (indicator)
36	OIPRICIE	☐	OIH_PRICIE	X	CHAR	1	0	ED pricing: external (indicator)
37	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	OIH16
38	OIEDBALM	☐	OIH_EDBALM	OIH_EDBALM	CHAR	1	0	Excise duty balancing method indicator
39	OITAXLOD	☐	OIH_TAXLOD	OIH_TXVAL	CURR	13	2	Excise duty tax value for goods loading
40	OITAXISS	☐	OIH_TAXISS	OIH_TXVAL	CURR	13	2	Excise duty value for goods issue
41	OITAXINV	☐	OIH_TAXINV	OIH_TXVAL	CURR	13	2	Excise duty tax value for an invoice
42	OIDRC	☐	OIC_DRC	OIC_DRC	CHAR	5	0	Differential Reference Code (DRC)	*
43	OIC_DRCTRY	☐	OIC_DRCTRY	LAND1	CHAR	3	0	DRC country	*
44	OIC_DRCREG	☐	OIC_DRCREG	REGIO	CHAR	3	0	DRC region	*
45	OIMETIND	☐	OIC_METIND	OIC_METIND	CHAR	4	0	Metropolitan indicator	*
46	OIWAP	☐	OIC_WAP	OIC_WAP	CHAR	3	0	Wide-area pricing zone	*
47	OISLF	☐	OIC_SLF	OIC_SLF	CHAR	3	0	State license fee zone	*
48	OIPSDRC	☐	OIC_PSDRC	OIC_DRC	CHAR	5	0	Pricing DRC (grouping customers by DRC for pricing)	*
49	OICONTNR	☐	OIC_CONTNR	VBELN	CHAR	10	0	Outline agreement: contract	*
50	OIC_KMPOS	☐	OIC_KMPOS	OIC_KMPOS	NUMC	6	0	Reference contract line item number
51	OIC_TIME	☐	OIC_TIME	OIC_TIME	TIMS	6	0	Time for time-pricing
52	OIC_DATE	☐	OIC_DATE	OIC_DATE	DATS	8	0	Date for time pricing
53	OIFEECH	☐	OIA_FEECH	OIA_FEECH	CHAR	1	0	Fee edit control
54	.INCLUDE	☐				0	0	Exchanges structure to be included in Core tables
60	OIH_LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
61	OIH_LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	OIHL
62	OIH_LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	OIHL
63	OIH_FOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
64	OIPBL	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
65	OISBREL	☐	OIA_SBREL	OIA_SBREL	NUMC	3	0	Sub product/ base product relevence indicator
66	OIBASPROD	☐	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
67	OITITLE	☐	OIC_TITLE	OIC_TITLE	CHAR	1	0	Location of title transfer for Incoterms purposes
68	OIGNRULE	☐	OIC_GNRULE	GRPNO	NUMC	3	0	Gross/net pricing rule	*
69	OIA_IPMVAT	☐	OIA_IPMVAT	OIA_IPMVAT	CHAR	1	0	VAT on internally-posted material
70	.INCLUDE	☐				0	0	Invoice cycle active flag 1-n (grouped)
80	OILIKWTF	☐	OIA_OLIKWT	WERTV10	CURR	19	2	Open delivery credit value transferred during billing
81	OILIMETF	☐	OIA_OLIMET	MENGV15_3	QUAN	15	3	Open delivery quantity transferred during billing
82	OIFKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
83	OISMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
84	OIFKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
85	OILMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
86	OINTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
87	OIBRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
88	OIVOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
89	OIHFOLQTY	☐	OIH_FOLQTY	MENG13	QUAN	13	3	Excise tax follow-on license quantity
90	OIVMENG	☐	OIC_VMENG	OIC_MENG13	QUAN	13	3	Req. quantity for mat.management in base uom (stand. conv.)
91	.INCLUDE	☐				0	0	SSR I&S Include for VBRP

Foreign Keys

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

History

Last changed by/on	SAP	20050223
SAP Release Created in