SAP Table EKES
Vendor Confirmations
EKES (Vendor Confirmations) 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 EKES to other SAP tables.
EKES table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | |||||||||||
|
ETENS
Sequential Number of Vendor Confirmation
|
ETENS |
NUMC
|
4 | 0 | ||||||||||||
|
EBTYP
Confirmation Category
|
EBTYP | T163E |
CHAR
|
2 | 0 | |||||||||||
|
EINDT
Delivery Date of Vendor Confirmation
|
BBEIN |
DATS
|
8 | 0 | ||||||||||||
|
LPEIN
Date category of delivery date in vendor confirmation
|
BBLPE |
CHAR
|
1 | 0 | ||||||||||||
|
UZEIT
Delivery Date Time-Spot in Vendor Confirmation
|
BBUZE |
TIMS
|
6 | 0 | ||||||||||||
|
ERDAT
Creation Date of Confirmation
|
BBERD |
DATS
|
8 | 0 | ||||||||||||
|
EZEIT
Time at Which Vendor Confirmation was Created
|
BBEZE |
TIMS
|
6 | 0 | ||||||||||||
|
MENGE
Quantity as Per Vendor Confirmation
|
BBMNG |
QUAN
|
13 | 3 | ||||||||||||
|
DABMG
Quantity Reduced (MRP)
|
DABMG |
QUAN
|
13 | 3 | ||||||||||||
|
ESTKZ
Creation Indicator: Vendor Confirmation
|
BBEST |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
LOEKZ
Vendor confirmation deletion indicator
|
BBLOE |
CHAR
|
1 | 0 | ||||||||||||
|
KZDIS
Indicator: Confirmation is Relevant to Materials Planning
|
KZDIS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
XBLNR
Reference Document Number (for Dependencies see Long Text)
|
XBLNR_LONG |
CHAR
|
35 | 0 | ||||||||||||
|
VBELN
Delivery
|
VBELN_VL | VBUK |
CHAR
|
10 | 0 | |||||||||||
|
VBELP
Delivery Item
|
POSNR_VL | VBUP |
NUMC
|
6 | 0 | |||||||||||
|
MPROF
Manufacturer Part Profile
|
MPROF |
CHAR
|
4 | 0 | ||||||||||||
|
EMATN
Material Number Corresponding to Manufacturer Part Number
|
EMATN | MARA |
CHAR
|
18 | 0 | |||||||||||
|
MAHNZ
Number of Reminders/Expediters
|
MAHNZ |
DEC
|
3 | 0 | ||||||||||||
|
CHARG
Batch Number
|
CHARG_D |
CHAR
|
10 | 0 | ||||||||||||
|
UECHA
Higher-Level Item of Batch Split Item
|
UECHA |
NUMC
|
6 | 0 | ||||||||||||
|
REF_ETENS
Sequential Number of Vendor Confirmation
|
ETENS |
NUMC
|
4 | 0 | ||||||||||||
|
IMWRK
Delivery has Status 'In Plant'
|
IMWRK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
VBELN_ST
Delivery
|
VBELN_VL |
CHAR
|
10 | 0 | ||||||||||||
|
VBELP_ST
Delivery Item
|
POSNR_VL |
NUMC
|
6 | 0 | ||||||||||||
|
/CWM/MENGE
Quantity of Order Confirmation in Base/Parallel UoM
|
/CWM/BBMNG |
QUAN
|
13 | 3 | ||||||||||||
|
/CWM/DABMG
MRP Reduced Quantity in Base/Parallel UoM
|
/CWM/DABMG |
QUAN
|
13 | 3 | ||||||||||||
EKES foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EKES | EBELN | EKES | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| EKES | EBELN | EKES | EBELN |
EKKO
Purchasing Document Header
|
EBELN |
| EKES | EBELP | EKES | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| EKES | EBELP | EKES | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| EKES | EBELP | EKES | EBELP |
EKPO
Purchasing Document Item
|
EBELP |
| EKES | EBTYP | EKES | MANDT |
T163E
Confirmation Categories
|
MANDT |
| EKES | EBTYP | EKES | EBTYP |
T163E
Confirmation Categories
|
EBTYP |
| EKES | EMATN | EKES | EMATN |
MARA
General Material Data
|
MATNR |
| EKES | EMATN | EKES | MANDT |
MARA
General Material Data
|
MANDT |
| EKES | MANDT | EKES | MANDT |
T000
Clients
|
MANDT |
| EKES | VBELN | EKES | VBELN |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| EKES | VBELN | EKES | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| EKES | VBELP | EKES | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| EKES | VBELP | EKES | VBELN |
VBUP
Sales Document: Item Status
|
VBELN |
| EKES | VBELP | EKES | VBELP |
VBUP
Sales Document: Item Status
|
POSNR |