SAP Table EKBEZ
GR/IR - Assignment from Purchase Order History
EKBEZ (GR/IR - Assignment 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 EKBEZ to other SAP tables.
EKBEZ table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
EBELP
Item Number of Purchasing Document
|
EBELP | EKPO |
NUMC
|
5 | 0 | |||||||
|
ZEKKN
Sequential Number of Account Assignment
|
DZEKKN |
NUMC
|
2 | 0 | ||||||||
|
LFGJA
Fiscal Year of Current Period
|
LFGJA |
NUMC
|
4 | 0 | ||||||||
|
LFBNR
Document No. of a Reference Document
|
LFBNR |
CHAR
|
10 | 0 | ||||||||
|
LFPOS
Item of a Reference Document
|
LFPOS |
NUMC
|
4 | 0 | ||||||||
|
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 | ||||||||
|
XBLNR
Reference Document Number
|
XBLNR1 |
CHAR
|
16 | 0 | ||||||||
|
BWTAR
Valuation Type
|
BWTAR_D | T149D |
CHAR
|
10 | 0 | |||||||
|
REEWR
Invoice Value Entered (in Local Currency)
|
REEWR |
CURR
|
13 | 2 | ||||||||
|
REFWR
Invoice value in foreign currency
|
REFWR |
CURR
|
13 | 2 | ||||||||
|
BUDAT
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||
|
KNUMV
Number of the document condition
|
KNUMV |
CHAR
|
10 | 0 | ||||||||
|
MBLNR
Number of Material Document
|
MBLNR |
CHAR
|
10 | 0 | ||||||||
|
MBLPO
Item in Material Document
|
MBLPO |
NUMC
|
4 | 0 | ||||||||
|
MJAHR
Material Document Year
|
MJAHR |
NUMC
|
4 | 0 | ||||||||
|
WEBUD
Posting Date in the Document
|
BUDAT |
DATS
|
8 | 0 | ||||||||
|
LSMNG
Quantity in Unit of Measure from Delivery Note
|
LSMNG |
QUAN
|
13 | 3 | ||||||||
|
LSMEH
Unit of Measure From Delivery Note
|
LSMEH |
UNIT
|
3 | 0 | ||||||||
|
REWAE
Currency Key
|
WAERS |
CUKY
|
5 | 0 | ||||||||
|
ETENS
Sequential Number of Vendor Confirmation
|
ETENS |
NUMC
|
4 | 0 | ||||||||
|
XUNPL
Unplanned Account Assignment from Invoice Verification
|
XUNPL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
WENAM
Goods receipt entered by
|
WENAM |
CHAR
|
12 | 0 | ||||||||
|
NEURH
Revaluation Value Entered (in Local Currency)
|
NEURH |
CURR
|
13 | 2 | ||||||||
|
NEURW
Revaluation Value Entered (in Foreign Currency)
|
NEURW |
CURR
|
13 | 2 | ||||||||
|
NEUDM
Revaluation Amount in Local Currency
|
NEUDM |
CURR
|
13 | 2 | ||||||||
|
NEUWR
Revaluation Amount in Foreign Currency
|
NEUWR |
CURR
|
13 | 2 | ||||||||
|
PACKNO
Package number
|
PACKNO |
NUMC
|
10 | 0 | ||||||||
|
INTROW
Internal line number for limits
|
INTROW |
NUMC
|
10 | 0 | ||||||||
|
LEMIN
Returns Indicator
|
SRVRET |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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_EKBE
Acceptance At Origin
|
WEORA |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
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 | ||||||||
|
CHARG
Batch Number
|
CHARG_D |
CHAR
|
10 | 0 | ||||||||
|
PRICING_QTY_GR
Goods Receipt Quantity in Purchase Order Price Unit
|
BPWEM |
QUAN
|
13 | 3 | ||||||||
|
/CWM/WEMNG
Goods Receipt Quantity in Base or Parallel Unit of Measure
|
/CWM/WEMNG |
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 | ||||||||
|
OIA_IPMVAT
VAT on internally-posted material
|
OIA_IPMVAT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
EKBEZ foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EKBEZ | BWTAR | SYST | MANDT |
T149D
Global Valuation Types
|
MANDT |
| EKBEZ | BWTAR | EKBEZ | BWTAR |
T149D
Global Valuation Types
|
BWTAR |
| EKBEZ | EBELP | EKKO | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| EKBEZ | EBELP | EKKO | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| EKBEZ | EBELP | EKBEZ | EBELP |
EKPO
Purchasing Document Item
|
EBELP |