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