SE11 ABAP Dictionary SE11 VBBE

Popular:

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

VBBE

Sales Requirements: Individual Records

SAP SD Transparent Table 40 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	MATNR	-	Material	CHAR	18	-	MARA	Material Number
6	WERKS	-	Plant	CHAR	4	-	T001W	Plant
7	BERID	-	MRP Area	CHAR	10	-	-	MRP Area
8	MBDAT	-	Mat.Av.Dt.	DATS	8	-	-	Material Staging/Availability Date
9	LGORT	-	Stor. Loc.	CHAR	4	-	T001L	Storage Location
10	CHARG	-	Batch	CHAR	10	-	-	Batch Number
11	VBTYP	-	Doc.cat.	CHAR	1	-	-	SD document category
12	BDART	-	Req.type	CHAR	2	-	-	Requirement type
13	PLART	-	Plan.type	CHAR	1	-	-	Planning type
14	OMENG	-	Open	QUAN	15	3	-	Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP
15	VMENG	-	Quantity	QUAN	15	3	-	Confirmed quantity for availability check in SKU
16	MEINS	-	Unit	UNIT	3	-	-	Base Unit of Measure
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	AWAHR	-	Probab.	NUMC	3	-	-	Order probability of the item
21	AUART	-	SalesDocTy	CHAR	4	-	-	Sales Document Type
22	PROJN	-	not in use	CHAR	16	-	-	Old: Project number : No longer used --> PS_POSNR
23	KUNNR	-	Sold-to pt	CHAR	10	-	KNA1	Sold-to party
24	NODIS	-	No MRP	CHAR	1	-	-	Requirements record not relevant to MRP
25	VPZUO	-	Alloc.ind.	CHAR	1	-	-	Allocation Indicator
26	VPMAT	-	Plng matl	CHAR	18	-	-	Planning material
27	VPWRK	-	Plng plant	CHAR	4	-	-	Planning plant
28	PRBME	-	PG unit	UNIT	3	-	-	Base unit of measure for product group
29	UMREF	-	Conversion	FLTP	16	16	-	Conversion factor: quantities
30	PZMNG	-	Plnnd qty	QUAN	15	3	-	Planned allocation quantity for independent requirements
31	KNTTP	-	AcctAssCat	CHAR	1	-	-	Account Assignment Category
32	SOBKZ	-	Spec.Stock	CHAR	1	-	-	Special Stock Indicator
33	KZVBR	-	Consumpt.	CHAR	1	-	-	Consumption Posting
34	SERNR	-	BOMexpl.no	CHAR	8	-	-	BOM explosion number
35	PSPEL	-	WBS Elem.	NUMC	8	-	-	WBS Element
36	PLNKZ	-	Plng ind.	CHAR	1	-	-	Planning Indicator
37	CUOBJ	-	Configurtn	NUMC	18	-	-	Configuration
38	MONKZ	-	Assembly	CHAR	1	-	-	Indicator: for assembly order procedures
39	KZBWS	-	Valuation	CHAR	1	-	-	Valuation of Special Stock
40	TECHS	-	StdVariant	CHAR	12	-	-	Parameter Variant/Standard Variant

Related References & SQL

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

Interactive ERD Diagrams

SAP SD Table Mapping & Document Flow →

Standard T-Codes

SE11 SE16

Related Tables

VBAK MARA T001W T001L KNA1 VBLB VBPA VBAP

ANSI SQL Query

SELECT a.VBELN,
       a.POSNR,
       a.ETENR,
       a.MATNR,
       a.WERKS,
       a.BERID,
       a.MBDAT
FROM VBBE AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~posnr,
       a~etenr,
       a~matnr,
       a~werks,
       a~berid,
       a~mbdat
  FROM vbbe AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbbe)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBBE

VBBE

Dictionary Fields Fields

Related References & SQL