1. Home
  2. Resources
  3. SAP Tables
  4. OIL_EKBZ - IS-OIL data fields for EKBZ

SAP Table OIL_EKBZ

IS-OIL data fields for EKBZ

OIL_EKBZ (IS-OIL data fields for EKBZ) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIL_EKBZ to other SAP tables.

Source: OIL_EKBZ (IS-OIL data fields for EKBZ)

OIL_EKBZ table fields

Field Data element Checktable Datatype Length Decimals
OIA_ZTERM Terms of Payment Key DZTERM CHAR 4 0
OIA_SPLTIV Indicator for split invoice verification OIA_SPLTIV CHAR 1 0
NULL No split invoice verification
X Split invoice verification
LFGJA Fiscal Year of a Reference Document LFBJA NUMC 4 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
OIINVCYC Invoice cycle OIA_INVCYC TOIA10 NUMC 1 0
KBETR Rate (condition amount or percentage) KBETR CURR 11 2
KRECH Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly price
O Quantity - daily price
P Quantity - weekly price
Q Commodity Price
R Distance-dependent
S Number of shipping units
T Multi-dimensional
U Percentage FIN (CRM Only)
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit KMEIN UNIT 3 0
KNTYP Condition category (examples: tax, freight, price, cost) KNTYP CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
B Delivery costs
C Insurance
D Tax
E Cash discount
F Freight
G Internal price
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Input Tax not Deductible
O Variants
P Base amount including tax
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
a Reserved (fixed extra pay)
b Transfer Price for Group Valuation
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m SSR Discount (only IS-Oil)
n Profit Center Internal Price (Route)
o AFS Season Determination
p SSR Partner Commission (only IS-OIL)
& AFS Value-Added Services
OICONDWAERS Currency Key WAERS CUKY 5 0

OIL_EKBZ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIL_EKBZ OIINVCYC EKBZ MANDT TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) MANDT
OIL_EKBZ OIINVCYC OIL_EKBZ OIINVCYC TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) OIINVCYC