SAP table VBPV (Sales Document: Product Proposal)

SAP table VBPV has 7 primary key fields being MANDT,VKORG,VTWEG,SPART,KUNNR,MATNR,CHARG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
MATNR Material Number CHAR 40 0 MARA MATNR
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
PVMNG01 Item proposal quantity QUAN 15 3 PVMNG
PVMNG02 Item proposal quantity QUAN 15 3 PVMNG
PVMNG03 Item proposal quantity QUAN 15 3 PVMNG
PVMNG04 Item proposal quantity QUAN 15 3 PVMNG
PVMNG05 Item proposal quantity QUAN 15 3 PVMNG
PVMNG06 Item proposal quantity QUAN 15 3 PVMNG
PVMNG07 Item proposal quantity QUAN 15 3 PVMNG
PVMNG08 Item proposal quantity QUAN 15 3 PVMNG
PVMNG09 Item proposal quantity QUAN 15 3 PVMNG
PVMNG10 Item proposal quantity QUAN 15 3 PVMNG
PVMNG11 Item proposal quantity QUAN 15 3 PVMNG
PVMNG12 Item proposal quantity QUAN 15 3 PVMNG
PVVRKME Sales unit UNIT 3 0 T006 VRKME
PVHKN Source indicator CHAR 1 0 TPVH PVHKN
PVSRT Sorting indicator for product proposal (source) NUMC 2 0 PVSRT
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
ERDAT Date on which the record was created DATS 8 0 ERDAT
NETWR Net Value of the Order Item in Document Currency CURR 15 2 NETWR_AP
WAERK SD Document Currency CUKY 5 0 TCURC WAERK

VBPV foreign key relationships

Table Field Check Table Check Field
0 VBPV CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
1 VBPV KUNNR KNA1 General Data in Customer Master MANDT
1 VBPV KUNNR KNA1 General Data in Customer Master KUNNR
0 VBPV MANDT T000 Clients MANDT
1 VBPV MATNR MARA General Material Data MANDT
1 VBPV MATNR MARA General Material Data MATNR
0 VBPV PVVRKME T006 Units of Measurement MANDT
1 VBPV SPART TVTA Organizational Unit: Sales Area(s) MANDT
1 VBPV SPART TVTA Organizational Unit: Sales Area(s) VKORG
1 VBPV SPART TVTA Organizational Unit: Sales Area(s) VTWEG
1 VBPV SPART TVTA Organizational Unit: Sales Area(s) SPART
0 VBPV VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 VBPV VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 VBPV VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
1 VBPV VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
1 VBPV VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
0 VBPV WAERK TCURC Currency Codes MANDT
0 VBPV WAERK TCURC Currency Codes WAERS