1. Home
  2. Resources
  3. SAP Tables
  4. EKBE - History per Purchasing Document

SAP Table EKBE

History per Purchasing Document

EKBE (History per Purchasing Document) 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 EKBE to other SAP tables.

EKBE 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
ZEKKN Sequential Number of Account Assignment DZEKKN 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 Material Document Year MJAHR NUMC 4 0
BELNR Number of Material Document MBLNR CHAR 10 0
BUZEI Item in Material Document MBLPO NUMC 4 0
BEWTP PO history category BEWTP T163B CHAR 1 0
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
MENGE Quantity MENGE_D QUAN 13 3
BPMNG Quantity in purchase order price unit MENGE_BPR 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 TCURC CUKY 5 0
AREWR GR/IR account clearing value in local currency AREWR CURR 13 2
WESBS Goods Receipt Blocked Stock in Order Unit WESBS QUAN 13 3
BPWES Quantity in GR blocked stock in order price unit BPWES QUAN 13 3
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
XBLNR Reference Document Number XBLNR1 CHAR 16 0
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
GRUND Reason for Movement MB_GRBEW T157D NUMC 4 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
EVERE Compliance with Shipping Instructions EVERE T027C CHAR 2 0
REFWR Invoice value in foreign currency REFWR CURR 13 2
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
XWSBR Reversal of GR allowed for GR-based IV despite invoice XWSBR CHAR 1 0
X Yes
NULL No
ETENS Sequential Number of Vendor Confirmation ETENS NUMC 4 0
KNUMV Number of the document condition KNUMV CHAR 10 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
LSMNG Quantity in Unit of Measure from Delivery Note LSMNG QUAN 13 3
LSMEH Unit of Measure From Delivery Note LSMEH T006 UNIT 3 0
EMATN Material Number EMATNR MARA CHAR 18 0
AREWW Clearing value on GR/IR clearing account (transac. currency) AREWW CURR 13 2
HSWAE Local currency key HSWAE TCURC CUKY 5 0
BAMNG Quantity MENGE_D QUAN 13 3
CHARG Batch Number CHARG_D CHAR 10 0
BLDAT Document Date in Document BLDAT DATS 8 0
XWOFF Calculation of val. open XWOFF CHAR 1 0
X Yes
NULL No
XUNPL Unplanned Account Assignment from Invoice Verification XUNPL CHAR 1 0
X Yes
NULL No
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
SRVPOS Service number SRVPOS CHAR 18 0
PACKNO Package Number of Service PACKNO_EKBE NUMC 10 0
INTROW Line Number of Service INTROW_EKBE NUMC 10 0
BEKKN Number of PO Account Assignment BEKKN NUMC 2 0
LEMIN Returns Indicator SRVRET CHAR 1 0
X Yes
NULL No
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
BPMNG_POP Quantity in purchase order price unit MENGE_BPR QUAN 13 3
DMBTR_POP Amount in Local Currency DMBTR CURR 13 2
WRBTR_POP Amount in document currency WRBTR CURR 13 2
WESBB Valuated Goods Receipt Blocked Stock in Order Unit WESBB QUAN 13 3
BPWEB Quantity in Valuated GR Blocked Stock in Order Price Unit BPWEB QUAN 13 3
WEORA Acceptance At Origin WEORA CHAR 1 0
X Yes
NULL No
AREWR_POP GR/IR account clearing value in local currency AREWR CURR 13 2
KUDIF Exchange Rate Difference Amount KUDIF CURR 13 2
RETAMT_FC Retention Amount in Document Currency RET_AMT_FC CURR 13 2
RETAMT_LC Retention Amount in Company Code Currency RET_AMT_LC CURR 13 2
RETAMTP_FC Posted Retention Amount in Document Currency RET_AMT_POST_FC CURR 13 2
RETAMTP_LC Posted Security Retention Amount in Company Code Currency RET_AMT_POST_LC CURR 13 2
XMACC Multiple Account Assignment XMACC CHAR 1 0
WKURS Exchange Rate WKURS DEC 9 5
INV_ITEM_ORIGIN Origin of an Invoice Item INV_ITM_ORIGIN CHAR 1 0
NULL Inv.Ver.: Item Newly Created
A Diff.Inv.: Item Newly Created
B Diff.Inv.: Item Copied from Preceding Invoice
VBELN_ST Delivery VBELN_VL CHAR 10 0
VBELP_ST Delivery Item POSNR_VL NUMC 6 0
FRBNR Number of Bill of Lading at Time of Goods Receipt FRBNR1 CHAR 16 0
OIA_IPMVAT VAT on internally-posted material OIA_IPMVAT CHAR 1 0
NULL No VAT calculation
X VAT calculation with subtotal V of pricing procedure
OIVATH Amount in Local Currency DMBTR CURR 13 2
OIVATF Amount in document currency WRBTR CURR 13 2
OIIMATV Internal material value OIA_IMATV CURR 13 2
OIMATCYC Invoicing cycle for purchase material costs OIA_MATCYC NUMC 1 0
OITAXVAL Excise duty value in material inventory account OIH_TAXVAL CURR 13 2
OITAXCON Excise duty tax from pricing conditions OIH_TAXCON CURR 13 2
OIEDCL Excise duty clearing value OIH_EDCL CURR 13 2
ET_UPD Procedure for Updating the Schedule Line Quantity ET_UPD1 CHAR 1 0
NULL 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 /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
/CWM/WESBB Val. Goods Receipt Blocked Stock in Basis or Parallel UoM /CWM/WESBB QUAN 13 3
J_SC_DIE_COMP_F Depreciation completion flag /SAPNEA/J_SC_DIE_COMP_F CHAR 1 0

EKBE foreign key relationships

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