SAP table EKES (Supplier Confirmations)

SAP table EKES has 4 primary key fields being MANDT,EBELN,EBELP,ETENS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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
ETENS Sequential Number of Supplier Confirmation NUMC 4 0 ETENS
EBTYP Confirmation Category CHAR 2 0 T163E EBTYP
EINDT Delivery Date of Supplier Confirmation DATS 8 0 BBEIN
LPEIN Date Category of Delivery Date in Supplier Confirmation CHAR 1 0 BBLPE
UZEIT Delivery Date Time-Spot in Supplier Confirmation TIMS 6 0 BBUZE
ERDAT Creation Date of Confirmation DATS 8 0 BBERD
EZEIT Time at Which Suppluer Confirmation was Created TIMS 6 0 BBEZE
MENGE Quantity as Per Supplier Confirmation QUAN 13 3 BBMNG
DABMG Quantity Reduced (MRP) QUAN 13 3 DABMG
ESTKZ Creation Indicator: Supplier Confirmation CHAR 1 0 BBEST
1 Manual
2 Shipping Notification
3 EDI
4 Return Delivery
LOEKZ Supplier Confirmation Deletion Indicator CHAR 1 0 BBLOE
KZDIS Indicator: Confirmation is Relevant to Materials Planning CHAR 1 0 KZDIS
XBLNR Reference Document Number (for Dependencies see Long Text) CHAR 35 0 XBLNR_LONG
VBELN Delivery CHAR 10 0 VBELN_VL
VBELP Delivery Item NUMC 6 0 POSNR_VL
MPROF Mfr part profile CHAR 4 0 MPROF
EMATN Material number corresponding to manufacturer part number CHAR 40 0 MARA EMATN
MAHNZ Number of Reminders/Expediters DEC 3 0 MAHNZ
CHARG Batch Number CHAR 10 0 CHARG_D
UECHA Higher-Level Item of Batch Split Item NUMC 6 0 UECHA
REF_ETENS Sequential Number of Supplier Confirmation NUMC 4 0 ETENS
IMWRK Delivery has Status 'In Plant' CHAR 1 0 IMWRK
VBELN_ST Delivery CHAR 10 0 VBELN_VL
VBELP_ST Delivery Item NUMC 6 0 POSNR_VL
HANDOVERDATE Handover Date at the Handover Location DATS 8 0 HANDOVER_DATE
HANDOVERTIME Handover time at the handover location TIMS 6 0 HANDOVER_TIME
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
MSGTSTMP UTC Timestamp DEC 21 7 EDI_UTC_TIMESTAMP
/CWM/MENGE Quantity of Order Confirmation in Base/Parallel UoM QUAN 13 3 /CWM/BBMNG
/CWM/DABMG MRP Reduced Quantity in Base/Parallel UoM QUAN 13 3 /CWM/DABMG
STARTDATE Start Date for Period of Performance DATS 8 0 MMPUR_SERVPROC_PERIOD_START
ENDDATE End Date for Period of Performance DATS 8 0 MMPUR_SERVPROC_PERIOD_END
SERVICEPERFORMER Service Performer CHAR 10 0 SERVICEPERFORMER
EXPECTED_VALUE Expected Value of Overall Limit CURR 13 2 COMMITMENT
SUPPLIER_CONF_NO Supplier Confirmation Number CHAR 10 0 MMPUR_SUPPLIERCONFNO
SUPPLIER_CONF_ITEM Supplier Confirmation Item NUMC 5 0 MMPUR_SUPPLIERCONFITEM
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
FSH_SALLOC_QTY Allocated Stock Quantity QUAN 13 3 FSH_SALLOC_QTY
ORMNG Original Quantity of Shipping Notification/Inbound Delivery QUAN 13 3 ORMNG
TMS_REF_UUID Reference UUID of Transportation Management CHAR 22 0 TMS_REF_UUID

EKES foreign key relationships

Table Field Check Table Check Field
0 EKES EBELN EKKO Purchasing Document Header EBELN
1 EKES EBELP EKPO Purchasing Document Item MANDT
1 EKES EBELP EKPO Purchasing Document Item EBELN
0 EKES EBTYP T163E Confirmation Categories MANDT
0 EKES EBTYP T163E Confirmation Categories EBTYP
1 EKES EMATN MARA General Material Data MANDT
1 EKES EMATN MARA General Material Data MATNR
0 EKES MANDT T000 Clients MANDT