SAP table EKETH (Scheduling Agreement Schedules: History Tables)

SAP table EKETH has 4 primary key fields being MANDT,EBELN,EBELP,ETENR.

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
ETENR Delivery Schedule Line Counter NUMC 4 0 EETEN
EINDT Item delivery date DATS 8 0 EINDT
SLFDT Statistics-Relevant Delivery Date DATS 8 0 SLFDT
LPEIN Category of delivery date CHAR 1 0 TPRG LPEIN
MENGE Scheduled Quantity QUAN 13 3 ETMEN
AMENG Previous Quantity (Delivery Schedule Lines) QUAN 13 3 VOMNG
WEMNG Quantity of goods received QUAN 13 3 WEEMG
WAMNG Issued Quantity QUAN 13 3 WAMNG
UZEIT Delivery Date Time-Spot TIMS 6 0 LZEIT
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BNFPO Item number of purchase requisition NUMC 5 0 EBAN BNFPO
ESTKZ Creation indicator (purchase requisition/schedule lines) CHAR 1 0 ESTKZ
A SAP APO
B Material requirements planning
D Direct procurement
E External Requirements
F Production order
G Store order
I SAP IBP
M Compression (monthly basis)
P Project Demand
R Realtime (manual)
S Self-Service Procurement
T S4CRM Service Order
U Converted planned order
V Sales and distribution document
Y Compression (annual basis)
QUNUM Number of quota arrangement CHAR 10 0 QUNUM
QUPOS Quota arrangement item NUMC 3 0 QUPOS
MAHNZ No. of Reminders/Expediters for Schedule Line DEC 3 0 MAHNZE
BEDAT Order date of schedule line DATS 8 0 ETBDT
RSNUM Number of reservation/dependent requirements NUMC 10 0 * RSNUM
SERNR BOM explosion number CHAR 8 0 * SERNR
FIXKZ Schedule Line is "Fixed" CHAR 1 0 ETFIX
GLMNG Quantity Delivered (Stock Transfer) QUAN 13 3 GLMNG
DABMG Quantity Reduced (MRP) QUAN 13 3 DABMG
CHARG Batch Number CHAR 10 0 * CHARG_D
LICHA Supplier Batch Number CHAR 15 0 LICHN
CHKOM Components CHAR 1 0 CHKOM
VERID Production Version CHAR 4 0 * VERID
ABART Scheduling agreement release type CHAR 1 0 MEABART
MNG02 Committed Quantity QUAN 13 3 MNG06
DAT01 Committed date DATS 8 0 DAT05
ALTDT Previous delivery date DATS 8 0 ALTDT
AULWE Route Schedule CHAR 10 0 VALW AULWE
MBDAT Material Staging/Availability Date DATS 8 0 MBDAT
MBUHR Material Staging Time (Local, Relating to a Plant) TIMS 6 0 MBUHR
LDDAT Loading Date DATS 8 0 LDDAT
LDUHR Loading Time (Local Time Relating to a Shipping Point) TIMS 6 0 LDUHR
TDDAT Transportation Planning Date DATS 8 0 TDDAT_D
TDUHR Transp. Planning Time (Local, Relating to a Shipping Point) TIMS 6 0 TDUHR
WADAT Goods Issue Date DATS 8 0 WADAT
WAUHR Time of Goods Issue (Local, Relating to a Plant) TIMS 6 0 WAUHR
ELDAT Goods Receipt End Date DATS 8 0 ELDAT
ELUHR Goods Receipt End Time (Local, Relating to a Plant) TIMS 6 0 ELUHR
ANZSN Number of serial numbers INT4 10 0 ANZSN
NODISP Ind: Reserv. not applicable to MRP;Purc. req. not created CHAR 1 0 NODISP
GEO_ROUTE Description of a Geographical Route CHAR 10 0 /SPE/DE_ROUTE_ID
ROUTE_GTS Route Code for SAP Global Trade Services CHAR 10 0 /SPE/DE_ROUTE_GTS_CODE
GTS_IND Goods Traffic Type CHAR 2 0 /SPE/DE_LEG_GTS_CODE
TSP Forwarding Agent CHAR 10 0 * SPDNR
CD_LOCNO Location number in APO CHAR 20 0 APOLOCNO
CD_LOCTYPE APO location type CHAR 4 0 APOLOCTYPE
HANDOVERDATE Handover Date at the Handover Location DATS 8 0 HANDOVER_DATE
HANDOVERTIME Handover time at the handover location TIMS 6 0 HANDOVER_TIME
WESBB Valuated Goods Receipt Blocked Stock in Order Unit QUAN 13 3 WESBB
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
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
/CWM/MENGE Schedule Line Quantity in Base/Parallel Unit of Measure QUAN 13 3 /CWM/ETMEN
/CWM/DABMG MRP Reduced Quantity in Base/Parallel UoM QUAN 13 3 /CWM/DABMG
/CWM/WEMNG Goods Receipt Quantity in Base or Parallel Unit of Measure QUAN 13 3 /CWM/WEMNG
TMS_REF_UUID Reference UUID of Transportation Management CHAR 22 0 TMS_REF_UUID

EKETH foreign key relationships

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