VBPV_E
Selling Recommender: Sales Document: Product Proposal
VBPV_E is an SAP database table in S/4HANA. Selling Recommender: Sales Document: Product Proposal. It contains 27 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SalesDocumentProposalItem | view | from | BASIC | Product Proposal for Sales Order Item |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | vkorg | vkorg | Sales Org. | |||
| KEY | vtweg | vtweg | Distr. Channel | |||
| KEY | spart | spart | Division | |||
| KEY | kunnr | kunnr | Customer | |||
| KEY | auart | auart | Sales Doc. Type | |||
| KEY | matnr | matnr | Material | |||
| KEY | charg | charg_d | Batch | |||
| pvmng01 | pvmng | IP quantity | ||||
| pvmng02 | pvmng | IP quantity | ||||
| pvmng03 | pvmng | IP quantity | ||||
| pvmng04 | pvmng | IP quantity | ||||
| pvmng05 | pvmng | IP quantity | ||||
| pvmng06 | pvmng | IP quantity | ||||
| pvmng07 | pvmng | IP quantity | ||||
| pvmng08 | pvmng | IP quantity | ||||
| pvmng09 | pvmng | IP quantity | ||||
| pvmng10 | pvmng | IP quantity | ||||
| pvmng11 | pvmng | IP quantity | ||||
| pvmng12 | pvmng | IP quantity | ||||
| pvvrkme | vrkme | Sales Unit | ||||
| pvhkn | pvhkn | Source | ||||
| pvsrt | pvsrt | Source sorting | ||||
| vbtyp | vbtypl | Document Cat. | ||||
| erdat | erdat | Created On | ||||
| netwr | netwr_ap | Net Value | ||||
| waerk | waerk | Doc. Currency |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Selling Recommender: Sales Document: Product Proposal
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBPV_E (
MANDT, -- Client [mandt]
VKORG, -- Sales Org. [vkorg]
VTWEG, -- Distr. Channel [vtweg]
SPART, -- Division [spart]
KUNNR, -- Customer [kunnr]
AUART, -- Sales Doc. Type [auart]
MATNR, -- Material [matnr]
CHARG, -- Batch [charg_d]
PVMNG01, -- IP quantity [pvmng]
PVMNG02, -- IP quantity [pvmng]
PVMNG03, -- IP quantity [pvmng]
PVMNG04, -- IP quantity [pvmng]
PVMNG05, -- IP quantity [pvmng]
PVMNG06, -- IP quantity [pvmng]
PVMNG07, -- IP quantity [pvmng]
PVMNG08, -- IP quantity [pvmng]
PVMNG09, -- IP quantity [pvmng]
PVMNG10, -- IP quantity [pvmng]
PVMNG11, -- IP quantity [pvmng]
PVMNG12, -- IP quantity [pvmng]
PVVRKME, -- Sales Unit [vrkme]
PVHKN, -- Source [pvhkn]
PVSRT, -- Source sorting [pvsrt]
VBTYP, -- Document Cat. [vbtypl]
ERDAT, -- Created On [erdat]
NETWR, -- Net Value [netwr_ap]
WAERK, -- Doc. Currency [waerk]
PRIMARY KEY (MANDT, VKORG, VTWEG, SPART, KUNNR, AUART, MATNR, CHARG)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA