cancel
Showing results for 
Search instead for 
Did you mean: 

Alternative calculation type and alterantive condition base value in pricin

Former Member
0 Kudos

Hi SAP EXPERTS,

Request to explain in detailed about the alternative calculation type and alterantive condition base value in pricing procedure..

Thanks in Advance

Kumar

SD Application Consultant

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

<b>AltCty - Condition formula for alternative calculation type:</b>

• It is again a Routine that is written by ABAP Consultant.

• It is an alternative formula for the condition type that can be used instead of standard formulas.

• For example, let us take the Profit Margin which can be both + / - , so here this routine will help us in generating the value which can be either + or -. Profit margin is not a condition type so it cannot be classified as +ve or -ve in the V/06.

• Ex.: 950 0 Profit Margin 11.

• So we assign 11 - Profit Margin.

• If new routines are to be defined we follow the procedure given below.

o Go to T.Code: VOFM. - Maintain Requirements & Formulas

o Click on the "Formulas" and then on the "Condition Values".

o We have a list of routines, we can ask ABAP consultant to create new routines based on the client requests.

o And we assign the application type.

<b>AltCBV - Alternative formula for condition base value:</b>• Formula for determining the condition basis as an alternative to the standard.

• It is again a Routine that is written by ABAP Consultant.

• It is used as a basis to calculate value of the condition type instead of using it from the "FROM" column.

• Ex.: Freight - KF00.

• Freight is calculated based on weight, volume etc. and not on the base price. In pricing there is no entry of weight from which the value can be referred like we do for discounts using base price. We have to get the value from the Material master.

• In this column we can mention the value as 12 - Gross Weight or 13 - Net Weight.

• During pricing, the system will consider the value that is mentioned in this column and determine the freight based on this value.

• Suppose we have Net weight: 100 kgs and Gross Weight: 150 kgs. And if we mention 13 in this column then the Freight condition KF00 will be calculated using the weight as 100 kgs.

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Manupati

Generally if one wants to calculate a value, we have to use a calculation type for determinating the value. This calculation type is either addition, subtraction or multiplication. Similarly SAP also has got a default calculation type in the control data of the condition type. There one has the options of either Qty based, Fixed Amount Based or Percentage based.

Suppose if we define our condition type that calculates the base price of a material on Qty based. Then the calculation will be done based on the quantity of the material. If the customer orders 10 Nos and we have maintained a unit price of $100 for each material then the value determined is $1000. Similarly if the discount condition type is maintain as calculation type as %. This means if we maintain the value of 10% in the condition record. Then this percentage is taken as the calculation type and the condition value is determined.

Now, in some cases one has to bypass the default calculation types and use the customer specific method for calculating a value.

Example: Calculating the Freight charges for a Material . It depends on so many criteria like, the weight, volume and also the minimum amount etc, in these cases, we bypass/forego the default value and then use the alternative calculation type in calculating the condition value against the particular condition.

Reward if useful to u

Former Member
0 Kudos

hi,

alternative calculation type :

if u want the system to calculate the condition value apart from a standard calculation type then we write a routine specifying the customised calculation type .

alternative base value :

if u want to calculate the condition value based on the customised base value apart from determined in the condition record then we use the alternate base value.

reward points

sriram.

former_member227476
Active Contributor
0 Kudos

dear kumar

Alternative formula for condition type:

We can specify the alternative formula instead of standard one as a condition type in the form of routines Ex: routine no: 11 -- profit margin can be used as an alternative formula for condition type to calculate profit margin. As there is no standard condition type to calculate profit margin.

Alternative formula for condition base value:

Instead of using from column as a basis to calculate further value for particular condition type. We can use a formula in the form of routine to use base. Ex: routine no: 12 or 13 (gross weight or net weight) can be used with the condition type “KF00” to calculate freight charges. As for freight charges always weight of the material taken as a base.

rewards if it helps

siva

Former Member
0 Kudos

HI

The alternate base value is used as the calculation basis only, while the alternate calculation is used to modify the final value.

For example, imagine you have a condition type ZZ01, with a condition record maintained (master data) for $100. Now, condition ZZ02 also exists lower in the schema, but with a rate of 10%. The standard calculation would result in a final value of $110.

The alternate base value could say, "don't use $100 as the basis -- use the original price PR00 only, which was $90." Then, the final value would be $100 + (10% of $90) = $109.

The alternate calculation routine says, "ignore the 10% altogether. Instead, use an externally calculated 20%." Then, you end up with a final value of $100 + (20% of $100) = $120.

Put them both together, and you could end up with $100 + (20% of $90) = $118.

Now once again,

Alternative Calculation Type:

Normally if you want to calculate a value you have to use a calculation type for determinating the value. This calculation type is either addition, subtraction or multiplication. Similarly SAP also has got a default calculation type in the control data of the condition type. There you have the options of either Qty based , Fixed Amount Based or Percentage based.

Here what happens is suppose if you define Your condition type that calculates the base price of a material on Qty based. Then the calculation will be done based on the quantity of the material. If the customer orders 10 Nos and you have maintained a unit price of 100 Rs for each material then the value determined is 1000 INR. Similarly if the discount condition type , you maintain the calculation type as %. This means if you maintain the value of 10 % in the condition record. Then this percentage is taken as the calculation type and the condition value is determined.

In some cases you have to forego the default calculation types and use the customer specific method for calculating a value. For ex if you are calculating the Freight charges for a Material . it depends on so many criteria like, the weight, volume and also the minimum amount etc etc, in those cases, you forego the default value and then use the alternative calculation type in calculating the condition value against the particular condition.

Alternative Condition Base value :

If you have to calculate any value then you have to have a base value for it. For ex if you want to calculate the discount of 10 % for a material then you have to have a base value on which this 10% is calculated. Normally you take the condition value of the base price of the material to calculate the value.

Now you don't want to take the base value and take other values as base value which are derived on some formulae. So you create a routine which will do the mathematical operations in the routine and derive you a value which is now used as the base value for calculating the condition value for a particular condition type.

Former Member

Hi Shesagiri,

Thanks a lot for explaining indetail.

Thanks and regards

kumar