topic Cumulative Order Quantity in Application Development and Automation Discussions

Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 13:24:42 GMT

Hi,

Please help me to understand 'Cumulative Order Quantity' and 'Cumulative Confirmed Quantity'.

In the conditions table KONV, the pricing details are maintained. Is this maintained for the order quantity or confirmed quantity?

How is the cumulative order quantity updated and is there any relvence to rejection reason.

Thanks.

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 13:55:56 GMT

Hi Niranchan,

In the conditions table KONV, the pricing details are maintained,

This is maintained for both order quantity and confirmed quantity.

Regards,

Akash Rana

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 14:01:06 GMT

Hi Akash,

Please let me know how can we differentiate between order quantity and confirmed quantity in KONV in case if its maintained for both the values.

Thanks.

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 14:03:11 GMT

Check the value of knumv.

Regards ,

Akash

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 14:04:28 GMT

are you doing asking for RFQ and PO cases.

Regards,

Akash Rana

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 14:15:36 GMT

Hi Akash,

There had been a requirement to calculate the quantity of an item in a sales order. Grouping of sales order based on either 'order quantity' or 'confirmed quantity'. This can be ascertained from the fields KWMENG / KBMENG respectively.

Now, the requirement is to group orders based on value. The value is now calulated based on conditions table field KWERT for the respective KNUMV of VBAP and POSNR of VBAP.

KONV table -

KNUMV = vbak-knumv

KPOSN = vbap-posnr

KWERT = value (this is calculated based on any conditions upon the requirement)

On what basis do i differentiate the ordered Q and confirmed Q for value calculation?

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 14:50:48 GMT

Dear friend now its the complete question,

Solution for this is,

For each SALES order go KONV with Knumv and posnr take kwert ,

this KWERT will be the total price of Odered Quantity.

price of confirmed QTY Has to be calculates as follows----->>>


calculate  price of 1 QTY by kwert / KWMENG.
and now u have the price of 1 QTY.
now calculate price of Confirmed quantities as- KBMENG * Price of 1 QTY.

After this u can easily differentiate between them.

Hope this solves ur issue.

Regards,

Akash Rana

Edited by: AKASH RANA on Aug 15, 2009 4:51 PM

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 14:59:08 GMT

Thanks a lot Akash. I also had thought of the same solution.

Please confirm this before i close this thread.

Is there no other way to differentiate it apart from the way mentioned?

Thanks.

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 15:02:50 GMT

No my dear friend there is no other way , i believe this is the best solution.

Regards,

Akash Rana

Re: Cumulative Order Quantity

Former Member — Sat, 15 Aug 2009 15:04:48 GMT

Thanks a lot Akash.