1. Home
  2. Resources
  3. SAP Tables
  4. FRM_EKETVB_T - Order Delivery Schedule: Open Delivery Quantity

SAP Table FRM_EKETVB_T

Order Delivery Schedule: Open Delivery Quantity

FRM_EKETVB_T (Order Delivery Schedule: Open Delivery Quantity) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FRM_EKETVB_T to other SAP tables.

Source: FRM_EKETVB_T (Order Delivery Schedule: Open Delivery Quantity)

FRM_EKETVB_T table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ETENR Delivery Schedule Line Counter EETEN NUMC 4 0
EINDT Item Delivery Date EINDT DATS 8 0
SLFDT Statistics-Relevant Delivery Date SLFDT DATS 8 0
LPEIN Category of Delivery Date LPEIN CHAR 1 0
MENGE Scheduled Quantity ETMEN QUAN 13 3
AMENG Previous Quantity (Delivery Schedule Lines) VOMNG QUAN 13 3
WEMNG Quantity of Goods Received WEEMG QUAN 13 3
WAMNG Issued Quantity WAMNG QUAN 13 3
UZEIT Delivery Date Time-Spot LZEIT TIMS 6 0
BANFN Purchase Requisition Number BANFN CHAR 10 0
BNFPO Item Number of Purchase Requisition BNFPO EBAN NUMC 5 0
ESTKZ Creation Indicator (Purchase Requisition/Schedule Lines) ESTKZ CHAR 1 0
B Material requirements planning
D Direct procurement
F Production order
G Store order
R Realtime (manual)
U Converted planned order
V Sales and distribution document
M Compression (monthly basis)
Y Compression (annual basis)
A SAP APO
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
MAHNZ No. of Reminders/Expediters for Schedule Line MAHNZE DEC 3 0
BEDAT Order date of schedule line ETBDT DATS 8 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
SERNR BOM explosion number SERNR CHAR 8 0
FIXKZ Schedule Line is "Fixed" ETFIX CHAR 1 0
X Yes
NULL No
GLMNG Quantity Delivered (Stock Transfer) GLMNG QUAN 13 3
DABMG Quantity Reduced (MRP) DABMG QUAN 13 3
CHARG Batch Number CHARG_D CHAR 10 0
LICHA Vendor Batch Number LICHN CHAR 15 0
CHKOM Components CHKOM CHAR 1 0
X Yes
NULL No
VERID Production Version VERID CHAR 4 0
ABART Scheduling agreement release type MEABART CHAR 1 0
NULL Order
1 Forecast dlv. sched.
2 JIT delivery schedule
3 Issue for external agent (only in delivery)
4 Returns for scheduling agreemnt w/ release (only in dlvy)
5 Planning delivery schedule
6 Delivery order (only in the delivery)
7 Returns for delivery order (only in delivery)
MNG02 Committed Quantity MNG06 QUAN 13 3
DAT01 Committed Date DAT05 DATS 8 0
ALTDT Previous delivery date ALTDT DATS 8 0
AULWE Route Schedule AULWE VALW CHAR 10 0
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
MBUHR Material Staging Time (Local, Relating to a Plant) MBUHR TIMS 6 0
LDDAT Loading Date LDDAT DATS 8 0
LDUHR Loading Time (Local Time Relating to a Shipping Point) LDUHR TIMS 6 0
TDDAT Transportation Planning Date TDDAT_D DATS 8 0
TDUHR Transp. Planning Time (Local, Relating to a Shipping Point) TDUHR TIMS 6 0
WADAT Goods Issue Date WADAT DATS 8 0
WAUHR Time of Goods Issue (Local, Relating to a Plant) WAUHR TIMS 6 0
ELDAT Goods Receipt End Date ELDAT DATS 8 0
ELUHR Goods Receipt End Time (Local, Relating to a Plant) ELUHR TIMS 6 0
ANZSN Number of serial numbers ANZSN INT4 10 0
NODISP Ind: Reserv. not applicable to MRP;Purc. req. not created NODISP CHAR 1 0
X Yes
NULL No
GEO_ROUTE Description of a Geographical Route /SPE/DE_ROUTE_ID CHAR 10 0
ROUTE_GTS Route Code for SAP Global Trade Services /SPE/DE_ROUTE_GTS_CODE CHAR 10 0
GTS_IND Goods Traffic Type /SPE/DE_LEG_GTS_CODE CHAR 2 0
TSP Forwarding agent SPDNR CHAR 10 0
CD_LOCNO Location number in APO APOLOCNO CHAR 20 0
CD_LOCTYPE APO location type APOLOCTYPE CHAR 4 0
HANDOVERDATE Handover Date at the Handover Location HANDOVER_DATE DATS 8 0
HANDOVERTIME Handover time at the handover location HANDOVER_TIME TIMS 6 0
/CWM/MENGE Schedule Line Quantity in Base/Parallel Unit of Measure /CWM/ETMEN QUAN 13 3
/CWM/DABMG MRP Reduced Quantity in Base/Parallel UoM /CWM/DABMG QUAN 13 3
/CWM/WEMNG Goods Receipt Quantity in Base or Parallel Unit of Measure /CWM/WEMNG QUAN 13 3
KEY_ID Unique Number of Budget WRF_BUDG_KEY_ID NUMC 16 0
OTB_VALUE Required Budget WRF_POTB_VALUE CURR 17 2
OTB_CURR OTB Currency WRF_POTB_CURRENCY CUKY 5 0
OTB_RES_VALUE Reserved Budget for OTB-Relevant Purchasing Document WRF_POTB_RES_VALUE CURR 17 2
OTB_SPEC_VALUE Special Release Budget WRF_POTB_SPECIAL_VALUE CURR 17 2
SPR_RSN_PROFILE Reason Profile for OTB Special Release WRF_POTB_SPR_RSN_PROFILE CHAR 4 0
BUDG_TYPE Budget Type WRF_BUDG_TYPE CHAR 2 0
OTB_STATUS OTB Check Status WRF_POTB_STATUS CHAR 1 0
NULL Not Checked
1 OTB Check Without Errors
2 Checked with Errors
OTB_REASON Reason Indicator for OTB Check Status WRF_POTB_STATUS_REASON CHAR 3 0
001 No Check Required
002 Active Budget Available
005 Complete OTB Check Successful
006 Complete OTB Check Not Successful
007 OTB Check Not Active According to Customizing
008 OTB Check Deactivated According to BAdI
009 At Least One Variant of Generic Material w. Negative OTB Ch.
010 All Variants of Generic Material with Positive OTB Check
011 At least one doc. w. same coll. no. OTB neg. (reason 006)
CHECK_TYPE Type of OTB Check WRF_BUDG_OTB_CHECK CHAR 1 0
1 Full Check
2 Limited Check
3 No Check
DL_ID Date Line ID (GUID) WRF_PSCD_DL_ID CHAR 22 0
HANDOVER_DATE Transfer Date WRF_PSCD_HANDOVER_DATE DATS 8 0
NO_SCEM Purchase Order Not Transferred to SCEM WRF_PSCD_NO_SCEM CHAR 1 0
NULL Not Selected
X Selected
DNG_DATE Creation Date of Reminder Message Record WRF_PCTR_DNG_DATE DATS 8 0
DNG_TIME Creation Time of Reminder Message Record WRF_PCTR_DNG_TIME TIMS 6 0
CNCL_ANCMNT_DONE Cancellation Threat Made WRF_PCTR_CNCL_ANCMT_DONE CHAR 1 0
NULL Not Selected
X Selected
DATESHIFT_NUMBER Number of Current Date Shifts WRF_PCTR_DATESHIFT_NUMBER DEC 3 0
OLFMNG Open quantity to be delivered (in sales unit) OLFMNG QUAN 13 3
OLFMNG_FLT Open quantity to be delivered (in sales unit) OLFMNG_FLT FLTP 16 16
OLFMNG_FLL Open Quantity to Be Delivered (in Base Unit of Measure) OLFMNG_FLL FLTP 16 16

FRM_EKETVB_T foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FRM_EKETVB_T AULWE SYST MANDT VALW Delivery Plan: Definition of Route Schedule MANDT
FRM_EKETVB_T AULWE FRM_EKETVB_T AULWE VALW Delivery Plan: Definition of Route Schedule AULWE
FRM_EKETVB_T BNFPO FRM_EKETVB_T MANDT EBAN Purchase Requisition MANDT
FRM_EKETVB_T BNFPO FRM_EKETVB_T BANFN EBAN Purchase Requisition BANFN
FRM_EKETVB_T BNFPO FRM_EKETVB_T BNFPO EBAN Purchase Requisition BNFPO
FRM_EKETVB_T EBELN FRM_EKETVB_T MANDT EKKO Purchasing Document Header MANDT
FRM_EKETVB_T EBELN FRM_EKETVB_T EBELN EKKO Purchasing Document Header EBELN
FRM_EKETVB_T EBELP FRM_EKETVB_T MANDT EKPO Purchasing Document Item MANDT
FRM_EKETVB_T EBELP FRM_EKETVB_T EBELN EKPO Purchasing Document Item EBELN
FRM_EKETVB_T EBELP FRM_EKETVB_T EBELP EKPO Purchasing Document Item EBELP
FRM_EKETVB_T MANDT FRM_EKETVB_T MANDT T000 Clients MANDT