Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table VAPMA - Sales Index: Order Items by Material

Hi , Can we always use table VAPMA instead of a join on VBAK and VBAP.

Does this table contain all the sales order items? When I did a "Number of entries" for table vbap and vapma, there is a slight difference in numbers.

How is this table updated?

Former Member

Your sales orders can contain line items that have materials in them and/or line items that have text or service items in them. VAPMA stores only the line items with material in them. VBAP stores all the sales order line items. So if you have a material number and you want to know all the sales orders that have this material, then VAPMA is good, but if you don't know the material number and/or you want all the line items of a sales order, then VBAP is the best place.

So, in short, VAPMA and VBAP can have different number of records but VBAP should always have more than VAPMA.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question