SAP ABAP Table OI0_BWVBRP (Oil fields for BW (S262,..) based on OILVBRP (billing item))
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS (Application Component) Downstream
⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)
⤷ IS-OIL-DS (Application Component) Downstream
⤷ OI0_BW (Package) Oil/BW Business Information Warehouse (extractors,..)
Basic Data
Table Category | INTTAB | Structure |
Structure | OI0_BWVBRP | Table Relationship Diagram |
Short Description | Oil fields for BW (S262,..) based on OILVBRP (billing item) |
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 | OIEDOK | OIH_EDOK | X | CHAR | 1 | 0 | Excise duty validation indicator | ||
2 | .INCLUDE | 0 | 0 | External Bill of Lading and Misc. Deliv. No | |||||
3 | OID_EXTBOL | OID_EXTBOL | OID_EXTBOL | CHAR | 16 | 0 | External bill of lading | ||
4 | OID_MISCDL | OID_MISCDL | OID_MISCDL | CHAR | 16 | 0 | Miscellaneous delivery number | ||
5 | OIPIPEVAL | OID_PIPEV | X | CHAR | 1 | 0 | Validation indicator for pipeline fields (X=ON, blank=OFF) | ||
6 | OIC_LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
7 | .INCLUDE | 0 | 0 | Destination/Origin City+County (part of OIC_DEST_ORIG incl.) | |||||
8 | OIC_DCITYC | OIC_DCITYC | CITYC | CHAR | 4 | 0 | Destination city code | * | |
9 | OIC_DCOUNC | OIC_DCOUNC | COUNC | CHAR | 3 | 0 | Destination county code | * | |
10 | OIC_OCITYC | OIC_OCITYC | CITYC | CHAR | 4 | 0 | Origin city code | * | |
11 | OIC_OCOUNC | OIC_OCOUNC | COUNC | CHAR | 3 | 0 | Origin county code | * | |
12 | OIC_PTRIP | OIC_PTRIP | OIC_PTRIP | CHAR | 16 | 0 | Pipeline trip number (external) | ||
13 | OIC_PBATCH | OIC_PBATCH | OIC_PBATCH | CHAR | 16 | 0 | Pipeline operator´s external batch number | ||
14 | OIC_MOT | OIC_MOT | VKTRA | CHAR | 2 | 0 | IS-OIL MAP external details mode of transport | TVTR | |
15 | OIC_TRUCKN | OIC_TRUCKN | OIC_TRUCKN | CHAR | 10 | 0 | Truck number | ||
16 | OIA_BASELO | OIA_BASELO | OIA_BASELO | CHAR | 15 | 0 | Base location | ||
17 | CMETH | OIB_CMETH | OIB_CMETH | CHAR | 1 | 0 | Quantity Conversion Method | ||
18 | OITAXFROM | OIH_TAXFRO | OIH_TAXKEY | CHAR | 2 | 0 | Excise duty tax key for 'from' location | * | |
19 | OIHANTYP | OIH_HANTYP | OIH_HANTYP | CHAR | 2 | 0 | Excise Duty Handling Type | * | |
20 | OITAXGRP | OIH_TAXGRP | OIH_TAXGRP | CHAR | 2 | 0 | Excise Duty Group | * | |
21 | OITAXTO | OIH_TAXTO | OIH_TAXKEY | CHAR | 2 | 0 | Excise duty tax key for 'to' location | * | |
22 | OICERTF1 | OIH_CERTF1 | OIH_CERTF1 | CHAR | 15 | 0 | Excise tax external license number | ||
23 | OIOILCON | OIH_OILCON | OIH_OILCON | DEC | 5 | 2 | Oil content in a material as a percentage | ||
24 | OIEDBAL | OIH_EDBAL | X | CHAR | 1 | 0 | Excise duty balancing is required (indicator) | ||
25 | OIPRICIE | OIH_PRICIE | X | CHAR | 1 | 0 | ED pricing: external (indicator) | ||
26 | OIINEX | OIH_INEX | OIH_INEX | CHAR | 2 | 0 | Code for internal or external excise duty rate determination | * | |
27 | OIDRC | OIC_DRC | OIC_DRC | CHAR | 5 | 0 | Differential Reference Code (DRC) | * | |
28 | OIPSDRC | OIC_PSDRC | OIC_DRC | CHAR | 5 | 0 | Pricing DRC (grouping customers by DRC for pricing) | * | |
29 | OICONTNR | OIC_CONTNR | VBELN | CHAR | 10 | 0 | Outline agreement: contract | * | |
30 | OIC_TIME | OIC_TIME | OIC_TIME | TIMS | 6 | 0 | Time for time-pricing | ||
31 | OIC_DATE | OIC_DATE | OIC_DATE | DATS | 8 | 0 | Date for time pricing | ||
32 | OIFEECH | OIA_FEECH | OIA_FEECH | CHAR | 1 | 0 | Fee edit control | ||
33 | OIEXGNUM | OIA_EXGNUM | OIA_EXGNUM | CHAR | 10 | 0 | Exchange agreement number | * | |
34 | OIEXGTYP | OIA_EXGTYP | OIA_EXGTYP | CHAR | 4 | 0 | Exchange type | TOIA2 | |
35 | OIFEEDT | OIA_FEEDT | DATUM | DATS | 8 | 0 | Fee pricing condition date | ||
36 | OINETCYC | OIA_NETCYC | ZAHLS | CHAR | 1 | 0 | Netting cycle (FI blocking indicator) | T008 | |
37 | OIH_LICTP | OIH_LICTP | OIH_LICTP | CHAR | 4 | 0 | License type | * | |
38 | OIH_LICIN | OIH_LICIN | OIH_LICIN | CHAR | 10 | 0 | Excise tax internal license number | * | |
39 | OIH_LCFOL | OIH_LCFOL | OIH_LICIN | CHAR | 10 | 0 | Follow-on license for quantity license | * | |
40 | OIPBL | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | * | |
41 | OIBASPROD | OIA_SBMAT | MATNR | CHAR | 18 | 0 | Base product number | * | |
42 | OIA_IPMVAT | OIA_IPMVAT | OIA_IPMVAT | CHAR | 1 | 0 | VAT on internally-posted material | ||
43 | OIINVCYC1 | OIA_INCYCA | KREUZ | CHAR | 1 | 0 | Invoice cycle indicator active (X/ ) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OI0_BWVBRP | OIC_LIFNR | LFA1 | LIFNR | |||
2 | OI0_BWVBRP | OIC_MOT | TVTR | VKTRA | |||
3 | OI0_BWVBRP | OIEXGTYP | TOIA2 | EXGTYP | |||
4 | OI0_BWVBRP | OINETCYC | T008 | ZAHLS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |