SAP VBPV Sales Document: Product Proposal Table
Overview
VBPV is a standard SAP S/4HANA table that stores Sales Document: Product Proposal data. There are total 26 fields in the VBPV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBPV belongs to Sales (SD-SLS) module and is located in the package Application development R/3 Sales (VA).
In addition, following links provide an overview of foreign key relationships, if any, that link VBPV to other SAP tables and standard CDS views available based on VBPV table in S/4HANA 2020.
Techincal Settings of VBPV
Below are technical details of the table VBPV
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of VBPV Fields
The following table gives you an overview of the fields available in VBPV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR | 2 |
| SPART | Division | SPART | TVTA | CHAR | 2 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 |
| PVMNG01 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG02 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG03 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG04 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG05 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG06 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG07 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG08 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG09 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG10 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG11 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVMNG12 | Item proposal quantity | PVMNG | QUAN | 15 | |
| PVVRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| PVHKN | Source indicator | PVHKN | TPVH | CHAR | 1 |
| PVSRT | Sorting indicator for product proposal (source) | PVSRT | NUMC | 2 | |
| VBTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| NETWR | Net Value of the Order Item in Document Currency | NETWR_AP | CURR | 15 | |
| WAERK | SD document currency | WAERK | TCURC | CUKY | 5 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBPV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBPV | CHARG | 1: CN | MCH1 |
| VBPV | KUNNR | 1: CN | KNA1 |
| VBPV | MANDT | 1: CN | T000 |
| VBPV | MATNR | 1: CN | MARA |
| VBPV | PVHKN | 1: CN | TPVH |
| VBPV | PVVRKME | C: CN | T006 |
| VBPV | SPART | 1: CN | TVTA |
| VBPV | VKORG | 1: CN | TVKO |
| VBPV | VTWEG | 1: CN | TVKOV |
| VBPV | WAERK | C: CN | TCURC |