cancel
Showing results for 
Search instead for 
Did you mean: 

Condition calculated based on the percentage of the quantity of the item

stedmuc
Participant
0 Kudos

Greetings and Happy 2015 to all

I would like your help in the following case ... need to create a condition Zxxx in percentage and in the calculation scheme is calculated on the basis of the quantity of the item, ie the value of the condition is calculated based on the percentage of the quantity of the item.

The other case that would greatly your help is as follows:

having the following variables

- NV = Net value = 3000 USD

- Qty = quantity of the item

- UN = unit price

- Zxxx = Condition Zxxx

- % = 4.27%

How could apply in calculation scheme of the price for Zxxx through the following formula Zxxx = (NV / UN) * %

Any Help Please.

Accepted Solutions (1)

Accepted Solutions (1)

jobis
Contributor
0 Kudos

Hi Stelio,

For this calculation you can use the 'Alt Condtion Base Value' routine in your pricing procedure.

Create a new routine with the logic for the required calculation.  assign that routine to your condition type Zxxx.


The logic can be NV/Un

Discuss with your ABAPer.

Is 'the net value' include the taxes and surcharges?

Are you maintaining the percentage in a condition record?

Thanks

Jobi

stedmuc
Participant
0 Kudos

Hi Jobi


Thank you for your quick help, answering your questions,

- The "net value '' does not include any taxes or surcharges.

- Yes the percentage,it is kept in a condition record for Zxxx.


There is no other alternative to equate this requirement ??

hugs

jobis
Contributor
0 Kudos

So Can we presume that the net value is nothing but the basic price (price per unit) * no. of units in the document (order quantity)..?

If so NV/Un is  your basic price (price per unit).. Is it that way..?

Reg

Jobi

Former Member
0 Kudos

Hi Stelio,

I'm not sure I fully understand what you're trying to achieve with your condition.

Based on your formula and answers above my wild guess is that

you try to do percentage rate based on item quantity. We don't have detailed requirements so I can't say if both of the following approaches are relevant;

  1. Condition record for Zxxx using scales, e.g. 1PC = 4,27%, from 2PC = 8,54% etc. (define Quntity as scale basis in condition type Zxxx)
  2. Alternative formula as described by Jobi above. However, in case you have larger quantities, can the percentage actually exceed 100%? Does it make sense? (for example Zxxx =  300/3 * 4,27 => Zxxx = 427%)

Hope this helps.

Cheers,

Tomas

stedmuc
Participant
0 Kudos

Hi Jobi

Yes the net value equals basic price * number of unity .... and say basic price is the same as saying unity price (depending on the terminology).

Thanks

stedmuc
Participant
0 Kudos

Hi Tomas

What I am trying to say is the following:

PR00 = quanty * basic price

           = 20 * 120

           = 2400

and

ZXXX = Quanty * 4,27 %

          = 20* 4,27%

          = 0,854

The total order value will be 2400 + 0.854 (PR00 + ZXXX)

jobis
Contributor
0 Kudos

Hi Stelio,

So in that case, NV/Un is nothing but the quantity of material.

Just being curious here,  Why do you have such a condition ?  Its very odd, and whats the purpose of such a pricing element?

I think only, a new pricing routine as suggested earlier will work for you. I dont think you can maintain a percentage value for a condition type when its calc type is 'C" - quantity

Jobi

Former Member
0 Kudos

Hi Stelio,

thanks for the clarification.

Quantity based scale for a percentage condition type is out of the question, I think that a routine as proposed by Jobi should work for you. It is a very unusual requirement though.

Regards,
Tomas

stedmuc
Participant
0 Kudos

Many thanks to both of you for your attention. I'm talking to the ABAP to create a routine as suggested by Jobi and associate the condition in the scheme of calculation.

Jobi this requirement came from a client because they have a rate that is calculated in this way.

Regards

Stélio

Answers (0)