topic Re: quantity order in Application Development and Automation Discussions

quantity order

Former Member — Fri, 02 Jun 2006 05:43:08 GMT

hi,

how to find out the quantity ordered for a particular customer on material wise.

Re: quantity order

Former Member — Fri, 02 Jun 2006 05:46:23 GMT

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

Re: quantity order

Former Member — Fri, 02 Jun 2006 05:46:53 GMT

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

Re: quantity order

Former Member — Fri, 02 Jun 2006 05:50:32 GMT

go to transaction ...

MCGL and check for field f1 for field discription....

Re: quantity order

Former Member — Fri, 02 Jun 2006 06:03:17 GMT

hi ravi,

can u explain a little more what r the fields and conditions on joins

Re: quantity order

Former Member — Fri, 02 Jun 2006 06:05:43 GMT

Kiran

SELECT VBAK_{KUNNR VBAP}MATNR VBAP~KWMENG

INTO CORRESPONDING FIELDS OF TABLE T_DATA

FROM VBAK INNER JOIN VBAP ON VBAK_{VBELN = VBAP}VBELN.

Regards,

Ravi

Re: quantity order

Former Member — Fri, 02 Jun 2006 06:20:54 GMT

hi ravi,

but i want if the customer is ordered more than 1 material but i want the material wise quantity...

Re: quantity order

Former Member — Fri, 02 Jun 2006 06:23:56 GMT

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

Re: quantity order

Former Member — Fri, 02 Jun 2006 06:30:54 GMT

hi ravi,

my actual requirement is----

Interactive report which displays all the sales orders for one particular customer, the materials ordered, quantity ordered

Re: quantity order

Former Member — Fri, 02 Jun 2006 06:34:53 GMT

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.

Regards,

Ravi

Note :Please mark all the helpful answers

Re: quantity order

Former Member — Fri, 02 Jun 2006 06:45:21 GMT

hi ravi thank u very much,

how to get the goods issue date of that particular order and contact information about that particular customer

Re: quantity order

Former Member — Fri, 02 Jun 2006 07:45:07 GMT

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