SAP ABAP View VBAP_VAPMA (Access to Item Info via 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 VBAP_VAPMA  
Short Description Access to Item Info via Material Index    
Root table VAPMA   Sales Index: Order Items by Material 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VAPMA VAPMA
2 VBAP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VBAP MANDT JL EQ 0 0
2 VAPMA MANDT JR EQ AND 0 0
3 VBAP VBELN JL EQ 0 0
4 VAPMA VBELN JR EQ AND 0 0
5 VBAP POSNR JL EQ 0 0
6 VAPMA POSNR JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 * VAPMA *    
2 MANDT VAPMA MANDT   MANDT Client
3 MATNR VAPMA MATNR   MATNR Material Number
4 VKORG VAPMA VKORG   VKORG Sales Organization
5 TRVOG VAPMA TRVOG   TRVOG Transaction group
6 AUDAT VAPMA AUDAT   AUDAT Document Date (Date Received/Sent)
7 VTWEG VAPMA VTWEG   VTWEG Distribution Channel
8 SPART VAPMA SPART   SPART Division
9 AUART VAPMA AUART   AUART Sales Document Type
10 KUNNR VAPMA KUNNR   KUNAG Sold-to party
11 VKBUR VAPMA VKBUR   VKBUR Sales office
12 VKGRP VAPMA VKGRP   VKGRP Sales group
13 BSTNK VAPMA BSTNK   BSTNK Customer purchase order number
14 ERNAM VAPMA ERNAM   ERNAM Name of Person who Created the Object
15 VBELN VAPMA VBELN   VBELN Sales and Distribution Document Number
16 POSNR VAPMA POSNR   POSNR Item number of the SD document
17 WERKS VAPMA WERKS   WERKS_D Plant
18 ADRNR VAPMA ADRNR   ADRNR_AG Address number of the sold-to party
19 DATAB VAPMA DATAB   DATAB_VI Quotation or contract valid from
20 DATBI VAPMA DATBI   DATBI_VI Quotation or contract valid to
21 * VBAP *    
22 - VBAP MANDT   MANDT Client
23 - VBAP VBELN   VBELN_VA Sales Document
24 - VBAP POSNR   POSNR_VA Sales Document Item
25 - VBAP MATNR   MATNR Material Number
26 MATWA VBAP MATWA   MATWA Material entered
27 PMATN VBAP PMATN   PMATN Pricing Reference Material
28 CHARG VBAP CHARG   CHARG_D Batch Number
29 MATKL VBAP MATKL   MATKL Material Group
30 ARKTX VBAP ARKTX   ARKTX Short text for sales order item
31 PSTYV VBAP PSTYV   PSTYV Sales document item category
32 POSAR VBAP POSAR   POSAR Item type
33 LFREL VBAP LFREL   LFREL_AP Item is relevant for delivery
34 FKREL VBAP FKREL   FKREL Relevant for Billing
35 UEPOS VBAP UEPOS   UEPOS Higher-level item in bill of material structures
36 GRPOS VBAP GRPOS   GRPOS Item for which this item is an alternative
37 ABGRU VBAP ABGRU   ABGRU_VA Reason for rejection of quotations and sales orders
38 PRODH VBAP PRODH   PRODH_D Product Hierarchy
39 ZWERT VBAP ZWERT   DZWERT Target value for outline agreement in document currency
40 ZMENG VBAP ZMENG   DZMENG Target quantity in sales units
41 ZIEME VBAP ZIEME   DZIEME Target quantity UoM
42 UMZIZ VBAP UMZIZ   UMZIZ Factor for converting sales units to base units (target qty)
43 UMZIN VBAP UMZIN   UMZIN Factor for converting sales units to base units (target qty)
44 MEINS VBAP MEINS   MEINS Base Unit of Measure
45 SMENG VBAP SMENG   SMENG Scale quantity in base unit of measure
46 ABLFZ VBAP ABLFZ   ABLFZ Rounding quantity for delivery
47 ABDAT VBAP ABDAT   ABDAT Reconciliation date for agreed cumulative quantity
48 ABSFZ VBAP ABSFZ   ABSFZ Allowed deviation in quantity (absolute)
49 POSEX VBAP POSEX   POSEX Item Number of the Underlying Purchase Order
50 KDMAT VBAP KDMAT   MATNR_KU Customer Material Number
51 KBVER VBAP KBVER   KBVER Allowed deviation in quantity (in percent)
52 KEVER VBAP KEVER   KEVER Days by which the quantity can be shifted
53 VKGRU VBAP VKGRU   VKGRU Repair processing: Classify items
54 VKAUS VBAP VKAUS   ABRVW Usage Indicator
55 GRKOR VBAP GRKOR   GRKOR Delivery group (items are delivered together)
56 FMENG VBAP FMENG   FMENG Quantity is fixed
57 UEBTK VBAP UEBTK   UEBTK_V Unlimited overdelivery allowed
58 UEBTO VBAP UEBTO   UEBTO Overdelivery Tolerance Limit
59 UNTTO VBAP UNTTO   UNTTO Underdelivery Tolerance Limit
60 FAKSP VBAP FAKSP   FAKSP_AP Billing block for item
61 ATPKZ VBAP ATPKZ   ATPKZ Replacement part
62 RKFKF VBAP RKFKF   RKFKF Form of Billing for CO/PPC Orders
63 - VBAP SPART   SPART Division
64 GSBER VBAP GSBER   GSBER Business Area
65 NETWR VBAP NETWR   NETWR_AP Net value of the order item in document currency
66 WAERK VBAP WAERK   WAERK SD document currency
67 ANTLF VBAP ANTLF   ANTLF Maximum number of partial deliveries allowed per item
68 KZTLF VBAP KZTLF   KZTLF Partial delivery at item level
69 CHSPL VBAP CHSPL   CHSPL Batch split allowed
70 KWMENG VBAP KWMENG   KWMENG Cumulative order quantity in sales units
71 LSMENG VBAP LSMENG   LSMENG Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
72 KBMENG VBAP KBMENG   KBMENG Cumulative confirmed quantity in sales unit
73 KLMENG VBAP KLMENG   KLMENG Cumulative Confirmed Quantity in Base Unit of Measure
74 VRKME VBAP VRKME   VRKME Sales unit
75 UMVKZ VBAP UMVKZ   UMVKZ Numerator (factor) for conversion of sales quantity into SKU
76 UMVKN VBAP UMVKN   UMVKN Denominator (divisor) for conversion of sales qty. into SKU
77 BRGEW VBAP BRGEW   BRGEW_AP Gross weight of item
78 NTGEW VBAP NTGEW   NTGEW_AP Net weight of item
79 GEWEI VBAP GEWEI   GEWEI Weight Unit
80 VOLUM VBAP VOLUM   VOLUM_AP Volume of the item
81 VOLEH VBAP VOLEH   VOLEH Volume unit
82 VBELV VBAP VBELV   VBELV Originating document
83 POSNV VBAP POSNV   POSNV Originating item
84 VGBEL VBAP VGBEL   VGBEL Document number of the reference document
85 VGPOS VBAP VGPOS   VGPOS Item number of the reference item
86 VOREF VBAP VOREF   VOREF Complete reference indicator
87 UPFLU VBAP UPFLU   UPFLV Update indicator for sales document document flow
88 ERLRE VBAP ERLRE   ERLRE Completion rule for quotation / contract
89 LPRIO VBAP LPRIO   LPRIO Delivery priority
90 - VBAP WERKS   WERKS_EXT Plant (Own or External)
91 LGORT VBAP LGORT   LGORT_D Storage location
92 VSTEL VBAP VSTEL   VSTEL Shipping Point/Receiving Point
93 ROUTE VBAP ROUTE   ROUTE Route
94 STKEY VBAP STKEY   STKEY Origin of the bill of material
95 STDAT VBAP STDAT   STDAT Date of Bill of Material
96 STLNR VBAP STLNR   STNUM Bill of Material
97 STPOS VBAP STPOS   STPOS_VBAP Bill of material item number VBAP not used
98 AWAHR VBAP AWAHR   AWAHR Order probability of the item
99 ERDAT VBAP ERDAT   ERDAT Date on which the record was created
100 - VBAP ERNAM   ERNAM Name of Person who Created the Object
101 ERZET VBAP ERZET   ERZET Entry time
102 TAXM1 VBAP TAXM1   TAXMT Tax classification material
103 TAXM2 VBAP TAXM2   TAXMT Tax classification material
104 TAXM3 VBAP TAXM3   TAXMT Tax classification material
105 TAXM4 VBAP TAXM4   TAXMT Tax classification material
106 TAXM5 VBAP TAXM5   TAXMT Tax classification material
107 TAXM6 VBAP TAXM6   TAXMT Tax classification material
108 TAXM7 VBAP TAXM7   TAXMT Tax classification material
109 TAXM8 VBAP TAXM8   TAXMT Tax classification material
110 TAXM9 VBAP TAXM9   TAXMT Tax classification material
111 VBEAF VBAP VBEAF   VBEAF Fixed shipping processing time in days (= setup time)
112 VBEAV VBAP VBEAV   VBEAV Variable shipping processing time in days
113 VGREF VBAP VGREF   VGREF Preceding document has resulted from reference
114 NETPR VBAP NETPR   NETPR Net price
115 KPEIN VBAP KPEIN   KPEIN Condition pricing unit
116 KMEIN VBAP KMEIN   KMEIN Condition Unit
117 SHKZG VBAP SHKZG   SHKZG_VA Returns Item
118 SKTOF VBAP SKTOF   SKTOF Cash discount indicator
119 MTVFP VBAP MTVFP   MTVFP Checking Group for Availability Check
120 SUMBD VBAP SUMBD   SUMBD Summing up of requirements
121 KONDM VBAP KONDM   KONDM Material Pricing Group
122 KTGRM VBAP KTGRM   KTGRM Account assignment group for this material
123 BONUS VBAP BONUS   BONUS Volume rebate group
124 PROVG VBAP PROVG   PROVG Commission group
125 EANNR VBAP EANNR   EANNR European Article Number (EAN) - obsolete!!!!!
126 PRSOK VBAP PRSOK   PRSOK Pricing is OK
127 BWTAR VBAP BWTAR   BWTAR_D Valuation type
128 BWTEX VBAP BWTEX   BWTEX Indicator: Separate valuation
129 XCHPF VBAP XCHPF   XCHPF Batch management requirement indicator
130 XCHAR VBAP XCHAR   XCHAR Batch management indicator (internal)
131 LFMNG VBAP LFMNG   MINLF Minimum delivery quantity in delivery note processing
132 STAFO VBAP STAFO   STAFO Update group for statistics update
133 WAVWR VBAP WAVWR   WAVWR Cost in document currency
134 KZWI1 VBAP KZWI1   KZWI1 Subtotal 1 from pricing procedure for condition
135 KZWI2 VBAP KZWI2   KZWI2 Subtotal 2 from pricing procedure for condition
136 KZWI3 VBAP KZWI3   KZWI3 Subtotal 3 from pricing procedure for condition
137 KZWI4 VBAP KZWI4   KZWI4 Subtotal 4 from pricing procedure for condition
138 KZWI5 VBAP KZWI5   KZWI5 Subtotal 5 from pricing procedure for condition
139 KZWI6 VBAP KZWI6   KZWI6 Subtotal 6 from pricing procedure for condition
140 STCUR VBAP STCUR   STCUR_AP Exchange rate for statistics (Exch.rate at time of creation)
141 AEDAT VBAP AEDAT   AEDAT Last Changed On
142 EAN11 VBAP EAN11   EAN11 International Article Number (EAN/UPC)
143 FIXMG VBAP FIXMG   FIXMG Delivery date and quantity fixed
144 PRCTR VBAP PRCTR   PRCTR Profit Center
145 MVGR1 VBAP MVGR1   MVGR1 Material group 1
146 MVGR2 VBAP MVGR2   MVGR2 Material group 2
147 MVGR3 VBAP MVGR3   MVGR3 Material group 3
148 MVGR4 VBAP MVGR4   MVGR4 Material group 4
149 MVGR5 VBAP MVGR5   MVGR5 Material group 5
150 KMPMG VBAP KMPMG   KMPMG Component Quantity
151 SUGRD VBAP SUGRD   SUGRD Reason for material substitution
152 SOBKZ VBAP SOBKZ   SOBKZ Special Stock Indicator
153 VPZUO VBAP VPZUO   VPZUO Allocation Indicator
154 PAOBJNR VBAP PAOBJNR   RKEOBJNR Profitability Segment Number (CO-PA)
155 PS_PSP_PNR VBAP PS_PSP_PNR   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
156 AUFNR VBAP AUFNR   AUFNR Order Number
157 VPMAT VBAP VPMAT   VPMAT Planning material
158 VPWRK VBAP VPWRK   VPWRK Planning plant
159 PRBME VBAP PRBME   PRBME Base unit of measure for product group
160 UMREF VBAP UMREF   UMREFF Conversion factor: quantities
161 KNTTP VBAP KNTTP   KNTTP Account assignment category
162 KZVBR VBAP KZVBR   KZVBR Consumption posting
163 SERNR VBAP SERNR   SERNR BOM explosion number
164 OBJNR VBAP OBJNR   OBJPO Object number at item level
165 ABGRS VBAP ABGRS   ABGR_SCHL Results Analysis Key
166 BEDAE VBAP BEDAE   BEDAE Requirements type
167 CMPRE VBAP CMPRE   CMPRE Item credit price
168 CMTFG VBAP CMTFG   CMTFG ID for partial release of order item, credit block
169 CMPNT VBAP CMPNT   CMPNT ID: Item with active credit function / relevant for credit
170 CMKUA VBAP CMKUA   CMKUA Credit data exchange rate for requested delivery date
171 CUOBJ VBAP CUOBJ   CUOBJ_VA Configuration
172 CUOBJ_CH VBAP CUOBJ_CH   CUOBJ_CH Internal object number of the batch classification
173 CEPOK VBAP CEPOK   CEPOK Status expected price
174 KOUPD VBAP KOUPD   KOUPD Condition update
175 SERAIL VBAP SERAIL   SERAIL Serial Number Profile
176 ANZSN VBAP ANZSN   ANZSN Number of serial numbers
177 NACHL VBAP NACHL   NACHL Customer has not posted goods receipt
178 MAGRV VBAP MAGRV   MAGRV Material Group: Packaging Materials
179 MPROK VBAP MPROK   MPROK Status manual price change
180 VGTYP VBAP VGTYP   VBTYP_V Document category of preceding SD document
181 PROSA VBAP PROSA   PROSA ID for material selection - active
182 UEPVW VBAP UEPVW   UEPVW ID for higher-level item usage
183 KALNR VBAP KALNR   CK_KALNR Cost Estimate Number for Cost Est. w/o Qty Structure
184 KLVAR VBAP KLVAR   CK_KLVAR Costing Variant
185 SPOSN VBAP SPOSN   SPOSN BOM Item Number
186 KOWRR VBAP KOWRR   KOWRR Statistical values
187 STADAT VBAP STADAT   STADAT Statistics date
188 EXART VBAP EXART   EXART Business Transaction Type for Foreign Trade
189 PREFE VBAP PREFE   PREFE Preference indicator in export/import
190 KNUMH VBAP KNUMH   KNUMH_CH Number of condition record from batch determination
191 CLINT VBAP CLINT   CLINT Internal Class Number
192 CHMVS VBAP CHMVS   CHMVS Batches: Exit to quantity proposal
193 STLTY VBAP STLTY   STLTY BOM Category
194 STLKN VBAP STLKN   STLKN BOM Item Node Number
195 STPOZ VBAP STPOZ   CIM_COUNT Internal counter
196 STMAN VBAP STMAN   CUINK Inconsistent configuration
197 ZSCHL_K VBAP ZSCHL_K   AUFZSCHL Overhead key
198 KALSM_K VBAP KALSM_K   AUFKALSM Costing Sheet
199 KALVAR VBAP KALVAR   CK_KLVAR Costing Variant
200 KOSCH VBAP KOSCH   KOSCH Product allocation determination procedure
201 UPMAT VBAP UPMAT   UPMAT Pricing reference material of main item
202 UKONM VBAP UKONM   UKONM Material pricing group of main item
203 MFRGR VBAP MFRGR   MFRGR Material freight group
204 PLAVO VBAP PLAVO   PLAVO Planning Release Regulation
205 KANNR VBAP KANNR   KANNR KANBAN/sequence number
206 CMPRE_FLT VBAP CMPRE_FLT   CMPRE_FLT Item credit price
207 ABFOR VBAP ABFOR   ABSFORM_CM Form of payment guarantee
208 ABGES VBAP ABGES   ABGES_CM Guaranteed (factor between 0 and 1)
209 J_1BCFOP VBAP J_1BCFOP   J_1BCFOP CFOP code and extension
210 J_1BTAXLW1 VBAP J_1BTAXLW1   J_1BTAXLW1 Tax law: ICMS
211 J_1BTAXLW2 VBAP J_1BTAXLW2   J_1BTAXLW2 Tax law: IPI
212 J_1BTXSDC VBAP J_1BTXSDC   J_1BTXSDC_ SD tax code
213 WKTNR VBAP WKTNR   WKTNR Value contract no.
214 WKTPS VBAP WKTPS   WKTPS Value contract item
215 SKOPF VBAP SKOPF   W_SORTK Assortment Module
216 KZBWS VBAP KZBWS   KZBWS Valuation of Special Stock
217 WGRU1 VBAP WGRU1   WGRU_HIE1 Material group hierarchy 1
218 WGRU2 VBAP WGRU2   WGRU_HIE2 Material group hierarchy 2
219 KNUMA_PI VBAP KNUMA_PI   KNUMA_PI Promotion
220 KNUMA_AG VBAP KNUMA_AG   KNUMA_AG Sales deal
221 KZFME VBAP KZFME   KZFME ID: Leading unit of measure for completing a transaction
222 LSTANR VBAP LSTANR   LSTANR Free goods delivery control
223 TECHS VBAP TECHS   TECHS Parameter Variant/Standard Variant
224 MWSBP VBAP MWSBP   MWSBP Tax amount in document currency
225 BERID VBAP BERID   BERID MRP Area
226 PCTRF VBAP PCTRF   PCTRF Profit Center for Billing
227 LOGSYS_EXT VBAP LOGSYS_EXT   LOGSYS Logical system
228 J_1BTAXLW3 VBAP J_1BTAXLW3   J_1BTAXLW3 Tax law: ISS
229 J_1BTAXLW4 VBAP J_1BTAXLW4   J_1BTAXLW4 COFINS Tax Law
230 J_1BTAXLW5 VBAP J_1BTAXLW5   J_1BTAXLW5 PIS Tax Law
231 STOCKLOC VBAP STOCKLOC   STOCKLOC First Inventory-Managing Location
232 SLOCTYPE VBAP SLOCTYPE   SLOCTYPE Type of First Inventory-Managing Location
233 MSR_RET_REASON VBAP MSR_RET_REASON   MSR_RETURNS_REASON Return Reason
234 MSR_REFUND_CODE VBAP MSR_REFUND_CODE   MSR_RETURNS_REFUND_CODE Returns Refund Code
235 MSR_APPROV_BLOCK VBAP MSR_APPROV_BLOCK   MSR_APPROVAL_BLOCK Approval Block
236 NRAB_KNUMH VBAP NRAB_KNUMH   KNUMH Condition record number
237 TRMRISK_RELEVANT VBAP TRMRISK_RELEVANT   SLS_TRM_RISK_RELEVANCY Risk Relevancy in Sales
238 HANDOVERLOC VBAP HANDOVERLOC   HANDOVER_LOC Location for a physical handover of goods
239 HANDOVERDATE VBAP HANDOVERDATE   HANDOVER_DATE Handover Date at the Handover Location
240 HANDOVERTIME VBAP HANDOVERTIME   HANDOVER_TIME Handover time at the handover location
241 TC_AUT_DET VBAP TC_AUT_DET   J_1BTC_AUT_DET Tax Code Automatically Determined
242 MANUAL_TC_REASON VBAP MANUAL_TC_REASON   J_1BMANUAL_TC_REASON Manual Tax Code Reason
243 FISCAL_INCENTIVE VBAP FISCAL_INCENTIVE   J_1BFISCAL_INCENTIVE_CODE Tax Incentive Type
244 TAX_SUBJECT_ST VBAP TAX_SUBJECT_ST   J_1BTC_TAX_SUBJECT_ST Tax Subject to Substituição Tributária
245 FISCAL_INCENTIVE_ID VBAP FISCAL_INCENTIVE_ID   J_1BFISCAL_INCENTIVE_ID_SD Incentive ID
246 SPCSTO VBAP SPCSTO   J_1BSPCSTO_SD Nota Fiscal Special Case for CFOP Determination
247 /BEV1/SRFUND VBAP /BEV1/SRFUND   /BEV1/SRBEFUND Analysis/Reason for Rejection
248 AUFPL_OLC VBAP AUFPL_OLC   CO_AUFPL Routing number of operations in the order
249 APLZL_OLC VBAP APLZL_OLC   CIM_COUNT Internal counter
250 FERC_IND VBAP FERC_IND   FE_IND Regulatory indicator
251 KOSTL VBAP KOSTL   KOSTL Cost Center
252 FONDS VBAP FONDS   BP_GEBER Fund
253 FISTL VBAP FISTL   FISTL Funds Center
254 FKBER VBAP FKBER   FKBER Functional Area
255 GRANT_NBR VBAP GRANT_NBR   GM_GRANT_NBR Grant
256 IUID_RELEVANT VBAP IUID_RELEVANT   IUID_RELEVANT_CUST IUID Relevant for Customer
257 PRS_OBJNR VBAP PRS_OBJNR   PRS_OBJNR Engagement mgmt: Object number
258 PRS_SD_SPSNR VBAP PRS_SD_SPSNR   PRS_SD_SPSNR Standard WBS Element for Project Inception via SD
259 PRS_WORK_PERIOD VBAP PRS_WORK_PERIOD   PRS_WORK_PERIOD Work Period (Internal Representation)
260 PARGB VBAP PARGB   PARGB Trading partner's business area
261 AUFPL_OAA VBAP AUFPL_OAA   CO_AUFPL Routing number of operations in the order
262 APLZL_OAA VBAP APLZL_OAA   CIM_COUNT Internal counter
263 - VBAP AUDAT    
                 
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  20140121 
SAP Release Created in