1. Home
  2. Resources
  3. SAP Tables
  4. EKBEV - PO History for Update Program

SAP Table EKBEV

PO History for Update Program

EKBEV (PO History for Update Program) 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 EKBEV to other SAP tables.

EKBEV 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
NOETT Do not update schedule (kanban scheduling agreement) NOETT CHAR 1 0
X Yes
NULL No
RETPO Returns Item RETPO CHAR 1 0
X Yes
NULL No
STATU Status of Purchasing Document ESTAK CHAR 1 0
A RFQ with Quotation
B Purchase Order from Automatic Conversion of Requisitions
C Purchase Order from Goods Receipt
D Purchase Order from Data Transfer
E Purchase Order from Allocation Table
F Purchase Order from Kanban
G Purchase Order from Store Order
H Purchase Order from DRP
I Purchase Order from BAPI
J Purchase Order from ALE Scenario
L Scheduling Agreement from CRM
S Collective Purchase Order
X Purchase Order Created via Function Module
1 Purchase Order from APO
9 Enjoy Purchase Order
K Purchase Order from BBP
2 Third-Party Order from CRM
3 Returns Order from Incorrect Delivery
M Purchasing Document from E-Sourcing
4 Subsequent Stock Transport Order for Additional Item
5 Incorrect Item Returns from Stock Transport Orders
T Purchase Order from Transportation Management
W Purchase Order Ignored for Collective Delivery Run
NOPOT Do not update purchase order item (purchase order in GR) NOPOT CHAR 1 0
X Yes
NULL No

EKBEV foreign key relationships

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