List Fields of the Pricing Table (SAP Library

List Fields of the Pricing Table

Use

The columns in the pricing table are also known as list fields. The list group and list variant define which list fields are displayed.

You can modify the price calculation by changing the values in the fields that are ready for input.

For further information, see Pricing Table.

Features

Particular characteristics are defined for every list field. These characteristics are: output length, principle ready for input status, list field type and indicator for resetting the ready for input status for pricing articles or fixed price articles. To display the characteristics for the list fields, choose System ® Services ® Table maintenance ® Extended table maintenance and enter the view name V_TWLF in the Table/view field. Price fields, percentage fields and list fields without amounts are differentiated using the list field type. Price fields are also differentiated according to the currency in which they are displayed. For further information, see Currencies.

You can maintain descriptions for the list fields under Texts for List Fields in Customizing for Pricing. These are then displayed as column headings in the pricing table.

Determining field contents

The majority of the list fields have predefined meanings for the business environment. There are, however, also list fields for which the meaning is defined by Customizing settings.

The master data fields and certain conditions are among those fields that have a fixed meaning. These are determined by the program using the appropriate master records and condition records. These include, for example:

Vendor with vendor sub-range and vendor currency
Purchasing organization
Local currency
Planned markup
Current final price with associated validity period

The contents of certain list fields are calculated by the program. These include:

Basic purchase price and purchase price (net/net)

These prices are taken from the purchase price calculation schema and may be converted to a different sales unit and sales price unit (see Pricing Table).

Final prices

The final price is calculated from the sales price (gross) by rounding to a predefined price point.

Margin (net/gross)

The margin is calculated from the sales price (net, gross) and the purchase price (net/net). The retail margin is calculated in a similar way using the retail price and the final price.

You can define the data transfer between the sales price calculation schema and the list fields for the user-definable list fields under Control Data for the Pricing Table and Data Backup in Customizing for Pricing. Some list fields also have a predefined meaning here. These include:

Actual markup
Sales price (net/gross)

You can define the following list fields as you wish:

"Reduced from" price (ROTPR)
Cash price (MITPR)
Suggested price (VORPR)
Variable sales price (VKPO1, for example)
Variable percentage fields (PROZ1, for example)

For more information, see Using the Condition Technique in Calculations and Price Determination.

Storing field contents

You can store the values of the price and percentage fields in the system.

You can define the storage of values for each list field in the master conditions. You do this under Control Data for the Pricing Table and Data Backup in Customizing for Pricing.

Condition type with application

You can define the condition type to which the value of a list field is to be stored. You can store values to main condition types or to supplementary conditions. In the case of supplementary condition types, the related main condition type has to be stored at the same time. Permitted applications are M (Purchasing) and V (Sales).

Default currency indicator

You can use the default currency indicator to determine the currency that is to be used for the price fields when the condition record is stored.

Condition tables

For main condition types, you enter the condition table to which the prices for the different pricing levels (site, distribution chain, price list or site price list) are to be stored.

When defining the storing of the Basic purchase price list field, there are two differences to storing the sales list fields that you should note:

Different purchase price calculation schemas can be used in determining purchase prices, depending on which vendor is found or which purchasing organization is responsible. This means that there may also be different condition types for the basic purchase price. This is taken into account by the Condition type determination type indicator, for which there are two possible settings. One setting allows you to enter a condition type from the control data for storing the data, as you can with the other list fields. The other setting allows the condition type to be determined dynamically from the relevant purchase price calculation schema.

As well as an amount, each price also has a currency, a unit of measure and a price unit (see Pricing Table and Currencies.) Different currencies and units of measure are generally significant for the basic purchase price. The condition record determination type takes this into account. The values for the pricing table (vendor currency, current sales unit and sales price unit) can be used for the condition record, as they are for other list fields. On the other hand, the settings for price determination (order price currency, purchase order price unit and order price unit) can also be used. You can display and if necessary, change these settings in the Purchasing detail screen of the pricing table.

To activate the prices for retail promotions, you must make settings for the promotion condition types in Customizing under Control Data for the Pricing Table and Data Backup in the same way as you maintain the settings for condition types for standard sales prices. Control data for the basic purchase price is mandatory.

In sales price calculations, condition record storage is determined via the indicator for storing purchasing and sales condition records. If the indicator is set for purchasing, condition records are created for all the main condition types maintained for application M, and their related supplementary conditions. The same applies for the sales indicator and the main condition types for application V.