In PDW Price Export Maintenance, you can create override maps in order to map Product Data Warehouse (PDW) pricing elements to existing price lines, price sheets, and discount classes.
Create price override maps by entering an actual price line and sheet from your pricing files on the PDW Price Export Maintenance screen. You can then map the PDW price elements to defined basis names within the price line and sheet.
On an override map, you can also define any pricing zones that may exist for the PDW pricing element.
To create an export price override map:
From the Tools > Product Data Warehouse (PDW) > PDW Export Maintenance menu, select PDW Price Export Maintenance to display the PDW Price Export Maintenance screen.
In the Line field, enter the price line you want to use for the override map.
The system displays a list of all price sheets and discount classes for the price line.
Select a price sheet to use for the override map.
Note: Sheets with asterisks (*) next to them already have override maps defined for them. You can edit these maps.
The system enters the Price Sheet and Discount Class in their fields. A tilde (~) represents the default price sheet or discount class for the price line.
In the Basis Names column, if the system did not populate it with all needed basis names for the current price sheet, press F10 and select a name to enter.
In the Calc Bas* field, for each basis name enter a calculation base.
Use the Formula field to enter a pricing formula to apply to the calculation basis.
The Calculation Basis and Formula fields modify the pricing element value, as needed. These calculation formulas work much like translate statements for data elements. For example, double the list cost when you export it into your Eclipse product file. Enter a formula that tells the system to multiply the pricing element value by 2.
In the R column, enter the number of places to round the number.
In the Pr column, enter a priority of 50 or higher for the system to use the override map instead of the default map.
In the Meta Item column, enter the metadata pricing element that you want to map to the basis.
Note: In the Zone/Sht column, the system enters ******** because pricing zones are not associated with the default map. You can enter pricing zones on override maps.
In the Zone/Sht field, if the metadata item has multiple price sheets for multiple branches, enter the pricing zone for it.
The system enters ******** if the metadata element does not have pricing zones associated with it.
Use the Expand hot key to expand the entry in the Zone/Sht column if it does not fit in the allotted space.
The PDW Eff Date displays in the lower right corner. This date indicates the effective date for the values shown in the Meta Value column.
See Also: