EKETH SAP (Scheduling Agreement Schedules: History Tables) Table details

Dictionary Type: Table
Description: Scheduling Agreement Schedules: History Tables




ABAP Code to SELECT data from EKETH
Related tables to EKETH
Access table EKETH




Table field list including key, data, relationships and ABAP select examples

EKETH is a standard SAP Table which is used to store Scheduling Agreement Schedules: History Tables data and is available within R/3 SAP systems depending on the version and release level.

The EKETH table consists of various fields, each holding specific information or linking keys about Scheduling Agreement Schedules: History Tables data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), ETENR (Delivery Schedule Line Counter), EINDT (Item Delivery Date).. 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: Not classified


SAP EKETH 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
MANDTClient MANDTCLNT3T000MANDT
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
ETENRDelivery Schedule Line Counter EETENNUMC4Assigned to domainEETEN
EINDTItem Delivery Date EINDTDATS8DATUM
SLFDTStatistics-Relevant Delivery Date SLFDTDATS8DATUM
LPEINCategory of Delivery Date LPEINCHAR1TPRGPRGBZ
MENGEScheduled Quantity ETMENQUAN13(3) MENGE
AMENGPrevious Quantity (Delivery Schedule Lines) VOMNGQUAN13(3) MENG13V
WEMNGQuantity of Goods Received WEEMGQUAN13(3) MENG13
WAMNGIssued Quantity WAMNGQUAN13(3) MENG13
UZEITDelivery Date Time-Spot LZEITTIMS6UZEIT
BANFNPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
BNFPOItem Number of Purchase Requisition BNFPONUMC5EBANBNFPOBAP
ESTKZCreation Indicator (Purchase Requisition/Schedule Lines) ESTKZCHAR1ESTKZ
QUNUMNumber of Quota Arrangement QUNUMCHAR10ALPHAQUNUM
QUPOSQuota Arrangement Item QUPOSNUMC3NUM03
MAHNZNo. of Reminders/Expediters for Schedule Line MAHNZEDEC3PACK2
BEDATOrder date of schedule line ETBDTDATS8DATUM
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
SERNRBOM explosion number SERNRCHAR8Assigned to domainSERNR
FIXKZSchedule Line is 'Fixed' ETFIXCHAR1XFELD
GLMNGQuantity Delivered (Stock Transfer) GLMNGQUAN13(3) MENG13
DABMGQuantity Reduced (MRP) DABMGQUAN13(3) MENGE
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
LICHAVendor Batch Number LICHNCHAR15LICHN
CHKOMComponents CHKOMCHAR1XFELD
VERIDProduction Version VERIDCHAR4Assigned to domainVERIDVER
ABARTScheduling agreement release type MEABARTCHAR1ABARTSAGA
MNG02Committed Quantity MNG06QUAN13(3) MENGV13
DAT01Committed Date DAT05DATS8DATUM
ALTDTPrevious delivery date ALTDTDATS8DATUM
AULWERoute Schedule AULWECHAR10VALWAULWE
MBDATMaterial Staging/Availability Date MBDATDATS8DATUM
MBUHRMaterial Staging Time (Local, Relating to a Plant) MBUHRTIMS6TIME_PLANT
LDDATLoading Date LDDATDATS8DATUM
LDUHRLoading Time (Local Time Relating to a Shipping Point) LDUHRTIMS6TIME_SHIPP
TDDATTransportation Planning Date TDDAT_DDATS8DATUM
TDUHRTransp. Planning Time (Local, Relating to a Shipping Point) TDUHRTIMS6TIME_SHIPP
WADATGoods Issue Date WADATDATS8DATUM
WAUHRTime of Goods Issue (Local, Relating to a Plant) WAUHRTIMS6TIME_PLANT
ELDATGoods Receipt End Date ELDATDATS8ELDAT
ELUHRGoods Receipt End Time (Local, Relating to a Plant) ELUHRTIMS6ELUHR
ANZSNNumber of serial numbers ANZSNINT410INT4
NODISPInd: Reserv. not applicable to MRP;Purc. req. not created NODISPCHAR1XFELD
GEO_ROUTEDescription of a Geographical Route /SPE/DE_ROUTE_IDCHAR10CHAR10
ROUTE_GTSRoute Code for SAP Global Trade Services /SPE/DE_ROUTE_GTS_CODECHAR10CHAR10
GTS_INDGoods Traffic Type /SPE/DE_LEG_GTS_CODECHAR2CHAR2
TSPForwarding agent SPDNRCHAR10Assigned to domainALPHALIFNR
CD_LOCNOLocation number in APO APOLOCNOCHAR20APOLOCNO
CD_LOCTYPEAPO location type APOLOCTYPECHAR4APOLOCTYPE
HANDOVERDATEHandover Date at the Handover Location HANDOVER_DATEDATS8HANDOVER_DATE
HANDOVERTIMEHandover time at the handover location HANDOVER_TIMETIMS6HANDOVER_TIME

Key field Non-key field



How do I retrieve data from SAP table EKETH using ABAP code

The following ABAP code Example will allow you to do a basic selection on EKETH to SELECT all data from the table
DATA: WA_EKETH TYPE EKETH.

SELECT SINGLE *
FROM EKETH
INTO CORRESPONDING FIELDS OF WA_EKETH
WHERE...

How to access SAP table EKETH

Within an ECC or HANA version of SAP you can also view further information about EKETH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!