| # Price Book Lines (tdpcg0131m000) Use this session to view, enter, and maintain price book lines. You can also enter and maintain price books if this session is started from the following sessions: Sales Contract Lines (tdsls3501m000) Sales Contract Price Revisions (tdsls3103m000) Purchase Contract Price Revisions (tdpur3103m000) Buy-from BP - Quotation (tdpur1506m000) If this session is started from the Sales Contract Lines (tdsls3501m000), Sales Contract Price Revisions (tdsls3103m000), or Purchase Contract Price Revisions (tdpur3103m000) session, you cannot delete price book lines if the contract status is Active. You can delete price book lines only if the contract status is Free or Terminated. This session appears as a tab in the Price Books - Lines (tdpcg0611m000) session. Related topics Setting up a price book Setting up a supplier price book Matrix structure An outline of the pricing information retrieval processes Additional costs - overview Price Book An entity in which you can store price information that is valid for a given period of time. A price book includes the following elements: A price book header, which contains the code, type, and use of the price book. One or more price book lines, which contain the items. A quantity or value break discount schedule can be linked to a price book. Type Displays whether the price book is a sales price book or a purchase price book. Default value This field is defaulted from the Type field in the Price Books (tdpcg0111m000) session. Item The item for which the price book line is created. Break Type An entity used to specify how breaks between ranges of entities such as distances, amounts, or ordered quantities of items are defined. A break, in this case, is the first or the last number of a range. A break type has either of the following values: Minimum The break is the lowest number of a range. Example
Break type minimum
Ordered quantity | Discount
--- | ---
10 | 3%
50 | 5%
In this case, the breaks are 10 and 50. Ordered quantities >= 10 and < 50 get a 3% discount. Ordered quantities of 50 and more get a 5% discount. Up To The break is the highest number of a range. Example
Break type up to
Distance | Freight rate
--- | ---
100 | 10
1000 | 50
In this case, the breaks are 100 and 1000. For distances <= 100, the rate is 10. For distances > 100 and <= 1000, the rate is 50. Allowed values Break Type Break Value The minimum or maximum order quantity or value, in inventory units, to which the price book applies. Unit The unit in which the item's quantity is expressed. Price The item's price. Price Unit The price unit in which the price is stored. Currency The price book currency is the currency in which the base price is stored. Effective Date The date and time from which the price book is valid. Default value If this session is started and the price book is entered from the: Sales Contract Lines (tdsls3501m000) session The effective date is defaulted from the Effective Date in the Sales Contract Lines (tdsls3501m000) session. Sales Contract Price Revisions (tdsls3103m000) The effective date is defaulted from the Effective Date in the Sales Contract Price Revisions (tdsls3103m000) session. Purchase Contract Price Revisions (tdpur3103m000) session The effective date is defaulted from the Effective Date in the Purchase Contract Price Revisions (tdpur3103m000) session. Buy-from BP - Quotation (tdpur1506m000) session The effective date is defaulted from the Delivery Period in the Buy-from BP - Quotation (tdpur1506m000) session. Expiry Date The expiry date and time of the current price book. If this field is not filled, the price book is infinitely valid. Default value If this session is started and the price book is entered from the: Sales Contract Lines (tdsls3501m000) session The expiry date is defaulted from the Expiry Date in the Sales Contract Lines (tdsls3501m000) session. Sales Contract Price Revisions (tdsls3103m000) The expiry date is defaulted from the Expiry Date in the Sales Contract Lines (tdsls3501m000) session. Purchase Contract Price Revisions (tdpur3103m000) session The expiry date is defaulted from the Expiry Date in the Purchase Contract Lines (tdpur3101m000) session. Buy-from BP - Quotation (tdpur1506m000) session The expiry date is defaulted from the Delivery Period in the Buy-from BP - Quotation (tdpur1506m000) session. Buy-from BP The business partner from whom you order goods or services; this usually represents a supplier's sales department. The definition includes the default price and discount agreements, purchase-order defaults, delivery terms, and the related ship-from and invoice-from business partner. Note You can only define the Buy-from BP if you specified the Supplier Price Book field in the Pricing Parameters (tdpcg0100m000) session. Related topics Setting up a supplier price book Ship-from BP The business partner that ships the ordered goods to your organization. This usually represents a supplier's distribution center or warehouse. The definition includes the default warehouse at which you want to receive the goods and if you want to inspect the goods, the carrier that takes care of the transport, and the related buy-from business partner. Note You can only define the Ship-from BP if you specified the Supplier Price Book field in the Pricing Parameters (tdpcg0100m000) session. Related topics Setting up a supplier price book Price / Percentage Define, for a cost or service item, whether you can enter a price or a percentage. Note The Additional Cost Type field in the Sales Additional Cost Set Items (tdsls0528m000) session determines whether a price or a percentage must be retrieved from the price book. Related topics Additional costs - overview Percentage The additional cost item's percentage, based on which an additional cost amount is calculated. The additional cost amount is calculated as follows:
Shipment based costs | Order based costs
--- | ---
Shipment dependent costs | Item dependent costs | -
percentage* total net amount of a shipment's shipment lines | percentage * net amount of a specific shipment line | percentage* total net amount of an order's order lines
Note A percentage is only retrieved from a price book if the Additional Cost Type field is set to Percentage in the Sales Additional Cost Set Items (tdsls0528m000) session. Related topics Additional costs - overview High Priority If this check box is selected, the price of the buy-from business partner/ship-from business partner/item combination has priority over the prices stored under the normal matrix priority structure. If this check box is cleared, the price of the buy-from business partner/ship-from business partner/item combination is subordinate to the prices stored under the normal matrix priority structure. Note You can only maintain the High Priority check box if you specified the Supplier Price Book field in the Pricing Parameters (tdpcg0100m000) session. As a result, the search sequence for pricing information is as follows: From valid special contracts. From valid normal contracts. From the supplier price book, 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. From valid price matrices, selected from the price matrices for which a matrix priority is defined. If more than one valid price matrix exists, price retrieval is controlled by the Price Control or Price Control fields in the Pricing Parameters (tdpcg0100m000) session. For sales prices, from the Default Sales Price Book. For purchase prices, from the Supplier Price Book for combinations that have the High Priority check box cleared in the Price Books (tdpcg0131m000) session. From Item Sales Data, or from Item Purchase Data. Performance aspects The setting of this field could affect system performance and database growth. For more information, refer to High priority supplier price book. Related topics Setting up a supplier price book Discount Schedule An entity in which you can store discount information that is valid for a given period of time and that is used to calculate discounts for an item. A discount schedule includes the following elements: A discount schedule header, which contains the code, type, and use of the discount schedule. One or more discount schedule lines, which contain the discounts. The discounts specified in a discount schedule are expressed as a percentage or an amount and are subject to a minimum or maximum quantity or value. A discount schedule can be linked to a price book. Related topics Setting up a discount schedule Entry Date The entry date of the current price book line. Used for Quotations If this check box is selected, the price book line is allocated to quotations. Reference Any informative description field used to refer to, for example: The person or department with authorization to perform a specific task. The business partner's contact. The original invoice number. Source The LN component in which the price is created, or the means by which the price is created. This field can have the following values: Manual The price is manually specified. Item data The price is imported from item data with the Import Prices from Item Data to Price Book (tdpcg0231m200) session. RFQ The price is copied from an RFQ with the Convert RFQs (tdpur1202m000) session. The number, position number and sequence number are displayed. Price book The price is copied from a price book with the Copy Price Book (tdpcg0231m100) session. The price book identification is displayed. Base Price If this check box is selected, the default sales or purchase price book from the Pricing Parameters (tdpcg0100m000) session is used to store the item's prices and discounts. Note When you enter a record in the Item - Purchase (tdipu0101m000) session or the Item - Sales (tdisa0501m000) session, and the Update Default Price Book or Update Supplier Price Book check boxes are selected in the Pricing Parameters (tdpcg0100m000) session, LN automatically inserts a line in this session with the Base Price check box selected. Update Order Lines with Price Unit from Price Book If this check box is selected, and an order line is entered, the price unit on the order line is similar to the price book's Price Unit. If this check box is cleared, and an order line is entered, the price unit on the order line is similar to the price unit in, for example, Item Purchase Data or Item Sales Data. As a result, the price on the order line is converted to a price for the price unit in Item Purchase Data or Item Sales Data. Example:
Origin | Price Unit
--- | ---
Price Book | box
Item Sales/Purchase Data | pieces
If the Update Order Lines with Price Unit from Price Book is selected, the price unit on the order line is boxes. If the Update Order Lines with Price Unit from Price Book is cleared, the price unit on the order line is converted to pieces. Picture The item's picture, which is defaulted from the Picture field in the Item - General (tcibd0101s000) session. Show only effective lines Only displays the price book lines that are valid and are within the effectivity period. Copy Price Book Starts the Copy Price Book (tdpcg0231m100) session. Update Prices... Starts the Global Update of Prices via Price Books (tdpcg0231m000) session. Delete Price Information Starts the Delete Price Information (tdpcg0200m000) session. Import Prices... Starts the Import Prices from Item Data to Price Book (tdpcg0231m200) session. View Default Purchase Price Book Displays the supplier price book, as specified in the Supplier Price Book field of the Pricing Parameters (tdpcg0100m000) session. View Default Sales Price Book Displays the default sales price book, as specified in the Default Sales Price Book field of the Pricing Parameters (tdpcg0100m000) session. View Default Service Price Book Displays the default service price book, as specified in the Default Service Price Book field of the Pricing Parameters (tdpcg0100m000) session. |