SAP ABAP Table FRM_EKETVB_T (Order Delivery Schedule: Open Delivery Quantity)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ LO-MDS (Application Component) Merchandise Distribution
     ⤷ WFRM (Package) ISR: Cross-Docking and Floor-Ready Merchandise

Basic Data

Table Category	INTTAB	Structure
Structure	FRM_EKETVB_T	Table Relationship Diagram
Short Description	Order Delivery Schedule: Open Delivery Quantity

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in