SE11 ABAP Dictionary SE11 VBEP

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VBEP

Sales Document: Schedule Line Data

SAP SD Transparent Table 58 Fields

Primary Key:

MANDT VBELN POSNR ETENR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	VBELN	KEY	Sales Doc.	CHAR	10	-	VBAK	Sales Document
3	POSNR	KEY	Item	NUMC	6	-	-	Sales Document Item
4	ETENR	KEY	Schd. Line	NUMC	4	-	-	Delivery Schedule Line Number
5	ETTYP	-	SchLineCat	CHAR	2	-	-	Schedule line category
6	LFREL	-	Item deliv	CHAR	1	-	-	Item is relevant for delivery
7	EDATU	-	Dlv.Date	DATS	8	-	-	Schedule line date
8	EZEIT	-	Arriv.time	TIMS	6	-	-	Arrival time
9	WMENG	-	Order qty	QUAN	13	3	-	Order quantity in sales units
10	BMENG	-	ConfirmQty	QUAN	13	3	-	Confirmed Quantity
11	VRKME	-	Sales unit	UNIT	3	-	-	Sales unit
12	LMENG	-	Req.qty	QUAN	13	3	-	Required quantity for mat.management in stockkeeping units
13	MEINS	-	Unit	UNIT	3	-	-	Base Unit of Measure
14	BDDAT	-	Req.date	DATS	8	-	-	Requirement date (deadline for procurement)
15	BDART	-	Req.type	CHAR	2	-	-	Requirement type
16	PLART	-	Plan.type	CHAR	1	-	-	Planning type
17	VBELE	-	Business	CHAR	10	-	-	Business document number
18	POSNE	-	Item	NUMC	6	-	-	Business item number
19	ETENE	-	Sched.line	NUMC	4	-	-	Schedule line
20	RSDAT	-	Res.date	DATS	8	-	-	Earliest possible reservation date
21	IDNNR	-	Maint.req.	NUMC	10	-	-	Maintenance request
22	BANFN	-	Purch.Req.	CHAR	10	-	-	Purchase Requisition Number
23	BSART	-	Order Type	CHAR	4	-	-	Order Type (Purchasing)
24	BSTYP	-	Doc. Cat.	CHAR	1	-	-	Purchasing Document Category
25	WEPOS	-	ConfStatus	CHAR	1	-	-	Confirmation status of schedule line (incl.ALE)
26	REPOS	-	IR	CHAR	1	-	-	Invoice Receipt Indicator
27	LRGDT	-	ReturnPack	DATS	8	-	-	Return date for returnable packaging
28	PRGRS	-	Date type	CHAR	1	-	-	Date type (day, week, month, interval)
29	TDDAT	-	TrpPlanDt	DATS	8	-	-	Transportation Planning Date
30	MBDAT	-	Mat.Av.Dt.	DATS	8	-	-	Material Staging/Availability Date
31	LDDAT	-	Loadg Date	DATS	8	-	-	Loading Date
32	WADAT	-	GI Date	DATS	8	-	-	Goods Issue Date
33	CMENG	-	Corr.qty	QUAN	13	3	-	Corrected quantity in sales unit
34	LIFSP	-	Dlv.block	CHAR	2	-	-	Schedule line blocked for delivery
35	GRSTR	-	Group definition of structure data	NUMC	3	-	-	Group definition of structure data
36	ABART	-	Rel.type	CHAR	1	-	-	Release type
37	ABRUF	-	Dlv.sched.	NUMC	10	-	-	Forecast Delivery schedule number
38	ROMS1	-	CommittQty	QUAN	13	3	-	Committed quantity
39	ROMS2	-	Size 2	QUAN	13	3	-	Size 2
40	ROMS3	-	Size 3	QUAN	13	3	-	Size 3
41	ROMEI	-	Size unit	UNIT	3	-	-	Unit of measure for sizes 1 to 3
42	RFORM	-	Formula	CHAR	2	-	-	Formula key
43	UMVKZ	-	Numerator	DEC	5	-	-	Numerator (factor) for conversion of sales quantity into SKU
44	UMVKN	-	Denominat.	DEC	5	-	-	Denominator (Divisor) for Conversion of Sales Qty into SKU
45	VERFP	-	Confirmed	CHAR	1	-	-	Availability confirmed automatically
46	BWART	-	Mvmt Type	CHAR	3	-	-	Movement Type (Inventory Management)
47	BNFPO	-	PReq. Item	NUMC	5	-	-	Item Number of Purchase Requisition
48	ETART	-	SchdLiType	CHAR	1	-	-	Schedule line type EDI
49	AUFNR	-	Order	CHAR	12	-	-	Order Number
50	PLNUM	-	Plnd order	CHAR	10	-	-	Planned order number
51	SERNR	-	BOMexpl.no	CHAR	8	-	-	BOM explosion number
52	AESKD	-	Change	CHAR	17	-	-	Customer Engineering Change Status
53	ABGES	-	Guaranteed	FLTP	16	16	-	Guaranteed (factor between 0 and 1)
54	MBUHR	-	Stag. Time	TIMS	6	-	-	Material Staging Time (Local, Relating to a Plant)
55	TDUHR	-	TP Time	TIMS	6	-	-	Transp. Planning Time (Local, Relating to a Shipping Point)
56	LDUHR	-	Loadg Time	TIMS	6	-	-	Loading Time (Local Time Relating to a Shipping Point)
57	WAUHR	-	GI Time	TIMS	6	-	-	Time of Goods Issue (Local, Relating to a Plant)
58	AULWE	-	RouteSched	CHAR	10	-	-	Route Schedule

Related References & SQL

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

Interactive ERD Diagrams

SAP SD - Sales Tables Relation → SAP SD Table Mapping & Document Flow →

Standard T-Codes

SE11 SE16

Related Tables

VBAK VBAP VBEH VBKD STXH STXL VBPA VAPMA

ANSI SQL Query

SELECT a.VBELN,
       a.POSNR,
       a.ETENR,
       a.ETTYP,
       a.LFREL,
       a.EDATU,
       a.EZEIT
FROM VBEP AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~posnr,
       a~etenr,
       a~ettyp,
       a~lfrel,
       a~edatu,
       a~ezeit
  FROM vbep AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbep)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBEP

VBEP

Dictionary Fields Fields

Related References & SQL