10-10-2007 4:29 PM
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?
10-11-2007 5:53 PM
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.