1. Home
  2. Resources
  3. SAP Tables
  4. EKBES - Item Totals from Purchase Order History

SAP Table EKBES

Item Totals from Purchase Order History

EKBES (Item Totals from Purchase Order History) 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 EKBES to other SAP tables.

EKBES table fields

Field Data element Checktable Datatype Length Decimals
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
WAMNG Issued Quantity WAMNG QUAN 13 3
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
WEMNG Quantity of Goods Received WEMNG QUAN 13 3
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
WEMMG Non-valuated goods receipt quantity WEMMG QUAN 13 3
BPWMM Non-valuated goods receipt quantity in order price unit BPWMM QUAN 13 3
WEWRT Value of goods received in local currency WEWRT CURR 13 2
WEWWR Value of goods received in foreign currency WEWWR CURR 13 2
REMNG Quantity invoiced REMNG QUAN 13 3
BPREM Invoice receipt quantity in order price unit BPREM QUAN 13 3
REWRT Invoice value in local currency REWRT CURR 13 2
REWWR Invoice Amount in Foreign Currency REWWR CURR 13 2
REWWB Invoice Amount in Foreign Currency REWWR CURR 13 2
AREWR GR/IR account clearing value in local currency AREWR CURR 13 2
AREWW Clearing value on GR/IR clearing account (transac. currency) AREWW CURR 13 2
ANZAL Total Down Payments in Local Currency ANZAL CURR 13 2
LVGDT Date of last transaction for reorg. LVGDT DATS 8 0
REEWR Invoice Value Entered (in Local Currency) REEWR CURR 13 2
REFWR Invoice value in foreign currency REFWR CURR 13 2
GLMNG Quantity Delivered (Stock Transfer) GLMNG QUAN 13 3
WESBA GR blocked stock in order unit (absolute amount) WESBA QUAN 13 3
WEMGA Goods receipt quantity: Absolute amount WEMGA QUAN 13 3
REMGA Invoice receipt quantity: Absolute amount REMGA QUAN 13 3
REWAE Currency Key WAERS CUKY 5 0
XUNPL Unplanned Account Assignment from Invoice Verification XUNPL CHAR 1 0
X Yes
NULL No
WENAM Goods receipt entered by WENAM CHAR 12 0
NEURH Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
NEURW Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
NEUDM Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
NEUWR Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
PREIV Parked Invoice Exists PREIV CHAR 1 0
X Yes
NULL No
WAWRT Sum of the values of goods issues WAWRT CURR 13 2
WAWWR Sum of the values of goods issues WAWRT CURR 13 2
AREWB Clearing Value on GR/IR Account in PO Currency AREWB CURR 13 2
REWRB Invoice Amount in PO Currency REWRB CURR 13 2
XBESW Indicator: Update in PO Currency XBESW CHAR 1 0
X Yes
NULL No
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
WEBSA Valuated Goods Receipt Blocked Stock in OUn, Absolute Amount WEBSA QUAN 13 3
REMNG_POP Quantity invoiced REMNG QUAN 13 3
REWRT_POP Invoice value in local currency REWRT CURR 13 2
REWWR_POP Invoice Amount in Foreign Currency REWWR CURR 13 2
AREWR_POP GR/IR account clearing value in local currency AREWR CURR 13 2
KUDIF Exchange Rate Difference Amount KUDIF CURR 13 2
KUDIF_GR Exchange Rate Difference Amount KUDIF CURR 13 2
KUDIF_IR Exchange Rate Difference Amount KUDIF CURR 13 2
REMNG_F Quantity (Floating Point Number - Internal Field) MENGE_F FLTP 16 16
BPREM_F Quantity (Floating Point Number - Internal Field) MENGE_F FLTP 16 16
WEWRK Value (Floating Point Number - Internal Field) WERT_F FLTP 16 16
REWRK Value (Floating Point Number - Internal Field) WERT_F FLTP 16 16
RETSUM_FC Total of Retention Amounts in Document Currency RET_SUM_FC CURR 13 2
RETSUM_LC Total of Retention Amounts in Company Code Currency RET_SUM_LC CURR 13 2
RETSUMP_FC Total Retention Amount Posted To Date in Document Currency RET_SUM_POST_FC CURR 13 2
RETSUMP_LC Total Retention Amount Posted in Company Code Currency RET_SUM_POST_LC CURR 13 2
OPSES Open Service Entry Sheet OPSES CHAR 1 0
X Yes
NULL No
PARKED_QTY Parked Invoice Quantity PARKED_QTY QUAN 13 3
PARKED_QTY_F Parked Invoice Quantity (Floating Point Number) PARKED_QTY_F FLTP 16 16
AAWRT Down Payment Request Value (Local Currency = LC) AAWHW CURR 13 2
AAWWR Down payment request value (purchase order currency = TC) AAWTW CURR 13 2
ANWWR Down payment value (purchase order currency = TC) AZWTW CURR 13 2
/CWM/WEMNG Goods Receipt Quantity in Base or Parallel Unit of Measure /CWM/WEMNG QUAN 13 3
/CWM/WAMNG Goods Issue Quantity in Base or Parallel Unit of Measure /CWM/WAMNG QUAN 13 3
/CWM/WESBS Goods Receipt Blocked Stock in Base/Parallel Unit of Measure /CWM/WESBS QUAN 13 3
/CWM/WESBB Val. Goods Receipt Blocked Stock in Basis or Parallel UoM /CWM/WESBB QUAN 13 3
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
OIWEEDWR Excise duty value - goods receipt OIH_WEEDWR CURR 13 2
OIREEDWR Excise duty value - invoice receipt OIH_REEDWR CURR 13 2

EKBES foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKBES EBELP SYST MANDT EKPO Purchasing Document Item MANDT
EKBES EBELP EKKO EBELN EKPO Purchasing Document Item EBELN
EKBES EBELP EKBES EBELP EKPO Purchasing Document Item EBELP