SAP table EKBE (History per Purchasing Document)

The EKBE table in SAP contains the history of purchasing documents. It tracks all changes and movements related to purchasing documents such as goods receipts, invoice receipts, and cancellations.

Key Features:

The EKBE table is essential for maintaining transparency and traceability in the procurement process.

SAP table EKBE has 8 primary key fields being MANDT,EBELN,EBELP,ZEKKN,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
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
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 Material Document Year NUMC 4 0 MJAHR
BELNR Number of Material Document CHAR 10 0 MBLNR
BUZEI Item in Material Document NUMC 4 0 MBLPO
BEWTP Purchase Order History Category CHAR 1 0 T163B BEWTP
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
BUDAT Posting Date in the Document DATS 8 0 BUDAT
MENGE Quantity QUAN 13 3 MENGE_D
BPMNG Quantity in purchase order price unit QUAN 13 3 MENGE_BPR
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 TCURC WAERS
AREWR GR/IR account clearing value in local currency CURR 13 2 AREWR
WESBS Goods Receipt Blocked Stock in Order Unit QUAN 13 3 WESBS
BPWES Quantity in GR blocked stock in order price unit QUAN 13 3 BPWES
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
XBLNR Reference Document Number CHAR 16 0 XBLNR1
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
GRUND Reason for Movement NUMC 4 0 T157D MB_GRBEW
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
EVERE Compliance with Shipping Instructions CHAR 2 0 T027C EVERE
REFWR Invoice Value in Foreign Currency CURR 13 2 REFWR
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
XWSBR Reversal of GR allowed for GR-based IV despite invoice CHAR 1 0 XWSBR
ETENS Sequential Number of Supplier Confirmation NUMC 4 0 ETENS
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
MWSKZ Tax on sales/purchases code CHAR 2 0 * MWSKZ
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
LSMNG Quantity in Unit of Measure from Delivery Note QUAN 13 3 LSMNG
LSMEH Unit of Measure From Delivery Note UNIT 3 0 T006 LSMEH
EMATN Material number CHAR 40 0 MARA EMATNR
AREWW Clearing value on GR/IR clearing account (transac. currency) CURR 13 2 AREWW
HSWAE Local currency key CUKY 5 0 TCURC HSWAE
BAMNG Quantity QUAN 13 3 MENGE_D
CHARG Batch Number CHAR 10 0 * CHARG_D
BLDAT Document Date in Document DATS 8 0 BLDAT
XWOFF Calculation of val. open CHAR 1 0 XWOFF
XUNPL Unplanned Account Assignment from Invoice Verification CHAR 1 0 XUNPL
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
SRVPOS Service number CHAR 18 0 * SRVPOS
PACKNO Package Number of Service NUMC 10 0 * PACKNO_EKBE
INTROW Line Number of Service NUMC 10 0 INTROW_EKBE
BEKKN Number of PO Account Assignment NUMC 2 0 BEKKN
LEMIN Returns Indicator CHAR 1 0 SRVRET
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
BPMNG_POP Quantity in purchase order price unit QUAN 13 3 MENGE_BPR
DMBTR_POP Amount in Local Currency CURR 13 2 DMBTR_CS
WRBTR_POP Amount in Document Currency CURR 13 2 WRBTR_CS
WESBB Valuated Goods Receipt Blocked Stock in Order Unit QUAN 13 3 WESBB
BPWEB Quantity in Valuated GR Blocked Stock in Order Price Unit QUAN 13 3 BPWEB
WEORA Acceptance At Origin CHAR 1 0 WEORA
AREWR_POP GR/IR account clearing value in local currency CURR 13 2 AREWR
KUDIF Exchange Rate Difference Amount CURR 13 2 KUDIF
RETAMT_FC Retention Amount in Document Currency CURR 13 2 RET_AMT_FC
RETAMT_LC Retention Amount in Company Code Currency CURR 13 2 RET_AMT_LC
RETAMTP_FC Posted Retention Amount in Document Currency CURR 13 2 RET_AMT_POST_FC
RETAMTP_LC Posted Security Retention Amount in Company Code Currency CURR 13 2 RET_AMT_POST_LC
XMACC Multiple Account Assignment CHAR 1 0 XMACC
WKURS Exchange Rate DEC 9 5 WKURS
INV_ITEM_ORIGIN Origin of an Invoice Item CHAR 1 0 INV_ITM_ORIGIN
Inv.Ver.: Item Newly Created
A Diff.Inv.: Item Newly Created
B Diff.Inv.: Item Copied from Preceding Invoice
VBELN_ST Delivery CHAR 10 0 VBELN_VL
VBELP_ST Delivery Item NUMC 6 0 POSNR_VL
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
SESUOM Unit of Measure from Service Entry Sheet UNIT 3 0 * SES_UOM
LOGSY Logical System CHAR 10 0 * LOGSYSTEM
ET_UPD Procedure for Updating the Schedule Line Quantity CHAR 1 0 ET_UPD1
No deviating procedure
1 Update MRP-Reduced Quantity Due to Return Delivery
2 Update Schedule Line Qty Due to ETANP = 'X'
3 Both MRP-Reduced Quantity and Schedule Line Quantity [1+2]
/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
/CWM/WESBB Val. Goods Receipt Blocked Stock in Basis or Parallel UoM QUAN 13 3 /CWM/WESBB
J_SC_DIE_COMP_F Depreciation completion flag CHAR 1 0 /SAPNEA/J_SC_DIE_COMP_F
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
QTY_DIFF Quantity QUAN 13 3 MENGE_QTYDIFF
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3

EKBE foreign key relationships

Table Field Check Table Check Field
0 EKBE BEWTP T163B Purchase Order History Categories MANDT
1 EKBE BWART T156 Movement Type MANDT
1 EKBE BWART T156 Movement Type BWART
0 EKBE BWTAR T149D Global Valuation Types MANDT
0 EKBE BWTAR T149D Global Valuation Types BWTAR
1 EKBE EBELN EKKO Purchasing Document Header EBELN
0 EKBE EBELP EKPO Purchasing Document Item MANDT
0 EKBE EBELP EKPO Purchasing Document Item EBELN
1 EKBE EMATN MARA General Material Data MANDT
1 EKBE EMATN MARA General Material Data MATNR
0 EKBE EVERE T027C Codes for Compliance with Shipping Instructions EVERE
1 EKBE GRUND T157D Reason for Movement MANDT
0 EKBE HSWAE TCURC Currency Codes MANDT
0 EKBE HSWAE TCURC Currency Codes WAERS
1 EKBE LSMEH T006 Units of Measurement MANDT
0 EKBE MANDT T000 Clients MANDT
1 EKBE MATNR MARA General Material Data MANDT
1 EKBE MATNR MARA General Material Data MATNR
0 EKBE WAERS TCURC Currency Codes MANDT
0 EKBE WAERS TCURC Currency Codes WAERS
1 EKBE WERKS T001W Plants/Branches MANDT
1 EKBE WERKS T001W Plants/Branches WERKS