Market Price Analysis 

Use

In market price analysis, the system searches for the lowest price (or the last price) for a material from among different stored prices. To obtain the most current market prices, the information needed to determine the market prices should be restricted to a limited time period, such as the last three months.

Features

Price Sources

The system can access the following objects when it determines market prices:

·        Incoming invoices

For the invoice price, all costs are considered including delivery costs and subsequent debits. If the ordering transactions are in a foreign currency, you can specify by means of a parameter whether an exchange rate comparison should be made on the balance sheet key date and how this should be done.

Another parameter defines how the prices found for a material are selected by the procedure. Usually the lowest or newest price is used.

·        Purchase orders

For each material, the purchase order prices of all purchase orders are compared whose ordering date is within the required time frame. This is independent of the following factors:

¡        Goods receipt for purchase order

¡        Posting of an invoice that differs from the purchase order price

One parameter defines how the prices found for a material are selected by the procedure. Usually the lowest or newest price is used. For purchase orders in a foreign currency, different types of exchange rate comparisons can be selected.

·        Contracts/Scheduling Agreements

For each material, the prices of all contracts or scheduling agreements are compared whose validity end is after the lower limit and whose validity start is before the upper limit of the requested time frame. The is independent of whether purchase orders exist for the contract or schedule lines for the scheduling agreement. For contracts or scheduling agreements in a foreign currency, different types of exchange rate comparisons can be selected.

·        Purchasing info records

For each material, the prices of all purchasing info records are compared for which the date of the last price change is within the requested time frame. For purchasing info records in a foreign currency, different types of exchange rate comparisons can be selected.

If purchasing info records are to be used as a source for determining the lowest value, they must be complete.

·        User exit

Since the SAP standard has no procedure for determining realistic sales prices automatically, you can use a BadI to customize how the sales prices are determined.

For materials with valuated batches, the system runs lowest value determination for each batch individually. The totals record is not used.

With market price analysis, the system compares the prices from the different price sources selected based on a defined relationship.

Result

The system outputs a list of materials with their market prices.