Table VAPMA - Sales Index: Order Items by Material

[Former Member]

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]

VAPMA can be used if you do not know the order number, but know the material number, or any other field on the index.

[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.