Purchased item graphs

Graphs display different types of information for an item.

In the Graphs group box of the Purchased Item 360 (tdipu0103m000) session, you can select these graphs:

  • On Time Delivery
  • Vendor Rating Top 8
  • Buying Percentage
  • Price History
  • Planned Available

To display information for the selected graph, select an item from the item list in the Purchased Item 360 (tdipu0103m000) session.

On Time Delivery

This graph shows the top five suppliers with the best on-time delivery performance for the selected item. You can view the data of all suppliers, or suppliers with 5, 10, 25, or more orders.

The rating is based on this data:

  • The criterion type Delivery.
  • The current period. You can use the arrow keys to select another period.
  • The Adjusted Rating.
Note: 
  • Vendor rating must be applicable for the suppliers. Update the vendor ratings regularly to display accurate ratings.
  • You can view a supplier's ratings in the Vendor Ratings by Period (tdpur8102m000) and Vendor Ratings by Criterion (tdpur8102m100) sessions.

Vendor Rating Top 8

This graph shows the vendor rating of the first eight suppliers for the selected item.

The rating is based on this data:

  • The criterion type Period Rating.
  • The current period.
  • The Adjusted Rating.
Note: 
  • Vendor rating must be applicable for the suppliers. Update the vendor ratings regularly to display accurate ratings.
  • You can view a supplier's ratings in the Vendor Ratings by Period (tdpur8102m000) and Vendor Ratings by Criterion (tdpur8102m100) sessions.

Buying Percentage

This graph shows the proportional purchased quantity of the selected item from suppliers (for a maximum of 10 suppliers).

The percentages are based on this data:

  • The last 12 months.
  • The total purchased quantity for a combination of the item, period, and supplier, which is retrieved from the tdpur801 table. This quantity is expressed in the inventory unit.
Note: 
  • Vendor rating must be applicable for the suppliers. Update the vendor ratings regularly to display accurate ratings.
  • The table tdpur801 has no associated session. Consequently, you cannot view the total quantity in a session.

Price History

This graph shows the price history of the selected item listed by suppliers (for a maximum of three suppliers).

This logic is used to determine which suppliers to include in the graph:

  1. The item's default business partner as specified in the Buy-from Business Partner field of the Item - Purchase session.
  2. The first business partners from the Items - Purchase Business Partner (tdipu0110m000) session.

    With the current date used as the search date, this search order is used:

    1. Business partners with the Item specified, the Item - Buy-from Business Partner status set to Approved, and the Preferred field set to Single Source.
    2. Business partners with the Item specified, the Item - Buy-from Business Partner status set to Approved, and the Preferred field set to Preferred.
    3. Business partners with the Item Group specified, the Item - Buy-from Business Partner status set to Approved, and the Preferred field set to Single Source.
    4. Business partners with the Item Group specified, the Item - Buy-from Business Partner status set to Approved, and the Preferred field set to Preferred.

The price history is based on this data:

  • The last six months.
  • The item price for a combination of the item, period, and supplier, which is retrieved from the tdpur801 table. The item price is calculated by dividing the total value by the total quantity.
Note: 
  • Vendor rating must be applicable for the suppliers. Update the vendor ratings regularly to display accurate ratings.
  • The table tdpur801 has no associated session. Consequently, you cannot view the item price in a session.

Planned Available

This graph shows the planned availability of the selected item for each day of a week. The quantity that is planned to be available is expressed in the inventory unit.

By default, the current week is shown. The arrow keys can be used to navigate to another week.

The planned availability data is retrieved from these sessions:

  • Planned Inventory Transactions (whinp1500m000)
  • Warehouse - Item Inventory (whwmd2515m000)