SAP ABAP Table EKET (Scheduling Agreement Schedule Lines)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EKET	Table Relationship Diagram
Short Description	Scheduling Agreement Schedule Lines

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
4	ETENR	☑	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter
5	.INCLUDE	☐				0	0	Scheduling Agreement Schedule Lines
6	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
7	SLFDT	☐	SLFDT	DATUM	DATS	8	0	Statistics-Relevant Delivery Date
8	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
9	MENGE	☐	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
10	AMENG	☐	VOMNG	MENG13V	QUAN	13	3	Previous Quantity (Delivery Schedule Lines)
11	WEMNG	☐	WEEMG	MENG13	QUAN	13	3	Quantity of goods received
12	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
13	UZEIT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot
14	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
15	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
16	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
17	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
18	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
19	MAHNZ	☐	MAHNZE	PACK2	DEC	3	0	No. of Reminders/Expediters for Schedule Line
20	BEDAT	☐	ETBDT	DATUM	DATS	8	0	Order date of schedule line
21	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
22	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
23	FIXKZ	☐	ETFIX	XFELD	CHAR	1	0	Schedule Line is "Fixed"
24	GLMNG	☐	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
25	DABMG	☐	DABMG	MENGE	QUAN	13	3	Quantity Reduced (MRP)
26	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
27	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
28	CHKOM	☐	CHKOM	XFELD	CHAR	1	0	Components
29	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
30	ABART	☐	MEABART	ABART	CHAR	1	0	Scheduling agreement release type
31	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
32	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
33	ALTDT	☐	ALTDT	DATUM	DATS	8	0	Previous delivery date
34	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	VALW
35	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
36	MBUHR	☐	MBUHR	TIME_PLANT	TIMS	6	0	Material Staging Time (Local, Relating to a Plant)
37	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
38	LDUHR	☐	LDUHR	TIME_SHIPP	TIMS	6	0	Loading Time (Local Time Relating to a Shipping Point)
39	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
40	TDUHR	☐	TDUHR	TIME_SHIPP	TIMS	6	0	Transp. Planning Time (Local, Relating to a Shipping Point)
41	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
42	WAUHR	☐	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
43	ELDAT	☐	ELDAT	ELDAT	DATS	8	0	Goods Receipt End Date
44	ELUHR	☐	ELUHR	ELUHR	TIMS	6	0	Goods Receipt End Time (Local, Relating to a Plant)
45	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
46	NODISP	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
47	GEO_ROUTE	☐	/SPE/DE_ROUTE_ID	CHAR10	CHAR	10	0	Description of a Geographical Route
48	ROUTE_GTS	☐	/SPE/DE_ROUTE_GTS_CODE	CHAR10	CHAR	10	0	Route Code for SAP Global Trade Services
49	GTS_IND	☐	/SPE/DE_LEG_GTS_CODE	CHAR2	CHAR	2	0	Goods Traffic Type
50	TSP	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	*
51	CD_LOCNO	☐	APOLOCNO	APOLOCNO	CHAR	20	0	Location number in APO
52	CD_LOCTYPE	☐	APOLOCTYPE	APOLOCTYPE	CHAR	4	0	APO location type
53	HANDOVERDATE	☐	HANDOVER_DATE	HANDOVER_DATE	DATS	8	0	Handover Date at the Handover Location
54	HANDOVERTIME	☐	HANDOVER_TIME	HANDOVER_TIME	TIMS	6	0	Handover time at the handover location
55	.INCLU--AP	☐				0	0	EKET Enhancement Seasonal Procurement: Procurement
56	.INCLUDE	☐				0	0	EKET Enhancement: OTB
57	.INCLUDE	☐				0	0	OTB-Relevant Data
58	KEY_ID	☐	WRF_BUDG_KEY_ID	WRF_BUDG_KEY_ID	NUMC	16	0	Unique Number of Budget
59	OTB_VALUE	☐	WRF_POTB_VALUE	WRF_POTB_VALUE	CURR	17	2	Required Budget
60	.INCLUDE	☐				0	0	OTB Currency
61	OTB_CURR	☐	WRF_POTB_CURRENCY	WAERS	CUKY	5	0	OTB Currency	*
62	OTB_RES_VALUE	☐	WRF_POTB_RES_VALUE	WRF_POTB_RES_VALUE	CURR	17	2	Reserved Budget for OTB-Relevant Purchasing Document
63	OTB_SPEC_VALUE	☐	WRF_POTB_SPECIAL_VALUE	WRF_POTB_SPECIAL_VALUE	CURR	17	2	Special Release Budget
64	SPR_RSN_PROFILE	☐	WRF_POTB_SPR_RSN_PROFILE	WRF_POTB_SPR_RSN_PROFILE	CHAR	4	0	Reason Profile for OTB Special Release
65	BUDG_TYPE	☐	WRF_BUDG_TYPE	WRF_BUDG_TYPE	CHAR	2	0	Budget Type
66	OTB_STATUS	☐	WRF_POTB_STATUS	WRF_POTB_STATUS	CHAR	1	0	OTB Check Status
67	OTB_REASON	☐	WRF_POTB_STATUS_REASON	WRF_POTB_STATUS_REASON	CHAR	3	0	Reason Indicator for OTB Check Status
68	CHECK_TYPE	☐	WRF_BUDG_OTB_CHECK	WRF_BUDG_OTB_CHECK	CHAR	1	0	Type of OTB Check
69	.INCLUDE	☐				0	0	EKET Enhancement: Scheduling
70	.INCLUDE	☐				0	0	Fields That Are Stored in Appl. Doc. e.g. Order List
71	DL_ID	☐	WRF_PSCD_DL_ID	SYSUUID_22	CHAR	22	0	Date Line ID (GUID)
72	HANDOVER_DATE	☐	WRF_PSCD_HANDOVER_DATE	DATS	DATS	8	0	Transfer Date
73	NO_SCEM	☐	WRF_PSCD_NO_SCEM	CHAR1_X	CHAR	1	0	Purchase Order Not Transferred to SCEM
74	DNG_DATE	☐	WRF_PCTR_DNG_DATE	DATUM	DATS	8	0	Creation Date of Reminder Message Record
75	DNG_TIME	☐	WRF_PCTR_DNG_TIME	UZEIT	TIMS	6	0	Creation Time of Reminder Message Record
76	CNCL_ANCMNT_DONE	☐	WRF_PCTR_CNCL_ANCMT_DONE	CHAR1_X	CHAR	1	0	Cancellation Threat Made
77	DATESHIFT_NUMBER	☐	WRF_PCTR_DATESHIFT_NUMBER	DEC3	DEC	3	0	Number of Current Date Shifts

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKET	AULWE	VALW	AULWE	REF
2	EKET	BNFPO	EBAN	BNFPO	REF	1	N
3	EKET	EBELN	EKKO	EBELN	KEY	1	CN
4	EKET	EBELP	EKPO	EBELP	KEY	1	CN
5	EKET	MANDT	T000	MANDT	KEY	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in