SAP table VBEP (Sales Document: Schedule Line Data)

SAP table VBEP (Sales Document: Schedule Line Data) contains detailed information about schedule lines for sales documents. Each entry represents a schedule line, which specifies delivery dates, quantities, and other logistics-related data for individual items in a sales order. This table is essential for managing delivery schedules, ensuring timely order fulfillment, and coordinating with inventory and production processes.

SAP table VBEP has 4 primary key fields being MANDT,VBELN,POSNR,ETENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Sales Document CHAR 10 0 VBELN_VA
POSNR Sales Document Item NUMC 6 0 POSNR_VA
ETENR Schedule Line Number NUMC 4 0 ETENR
ETTYP Schedule line category CHAR 2 0 TVEP ETTYP
LFREL Item is relevant for delivery CHAR 1 0 LFREL
EDATU Schedule line date DATS 8 0 EDATU
EZEIT Arrival time TIMS 6 0 EZEIT_VBEP
WMENG Order Quantity in Sales Units QUAN 13 3 WMENG
BMENG Confirmed Quantity QUAN 13 3 BMENG
VRKME Sales unit UNIT 3 0 T006 VRKME
LMENG Required quantity for mat.management in stockkeeping units QUAN 13 3 LMENG
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
BDDAT Requirement date (deadline for procurement) DATS 8 0 BDDAT
BDART Requirement type CHAR 2 0 BDART
PLART Planning type CHAR 1 0 PLART
VBELE Business document number CHAR 10 0 VBELE
POSNE Business item number NUMC 6 0 POSNE
ETENE Schedule line NUMC 4 0 VBEP ETENE
RSDAT Earliest possible reservation date DATS 8 0 RSDAT
IDNNR Maintenance request NUMC 10 0 IDNNR
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BSART Order Type (Purchasing) CHAR 4 0 T161 BSART
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
WEPOS Confirmation status of schedule line (incl.ALE) CHAR 1 0 WEPOS_A
REPOS Invoice receipt indicator CHAR 1 0 REPOS
LRGDT Return date for returnable packaging DATS 8 0 LRGDT
PRGRS Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
TDDAT Transportation Planning Date DATS 8 0 TDDAT_D
MBDAT Material Staging/Availability Date DATS 8 0 MBDAT
LDDAT Loading Date DATS 8 0 LDDAT
WADAT Goods Issue Date DATS 8 0 WADAT
CMENG Corrected quantity in sales unit QUAN 13 3 CMENG
LIFSP Schedule Line Blocked for Delivery CHAR 2 0 TVLS LIFSP_EP
GRSTR Group definition of structure data NUMC 3 0 GRSTR
ABART Release type CHAR 1 0 ABART
Order
1 Forecast Delivery Schedule
2 JIT Delivery Schedule
3 Issue for External Agent (only in delivery)
4 Return for Scheduling Agreemnt with Release (only in dlvy)
5 Planning Delivery Schedule
6 Delivery Order (only in the delivery)
7 Return for Delivery Order (only in delivery)
ABRUF Forecast Delivery schedule number NUMC 10 0 ABRUF
ROMS1 Committed quantity QUAN 13 3 DCQNT
ROMS2 Size 2 QUAN 13 3 ROMS2
ROMS3 Size 3 QUAN 13 3 ROMS3
ROMEI Unit of measure for sizes 1 to 3 UNIT 3 0 T006 ROMEI
RFORM Formula Key for Variable-Size Items CHAR 2 0 RFORM
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
VERFP Availability confirmed automatically CHAR 1 0 VERFP_MAS
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
BNFPO Item number of purchase requisition NUMC 5 0 EBAN BNFPO
ETART Schedule line type EDI CHAR 1 0 TVET EDI_ETTYP
AUFNR Order Number CHAR 12 0 AUFK AUFNR
PLNUM Planned Order CHAR 10 0 PLAF PLNUM
SERNR BOM explosion number CHAR 8 0 SNUM SERNR
AESKD Customer Engineering Change Status CHAR 17 0 AESKD
ABGES Guaranteed (factor between 0 and 1) FLTP 16 16 ABGES_CM
MBUHR Material Staging Time (Local, Relating to a Plant) TIMS 6 0 MBUHR
TDUHR Transp. Planning Time (Local, Relating to a Shipping Point) TIMS 6 0 TDUHR
LDUHR Loading Time (Local Time Relating to a Shipping Point) TIMS 6 0 LDUHR
WAUHR Time of Goods Issue (Local, Relating to a Plant) TIMS 6 0 WAUHR
AULWE Route Schedule CHAR 10 0 VALW AULWE
HANDOVERDATE Handover Date at the Handover Location DATS 8 0 HANDOVER_DATE
HANDOVERTIME Handover time at the handover location TIMS 6 0 HANDOVER_TIME
DELIVERY_DATE_TYPE_RULE Delivery Date Rule CHAR 1 0 SD_DELIVERY_DATE_TYPE_RULE
On Requested Date or Later
A On Confirmed Date
B By Confirmed Date
DLVQTY_BU Delivered Quantity QUAN 13 3 DLVQTY
DLVQTY_SU Delivered Quantity QUAN 13 3 DLVQTY
OCDQTY_BU Open Confirmed Delivery Quantity QUAN 13 3 OCDQTY
OCDQTY_SU Open Confirmed Delivery Quantity QUAN 13 3 OCDQTY
ORDQTY_BU Open requested Delivery Quantity QUAN 13 3 ORDQTY
ORDQTY_SU Open requested Delivery Quantity QUAN 13 3 ORDQTY
CREA_DLVDATE Delivery Creation Date DATS 8 0 LEDAT
REQ_DLVDATE Schedule line date DATS 8 0 EDATU
BEDAR Requirements class CHAR 3 0 BEDAR
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
WAERK SD Document Currency CUKY 5 0 WAERK
ODN_AMOUNT Open Delivery Net Amount (in Sales Document Currency) CURR 15 2 TDD_ODN_AMOUNT
HANDLE GUID in 'RAW' format RAW 16 0 GUID_16
LCCST Legal Control Status CHAR 1 0 TDD_LCCST
RRQQTY_BU Requested Requirement Quantity in Base Unit QUAN 15 3 TDD_RRQQTY_BU
CRQQTY_BU Confirmed Requirement Quantity in Base Unit QUAN 15 3 TDD_CRQQTY_BU
DUMMY_SLSDOCSCHEDL_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
FSH_RALLOC_QTY ARun Requirement Allocated Quantity QUAN 13 3 FSH_RALLOC_QTY
FSH_OS_ID Order Scheduling Group ID NUMC 4 0 FSH_OS_ID
FSH_PQR_RC Rejection Code for Partial Quantity Rejection CHAR 2 0 FSH_PQR_RC
MBDAT_DRS Material Availability Date Third-Party Order Planning DATS 8 0 MBDAT_DRS

VBEP foreign key relationships

Table Field Check Table Check Field
0 VBEP AUFNR AUFK Order master data AUFNR
1 VBEP AULWE VALW Delivery Plan: Definition of Route Schedule MANDT
1 VBEP AULWE VALW Delivery Plan: Definition of Route Schedule AULWE
0 VBEP BNFPO EBAN Purchase Requisition BANFN
0 VBEP BNFPO EBAN Purchase Requisition BNFPO
1 VBEP BSART T161 Purchasing Document Types MANDT
0 VBEP BWART T156 Movement Type MANDT
0 VBEP BWART T156 Movement Type BWART
1 VBEP ETART TVET Sched.line types for sched.agreements (e.g.backlog, provis.) MANDT
0 VBEP ETENE VBEP Sales Document: Schedule Line Data MANDT
0 VBEP ETENE VBEP Sales Document: Schedule Line Data VBELN
0 VBEP ETENE VBEP Sales Document: Schedule Line Data POSNR
0 VBEP ETENE VBEP Sales Document: Schedule Line Data ETENR
1 VBEP ETTYP TVEP Sales Document: Schedule Line Categories ETTYP
0 VBEP LIFSP TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 VBEP LIFSP TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 VBEP MANDT T000 Clients MANDT
0 VBEP MEINS T006 Units of Measurement MANDT
0 VBEP MEINS T006 Units of Measurement MSEHI
1 VBEP PLNUM PLAF Planned Order MANDT
0 VBEP ROMEI T006 Units of Measurement MANDT
1 VBEP SERNR SNUM BOM explosion number MANDT
0 VBEP VRKME T006 Units of Measurement MANDT
0 VBEP VRKME T006 Units of Measurement MSEHI