SE11 ABAP Dictionary SE11 EKET

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

EKET

Scheduling Agreement Schedule Lines
SAP MM Transparent Table 62 Fields
Primary Key:
MANDT EBELN EBELP ETENR

Dictionary Fields Fields

(62 dari 62 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
EBELN
KEY Purch.Doc. CHAR 10 - EKKO Purchasing Document Number
3
EBELP
KEY Item NUMC 5 - - Item Number of Purchasing Document
4
ETENR
KEY Sch. Line NUMC 4 - - Delivery Schedule Line Counter
5
EINDT
- Del. Date DATS 8 - - Item Delivery Date
6
SLFDT
- StatDelDte DATS 8 - - Statistics-Relevant Delivery Date
7
LPEIN
- Deliv.Date CHAR 1 - - Category of Delivery Date
8
MENGE
- Sched. Qty QUAN 13 3 - Scheduled Quantity
9
AMENG
- Prev. Qty QUAN 13 3 - Previous Quantity (Delivery Schedule Lines)
10
WEMNG
- GR Qty QUAN 13 3 - Quantity of Goods Received
11
WAMNG
- Issued QUAN 13 3 - Issued Quantity
12
UZEIT
- Time TIMS 6 - - Delivery Date Time-Spot
13
BANFN
- Purch.Req. CHAR 10 - - Purchase Requisition Number
14
BNFPO
- PReq. Item NUMC 5 - - Item Number of Purchase Requisition
15
ESTKZ
- Crea. Ind. CHAR 1 - - Creation Indicator (Purchase Requisition/Schedule Lines)
16
QUNUM
- Quota Arr. CHAR 10 - - Number of Quota Arrangement
17
QUPOS
- QuotArrItm NUMC 3 - - Quota Arrangement Item
18
MAHNZ
- No. R/E DEC 3 - - No. of Reminders/Expediters for Schedule Line
19
BEDAT
- Order date DATS 8 - - Order date of schedule line
20
RSNUM
- Reserv.No. NUMC 10 - - Number of Reservation/Dependent Requirement
21
SERNR
- BOMexpl.no CHAR 8 - - BOM explosion number
22
FIXKZ
- Fixed CHAR 1 - - Schedule Line is "Fixed"
23
GLMNG
- Qty Deliv. QUAN 13 3 - Quantity Delivered (Stock Transfer)
24
DABMG
- Qty Red. QUAN 13 3 - Quantity Reduced (MRP)
25
CHARG
- Batch CHAR 10 - - Batch Number
26
LICHA
- Vend.Batch CHAR 15 - - Vendor Batch Number
27
CHKOM
- Comp. Chg. CHAR 1 - - Components
28
VERID
- Version CHAR 4 - - Production Version
29
ABART
- Rel. type CHAR 1 - - Scheduling agreement release type
30
MNG02
- Comm. Qty QUAN 13 3 - Committed Quantity
31
DAT01
- Comm. Date DATS 8 - - Committed Date
32
ALTDT
- Del. date DATS 8 - - Previous delivery date
33
AULWE
- RouteSched CHAR 10 - - Route Schedule
34
MBDAT
- Mat.Av.Dt. DATS 8 - - Material Staging/Availability Date
35
MBUHR
- Stag. Time TIMS 6 - - Material Staging Time (Local, Relating to a Plant)
36
LDDAT
- Loadg Date DATS 8 - - Loading Date
37
LDUHR
- Loadg Time TIMS 6 - - Loading Time (Local Time Relating to a Shipping Point)
38
TDDAT
- TrpPlanDt DATS 8 - - Transportation Planning Date
39
TDUHR
- TP Time TIMS 6 - - Transp. Planning Time (Local, Relating to a Shipping Point)
40
WADAT
- GI Date DATS 8 - - Goods Issue Date
41
WAUHR
- GI Time TIMS 6 - - Time of Goods Issue (Local, Relating to a Plant)
42
ELDAT
- GR End DATS 8 - - Goods Receipt End Date
43
ELUHR
- GR End TIMS 6 - - Goods Receipt End Time (Local, Relating to a Plant)
44
ANZSN
- No.ser.no. INT4 10 - - Number of serial numbers
45
NODISP
- Res/PurcRq CHAR 1 - - Ind: Reserv. not applicable to MRP;Purc. req. not created
46
KEY_ID
- Budget NUMC 16 - - Unique Number of Budget
47
OTB_VALUE
- Budget CURR 17 2 - Required Budget
48
OTB_CURR
- OTB Crrncy CUKY 5 - - OTB Currency
49
OTB_RES_VALUE
- ReservBudg CURR 17 2 - Reserved Budget for OTB-Relevant Purchasing Document
50
OTB_SPEC_VALUE
- SpclReleas CURR 17 2 - Special Release Budget
51
SPR_RSN_PROFILE
- OTBRsnPrfl CHAR 4 - - Reason Profile for OTB Special Release
52
BUDG_TYPE
- Bdgt Type CHAR 2 - - Budget Type
53
OTB_STATUS
- OTB Status CHAR 1 - - OTB Check Status
54
OTB_REASON
- Reason CHAR 3 - - Reason Indicator for OTB Check Status
55
CHECK_TYPE
- Check Type CHAR 1 - - Type of OTB Check
56
DL_ID
- ID CHAR 22 - - Date Line ID (GUID)
57
HANDOVER_DATE
- TrnsfDate DATS 8 - - Transfer Date
58
NO_SCEM
- No SCEM CHAR 1 - - Purchase Order Not Transferred to SCEM
59
DNG_DATE
- Rem.Date DATS 8 - - Creation Date of Reminder Message Record
60
DNG_TIME
- Rem.Time TIMS 6 - - Creation Time of Reminder Message Record
61
CNCL_ANCMNT_DONE
- Cnc.Thr. CHAR 1 - - Cancellation Threat Made
62
DATESHIFT_NUMBER
- No. DS DEC 3 - - Number of Current Date Shifts

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk EKET.

Interactive ERD Diagrams
SAP MM - Purchase Orders Relation →
Standard T-Codes
SE11 SE16
Related Tables
EKKO EKPO EKKN EORD EINA EINE S011 S012
ANSI SQL Query 
SELECT a.EBELN,
       a.EBELP,
       a.ETENR,
       a.EINDT,
       a.SLFDT,
       a.LPEIN,
       a.MENGE
FROM EKET AS a
WHERE a.EBELN = '4500017291'
  AND a.EBELP = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~ebeln,
       a~ebelp,
       a~etenr,
       a~eindt,
       a~slfdt,
       a~lpein,
       a~menge
  FROM eket AS a
  WHERE a~ebeln = '4500017291'
  and a~ebelp = '0001'
  INTO TABLE @DATA(lt_eket)
  UP TO 100 ROWS.