1. Home
  2. Resources
  3. SAP Tables
  4. EKBZ - History per Purchasing Document: Delivery Costs

SAP Table EKBZ

History per Purchasing Document: Delivery Costs

EKBZ (History per Purchasing Document: Delivery Costs) 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 EKBZ to other SAP tables.

Source: EKBZ (History per Purchasing Document: Delivery Costs)

EKBZ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
STUNR Step number STUNR NUMC 3 0
ZAEHK Condition counter DZAEHK NUMC 2 0
VGABE Transaction/event type, purchase order history VGABE CHAR 1 0
1 Goods Receipt
2 Invoice Receipt
3 Subseq. Debit/Credit
4 Down Payment
5 Payment
6 Goods Issue for Stock Transfer
7 Consumption (Subcontracting)
8 Delivery (Stock Transfer)
9 Service Entry Sheet
A Down Payment Request
C Down Payment Clearing
Q Comparison for Internally Posted Material (Only IS-OIL)
R Return Delivery via Delivery Note
P Invoice Parking
V Down Payment Request Clearing
H Invoice On Hold
M Posted Subsequent Debit with Reference to a Contract
K Posted Invoice with Reference to a Contract
L Parked Invoice with Reference to a Contract
N Posted Subsequent Debit for Contract in Blanket PO
O Posted Invoice for Contract in Blanket Purchase Order
G Parked Invoice for Contract in Blanket Purchase Order
GJAHR Fiscal Year GJAHR NUMC 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Item in Material Document MBLPO NUMC 4 0
BEWTP PO history category BEWTP CHAR 1 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
MENGE Quantity MENGE_D QUAN 13 3
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
AREWR GR/IR account clearing value in local currency AREWR CURR 13 2
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
XBLNR Reference Document Number XBLNR1 CHAR 16 0
FRBNR Number of Bill of Lading at Time of Goods Receipt FRBNR1 CHAR 16 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
REEWR Invoice Value Entered (in Local Currency) REEWR CURR 13 2
REFWR Invoice value in foreign currency REFWR CURR 13 2
BWTAR Valuation Type BWTAR_D CHAR 10 0
KSCHL Condition Type KSCHL CHAR 4 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
AREWW Clearing value on GR/IR clearing account (transac. currency) AREWW CURR 13 2
HSWAE Local currency key HSWAE CUKY 5 0
VNETW Net value of condition (predefined externally) VNETWR CURR 13 2
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
SHKKO Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
AREWB Clearing Value on GR/IR Account in PO Currency AREWB CURR 13 2
REWRB Invoice Amount in PO Currency REWRB CURR 13 2
SAPRL SAP Release SAPRL CHAR 4 0
MENGE_POP Quantity MENGE_D QUAN 13 3
DMBTR_POP Amount in Local Currency DMBTR CURR 13 2
WRBTR_POP Amount in document currency WRBTR CURR 13 2
BPMNG_POP Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
AREWR_POP GR/IR account clearing value in local currency AREWR CURR 13 2
KUDIF Exchange Rate Difference Amount KUDIF CURR 13 2
XMACC Multiple Account Assignment XMACC CHAR 1 0
WKURS Exchange Rate WKURS DEC 9 5
/CWM/BAMNG Quantity in Parallel Unit of Measure /CWM/BAMNG QUAN 13 3
/CWM/WESBS Goods Receipt Blocked Stock in Base/Parallel Unit of Measure /CWM/WESBS QUAN 13 3
/CWM/TY2TQ Type of Parallel Unit of Measure /CWM/TY2TQ CHAR 1 0
A Parallel Unit of Measure and Valuation Unit of Measure
B Parallel Unit of Measure (BUoM is Valuation Unit of Measure)
C Alternative Parallel Unit of Measure
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

EKBZ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKBZ EBELN EKBZ MANDT EKKO Purchasing Document Header MANDT
EKBZ EBELN EKBZ EBELN EKKO Purchasing Document Header EBELN
EKBZ EBELP EKBZ MANDT EKPO Purchasing Document Item MANDT
EKBZ EBELP EKBZ EBELN EKPO Purchasing Document Item EBELN
EKBZ EBELP EKBZ EBELP EKPO Purchasing Document Item EBELP
EKBZ MANDT EKBZ MANDT T000 Clients MANDT
EKBZ OIINVCYC EKBZ MANDT TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) MANDT
EKBZ OIINVCYC EKBZ OIINVCYC TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) OIINVCYC