1. Home
  2. Resources
  3. SAP Tables
  4. EKETH - Scheduling Agreement Schedules: History Tables

SAP Table EKETH

Scheduling Agreement Schedules: History Tables

EKETH (Scheduling Agreement Schedules: History Tables) 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 EKETH to other SAP tables.

EKETH table fields

Field Data element Checktable Datatype Length Decimals
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
ETENR Delivery Schedule Line Counter EETEN NUMC 4 0
EINDT Item Delivery Date EINDT DATS 8 0
SLFDT Statistics-Relevant Delivery Date SLFDT DATS 8 0
LPEIN Category of Delivery Date LPEIN TPRG CHAR 1 0
MENGE Scheduled Quantity ETMEN QUAN 13 3
AMENG Previous Quantity (Delivery Schedule Lines) VOMNG QUAN 13 3
WEMNG Quantity of Goods Received WEEMG QUAN 13 3
WAMNG Issued Quantity WAMNG QUAN 13 3
UZEIT Delivery Date Time-Spot LZEIT TIMS 6 0
BANFN Purchase Requisition Number BANFN CHAR 10 0
BNFPO Item Number of Purchase Requisition BNFPO EBAN NUMC 5 0
ESTKZ Creation Indicator (Purchase Requisition/Schedule Lines) ESTKZ CHAR 1 0
B Material requirements planning
D Direct procurement
F Production order
G Store order
R Realtime (manual)
U Converted planned order
V Sales and distribution document
M Compression (monthly basis)
Y Compression (annual basis)
A SAP APO
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
MAHNZ No. of Reminders/Expediters for Schedule Line MAHNZE DEC 3 0
BEDAT Order date of schedule line ETBDT DATS 8 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
SERNR BOM explosion number SERNR CHAR 8 0
FIXKZ Schedule Line is "Fixed" ETFIX CHAR 1 0
X Yes
NULL No
GLMNG Quantity Delivered (Stock Transfer) GLMNG QUAN 13 3
DABMG Quantity Reduced (MRP) DABMG QUAN 13 3
CHARG Batch Number CHARG_D CHAR 10 0
LICHA Vendor Batch Number LICHN CHAR 15 0
CHKOM Components CHKOM CHAR 1 0
X Yes
NULL No
VERID Production Version VERID CHAR 4 0
ABART Scheduling agreement release type MEABART CHAR 1 0
NULL Order
1 Forecast dlv. sched.
2 JIT delivery schedule
3 Issue for external agent (only in delivery)
4 Returns for scheduling agreemnt w/ release (only in dlvy)
5 Planning delivery schedule
6 Delivery order (only in the delivery)
7 Returns for delivery order (only in delivery)
MNG02 Committed Quantity MNG06 QUAN 13 3
DAT01 Committed Date DAT05 DATS 8 0
ALTDT Previous delivery date ALTDT DATS 8 0
AULWE Route Schedule AULWE VALW CHAR 10 0
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
MBUHR Material Staging Time (Local, Relating to a Plant) MBUHR TIMS 6 0
LDDAT Loading Date LDDAT DATS 8 0
LDUHR Loading Time (Local Time Relating to a Shipping Point) LDUHR TIMS 6 0
TDDAT Transportation Planning Date TDDAT_D DATS 8 0
TDUHR Transp. Planning Time (Local, Relating to a Shipping Point) TDUHR TIMS 6 0
WADAT Goods Issue Date WADAT DATS 8 0
WAUHR Time of Goods Issue (Local, Relating to a Plant) WAUHR TIMS 6 0
ELDAT Goods Receipt End Date ELDAT DATS 8 0
ELUHR Goods Receipt End Time (Local, Relating to a Plant) ELUHR TIMS 6 0
ANZSN Number of serial numbers ANZSN INT4 10 0
NODISP Ind: Reserv. not applicable to MRP;Purc. req. not created NODISP CHAR 1 0
X Yes
NULL No
GEO_ROUTE Description of a Geographical Route /SPE/DE_ROUTE_ID CHAR 10 0
ROUTE_GTS Route Code for SAP Global Trade Services /SPE/DE_ROUTE_GTS_CODE CHAR 10 0
GTS_IND Goods Traffic Type /SPE/DE_LEG_GTS_CODE CHAR 2 0
TSP Forwarding agent SPDNR CHAR 10 0
CD_LOCNO Location number in APO APOLOCNO CHAR 20 0
CD_LOCTYPE APO location type APOLOCTYPE CHAR 4 0
HANDOVERDATE Handover Date at the Handover Location HANDOVER_DATE DATS 8 0
HANDOVERTIME Handover time at the handover location HANDOVER_TIME TIMS 6 0
/CWM/MENGE Schedule Line Quantity in Base/Parallel Unit of Measure /CWM/ETMEN QUAN 13 3
/CWM/DABMG MRP Reduced Quantity in Base/Parallel UoM /CWM/DABMG QUAN 13 3
/CWM/WEMNG Goods Receipt Quantity in Base or Parallel Unit of Measure /CWM/WEMNG QUAN 13 3

EKETH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EKETH AULWE SYST MANDT VALW Delivery Plan: Definition of Route Schedule MANDT
EKETH AULWE EKETH AULWE VALW Delivery Plan: Definition of Route Schedule AULWE
EKETH BNFPO EKETH MANDT EBAN Purchase Requisition MANDT
EKETH BNFPO EKETH BANFN EBAN Purchase Requisition BANFN
EKETH BNFPO EKETH BNFPO EBAN Purchase Requisition BNFPO
EKETH EBELN EKETH MANDT EKKO Purchasing Document Header MANDT
EKETH EBELN EKETH EBELN EKKO Purchasing Document Header EBELN
EKETH EBELP EKETH MANDT EKPO Purchasing Document Item MANDT
EKETH EBELP EKETH EBELN EKPO Purchasing Document Item EBELN
EKETH EBELP EKETH EBELP EKPO Purchasing Document Item EBELP
EKETH LPEIN EKETH MANDT TPRG Date display format MANDT
EKETH LPEIN SYST SPRAS TPRG Date display format SPRAS
EKETH LPEIN EKETH LPEIN TPRG Date display format PRGBZ
EKETH MANDT EKETH MANDT T000 Clients MANDT