Creating a Lookup Table

Objective

After completing this lesson, you will be able to create lookup tables to manage and organize price-related information.

Creating Lookup Tables

Our current step in the process takes us to Unit 6: Creating lookup tables in SAP Price Calculation.

In the previous unit, Lisa defined a set of price calculation fields in SAP Price Calculation’s Manage Field Catalog app. Her next step is to create a lookup table in the Manage Lookup Tables app. Lookup tables store price-related master data that can be easily referenced to determine prices.

Before creating a lookup table, Lisa will explain to Bob why lookup tables help organize pricing information and make the entire price calculation process more efficient.

SAP Price Calculation Overview

A lookup table contains relevant price information that is quickly accessed by the system to simplify the price calculation process. These tables contain data for products, rate elements, discounts, markets, individual customers, and more, and are used in various combinations to calculate prices.

A lookup table contains pricing information that does not often change. The constancy of pricing information helps prevent the need to repeatedly input new data and minimize mistakes. Lookup tables streamline complex pricing scenarios and enable flexible, accurate pricing to meet individual customer needs and marketing strategies.

When a price needs to be determined, the system refers to these lookup tables to retrieve the correct pricing factors or values. The result is a single price value.

In SAP Price Calculation, the table format is defined separately within a spreadsheet. The spreadsheet is subsequently uploaded to the system when you create a new table instance based on an existing table format.

Let’s create a new table format using the Manage Lookup Tables app.

Select the video below to create a lookup table for SAP Price Calculation!

Summary

Now that Lisa has defined the format for lookup tables using the Manage Lookup Tables app, her next step is to create table instances based on our new table formats and enter the proper table data using the Manage Lookup Table Data app.

Create Lookup Tables in SAP Price Calculation

Exercise Objective:

After completing this exercise, you will be able to create lookup tables in SAP Price Calculation where you can store your product’s prices.

Business Scenario

After a bit of thinking, you have decided to use SAP Price Calculation for the determination of your product’s charges. This will allow you more flexibility in the future for quick adaptations of your products price calculation logic. As the first step, you need to define the format of the tables that will contain your products prices. 

Task 1:

Create a new Lookup Table called, BR468_##_LT_PRT_PRC. Replace ## with your group number. Prices should be calculated based on the market the product is sold, the product and the rate element. In this table, we want to store the pricing information for the usage-based fees (standard and premium print).

Steps

Log on to SAP Price Calculation.
Select the tile, Manage Lookup Tables. 
Select the Create button on the top right corner. A new window opens. 
For the code, enter BR468_##_LT_PRT_PRC. Replace ## with your group number.
For the description, enter Prices for the printing service of group ##. Replace ## with your group number. 
In the section, Lookup Table Inputs, select the Create button. A new empty line is created. 
In the new line, select the field marktId. 
Create more lines and add the fields productCode and rateElement. 
In the section, Lookup Table Outputs, add the field, Price, to the list. 
Select Create on the bottom right.

Task 1: Create a New Lookup Table

Task 2:

Create a new Lookup Table called, BR468_##_LT_REC_PRC. Replace ## with your group number. Prices should be calculated based on the market the product is sold, the product, the rate element and the field Refurbished. In this table, we want to store pricing information for the recurring fees.

Steps

Log on to SAP Price Calculation.
Select the tile, Manage Lookup Tables. 
Select the Create button on the top right corner. A new window opens. 
For the code, enter BR468_##_LT_REC_PRC. Replace ## with your group number.
For the description, enter Prices for recurring fees of the printing service of group ##. Replace ## with your group number. 
In the section, Lookup Table Inputs, select the Create button. A new empty line is created. 
In the new line, select the field marktId. 
Also add the fields productCode, rateElement, and Refurbished to the list. 
In the section, Lookup Table Outputs, add the field, Price, to the list. 
Select Create on the bottom right.

Continue to quiz