SAP ABAP View VBRP_VRPMA (Access to VBRP using Material Index)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷
SD-CAS (Application Component) Sales Support
⤷
VCR (Package) CAS - reporting

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | VBRP_VRPMA | |
Short Description | Access to VBRP using Material Index | |
Root table | VRPMA | SD Index: Billing Items per Material |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
VRPMA | ||
2 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
MANDT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
MANDT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
VBELN | JL | EQ | 0 | 0 | ||||
4 | ![]() |
VBELN | JR | EQ | AND | 0 | 0 | |||
5 | ![]() |
POSNR | JL | EQ | 0 | 0 | ||||
6 | ![]() |
POSNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
* | |||||
2 | ![]() |
![]() |
MANDT | MANDT | Client | |||
3 | ![]() |
![]() |
MATNR | MATNR | Material Number | |||
4 | ![]() |
![]() |
VKORG | VKORG | Sales Organization | |||
5 | ![]() |
![]() |
FKDAT | FKDAT | Billing date for billing index and printout | |||
6 | ![]() |
![]() |
VTWEG | VTWEG | Distribution Channel | |||
7 | ![]() |
![]() |
FKART | FKART | Billing Type | |||
8 | ![]() |
![]() |
KUNNR | KUNRG | Payer | |||
9 | ![]() |
![]() |
KUNAG | KUNAG | Sold-to party | |||
10 | ![]() |
![]() |
VBTYP | VBTYP | SD document category | |||
11 | ![]() |
![]() |
ERNAM | ERNAM | Name of Person who Created the Object | |||
12 | ![]() |
![]() |
VBELN | VBELN_VF | Billing document | |||
13 | ![]() |
![]() |
POSNR | POSNR_VF | Billing item | |||
14 | ![]() |
![]() |
FKTYP | FKTYP | Billing Category | |||
15 | ![]() |
![]() |
ADRNR | ADRNR_RG | Address nummer of the payer | |||
16 | ![]() |
![]() |
BELNR | BELNR_D | Accounting Document Number | |||
17 | ![]() |
![]() |
GJAHR | GJAHR | Fiscal Year | |||
18 | ![]() |
![]() |
* | |||||
19 | ![]() |
![]() |
MANDT | MANDT | Client | |||
20 | ![]() |
![]() |
VBELN | VBELN_VF | Billing document | |||
21 | ![]() |
![]() |
POSNR | POSNR_VF | Billing item | |||
22 | ![]() |
![]() |
UEPOS | UEPOS | Higher-level item in bill of material structures | |||
23 | ![]() |
![]() |
FKIMG | FKIMG | Actual billed quantity | |||
24 | ![]() |
![]() |
VRKME | VRKME | Sales unit | |||
25 | ![]() |
![]() |
UMVKZ | UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | |||
26 | ![]() |
![]() |
UMVKN | UMVKN | Denominator (divisor) for conversion of sales qty. into SKU | |||
27 | ![]() |
![]() |
MEINS | MEINS | Base Unit of Measure | |||
28 | ![]() |
![]() |
SMENG | SMENG | Scale quantity in base unit of measure | |||
29 | ![]() |
![]() |
FKLMG | FKLMG | Billing quantity in stockkeeping unit | |||
30 | ![]() |
![]() |
LMENG | LMENG | Required quantity for mat.management in stockkeeping units | |||
31 | ![]() |
![]() |
NTGEW | NTGEW_15 | Net weight | |||
32 | ![]() |
![]() |
BRGEW | BRGEW_15 | Gross weight | |||
33 | ![]() |
![]() |
GEWEI | GEWEI | Weight Unit | |||
34 | ![]() |
![]() |
VOLUM | VOLUM_15 | Volume | |||
35 | ![]() |
![]() |
VOLEH | VOLEH | Volume unit | |||
36 | ![]() |
![]() |
GSBER | GSBER | Business Area | |||
37 | ![]() |
![]() |
PRSDT | PRSDT | Date for pricing and exchange rate | |||
38 | ![]() |
![]() |
FBUDA | FBUDA | Date When Services Rendered | |||
39 | ![]() |
![]() |
KURSK | KURSK | Exchange Rate for Pricing and Statistics | |||
40 | ![]() |
![]() |
NETWR | NETWR_FP | Net value of the billing item in document currency | |||
41 | ![]() |
![]() |
VBELV | VBELV | Originating document | |||
42 | ![]() |
![]() |
POSNV | POSNV | Originating item | |||
43 | ![]() |
![]() |
VGBEL | VGBEL | Document number of the reference document | |||
44 | ![]() |
![]() |
VGPOS | VGPOS | Item number of the reference item | |||
45 | ![]() |
![]() |
VGTYP | VBTYP_V | Document category of preceding SD document | |||
46 | ![]() |
![]() |
AUBEL | VBELN_VA | Sales Document | |||
47 | ![]() |
![]() |
AUPOS | POSNR_VA | Sales Document Item | |||
48 | ![]() |
![]() |
AUREF | AUREF | Sales document was created from reference | |||
49 | ![]() |
![]() |
MATNR | MATNR | Material Number | |||
50 | ![]() |
![]() |
ARKTX | ARKTX | Short text for sales order item | |||
51 | ![]() |
![]() |
PMATN | PMATN | Pricing Reference Material | |||
52 | ![]() |
![]() |
CHARG | CHARG_D | Batch Number | |||
53 | ![]() |
![]() |
MATKL | MATKL | Material Group | |||
54 | ![]() |
![]() |
PSTYV | PSTYV | Sales document item category | |||
55 | ![]() |
![]() |
POSAR | POSAR | Item type | |||
56 | ![]() |
![]() |
PRODH | PRODH_D | Product Hierarchy | |||
57 | ![]() |
![]() |
VSTEL | VSTEL | Shipping Point/Receiving Point | |||
58 | ![]() |
![]() |
ATPKZ | ATPKZ | Replacement part | |||
59 | ![]() |
![]() |
SPART | SPART | Division | |||
60 | ![]() |
![]() |
POSPA | POSPA | Item number in the partner segment | |||
61 | ![]() |
![]() |
WERKS | WERKS_D | Plant | |||
62 | ![]() |
![]() |
ALAND | ALAND | Departure country (country from which the goods are sent) | |||
63 | ![]() |
![]() |
WKREG | WKREG | Region in which plant is located | |||
64 | ![]() |
![]() |
WKCOU | WKCOU | County in which plant is located | |||
65 | ![]() |
![]() |
WKCTY | WKCTY | City in which plant is located | |||
66 | ![]() |
![]() |
TAXM1 | TAXM1 | Tax classification material | |||
67 | ![]() |
![]() |
TAXM2 | TAXM2 | Tax classification material | |||
68 | ![]() |
![]() |
TAXM3 | TAXM3 | Tax classification material | |||
69 | ![]() |
![]() |
TAXM4 | TAXM4 | Tax Classification 4 Material | |||
70 | ![]() |
![]() |
TAXM5 | TAXM5 | Tax classification 5 for material | |||
71 | ![]() |
![]() |
TAXM6 | TAXM6 | Tax classification 6 for material | |||
72 | ![]() |
![]() |
TAXM7 | TAXM7 | Tax classification 7 for material | |||
73 | ![]() |
![]() |
TAXM8 | TAXM8 | Tax Classification 8 Material | |||
74 | ![]() |
![]() |
TAXM9 | TAXM9 | Tax Classification 9 Material | |||
75 | ![]() |
![]() |
KOWRR | KOWRR | Statistical values | |||
76 | ![]() |
![]() |
PRSFD | PRSFD | Carry out pricing | |||
77 | ![]() |
![]() |
SKTOF | SKTOF | Cash discount indicator | |||
78 | ![]() |
![]() |
SKFBP | SKFBP | Amount eligible for cash discount in document currency | |||
79 | ![]() |
![]() |
KONDM | KONDM | Material Pricing Group | |||
80 | ![]() |
![]() |
KTGRM | KTGRM | Account assignment group for this material | |||
81 | ![]() |
![]() |
KOSTL | KOSTL | Cost Center | |||
82 | ![]() |
![]() |
BONUS | BONUS | Volume rebate group | |||
83 | ![]() |
![]() |
PROVG | PROVG | Commission group | |||
84 | ![]() |
![]() |
EANNR | EANNR | European Article Number (EAN) - obsolete!!!!! | |||
85 | ![]() |
![]() |
VKGRP | VKGRP | Sales group | |||
86 | ![]() |
![]() |
VKBUR | VKBUR | Sales office | |||
87 | ![]() |
![]() |
SPARA | SPART_AK | Division for order header | |||
88 | ![]() |
![]() |
SHKZG | SHKZG_VF | Returns item | |||
89 | ![]() |
![]() |
ERNAM | ERNAM | Name of Person who Created the Object | |||
90 | ![]() |
![]() |
ERDAT | ERDAT | Date on which the record was created | |||
91 | ![]() |
![]() |
ERZET | ERZET | Entry time | |||
92 | ![]() |
![]() |
BWTAR | BWTAR_D | Valuation type | |||
93 | ![]() |
![]() |
LGORT | LGORT_D | Storage location | |||
94 | ![]() |
![]() |
STAFO | STAFO | Update group for statistics update | |||
95 | ![]() |
![]() |
WAVWR | WAVWR | Cost in document currency | |||
96 | ![]() |
![]() |
KZWI1 | KZWI1 | Subtotal 1 from pricing procedure for condition | |||
97 | ![]() |
![]() |
KZWI2 | KZWI2 | Subtotal 2 from pricing procedure for condition | |||
98 | ![]() |
![]() |
KZWI3 | KZWI3 | Subtotal 3 from pricing procedure for condition | |||
99 | ![]() |
![]() |
KZWI4 | KZWI4 | Subtotal 4 from pricing procedure for condition | |||
100 | ![]() |
![]() |
KZWI5 | KZWI5 | Subtotal 5 from pricing procedure for condition | |||
101 | ![]() |
![]() |
KZWI6 | KZWI6 | Subtotal 6 from pricing procedure for condition | |||
102 | ![]() |
![]() |
STCUR | STCUR_AP | Exchange rate for statistics (Exch.rate at time of creation) | |||
103 | ![]() |
![]() |
UVPRS | UVPRS | Incomplete with respect to pricing | |||
104 | ![]() |
![]() |
UVALL | UVALL | Generally incomplete | |||
105 | ![]() |
![]() |
EAN11 | EAN11 | International Article Number (EAN/UPC) | |||
106 | ![]() |
![]() |
PRCTR | PRCTR | Profit Center | |||
107 | ![]() |
![]() |
KVGR1 | KVGR1 | Customer group 1 | |||
108 | ![]() |
![]() |
KVGR2 | KVGR2 | Customer group 2 | |||
109 | ![]() |
![]() |
KVGR3 | KVGR3 | Customer group 3 | |||
110 | ![]() |
![]() |
KVGR4 | KVGR4 | Customer group 4 | |||
111 | ![]() |
![]() |
KVGR5 | KVGR5 | Customer group 5 | |||
112 | ![]() |
![]() |
MVGR1 | MVGR1 | Material group 1 | |||
113 | ![]() |
![]() |
MVGR2 | MVGR2 | Material group 2 | |||
114 | ![]() |
![]() |
MVGR3 | MVGR3 | Material group 3 | |||
115 | ![]() |
![]() |
MVGR4 | MVGR4 | Material group 4 | |||
116 | ![]() |
![]() |
MVGR5 | MVGR5 | Material group 5 | |||
117 | ![]() |
![]() |
MATWA | MATWA | Material entered | |||
118 | ![]() |
![]() |
BONBA | BONBA | Rebate basis 1 | |||
119 | ![]() |
![]() |
KOKRS | KOKRS | Controlling Area | |||
120 | ![]() |
![]() |
PAOBJNR | RKEOBJNR | Profitability Segment Number (CO-PA) | |||
121 | ![]() |
![]() |
PS_PSP_PNR | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | |||
122 | ![]() |
![]() |
AUFNR | AUFNR | Order Number | |||
123 | ![]() |
![]() |
TXJCD | TXJCD | Tax Jurisdiction | |||
124 | ![]() |
![]() |
CMPRE | CMPRE | Item credit price | |||
125 | ![]() |
![]() |
CMPNT | CMPNT | ID: Item with active credit function / relevant for credit | |||
126 | ![]() |
![]() |
CUOBJ | CUOBJ_VA | Configuration | |||
127 | ![]() |
![]() |
CUOBJ_CH | CUOBJ_CH | Internal object number of the batch classification | |||
128 | ![]() |
![]() |
KOUPD | KOUPD | Condition update | |||
129 | ![]() |
![]() |
UECHA | UECHA | Higher-Level Item of Batch Split Item | |||
130 | ![]() |
![]() |
XCHAR | XCHAR | Batch management indicator (internal) | |||
131 | ![]() |
![]() |
ABRVW | ABRVW | Usage Indicator | |||
132 | ![]() |
![]() |
SERNR | SERNR | BOM explosion number | |||
133 | ![]() |
![]() |
BZIRK_AUFT | BZIRK_AUFT | Sales district of sales order | |||
134 | ![]() |
![]() |
KDGRP_AUFT | KDGRP_AUFT | Customer group of sales order | |||
135 | ![]() |
![]() |
KONDA_AUFT | KONDA_AUFT | Price group of sales order | |||
136 | ![]() |
![]() |
LLAND_AUFT | LLAND_AUFT | Country of destination of sales order | |||
137 | ![]() |
![]() |
MPROK | MPROK | Status manual price change | |||
138 | ![]() |
![]() |
PLTYP_AUFT | PLTYP_AUFT | Price list type of sales order | |||
139 | ![]() |
![]() |
REGIO_AUFT | REGIO_AUFT | Region of sales order | |||
140 | ![]() |
![]() |
VKORG_AUFT | VKORG_AUFT | Sales organization of sales order | |||
141 | ![]() |
![]() |
VTWEG_AUFT | VTWEG_AUFT | Distribution channel of sales order | |||
142 | ![]() |
![]() |
ABRBG | ABRBG | Start of accounting settlement period | |||
143 | ![]() |
![]() |
PROSA | PROSA | ID for material selection - active | |||
144 | ![]() |
![]() |
UEPVW | UEPVW | ID for higher-level item usage | |||
145 | ![]() |
![]() |
AUTYP | VBTYP | SD document category | |||
146 | ![]() |
![]() |
STADAT | STADAT | Statistics date | |||
147 | ![]() |
![]() |
FPLNR | FPLNR | Billing plan number / invoicing plan number | |||
148 | ![]() |
![]() |
FPLTR | FPLTR | Item for billing plan/invoice plan/payment cards | |||
149 | ![]() |
![]() |
AKTNR | WAKTION | Promotion | |||
150 | ![]() |
![]() |
KNUMA_PI | KNUMA_PI | Promotion | |||
151 | ![]() |
![]() |
KNUMA_AG | KNUMA_AG | Sales deal | |||
152 | ![]() |
![]() |
PREFE | PREFE | Preference indicator in export/import | |||
153 | ![]() |
![]() |
MWSBP | MWSBP | Tax amount in document currency | |||
154 | ![]() |
![]() |
AUGRU_AUFT | AUGRU | Order reason (reason for the business transaction) | |||
155 | ![]() |
![]() |
FAREG | FAREG | Rule in billing plan/invoice plan | |||
156 | ![]() |
![]() |
UPMAT | UPMAT | Pricing reference material of main item | |||
157 | ![]() |
![]() |
UKONM | UKONM | Material pricing group of main item | |||
158 | ![]() |
![]() |
CMPRE_FLT | CMPRE_FLT | Item credit price | |||
159 | ![]() |
![]() |
ABFOR | ABSFORM_CM | Form of payment guarantee | |||
160 | ![]() |
![]() |
ABGES | ABGES_CM | Guaranteed (factor between 0 and 1) | |||
161 | ![]() |
![]() |
J_1ARFZ | J_1ARFZVAT | Reason for zero VAT | |||
162 | ![]() |
![]() |
J_1AREGIO | REGIO | Region (State, Province, County) | |||
163 | ![]() |
![]() |
J_1AGICD | J_1AGICD_D | Activity Code for Gross Income Tax | |||
164 | ![]() |
![]() |
J_1ADTYP | J_1ADTYP_D | Distribution Type for Employment Tax | |||
165 | ![]() |
![]() |
J_1ATXREL | J_1ATXREL_ | Tax relevant classification | |||
166 | ![]() |
![]() |
J_1BCFOP | J_1BCFOP | CFOP code and extension | |||
167 | ![]() |
![]() |
J_1BTAXLW1 | J_1BTAXLW1 | Tax law: ICMS | |||
168 | ![]() |
![]() |
J_1BTAXLW2 | J_1BTAXLW2 | Tax law: IPI | |||
169 | ![]() |
![]() |
J_1BTXSDC | J_1BTXSDC_ | SD tax code | |||
170 | ![]() |
![]() |
BRTWR | BRTWR_FP | Gross value of the billing item in document currency | |||
171 | ![]() |
![]() |
WKTNR | WKTNR | Value contract no. | |||
172 | ![]() |
![]() |
WKTPS | WKTPS | Value contract item | |||
173 | ![]() |
![]() |
RPLNR | RPLNR_AU | Payment card plan number of sales document | |||
174 | ![]() |
![]() |
KURSK_DAT | WWERT_D | Translation date | |||
175 | ![]() |
![]() |
WGRU1 | WGRU_HIE1 | Material group hierarchy 1 | |||
176 | ![]() |
![]() |
WGRU2 | WGRU_HIE2 | Material group hierarchy 2 | |||
177 | ![]() |
![]() |
KDKG1 | KDKG1 | Customer condition group 1 | |||
178 | ![]() |
![]() |
KDKG2 | KDKG2 | Customer condition group 2 | |||
179 | ![]() |
![]() |
KDKG3 | KDKG3 | Customer condition group 3 | |||
180 | ![]() |
![]() |
KDKG4 | KDKG4 | Customer condition group 4 | |||
181 | ![]() |
![]() |
KDKG5 | KDKG5 | Customer condition group 5 | |||
182 | ![]() |
![]() |
VKAUS | ABRVW | Usage Indicator | |||
183 | ![]() |
![]() |
J_1AINDXP | J_1AINDXP | Inflation Index | |||
184 | ![]() |
![]() |
J_1AIDATEP | J_1AIDATES | Indexing base date | |||
185 | ![]() |
![]() |
KZFME | KZFME | ID: Leading unit of measure for completing a transaction | |||
186 | ![]() |
![]() |
MWSKZ | MWSKZ | Tax on sales/purchases code | |||
187 | ![]() |
![]() |
VERTT | RANTYP | Contract Type | |||
188 | ![]() |
![]() |
VERTN | RANL | Contract Number | |||
189 | ![]() |
![]() |
SGTXT | SGTXT | Item Text | |||
190 | ![]() |
![]() |
DELCO | DELCO | Agreed delivery time | |||
191 | ![]() |
![]() |
BEMOT | BEMOT | Accounting Indicator | |||
192 | ![]() |
![]() |
RRREL | RR_RELTYP | Revenue recognition category | |||
193 | ![]() |
![]() |
AKKUR | AKKUR | Exchange rate for letter-of-credit procg in foreign trade | |||
194 | ![]() |
![]() |
WMINR | WMINR | Product catalog number | |||
195 | ![]() |
![]() |
VGBEL_EX | VGBEL | Document number of the reference document | |||
196 | ![]() |
![]() |
VGPOS_EX | VGPOS | Item number of the reference item | |||
197 | ![]() |
![]() |
LOGSYS | LOGSYS | Logical system | |||
198 | ![]() |
![]() |
VGTYP_EX | VGTYP_EX | Category of an external transaction or element | |||
199 | ![]() |
![]() |
J_1BTAXLW3 | J_1BTAXLW3 | Tax law: ISS | |||
200 | ![]() |
![]() |
J_1BTAXLW4 | J_1BTAXLW4 | COFINS Tax Law | |||
201 | ![]() |
![]() |
J_1BTAXLW5 | J_1BTAXLW5 | PIS Tax Law | |||
202 | ![]() |
![]() |
MSR_ID | MSR_PROCESS_ID | Process Identification Number | |||
203 | ![]() |
![]() |
MSR_REFUND_CODE | MSR_RETURNS_REFUND_CODE | Returns Refund Code | |||
204 | ![]() |
![]() |
MSR_RET_REASON | MSR_RETURNS_REASON | Return Reason | |||
205 | ![]() |
![]() |
NRAB_KNUMH | KNUMH | Condition record number | |||
206 | ![]() |
![]() |
NRAB_VALUE | KWERT | Condition Value | |||
207 | ![]() |
![]() |
DISPUTE_CASE | DISPUTE_CASE | Dispute Case | |||
208 | ![]() |
![]() |
FUND_USAGE_ITEM | FUND_USAGE_ITEM | Fund Usage Item | |||
209 | ![]() |
![]() |
CLAIMS_TAXATION | CLAIMS_TAXATION | Claims Taxation | |||
210 | ![]() |
![]() |
KURRF_DAT_ORIG | WWERT_D | Translation date | |||
211 | ![]() |
![]() |
VGTYP_EXT | TDD_VBTYP_EXT_V | Extension of SD document category of preceding document | |||
212 | ![]() |
![]() |
AUFPL | CO_AUFPL | Routing number of operations in the order | |||
213 | ![]() |
![]() |
APLZL | CIM_COUNT | Internal counter | |||
214 | ![]() |
![]() |
DPCNR | /SAPPCE/DPCNR | Down Payment Chain Number | |||
215 | ![]() |
![]() |
DCPNR | /SAPPCE/DPCPNR | Transaction Number | |||
216 | ![]() |
![]() |
DPNRB | /SAPPCE/DPCPNRB | Sequence Number of Accounting Document in Transaction | |||
217 | ![]() |
![]() |
PEROP_BEG | FM_PEROP_SD_LOW | Period of Performance Start Date | |||
218 | ![]() |
![]() |
PEROP_END | FM_PEROP_SD_HIGH | Period of Performance End Date | |||
219 | ![]() |
![]() |
FONDS | BP_GEBER | Fund | |||
220 | ![]() |
![]() |
FISTL | FISTL | Funds Center | |||
221 | ![]() |
![]() |
FKBER | FKBER | Functional Area | |||
222 | ![]() |
![]() |
GRANT_NBR | GM_GRANT_NBR | Grant | |||
223 | ![]() |
![]() |
PRS_WORK_PERIOD | PRS_WORK_PERIOD | Work Period (Internal Representation) | |||
224 | ![]() |
![]() |
PPRCTR | PPRCTR | Partner Profit Center | |||
225 | ![]() |
![]() |
PARGB | PARGB | Trading partner's business area | |||
226 | ![]() |
![]() |
AUFPL_OAA | CO_AUFPL | Routing number of operations in the order | |||
227 | ![]() |
![]() |
APLZL_OAA | CIM_COUNT | Internal counter | |||
228 | ![]() |
![]() |
CAMPAIGN | CGPL_GUID16_R3 | Generic project planning: GUID from external R/3 system | |||
229 | ![]() |
![]() |
COMPREAS | CMP_COMPREAS_COPY | Abbreviation for Complaints Reason | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |