pricing

[Former Member]

Hello sap prof,

Can u plz tell me the definitions of the following.

1. What is condition Update.

2. what is condition Index.

3. what is meant by alt calc type and alt cond base value

[Former Member · Accepted solution]

<b>Condition Index:</b>

It can be created for particular condition type to maintain condition records.

When checked this specifies whether the system updates one or more condition indices when maintaining condition records.

This makes it possible to list or maintain condition records independently of condition type and condition table

<b>Condition Update:</b>

Together with condition index, this field when checked allows to restrict the usage of the condition type for limited sales orders or for particular condition value.

<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.

Go to T.Code: VOFM. – Maintain Requirements & Formulas

Click on the “Formulas” and then on the “Condition Values”.

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

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.

Regards

AK

Reward points if helpful

[anilkumar_suri]

Hi ,

I have a small issue comming . When creating a sales dael and i do put scales intially the scales are set at from scale , I press F6 and change the *Scale Type to "B" *it gets saved .This is fine.

But when i want to copy the same by selecting the Copying Condition a tab near to Select Rule at the bottom , the system does not Copy the scale Type to "B" it takes as "A".

If there is any solution Please Provide the settings.

Regards

Anil

[Former Member]

Hi,

<b>CONDITION INDEX</b>

You specify which fields of the condition records are taken into account when creating the index. The selected fields are displayed as selection criteria in the application menu for selecting condition records. In addition to the possibility of searching for condition records using the condition type (for example, prices, surcharges, discounts) and the organizational data, you can define and use other selection criteria using the condition index.

Example:

The standard system contains two indexes with which all condition records can be selected for a certain material (index 001) or a certain customer (index 002) independently of the condition type,

<b>Actions if you create and use your own indexes</b>

1. You can create a condition index either by copying an existing index and changing it afterwards or by carrying out the following steps.

2. Check whether the list of allowed fields meets your requirements. If you need new fields, you can include them in the field catalog for the condition index.

3. Create a condition index by entering a table between 501 and 999 and choosing the required fields from the list of the allowed fields.

The selected fields can have a maximum length of 100 characters.

Define the sequence of the fields so that the first field in the index is the field that is most frequently searched for. In addition, SAP recommends that you include the sales organization and the distribution channel.

Generate the condition index. Indexes created by you are activated automatically.

4. In the field "Condition index" on the detail screen of the respective condition type, select the condition types to be taken into account for the condition index.

<b>CONDITION UPDATE</b>

Controls whether limit values are relevant for pricing.

E.g.: you can make the use of a particular condition record in the document dependent on a specified total value.

This total value can be specified in the condition record.

In VK11, when you maintain a condition record, select the line item, in the menu bar select go to – additional data. Here you can limit the cumulated value of the condition type and you restrict the value up to a definite number of sales orders.

<b>ALTERNATIVE CALCULATION TYPE</b>

Alternative formula to the formula in the standard system that determines a condition. For this you specify a routine which is defined in VOFM transaction code. Standard routines are available and with the help of the Abaper new routines can also be developed.

<b>ALTERNATIVE CONDITION BASE VALUE</b>

Formula for determining the condition basis as an alternative to the standard.

Example

An absolute header discount is, for example, distributed in the standard system according to the cumulative value of the items.

If the system, however, distributes the absolute header discount according to volume, a header discount of $30 results in the following discounts:

Item Value Volume Discount

Stand. disc. Volume disc.

1 $1000 2 cbm $20 $10

2 $500 4 cbm $10 $20

Reward points if solution helps.

Regards,

Allabaqsh G. Patil

[Former Member]

hi,

1. <b>Condition Index</b>

You can create and use condition indices. You can use these indices to display, change and create condition records with reference. This transaction can include condition records with several condition types and tables. For example, you can use a condition index if you want to see all condition records that apply to a particular product regardless of whether the records are prices or discounts. In this case, you can use one of the standard condition indexes. Or you may want to see a list of condition records that contain a particular sales deal and a material from a user-specified list of products. To display this information, you can create your own condition index.

2. <b>Condition Update</b>

Special offers and discounts to customers are frequently offered as part of a sales promotion based on accumulated sales order data. For example, when your customers place orders for a new product, you may offer them an introductory allowance up to a specified total value (for example, up to USD 5,000). As a customer places orders for the new product, the system must be able to keep track of the cumulative discount total. With Release 2.1, it was possible to accumulate values based on invoices for the purpose of processing rebate agreements. In Release 2.2 this idea was extended to include a new, more general condition update function.

Controlling Condition Update

Condition update is controlled by the condition type in setting Customizing for Sales. If you set the condition update for a particular condition type, the system subsequently updates the corresponding condition records whenever you process relevant sales and billing documents.

Pricing Function Support

Condition update provides the basis for the following pricing functions:

Maximum Value

Maximum quantity

Maximum Number of Sales Orders

source : Library

3) <a href="http://www.sap-img.com/sap-sd/what-is-alt-cal-type-alt-base-value-and-requirement-field-in-pricing.htm">Alt cal type, Alt cond base value</a>

Also regarding this, I have given different examples many a times in this forum. You can search forum on this and sure you will get more ideas.

Thanks

Sadhu Kishore

[Former Member]

Hi

3.

Alternative Calculation Type:

Normally if you want to calculate a value you have to use a calculation type for determination 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 formula. 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
2.

Condition Index

You can create and use condition indices. You can use these indices to display, change and create condition records with reference. This transaction can include condition records with several condition types and tables. For example, you can use a condition index if you want to see all condition records that apply to a particular product regardless of whether the records are prices or discounts. In this case, you can use one of the standard condition indexes. Or you may want to see a list of condition records that contain a particular sales deal and a material from a user-specified list of products. To display this information, you can create your own condition index.

Creating an Index

Creating a condition index is similar to creating a condition table. In Customizing for Sales, you select the combination of fields that you want in the index key. The system automatically proposes a list of permitted fields to choose from. The fields you specify for the key can have a maximum combined length of 100 characters. Further information on creating an index can be found in the IMG (Implementation Guide).

Reorganizing an Index

Reorganization means updating an index with current data. The following are examples of when this might be required.

After you create a new index and generate it, you want to fill the index with the current data in your system. (This also applies if you choose to activate one of the standard condition indexes).
After you specify that condition indexes should be updated for a particular condition type, you want to fill the indexes with the corresponding condition records that already exist.


Please note that since the system has to read all the relevant condition records, reorganization is automatically submitted as a background task.

Activating an Index

The activation function displays a list of all available condition indexes and indicates which are active. The system can use a condition index only when it is activated. Before you can use the indexes that are delivered in the standard version, you must first activate them in Customizing for Sales. Some indices are activated automatically during generation. In addition, you must specify one of the following index updating requirements for each condition index:

Requirement 1: The index is updated when the user provides data for all fields in the index
Requirement 2: The index is updated when the user provides data for at least the first index field
Controlling Index Update by Condition Type

You can specify for each condition type whether or not the system updates the condition indexes when you post condition records. In cases where updating condition indexes may not be necessary - for example, with freight- and tax-related condition records - you can leave the condition index indicator blank.

Selecting Condition Records Using an Index

After you have defined a condition index and the system has updated it with current data, you can use it to search condition records.

Procedure

To select condition records using an index:

Choose Logistics ® Sales and Distribution ® Master Data from the main menu.
Choose Conditions ® Select using index and specify whether you want to change or display condition records.
A dialog box displays the condition indexes that are currently available.

Select the condition index you want to use and choose ENTER.
You reach the screen where you enter selection criteria.

Enter your selection criteria and choose Execute.
The system displays a list of the condition records by condition type for the selection criteria you entered.
1.

Condition Update

Special offers and discounts to customers are frequently offered as part of a sales promotion based on accumulated sales order data. For example, when your customers place orders for a new product, you may offer them an introductory allowance up to a specified total value (for example, up to USD 5,000). As a customer places orders for the new product, the system must be able to keep track of the cumulative discount total. With Release 2.1, it was possible to accumulate values based on invoices for the purpose of processing rebate agreements. In Release 2.2 this idea was extended to include a new, more general condition update function.

Controlling Condition Update

Condition update is controlled by the condition type in setting Customizing for Sales. If you set the condition update for a particular condition type, the system subsequently updates the corresponding condition records whenever you process relevant sales and billing documents.

Pricing Function Support

Condition update provides the basis for the following pricing functions:

• Maximum Value

• Maximum quantity

• Maximum Number of Sales Orders

https://www.sdn.sap.com/irj/sdn/forums