SAP table OIL_EKBZ (IS-OIL data fields for EKBZ)

Field Description Data Type Length Decimals Checktable Data Element
OIA_ZTERM Terms of payment key CHAR 4 0 DZTERM
OIA_SPLTIV Indicator for split invoice verification CHAR 1 0 OIA_SPLTIV
No split invoice verification
X Split invoice verification
LFGJA Fiscal Year of a Reference Document NUMC 4 0 LFBJA
LFBNR Document No. of a Reference Document CHAR 10 0 LFBNR
LFPOS Item of a Reference Document NUMC 4 0 LFPOS
OIINVCYC Invoice cycle NUMC 1 0 TOIA10 OIA_INVCYC
KBETR Condition Amount or Percentage CURR 11 2 KBETR
KRECH Calculation Type for Condition CHAR 1 0 KRECH
A Percentage
B Fixed Amount
C Quantity
D Gross Weight
E Net Weight
F Volume
G Formula
H Percentage (in Hundreds)
I Percentage (Travel Costs)
J Per Mille
K Per Mille (in Thousands)
L Points
M Quantity - Monthly Price
N Quantity - Year 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)
V Quantity Adjustment
W Percentage (with 6 Decimal Places)
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 * KMEIN
KNTYP Condition Category (Examples: Tax, Freight, Price, Cost) CHAR 1 0 KNTYP
$ TaxJurCode trigger (without license check KNVL)
& AFS Value-Added Services
+ 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
a Reserved (fixed extra pay)
B Delivery costs
b Transfer Price for Group Valuation
C Insurance
c Transfer price for profit centers
d Confirmed purchase net price/value
D Tax
E Cash discount
e Down payment request/down payment clearing
f Free goods - inclusive
F Freight
G Internal price
g Payment
H Basic price
h Profit Center Cost
I Price for intercompany billing
i Ship & Debit 1 (IBU HiTec)
J Customer expected price / customer value (excl.tax)
j Ship & Debit 2 (IBU HiTec)
K Base amount excluding tax
L Generally new when copying
l TP-ILV: Base Tarif That Covers Costs
M Sales tax w/license-checking (VAT)
m SSR Discount (only IS-Oil)
N Input Tax not Deductible
n Profit Center Internal Price (Route)
o AFS Season Determination
O Variants
P Base amount including tax
p SSR Partner Commission (only IS-OIL)
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
OICONDWAERS Currency Key CUKY 5 0 * WAERS

OIL_EKBZ foreign key relationships

Table Field Check Table Check Field
0 OIL_EKBZ OIINVCYC TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) MANDT
0 OIL_EKBZ OIINVCYC TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) OIINVCYC