EKET is a standard Purchasing Transparent Table in SAP MM application, which stores Scheduling Agreement Schedule Lines data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for EKET. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

EKET — Meta Data

Description: Scheduling Agreement Schedule Lines
Main Category: MM
Sub Category: Purchasing
Table type: Transparent Table (TRANSP)

EKET — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 EBELN Purchasing Doc. X CHAR 10 EKKO
    3 EBELP ARIBA item number X NUMC 5 EKPO
    4 ETENR Schedule Line X NUMC 4
    5 UNIQUEID Comment CHAR 19
    6 .INCLUDE 0
    7 EINDT Delivery Date DATS 8
    8 SLFDT Stat. Del. Date DATS 8
    9 LPEIN Price unit CHAR 1 *
    10 MENGE Quantity in base unit of measure QUAN 13
    11 AMENG Qty Issued QUAN 13
    12 WEMNG Purchase Order Quantity QUAN 13
    13 WAMNG Updated information in related user data field QUAN 13
    14 UZEIT Time TIMS 6
    15 BANFN Purchase Req. CHAR 10
    16 BNFPO Requisn Item NUMC 5 EBAN
    17 ESTKZ Creation indicator (purchase requisition/schedule lines) CHAR 1
    18 QUNUM Number of quota arrangement CHAR 10
    19 QUPOS Quota arrangement item NUMC 3
    20 MAHNZ No. Rem./Exp. DEC 3
    21 BEDAT Document Date DATS 8
    22 RSNUM Number of Reservation/Dependent Requirement NUMC 10 *
    23 SERNR BOM explosion number CHAR 8 *
    24 FIXKZ Purchase requisition is fixed CHAR 1
    25 GLMNG Updated information in related user data field QUAN 13
    26 DABMG Updated information in related user data field QUAN 13
    27 CHARG Batch CHAR 10 *
    28 LICHA Updated information in related user data field CHAR 15
    29 CHKOM Updated information in related user data field CHAR 1
    30 VERID Production Version CHAR 4 *
    31 ABART Release type CHAR 1
    32 MNG02 Committed Quantity QUAN 13
    33 DAT01 Committed date DATS 8
    34 ALTDT Updated information in related user data field DATS 8
    35 AULWE Route Schedule CHAR 10 VALW
    36 MBDAT Mat.Avail.Date DATS 8
    37 MBUHR Material Staging Time (Local, Relating to a Plant) TIMS 6
    38 LDDAT Loading Date DATS 8
    39 LDUHR Loading Time (Local Time Relating to a Shipping Point) TIMS 6
    40 TDDAT TranspPlngDate DATS 8
    41 TDUHR Transp. Planning Time (Local, Relating to a Shipping Point) TIMS 6
    42 WADAT Goods Issue DATS 8
    43 WAUHR Time of Goods Issue (Local, Relating to a Plant) TIMS 6
    44 ELDAT Updated information in related user data field DATS 8
    45 ELUHR Updated information in related user data field TIMS 6
    46 ANZSN Number of Serial Numbers INT4 10
    47 NODISP Flag: Do not display CHAR 1
    48 GEO_ROUTE Updated information in related user data field CHAR 10
    49 ROUTE_GTS Updated information in related user data field CHAR 10
    50 GTS_IND Updated information in related user data field CHAR 2
    51 TSP NodeID CHAR 10 *
    52 CD_LOCNO Updated information in related user data field CHAR 20
    53 CD_LOCTYPE Updated information in related user data field CHAR 4
    54 HANDOVERDATE Updated information in related user data field DATS 8
    55 HANDOVERTIME Updated information in related user data field TIMS 6
    56 .INCLUDE 0
    57 STARTDATE SAP Workload: Workload/Acc. exit: Start date of meas. period DATS 8
    58 ENDDATE Job start date DATS 8
    59 _DATAAGING Data Filter Value for Data Aging DATS 8
    60 .INCLUDE 0
    61 /CWM/MENGE Quantity QUAN 13
    62 /CWM/DABMG MRP Reduced Quantity in Base/Parallel UoM QUAN 13
    63 /CWM/WEMNG Goods Receipt Quantity in Base or Parallel Unit of Measure QUAN 13
    64 .INCLU--AP 0
    65 TMS_REF_UUID Updated information in related user data field CHAR 22
    66 .INCLU--AP 0
    67 ARUN_REQ_DLVDATE Date DATS 8
    68 .INCLU--AP 0
    69 FSH_RALLOC_QTY QUAN 13
    70 FSH_SALLOC_QTY ARun Allocated Quantity QUAN 13
    71 FSH_OS_ID Updated information in related user data field NUMC 4
    72 .INCLU--AP 0
    73 .INCLUDE 0
    74 .INCLUDE 0
    75 KEY_ID Budget Number NUMC 16
    76 OTB_VALUE Required Budget CURR 17
    77 .INCLUDE 0
    78 OTB_CURR OTB Currency CUKY 5 *
    79 OTB_RES_VALUE Reserved Budget CURR 17
    80 OTB_SPEC_VALUE Special Release CURR 17
    81 SPR_RSN_PROFILE OTB Reason Profile CHAR 4
    82 BUDG_TYPE Budget Type CHAR 2
    83 OTB_STATUS OTB Status CHAR 1
    84 OTB_REASON Reason CHAR 3
    85 CHECK_TYPE Type of OTB Check CHAR 1
    86 .INCLUDE 0
    87 .INCLUDE 0
    88 DL_ID DateLine ID CHAR 22
    89 HANDOVER_DATE Transfer Date DATS 8
    90 NO_SCEM No SCEM Contr. CHAR 1
    91 DNG_DATE Rem. Date DATS 8
    92 DNG_TIME Reminder Time TIMS 6
    93 CNCL_ANCMNT_DONE Cancel.Threat Made CHAR 1
    94 DATESHIFT_NUMBER Updated information in related user data field DEC 3

SAP Help, Wiki Resources, and Forum Discussions on EKET

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Updating EKET & EKES | SCN

    My requirement is to update few fields in tables EKET(Schedule line) & EKES(Vendor Confirmations).

    http://scn.sap.com/message/3072054

  • Update Table EKET from ME29N | SCN

    The structure E_CI_EKKO contains the data from User to DB and the structure EKKO contains what the user enterd on screen .

    http://scn.sap.com/message/13549641

  • Incorrect EKET-LDDAT value for Stock Transport Orders (STOs)

    We have turned on route scheduling/shipment scheduling for STOs in EEC 6.0 version of SAP. I have noticed that on a STO (under the delivery schedule tab) the loading date field (EKET-LDDAT) is getting calculated based on the committed date (EKET-DAT01) and not based on the delivery date (EKET-EINDT).

    http://scn.sap.com/message/9211962

  • EINDT In EKET | SCN

    Hi!

    Whats the description for EINDT in EKET?

    http://scn.sap.com/message/3539749

  • User exit  / BADI to update EKET table | SCN

    I need a user exit/ badi which will update EKET-EINDT ( in item overview collapsed subscreen MEPO1211 structure ) field in me22n transaction when i updating a item details EKES table ( which is in item in detail collapsed subscreen, RM06E structure). if anybody worked on it please let me know asap.

    http://scn.sap.com/message/2597235

  • TABLE LINKS: EKKO, EKET, EKPO, CDHDR, CDPOS and NAST

    I am new to linking the SAP tables and I'd like to ask for the links of the following tables: EKKO, EKET, EKPO, linked to CDHDR, CDPOS and NAST.

    http://scn.sap.com/message/13738856

  • Error with ABAP driver B - Smartform using EKET-MENGE field

    I've a z smartform and I need to use data from EKET. I'm already using &LS_EKET-EINDT& field from same table but when i try to use &ls_EKET-menge& i've this error when i print preview

    http://scn.sap.com/message/8334260

  • HANA Slow for EKKO->EKPO->EKET | SCN

    I am trying to pick up details from EKET along with EKPO and EKKO. All the tables are created as Column tables. 

    http://scn.sap.com/message/13805376

  • Connecting EKET and EKBE | SCN

    http://scn.sap.com/message/3061910

  • BAPI FOR Deleting a Schedule Line Item from EKES and EKET tables

    I would like to for deleting one of the line item from EKES (Po Confirmation ) and the respective line item from the EKET(PO Schedule Line Item Table).

    http://scn.sap.com/thread/185665

  • Index behaviour in select query and in database view?? for EKET and EKPO

    I am writing a select query to fetch EBELN and EBELP from EKET table using the delivery date EINDT which is one of the secondary indexes for the table, just this one field. But then it takes too much of a time to fetch the information using this select query. While if I give the same information in the SE16 screen it seems to run faster!! Can anyone explain how can something like this happen??

    http://scn.sap.com/message/2305555


Related Tables

TABLE Description Functional Area
EKPO Purchasing Document Item MM - Purchasing
EKBE History per Purchasing Document MM - Purchasing
EKKN Account Assignment in Purchasing Document MM - Purchasing
EBAN Purchase Requisition MM - Purchasing
MARA General Material Data Logistics - Material Master
MKPF Header: Material Document MM - Inventory Management
MAKT Material Descriptions Logistics - Material Master

Transaction Codes for SAP Table EKET

TCODE Description Functional Area
ME21N Create Purchase Order MM - Purchasing
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
MIGO Goods Movement MM - Inventory Management
ME23N Display Purchase Order MM - Purchasing
MIRO Enter Incoming Invoice MM - Invoice Verification
ME22N Change Purchase Order MM - Purchasing
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
MB1A Goods Withdrawal MM - Inventory Management

FMs for SAP Table EKET

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
BAPI_PO_CHANGE Change Purchase Order MM - Purchasing
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
BAPI_PO_CREATE1 Create Purchase Order MM - Purchasing
CHANGEDOCUMENT_READ_POSITIONS Change document: Read change document items Basis - Change Documents
CHANGEDOCUMENT_READ_HEADERS Change document: Read change document header Basis - Change Documents

ABAP Reports for SAP Table EKET

ABAP REPORT Description Functional Area
SAPMM06E Module Pool: PO History MM - Purchasing
SPRSL TEXT 630 - Workbench Tools: Editors
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMM07M Module Pool for Goods Movements MM - Inventory Management
BCALV_EDIT_01 Switch on and off the ready-for-input status of the entire grid Basis - SAP List Viewer
SAPLEINB A
SAPFM06P Print Program for Purchasing Documents MM - Purchasing
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony

BW Datasources for SAP Table EKET

BW DATASOURCE Description Functional Area
2LIS_02_SCL Purchasing Data (Schedule Line Level) MM - Materials Management
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management
2LIS_02_SGR Produced Activity: Delivery of Schedule Lines MM - Materials Management
2LIS_02_HDR Purchasing Data (Header Level) MM - Materials Management
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
2LIS_02_SCN Produced Activity: Confirmation of Schedule Lines MM - Materials Management
2LIS_02_CGR Produced Activity: Delivery of Confirmations MM - Materials Management
2LIS_12_VCITM Delivery Item Data SD - Sales and Distribution

Authorization Objects for SAP Table EKET

AUTHORIZATION OBJECT Description Functional Area
S_TCODE Transaction Code Check at Transaction Start
I_TCODE PM: Transaction Code
M_BANF_WRK Plant in Purchase Requisition
E_GRID Authorization Object for Grid
F_BKPF_BUK Accounting Document: Authorization for Company Codes
M_BANF_EKG Purchasing Group in Purchase Requisition
M_BEST_EKG Purchasing Group in Purchase Order

Most searched SAP Materials Management Tables