Monthly Sales Quantity of a material plant wise

[Former Member]

Hi Gurus,

     I am developing a report in SD area. Which displays material monthly sales quantity and Yearly Sales Quantity. On the selection screen i am providing Material No, Plant, Date Range and material group1. I want to know from which table i can get monthly and yearly sales quantity of a material. To which field of a table i have to pass date and get these values. Please provide ur valuable suggestions.

Advance Thanks,

ABAPER

[Lakshmipathi]

from which table i can get monthly and yearly sales quantity of a material

Whether it is a monthly data or yearly data, if you want to see any sales related data, you have to consider

a)  VBRK  for header related data and

b)  VBRP  for item related data

For your requirement, you can consider VBRP which should suffice.

G. Lakshmipathi

[Former Member]

Hi,

can you provide some more information like there may be some orders where you do not have delivery created. which quantity you want to consider whether order quantity or confirm quantity or delivered quantity? so please give me some more information.

if you want to consider the order quantity than take field KWMENG and table VBAP. For date you can take the delivery date into account. for delivery date field name is ETDAT which is delivery date and table name is VBEP which is schedule line data.

If you want to consider the delivered quantity then take the field VSMNG which is delivered quantity and table name is WVBEP/VBEPD (Structure)/VBEP (table)

below is the link may be useful for you.

http://help.sap.com/saphelp_sm32/helpdata/en/21/ca6d07d5b807459ec8957dad97c179/content.htm

Rajiv Rana

[Shiva_Ram]

Check the t.code MC+E and the underlying program RMCV0100. In one of the includes you can find the list of tables used in this t.code. You can make use of these tables for developing the report.

Regards,