Collective billing in VF01 to have pricing based on weighted average price

[Former Member]

Hi All,

Brief about process :

We have a process where we do billing via VF01 for multiple deliveries. Each delivery is always having 1 material.Suppose i have created 4 deliveries for customer - X for material - ABC with different qty. Now i go to VF01 and enter ONLY 2 deliveries and here i want that the prices should be redetermined and it should be the weighted average price. For ex 1st delivery for material ABC has 25EA @ 230/EA and 2nd delivery for material ABC has 40EA @200/EA. So in this case price should be redetermined as 25*230 + 40*200/65 = 211.54.

Can someone please advise how i can achieve this .

Thanks in advance.

[Former Member]

hI vimlesh,

    Price re- determine or not is purely depending on copy control settings so first you decide whether you do order related billing or delivery related billing .

Sap standard are in order related billing ( billing type F1) prices are re- determined by selecting pricing type "C" in item level copy control VTFA.  and delivery related billing (billing type F2) prices are un changed but taxes are re- determined by selecting pricing type "G" in item level copy control VTFA.

So maintain relevant price type in copy control based on your business requirements.

Please find the attached screen shots for clarification .

If you want any further clarification , please let me know.

Regards,

Patchala.

[Former Member]

Hi Patchala,

Thanks for the answer but i think you did not get my requirement properly. My requirement is that i do billing of multiple deliveries at once in VF01 and there i want my price to be redetermined based on weighted average price of both deliveries, which i suppose cannot be achieved with copy control as it controls pricing for specific material for specific deliveries.

Kindly revisit my requirement.

Thanks,

Vimlesh

[Former Member]

hi patachala sir

really it is very helpful

[Former Member]

Hi Vimlesh,

Sorry i did`t go through your requirement properly, and i think standard sap will not salve your requirement .

I just try to explain my view below.

• create one condition type zk55  ( no access sequence, condition class : discount/sur charge , calculation type : quantity )
• Place the ZK55 just before Gross price with requirement 23 , so it will only activated in billing document .
• Discuss with your ABAPER and create one calculation routine, the logic here is  first take the gross price than divided by quantity so the individual gross price per quantity will come, than calculated total line item net value (per piece net value * line item quantity) .
• Next check with the line item gross value and different amount calculated in ZK55 with positive or negative value.
• So system will calculate the total gross value per line item after adding condition type ZK55.

In Order:

line item 1  25 * 330 = 5750

             line item 2  40* 200 = 8000

                                            -----------

                                            13750

In Billing:

For 1 st line item

Calculation Routine will calculate value

(  1) 13750/ 65 = 211.5384

     2) 211.5384 * 25 = 5288.46

     3) 5288.46 - 5750( line item gross value) = - 461.54)

In pricing procedure zk55 condition is active with -461.55 value , where we assign ZK55 before Gross value so -461.54 will be deducted from 5750 = 5288.46

This value is same as 25 EA * 211.5384 ( ave price ) = 5288.46

For 2 nd line item

ZK55 = + 461.536

SO 8000(2 nd line item gross price ) + 461.536 = 8461.536

This value is same as 40 EA * 211.5384 = 8461.536.

If you want any further clarification , please let me know.

Regards,

Patchala.