SAP ABAP Table VBBE (Sales Requirements: Individual Records)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VBBE	Table Relationship Diagram
Short Description	Sales Requirements: Individual Records

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
3	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
4	ETENR	☑	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
8	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
9	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
10	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
11	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
12	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
13	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
14	OMENG	☐	OMENG	MENG15	QUAN	15	3	Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP
15	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
16	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
17	VBELE	☐	VBELE	VBELN	CHAR	10	0	Business document number	VBUK
18	POSNE	☐	POSNE	POSNR	NUMC	6	0	Business item number	VBUP
19	ETENE	☐	ETENE	ETENR	NUMC	4	0	Schedule line	VBEP
20	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
21	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
22	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
23	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
24	NODIS	☐	NODIS	NODIS	CHAR	1	0	Requirements record not relevant to MRP
25	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
26	VPMAT	☐	VPMAT	MATNR	CHAR	18	0	Planning material	MARA
27	VPWRK	☐	VPWRK	WERKS	CHAR	4	0	Planning plant	T001W
28	PRBME	☐	PRBME	MEINS	UNIT	3	0	Base unit of measure for product group	T006
29	UMREF	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
30	PZMNG	☐	PZMNG	MENG15	QUAN	15	3	Planned allocation quantity for independent requirements
31	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
32	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
33	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
34	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
35	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
36	PLNKZ	☐	PLNKZ	PLNKZ	CHAR	1	0	Planning Indicator
37	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
38	MONKZ	☐	MONKZ	XFELD	CHAR	1	0	Indicator: for assembly order procedures
39	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
40	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBBE	AUART	TVAK	AUART	REF	C	CN
2	VBBE	CHARG	MCHA	CHARG	REF	C	CN
3	VBBE	ETENE	VBEP	ETENR	REF	C	CN
4	VBBE	ETENR	VBEP	ETENR	KEY	1	CN
5	VBBE	KNTTP	T163K	KNTTP	REF	1	CN
6	VBBE	KUNNR	KNA1	KUNNR	REF	C	CN
7	VBBE	LGORT	T001L	LGORT	REF	C	CN
8	VBBE	MANDT	T000	MANDT	KEY	1	CN
9	VBBE	MATNR	MARA	MATNR	KEY	1	CN
10	VBBE	MEINS	T006	MSEHI	REF	C	CN
11	VBBE	POSNE	VBUP	POSNR	REF	C	CN
12	VBBE	POSNR	VBUP	POSNR	KEY	1	CN
13	VBBE	PRBME	T006	MSEHI	REF	1	CN
14	VBBE	SOBKZ	T148	SOBKZ	REF	1	CN
15	VBBE	VBELE	VBUK	VBELN	REF	C	CN
16	VBBE	VBELN	VBUK	VBELN	KEY	1	CN
17	VBBE	VPMAT	MARA	MATNR	REF	1	CN
18	VBBE	VPWRK	T001W	WERKS	REF	1	CN
19	VBBE	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in