SAP table EKBZ (History per Purchasing Document: Delivery Costs)

SAP table EKBZ has 9 primary key fields being MANDT,EBELN,EBELP,STUNR,ZAEHK,VGABE,GJAHR,BELNR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
STUNR Step Number NUMC 3 0 STUNR
ZAEHK Condition Counter NUMC 3 0 DZAEHK
VGABE Transaction/event type, purchase order history CHAR 1 0 VGABE
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
P Invoice Parking
Q Comparison for Internally Posted Material (Only IS-OIL)
R Return Delivery via Delivery Note
S Service Entry Sheet in SAP S/4HANA
V Down Payment Request Clearing
GJAHR Fiscal Year NUMC 4 0 GJAHR
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI Item in Material Document NUMC 4 0 MBLPO
BEWTP Purchase Order History Category CHAR 1 0 BEWTP
BUDAT Posting Date in the Document DATS 8 0 BUDAT
MENGE Quantity QUAN 13 3 MENGE_D
DMBTR Amount in Local Currency CURR 13 2 DMBTR_CS
WRBTR Amount in Document Currency CURR 13 2 WRBTR_CS
WAERS Currency Key CUKY 5 0 WAERS
AREWR GR/IR account clearing value in local currency CURR 13 2 AREWR
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
XBLNR Reference Document Number CHAR 16 0 XBLNR1
FRBNR Number of Bill of Lading at Time of Goods Receipt CHAR 16 0 FRBNR1
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
REEWR Invoice Value Entered (in Local Currency) CURR 13 2 REEWR
REFWR Invoice Value in Foreign Currency CURR 13 2 REFWR
BWTAR Valuation Type CHAR 10 0 BWTAR_D
KSCHL Condition Type CHAR 4 0 KSCHL
BPMNG Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
AREWW Clearing value on GR/IR clearing account (transac. currency) CURR 13 2 AREWW
HSWAE Local currency key CUKY 5 0 HSWAE
VNETW Net value of condition (predefined externally) CURR 13 2 VNETWR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
SHKKO Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
AREWB Clearing Value on GR/IR Account in PO Currency CURR 13 2 AREWB
REWRB Invoice Amount in PO Currency CURR 13 2 REWRB
SAPRL SAP Release CHAR 4 0 SAPRL
MENGE_POP Quantity QUAN 13 3 MENGE_D
DMBTR_POP Amount in Local Currency CURR 13 2 DMBTR_CS
WRBTR_POP Amount in Document Currency CURR 13 2 WRBTR_CS
BPMNG_POP Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
AREWR_POP GR/IR account clearing value in local currency CURR 13 2 AREWR
KUDIF Exchange Rate Difference Amount CURR 13 2 KUDIF
XMACC Multiple Account Assignment CHAR 1 0 XMACC
WKURS Exchange Rate DEC 9 5 WKURS
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
/CWM/BAMNG Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/BAMNG
/CWM/WESBS Goods Receipt Blocked Stock in Base/Parallel Unit of Measure QUAN 13 3 /CWM/WESBS
/CWM/TY2TQ Type of Parallel Unit of Measure CHAR 1 0 /CWM/TY2TQ

EKBZ foreign key relationships

Table Field Check Table Check Field
0 EKBZ EBELN EKKO Purchasing Document Header EBELN
1 EKBZ EBELP EKPO Purchasing Document Item MANDT
1 EKBZ EBELP EKPO Purchasing Document Item EBELN
0 EKBZ MANDT T000 Clients MANDT