1. Home
  2. Resources
  3. SAP Tables
  4. ATP_VBBE - Generated Table for View

SAP Table ATP_VBBE

Generated Table for View

ATP_VBBE (Generated Table for View) 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 ATP_VBBE to other SAP tables.

Source: ATP_VBBE (Generated Table for View)

ATP_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
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
KUNNR Sold-to party KUNAG KNA1 CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
PSPEL WBS Element PS_POSNR NUMC 8 0

ATP_VBBE foreign key relationships

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