06-02-2006 6:43 AM
hi,
how to find out the quantity ordered for a particular customer on material wise.
06-02-2006 6:46 AM
Kiran,
Execute a join between VBAK and VBAP.
VBAK will have the customer data and VBAP will have the Material and Qty data.
Regards,
Ravi
06-02-2006 6:46 AM
Kiran,
Execute a join between VBAK and VBAP.
VBAK will have the customer data and VBAP will have the Material and Qty data.
Regards,
Ravi
06-02-2006 7:03 AM
hi ravi,
can u explain a little more what r the fields and conditions on joins
06-02-2006 7:05 AM
Kiran
SELECT VBAKKUNNR VBAPMATNR VBAP~KWMENG
INTO CORRESPONDING FIELDS OF TABLE T_DATA
FROM VBAK INNER JOIN VBAP ON VBAKVBELN = VBAPVBELN.
Regards,
Ravi
06-02-2006 7:20 AM
hi ravi,
but i want if the customer is ordered more than 1 material but i want the material wise quantity...
06-02-2006 7:23 AM
Kiran,
In that case you will have to select the order number as well and process the data by looping at the internal table figure out how you want to seggregate the data.
Regards,
Ravi
Note :Please mark the helpful anwers
06-02-2006 7:30 AM
hi ravi,
my actual requirement is----
Interactive report which displays all the sales orders for one particular customer, the materials ordered, quantity ordered
06-02-2006 7:34 AM
Kiran,
SELECT VBELN KUNNR FROM VBAK.
SELECT VBELN MATNR KWMENG FROM VBAP FOR ALL ENTRIES OF T_VBAK WHERE VBELN - T_VBAK-VBELN.
LOOP T_VBAK.
LOOP AT T_VBAP WHERE VBELN = VBAK-VBELN.
Now calculate the total for the same material and dump into a third table.
ENDLOOP.
ENDLOOP.
Regards,
Ravi
Note :Please mark all the helpful answers
06-02-2006 7:45 AM
hi ravi thank u very much,
how to get the goods issue date of that particular order and contact information about that particular customer
06-02-2006 8:45 AM
Kiran,
You can look at VBFA table for gettingthe subsquent documents of a Sales order using VBELN.
Contact information, you should be able to get from KNA1 (Customer Master) using KUNNR as the key and also you can look at KNVK table for Contact partners information.
Please mark all the helpful answers
regards,
Ravi
06-02-2006 6:46 AM
Kiran,
Are you talking about the Sales Order line time level table(<b>VBAP</b>) wherein you will get quantity of each line item.
Cheers,
Thomas
06-02-2006 6:50 AM
go to transaction ...
MCGL and check for field f1 for field discription....