| # Price retrieval Step 1. To retrieve prices from a contract When searching for prices, LN first checks whether a valid special contract and next a valid normal contract exists. You can define: Sales contract prices in the Sales Contract Lines (tdsls3501m000) session. Purchase contract prices in the Purchase Contract Price Revisions (tdpur3103m000) session. Step 2. To retrieve prices from a price book If LN cannot find a price in a special contract or a normal contract, LN tries to retrieve prices from a price book. LN uses a specific searching logic: Supplier price book with high priority LN first searches for a supplier price book as defined in the Supplier Price Book field of the Pricing Parameters (tdpcg0100m000) session, for combinations that have the High Priority check box selected in the Price Books (tdpcg0131m000) session. This search step is only applicable when retrieving purchase prices, not sales prices. Price book linked to a price matrix Next, LN searches for price books that are linked to valid price matrices, selected from the price matrices for which a matrix sequence is defined. LN looks for price matrices with a matrix definition and matrix attributes that match the properties of the relevant order. Note that all of the matrix attributes must match the properties of the order. When found, the price book of the price matrix, in which the matrix definition and the matrix attributes are stored, is used to calculate the price of the order. If more than one valid price matrix exists, price retrieval is controlled by the Price Control/ Price Control parameters in the Pricing Parameters (tdpcg0100m000) session. Default price book Finally, LN searches for: A default sales price book, as entered in the Default Service Price Book field of the Pricing Parameters (tdpcg0100m000) session to retrieve sales prices. A supplier price book, for combinations that have the High Priority check box cleared in the Price Books (tdpcg0131m000) session to retrieve purchase prices. Searching logic for retrieving prices from a price book entry in a price book Once a price book is found, the following factors (in the following sequence) determine the retrieval of prices from the correct price book entry in a price book: Business partners LN checks whether business partners are entered. This step only applies to supplier price books. LN checks whether: Both the buy-from business partner and the ship-from business partner are filled. Only the buy-from business partner is filled. The buy-from business partner, nor the ship-from business partner are filled. Currency LN checks the currency. LN checks whether: The order currency is used. The reference currency is used. Another currency is used. Unit LN checks the unit. LN checks whether: The quantity unit of the order line is used. The item's inventory unit is used. The item's price unit is used. Notes The item's price unit is retrieved from the Items - Purchase (tdipu0101m000), Items - Sales (tdisa0501m000), or Items - Service (tsmdm2100m000) sessions. If prices must be retrieved from a contract price book, or an RFQ price book, the price unit is not the item's price unit, but the price unit of the RFQ line, the sales contract line, or the purchase contract price revision.
Searching logic when a supplier price book is found
Searching logic | Buy-from BP | Ship-from BP | Currency | Unit
--- | --- | --- | --- | ---
1. | from order line | from order line | order currency | quantity unit of order line
2. | from order line | from order line | order currency | inventory unit
3. | from order line | from order line | order currency | price unit of item
4. | from order line | from order line | reference currency | quantity unit of order line
5. | from order line | from order line | reference currency | inventory unit
6. | from order line | from order line | reference currency | price unit of item
7. | from order line | from order line | each currency | quantity unit of order line
8. | from order line | from order line | each currency | inventory unit
9. | from order line | from order line | each currency | price unit of item
10. | from order line | empty | order currency | quantity unit of order line
11. | from order line | empty | order currency | inventory unit
12. | from order line | empty | order currency | price unit of item
13. | from order line | empty | reference currency | quantity unit of order line
14. | from order line | empty | reference currency | inventory unit
15. | from order line | empty | reference currency | price unit of item
16. | from order line | empty | each currency | quantity unit of order line
17. | from order line | empty | each currency | inventory unit
18. | from order line | empty | each currency | price unit of item
19. | empty | empty | order currency | quantity unit of order line
20. | empty | empty | order currency | inventory unit
21. | empty | empty | order currency | price unit of item
22. | empty | empty | reference currency | quantity unit of order line
23. | empty | empty | reference currency | inventory unit
24. | empty | empty | reference currency | price unit of item
25. | empty | empty | each currency | quantity unit of order line
26. | empty | empty | each currency | inventory unit
27. | empty | empty | each currency | price unit of item
Searching logic when a price book other than a supplier price book is found
Searching logic | Buy-from BP | Ship-from BP | Currency | Unit
--- | --- | --- | --- | ---
1. | empty | empty | order currency | quantity unit of order line
2. | empty | empty | order currency | inventory unit
3. | empty | empty | order currency | price unit of item
4. | empty | empty | reference currency | quantity unit of order line
5. | empty | empty | reference currency | inventory unit
6. | empty | empty | reference currency | price unit of item
7. | empty | empty | each currency | quantity unit of order line
8. | empty | empty | each currency | inventory unit
9. | empty | empty | each currency | price unit of item
Step 3. To retrieve prices from the item files If LN cannot find prices in price books, it searches for prices in the Items - Purchase (tdipu0101m000) session, or the Items - Sales (tdisa0501m000) session. Note If the Use Upgrade Prices check box is selected in the Unit Effectivity Parameters (tcuef0100s000) session and the order line contains an effectivity unit, upgrade prices, which are defined in the Unit Effectivity module of Common, are added to the price. You can always enter, or overwrite prices manually. As a result, the following origins can exist for prices: Item Purchase Data or Item Sales Data The price originates from the Item Purchase Data or Item Sales Data module. Supplier Price Book The price originates from the supplier price book, which is entered in the Supplier Price Book field of the Pricing Parameters (tdpcg0100m000) session. Default Price Book The price originates from the default sales price book, which is entered in the Default Sales Price Book field of the Pricing Parameters (tdpcg0100m000) session. Price Structure The price originates from a price book that is linked to a Pricing Control (PCG) matrix of the price matrix type. External The price originates from an external package. Manual The price is entered manually. Contract The price originates from a contract. Variant The price originates from the Product Configuration module. Related topics Sales contracts Purchase contracts To set up a supplier price book To set up a price matrix An outline of the pricing information retrieval processes To set up unit effectivity |