on 10-24-2014 11:05 AM
Dear All
i am creating a z report where i want to display total order recieved for a single material for a particular 1 month. From which table can i fetch the data. pleasae find below the structure of the report
material Code | Material description | Pack Size | Total Order's Received | Quantities Desp. | Sales value | Inventory (opening Stock) | Inventory (Closing Stock) |
Thanks & Regards
Vincent
vincent,
will material code be an input parameter is the selection screen?
all the values in the report can be extracted from VBAK and VBAP. But do not understand last two fields - inventory (opening stock) and inventory (closing stock)
tw
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes material will be an input parameter.
can you please elloborate how can i extract the data from VBAK and VBAP. for example if a material no.1700013 has been created in 10 sales order in a single month, so i want the cummalative of the total sales order of a single material for e.g, every order has a 5 quantity for the material 1700013 so the total will be 50 .
But do not understand last two fields - inventory (opening stock) and inventory (closing stock)
opening stock of the month for the material ( quantity avaliable for sale) - sales = quantity left after sales for the month ( closing stock)
vincent,
if you want a report for a time duration (e.g. a month), then creation date From and To should also be given in the selection screen.
What sales document types are relevant for business? this has to be given, so that relevant sales orders can be selected (and not all sales orders)
VBAK-AUART*
*different processes - would you include return process too, along with normal sales in this report
By giving below in selection screen:
Date From To
Material
You get all the sales orders, with that particular material
Summation of all rows,
VBAP-KWMENG is Quantity
VBAP-NETWR is Net price
VBAP-MWSBP is tax
Total is Net price + tax
another important point is currency, if all documents are created with the same currency, then it is fine. Or else you have to take this in to consideration.
VBAP-ARKTX is Material description
tw
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.