EKES SAP (Vendor Confirmations) Table details
Dictionary Type: Table
Description: Vendor Confirmations
Description: Vendor Confirmations
Table field list including key, data, relationships and ABAP select examples
EKES is a standard SAP Table which is used to store Vendor Confirmations data and is available within R/3 SAP systems depending on the version and release level.
The EKES table consists of various fields, each holding specific information or linking keys about Vendor Confirmations data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), ETENS (Sequential Number of Vendor Confirmation), EBTYP (Confirmation Category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP EKES table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
ETENS | Sequential Number of Vendor Confirmation | ETENS | NUMC | 4 | NUM04 | ||||
EBTYP | Confirmation Category | EBTYP | CHAR | 2 | T163E | EBTYP | |||
EINDT | Delivery Date of Vendor Confirmation | BBEIN | DATS | 8 | DATUM | ||||
LPEIN | Date category of delivery date in vendor confirmation | BBLPE | CHAR | 1 | Assigned to domain | PRGBZ | |||
UZEIT | Delivery Date Time-Spot in Vendor Confirmation | BBUZE | TIMS | 6 | UZEIT | ||||
ERDAT | Creation Date of Confirmation | BBERD | DATS | 8 | DATUM | ||||
EZEIT | Time at Which Vendor Confirmation was Created | BBEZE | TIMS | 6 | UZEIT | ||||
MENGE | Quantity as Per Vendor Confirmation | BBMNG | QUAN | 13(3) | MENGE | ||||
DABMG | Quantity Reduced (MRP) | DABMG | QUAN | 13(3) | MENGE | ||||
ESTKZ | Creation Indicator: Vendor Confirmation | BBEST | CHAR | 1 | BBEST | ||||
LOEKZ | Vendor confirmation deletion indicator | BBLOE | CHAR | 1 | ELOEK | ||||
KZDIS | Indicator: Confirmation is Relevant to Materials Planning | KZDIS | CHAR | 1 | XFELD | ||||
XBLNR | Reference Document Number (for Dependencies see Long Text) | XBLNR_LONG | CHAR | 35 | XBLNR_LONG | ||||
VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | ALPHA | VBELN | VL | |
VBELP | Delivery Item | POSNR_VL | NUMC | 6 | VBUP | POSNR | |||
MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | Assigned to domain | MPROF | |||
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | MARA | MATN1 | MATNR | HTN | |
MAHNZ | Number of Reminders/Expediters | MAHNZ | DEC | 3 | PACK2 | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
UECHA | Higher-Level Item of Batch Split Item | UECHA | NUMC | 6 | Assigned to domain | POSNR | |||
REF_ETENS | Sequential Number of Vendor Confirmation | ETENS | NUMC | 4 | NUM04 | ||||
IMWRK | Delivery has Status 'In Plant' | IMWRK | CHAR | 1 | XFELD | ||||
VBELN_ST | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
VBELP_ST | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
.INCLU--AP | 0 | ||||||||
ORMNG | Original Quantity of Shipping Notification/Inbound Delivery | ORMNG | QUAN | 13(3) | MENGE |
Key field | Non-key field |
How do I retrieve data from SAP table EKES using ABAP code
The following ABAP code Example will allow you to do a basic selection on EKES to SELECT all data from the tableDATA: WA_EKES TYPE EKES.
SELECT SINGLE *
FROM EKES
INTO CORRESPONDING FIELDS OF WA_EKES
WHERE...
How to access SAP table EKES
Within an ECC or HANA version of SAP you can also view further information about EKES and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects