SAP Table VBBE

Sales Requirements: Individual Records

VBBE (Sales Requirements: Individual Records) 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 VBBE to other SAP tables.

VBBE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales Document VBELN_VA VBUK CHAR 10 0
POSNR Sales Document Item POSNR_VA VBUP NUMC 6 0
ETENR Delivery Schedule Line Number ETENR VBEP NUMC 4 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
BERID MRP Area BERID CHAR 10 0
MBDAT Material Staging/Availability Date MBDAT DATS 8 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
BDART Requirement type BDART CHAR 2 0
PLART Planning type PLART CHAR 1 0
OMENG Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP OMENG QUAN 15 3
VMENG Confirmed quantity for availability check in SKU VMENG QUAN 15 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
VBELE Business document number VBELE VBUK CHAR 10 0
POSNE Business item number POSNE VBUP NUMC 6 0
ETENE Schedule line ETENE VBEP NUMC 4 0
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
AUART Sales Document Type AUART TVAK CHAR 4 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
NODIS Requirements record not relevant to MRP NODIS CHAR 1 0
NULL Requirement planned
1 Requirement not planned, but displayed
2 Requirements neither planned or displayed
VPZUO Allocation Indicator VPZUO CHAR 1 0
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
VPMAT Planning material VPMAT MARA CHAR 18 0
VPWRK Planning plant VPWRK T001W CHAR 4 0
PRBME Base unit of measure for product group PRBME T006 UNIT 3 0
UMREF Conversion factor: quantities UMREFF FLTP 16 16
PZMNG Planned allocation quantity for independent requirements PZMNG QUAN 15 3
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
SERNR BOM explosion number SERNR CHAR 8 0
PSPEL WBS Element PS_POSNR NUMC 8 0
PLNKZ Planning Indicator PLNKZ CHAR 1 0
1 Net requirements planning
2 Gross requirements planning
3 Single-item planning
CUOBJ Configuration CUOBJ_VA NUMC 18 0
MONKZ Indicator: for assembly order procedures MONKZ CHAR 1 0
X Yes
NULL No
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0

VBBE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBBE AUART VBBE MANDT TVAK Sales Document Types MANDT
VBBE AUART VBBE AUART TVAK Sales Document Types AUART
VBBE CHARG VBBE WERKS MCHA Batches WERKS
VBBE CHARG VBBE CHARG MCHA Batches CHARG
VBBE CHARG VBBE MANDT MCHA Batches MANDT
VBBE CHARG VBBE MATNR MCHA Batches MATNR
VBBE ETENE VBBE POSNE VBEP Sales Document: Schedule Line Data POSNR
VBBE ETENE VBBE ETENE VBEP Sales Document: Schedule Line Data ETENR
VBBE ETENE VBBE MANDT VBEP Sales Document: Schedule Line Data MANDT
VBBE ETENE VBBE VBELE VBEP Sales Document: Schedule Line Data VBELN
VBBE ETENR VBBE ETENR VBEP Sales Document: Schedule Line Data ETENR
VBBE ETENR VBBE MANDT VBEP Sales Document: Schedule Line Data MANDT
VBBE ETENR VBBE VBELN VBEP Sales Document: Schedule Line Data VBELN
VBBE ETENR VBBE POSNR VBEP Sales Document: Schedule Line Data POSNR
VBBE KNTTP VBBE MANDT T163K Account Assignment Categories in Purchasing Document MANDT
VBBE KNTTP VBBE KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
VBBE KUNNR VBBE MANDT KNA1 General Data in Customer Master MANDT
VBBE KUNNR VBBE KUNNR KNA1 General Data in Customer Master KUNNR
VBBE LGORT VBBE MANDT T001L Storage Locations MANDT
VBBE LGORT VBBE WERKS T001L Storage Locations WERKS
VBBE LGORT VBBE LGORT T001L Storage Locations LGORT
VBBE MANDT VBBE MANDT T000 Clients MANDT
VBBE MATNR VBBE MATNR MARA General Material Data MATNR
VBBE MATNR VBBE MANDT MARA General Material Data MANDT
VBBE MEINS VBBE MEINS T006 Units of Measurement MSEHI
VBBE MEINS VBBE MANDT T006 Units of Measurement MANDT
VBBE POSNE VBBE MANDT VBUP Sales Document: Item Status MANDT
VBBE POSNE VBBE VBELE VBUP Sales Document: Item Status VBELN
VBBE POSNE VBBE POSNE VBUP Sales Document: Item Status POSNR
VBBE POSNR VBBE MANDT VBUP Sales Document: Item Status MANDT
VBBE POSNR VBBE VBELN VBUP Sales Document: Item Status VBELN
VBBE POSNR VBBE POSNR VBUP Sales Document: Item Status POSNR
VBBE PRBME VBBE MANDT T006 Units of Measurement MANDT
VBBE PRBME VBBE PRBME T006 Units of Measurement MSEHI
VBBE SOBKZ VBBE MANDT T148 Special Stock Indicator MANDT
VBBE SOBKZ VBBE SOBKZ T148 Special Stock Indicator SOBKZ
VBBE VBELE VBBE MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBBE VBELE VBBE VBELE VBUK Sales Document: Header Status and Administrative Data VBELN
VBBE VBELN VBBE MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBBE VBELN VBBE VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBBE VPMAT VBBE MANDT MARA General Material Data MANDT
VBBE VPMAT VBBE VPMAT MARA General Material Data MATNR
VBBE VPWRK VBBE MANDT T001W Plants/Branches MANDT
VBBE VPWRK VBBE VPWRK T001W Plants/Branches WERKS
VBBE WERKS VBBE MANDT T001W Plants/Branches MANDT
VBBE WERKS VBBE WERKS T001W Plants/Branches WERKS