Business Scenario:

Retail clients heavily rely on the selling price of articles as a key factor in their business success. Various elements, including article cost, profit margins, and market conditions, influence the final selling price, therefore accurate calculation of the selling price considering all the key factors is crucial for maintaining competitiveness, ensuring profitability, and meeting customer expectations.

Problem Statement:

The purchase price is a crucial factor in determining the final selling price, but it often fluctuates due to varying supplier agreements and market conditions. Keeping track of these frequent changes and promptly adjusting the sales price accordingly can be challenging. Ensuring that final selling price reflects the latest purchase costs requires a systematic approach which can automatically consider such changes to accurately calculate new selling price and remain competitive in the market.

Solution:

If the purchase price or the parameters for source determination changes, it is advisable to check the existing sales prices with respect to the new margin and perform a new sales price calculation. The pricing worklist is used to perform new calculations for certain articles and the relevant organizational levels, this is only possible if their sales price calculation(s) is (are) affected by pricing-relevant changes. This is flagged by a change pointer or a document index.

Pricing Worklist is a functionality used to manage and streamline the pricing process by tracking and processing price changes efficiently. It helps retailers maintain up-to-date sales prices by capturing changes triggered by factors such as purchase price fluctuations and automatically determining all previous calculations affected by the changes. This enables you to perform new sales price calculations considering all the changes.

Pre-requisite, Configuration and Step by Step process to use Pricing worklist for Sales Price Calculation in S/4HANA

Sales prices are generally calculated on the basis of the purchase price, which is in turn calculated using the purchase price calculation schema on the basis of condition types affecting pricing (the basic purchase price, vendor discount, for example). Other pricing-relevant parameters including the regular vendor  indicator in the purchase info record and the source of supply indicator in the article master data are evaluated in supply source determination.

If you want to use the pricing worklist function, you must make sure that when you save a sales price a pricing document is created with a document index. This setting is made under Pricing type.

• Pricing documents with adjustments for changes in conditions:

  This document index determines only those calculations affected by a change in purchase price.

• Pricing documents with adjustments for changes in conditions and master data:

  With this document index, calculations that are affected by changes to the source of supply parameters are entered, in addition to those affected by changes in purchase prices.

The entries in tables S111 and WIND are controlled using filters. These filters are Customizing table.

Prerequisite: 

The prerequisite for creating change pointers for the pricing worklist is that there’s an initial pricing document (table WKBP) in the system for a new article, because the last pricing document is used to determine the calculation settings (e.g. purchase- and sales price determination sequence) when the articles are re-calculated using the pricing worklist function.

Configuration:

1. First, you activate the direct entry for creating the worklist for document category 10 (Pricing: Pricing worklist). IMG: → Logistics General → Retail Pricing → Pricing Worklist → Direct Entry for Creating Worklist → Activation of the Direct Entry for Creating the Worklist

(You can also use Program: RMEBEMIG to set direct entry indicator for Pricing)

2. Then, table T6I2A determines the scope of changes for direct entry into the worklist: IMG: → Logistics General → Retail Pricing → Pricing Worklist → Direct Entry for Creating Worklist → Define the Scope of Change for Direct Entry in Worklist.

3. Table T6I1 contains the condition types and corresponding condition tables that are to be checked for changes: IMG: → Logistics General → Retail Pricing → Pricing Worklist → Control Automatic Document Adjustment → Control Pricing Document Adjustment for External / Internal Procurement.

So this means that the system creates the entries for condition-related changes, which are relevant for the pricing worklist, in the WIND — Document Index: Conditions for Automatic Document Adjustment table.

The pricing worklist is used to create a list of newly performed calculations in the form of pricing documents. This includes all calculations affected by the changes and their validity periods. A comparison is made between the entries in table S111 and those in table WIND via field VARKEY.

Procedure:

1. Create a buffer of data out of the changed parameters (known simply as a “worklist”) which forms the basis for generating the pricing worklist.

You do not have to perform this Customizing activity if you have made the settings for the direct entries in the worklist for condition changes in Retail Pricing (document category 10) under Logistics – General  Retail Basic Data Activation of the Direct Entry for Creating the Worklist.

2. Generate the pricing worklist from the worklist of price calculations you wish to update. (T-code: WVN0)

3. When a change is made to the master data concerned in the pricing worklist function (regular vendor indicator and vendor subrange in the info record, source of supply indicator in the article master), you no longer have to perform IMG activities 1 and 2. This is because when the master data change is saved, the pricing that is affected by this is determined at the same time and the appropriate entries are created in the pricing worklist.

4. Process the pricing worklist for specific articles and organizational units. (T-code: WVN1/WVN2)

5. The new prices that are calculated are stored, as before, in pricing documents. You can change the results by setting certain parameters, such as the article markup rate, the margin, the sales price or the final price.

6. Save new sales prices that you are happy with and delete any price calculations that you do not want.