SAP VBPV_E Selling Recommender: Sales Document: Product Proposal Table
Overview
VBPV_E is a standard SAP S/4HANA table that stores Selling Recommender: Sales Document: Product Proposal data. There are total 27 fields in the VBPV_E table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBPV_E 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_E to other SAP tables and standard CDS views available based on VBPV_E table in S/4HANA 2020.
Techincal Settings of VBPV_E
Below are technical details of the table VBPV_E
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of VBPV_E Fields
The following table gives you an overview of the fields available in VBPV_E
| 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 |
| AUART | Sales Document Type | AUART | CHAR | 4 | |
| 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_E
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBPV_E | CHARG | 1: CN | MCH1 |
| VBPV_E | KUNNR | 1: CN | KNA1 |
| VBPV_E | MANDT | 1: CN | T000 |
| VBPV_E | MATNR | 1: CN | MARA |
| VBPV_E | PVHKN | 1: CN | TPVH |
| VBPV_E | PVVRKME | C: CN | T006 |
| VBPV_E | SPART | 1: CN | TVTA |
| VBPV_E | VKORG | 1: CN | TVKO |
| VBPV_E | VTWEG | 1: CN | TVKOV |
| VBPV_E | WAERK | C: CN | TCURC |