Cumulative Order Quantity

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Check the value of knumv.

Regards ,

Akash

[Former Member]

are you doing asking for RFQ and PO cases.

Regards,

Akash Rana

[Former Member]

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?

[Former Member]

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

[Former Member]

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.

[Former Member]

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

Regards,

Akash Rana

[Former Member]

Thanks a lot Akash.