SAP table EKBEV (PO History for Update Program)

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
NOETT Do not update schedule (kanban scheduling agreement) CHAR 1 0 NOETT
RETPO Returns Item CHAR 1 0 RETPO
STATU Status of Purchasing Document CHAR 1 0 ESTAK
1 Purchase Order from APO
2 Third-Party Order from CRM
3 Returns Order from Incorrect Delivery
4 Subsequent Stock Transport Order for Additional Item
5 Incorrect Item Returns from Stock Transport Orders
9 Enjoy Purchase Order
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
K Purchase Order from BBP
L Scheduling Agreement from CRM
M Purchasing Document from E-Sourcing
N Purchase Document from external Network / System
R S4CRM Service Order
S Collective Purchase Order
T Purchase Order from Transportation Management
W Purchase Order Ignored for Collective Delivery Run
X Purchase Order Created via Function Module
NOPOT Do not update purchase order item (purchase order in GR) CHAR 1 0 NOPOT
PRODUCTTYPE Product Type Group CHAR 2 0 PRODUCT_TYPE

EKBEV foreign key relationships

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