Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Fastest way to calculate total sales per material?

Former Member
0 Kudos

I'm creating a report where I need the total sum of sales per material.

Is the fastest & most efficient / only way to do this by querying VBAP? We're talking about millions of lines.

I guess I'm hoping that there is a FM already in place or that some sort of summary table exists.

Any ideas?

1 REPLY 1

Jelena
Active Contributor
0 Kudos

There is no FM. In the program you should be able to use table VAPMA, which has the same data as VBAP but the primary key is MATNR.

Depending on the requirements, it might be beneficial to create an info structure (LIS) to track summarized sales. Your SD consultant should be able to do that, there is no programming required.

Hope this helps.