Follow us on LinkedIn for your next SAP project

← Back to Search

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.

EKBZ table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

MANDT

Client

MANDT

T000

CLNT

EBELN

Purchasing Document Number

EBELN

EKKO

CHAR

EBELP

Item Number of Purchasing Document

EBELP

EKPO

NUMC

STUNR

Step number

STUNR

NUMC

ZAEHK

Condition counter

DZAEHK

NUMC

VGABE

Transaction/event type, purchase order history

VGABE

CHAR

Value	Description
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

BELNR

Accounting Document Number

BELNR_D

CHAR

BUZEI

Item in Material Document

MBLPO

NUMC

BEWTP

PO history category

BEWTP

CHAR

BUDAT

Posting Date in the Document

BUDAT

DATS

MENGE

Quantity

MENGE_D

QUAN

DMBTR

Amount in Local Currency

DMBTR

CURR

WRBTR

Amount in document currency

WRBTR

CURR

WAERS

Currency Key

WAERS

CUKY

AREWR

GR/IR account clearing value in local currency

AREWR

CURR

SHKZG

Debit/Credit Indicator

SHKZG

CHAR

Value	Description
H	Credit
S	Debit

XBLNR

Reference Document Number

XBLNR1

CHAR

FRBNR

Number of Bill of Lading at Time of Goods Receipt

FRBNR1

CHAR

LIFNR

Account Number of Vendor or Creditor

LIFNR

CHAR

CPUDT

Day On Which Accounting Document Was Entered

CPUDT

DATS

CPUTM

Time of Entry

CPUTM

TIMS

REEWR

Invoice Value Entered (in Local Currency)

REEWR

CURR

REFWR

Invoice value in foreign currency

REFWR

CURR

BWTAR

Valuation Type

BWTAR_D

CHAR

KSCHL

Condition Type

KSCHL

CHAR

BPMNG

Quantity in Purchase Order Price Unit

BPMNG

QUAN

AREWW

Clearing value on GR/IR clearing account (transac. currency)

AREWW

CURR

HSWAE

Local currency key

HSWAE

CUKY

VNETW

Net value of condition (predefined externally)

VNETWR

CURR

ERNAM

Name of Person who Created the Object

ERNAM

CHAR

SHKKO

Debit/Credit Indicator

SHKZG

CHAR

Value	Description
H	Credit
S	Debit

AREWB

Clearing Value on GR/IR Account in PO Currency

AREWB

CURR

REWRB

Invoice Amount in PO Currency

REWRB

CURR

SAPRL

SAP Release

SAPRL

CHAR

MENGE_POP

Quantity

MENGE_D

QUAN

DMBTR_POP

Amount in Local Currency

DMBTR

CURR

WRBTR_POP

Amount in document currency

WRBTR

CURR

BPMNG_POP

Quantity in Purchase Order Price Unit

BPMNG

QUAN

AREWR_POP

GR/IR account clearing value in local currency

AREWR

CURR

KUDIF

Exchange Rate Difference Amount

KUDIF

CURR

XMACC

Multiple Account Assignment

XMACC

CHAR

WKURS

Exchange Rate

WKURS

DEC

/CWM/BAMNG

Quantity in Parallel Unit of Measure

/CWM/BAMNG

QUAN

/CWM/WESBS

Goods Receipt Blocked Stock in Base/Parallel Unit of Measure

/CWM/WESBS

QUAN

/CWM/TY2TQ

Type of Parallel Unit of Measure

/CWM/TY2TQ

CHAR

Value	Description
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

OIA_SPLTIV

Indicator for split invoice verification

OIA_SPLTIV

CHAR

Value	Description
NULL	No split invoice verification
X	Split invoice verification

LFGJA

Fiscal Year of a Reference Document

LFBJA

NUMC

LFBNR

Document No. of a Reference Document

LFBNR

CHAR

LFPOS

Item of a Reference Document

LFPOS

NUMC

OIINVCYC

Invoice cycle

OIA_INVCYC

TOIA10

NUMC

KBETR

Rate (condition amount or percentage)

KBETR

CURR

KRECH

Calculation type for condition

KRECH

CHAR

Value	Description
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

KMEIN

Condition unit

KMEIN

UNIT

KNTYP

Condition category (examples: tax, freight, price, cost)

KNTYP

CHAR

Value	Description
$	TaxJurCode trigger (without license check KNVL)
+	Tax exemption license via conditions
-	Total charges (only IS-OIL)
NULL	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

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