Breadcrumbs

Preparing Data (Price Setting)

This is a list of required and optional data for the Price Setting Accelerator. It helps you identify what data you need from the customer to set up and configure the accelerator.

You can start with requirements for Core (Product Data) and at least the required data for one pricing strategy.

Type

Data

Fields

Mandatory for Use Case

Master Data

Products

  • SKU

  • Field(s) to be used as Lookup Key

Core

Technically, the key could be SKU, but this would probably make no sense – you could completely “skip” the lookup key concept by defining SKU as the only Lookup Key Dimension and configure everything with the “*” value.

Product Cost

  • SKU

  • Cost

  • Pricing Level Identifier (e.g. Country)

Optional:

  • Validity Period

  • Currency

Pricing Strategy: Cost+

Cost and Margin Module

Advanced Cost Definition

Per Advanced Cost type:

  • The same as Product Cost

  • Optionally, you can use SUM, AVG when you want to use multiple cost entries and combine them into one

Advanced Cost Module

Discount Structure

Discount Groups and Discount Values

Net Price Module

Exchange Rates

Currency and Conversion Rates

Dependent pricing in different currencies

Competition Data

  • SKU

  • Competition Price

Optional:

  • Competitor Name

  • Validity Dates

  • Currency

  • Relevant Competition Definition

Product Competition Module

Price List Data

  • SKU

  • Pricing Level (Country, Global, Channel, …)

Initial Prices

All checks and KPI regarding price increase

Pricing Strategy: Price Increase

Stock Data

  • SKU

  • Pricing Level Identifier (e.g. Country)

  • Stock

Optional:

  • Validity Dates

KPI Days of Cover (DoC)

DoC related Pricing Strategies

Stock Module

Product References

  • SKU

  • Reference SKU

Pricing Strategies: Anchor Pricing, Attribute Based Pricing

BoM (Kit List)

  • SKU

  • Sub-Component SKU

  • Quantity

Pricing Strategy: Kit Pricing

Business Data

Plus for Product

  • Lookup Key

  • Plus %

Pricing Strategy: Cost+

Price Increase

  • Lookup Key

  • Price Increase

Pricing Strategy: Price Increase

Pricing relevant Attributes

  • Attributes in P/PX

  • Value Impacts of Pricing Attributes

Pricing Strategy: Attribute Based

Pricing Level Adjustment

  • Pricing Level

  • Adjustment %

Dependent Pricing of Parent (e.g. Global Reference Price List → Country Price List)

Sales Forecast

  • SKU

  • Sales Volume

  • Forecast Date

  • Pricing Level Identifier (e.g. Country)

Optional:

  • Currency

Lookup Based Forecast (optionally, you can use Lookup Based or Transaction Based Forecast)

Transaction Module

Transaction Data

Sales Data (Transactions)

  • SKU

  • Sales Volume

  • Sales Turnover (Sold Price)

  • Transaction Date

  • Pricing Level Identifier (e.g. Country)

Optional:

  • Currency (you need filled CCY DM when using CCY)

All KPI regarding “Sales History”

  • Historical Sales/Turnover

  • Forecast based on historical data

Transaction Module