on 04-11-2012 1:51 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.