Ansicht
Dokumentation

RNLMAT02 - IS-H: Ad Hoc Purchasing and Consumption Analysis

RNLMAT02 - IS-H: Ad Hoc Purchasing and Consumption Analysis

Vendor Master (General Section)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book

Title

IS-H: AD Hoc Purchasing and Consumption Analysis

Purpose

The report creates a purchasing and consumption analysis in relation to a material number, cost center or vendor.

It analyzes the material documents with regard to quantity and consumption. Three different view types are available to you for this:

  • Per material number
  • Per cost center
  • Per vendor.

In relation to the evaluation and comparison interval you specify, the program creates a monthly report with assigned quantity and consumption. Purchasing-related (e.g. goods receipt) and consumption-related (e.g. goods issue to a cost center) material movements are included in the analysis depending on the selected view type.

The monthly time series is supplemented by various global information. This information relates to the respective period and selected view type (material number, vendor, cost center).

Integration

Prerequisites

Note that the analysis period cannot exceed twelve months. The material documents are assigned to the relevant period using the posting date.

When creating an analysis by cost center, the report analyzes all movement types of the material documents, which are assigned to the corresponding cost center. For the summation of the amounts and quantities of the various material documents, the report analyzes the relevant debit/credit indicator. Material documents with a debit indicator increase the amounts and quantities; material documents with a credit indicator decrease the amounts and quantities.

When creating an analysis by material number and vendor, the report uses the following standard movement types for the consumption and quantity key figures:

101, 102, 122, 123, 221, 222, 231, 232, 241, 242, 261, 262, 501, 502, 511, 512

Features

Selection

You have to specify the evaluation period and the desired view type. You can create the analysis:

  • Per material number
  • Per cost center or
  • Per vendor.

If you select the Per Material Number analysis, you are required to specify exactly one material number. The remaining parameters are used to further restrict the analysis. For instance, you can further restrict the analysis to one or more cost center(s). Similarly, if you select Per Cost Center, you must specify exactly one cost center. In such cases, the material numbers act as additional selection criteria. If you select Per Vendor, you can again only specify one vendor.

You can also the following information from the material master as additional selection criteria:

  • Plant
  • Material group
  • ATC code

You can restrict the analysis to purchasing organizations, if single material documents are assigned to a purchase order.

The specification of a comparison period is optional. You can specify no more than twelve months for the evaluation and comparison period.

Standard Variants

Output

The report creates a monthly time series with assigned quantity and consumption in relation to the selected view type and specified periods. The system outputs the amount per month as standard. You can use layout management to include the quantities per month.

The time series is constructed according to the following criteria:

  • When the material number is specified, a time series is output per plant.
  • When the cost center is specified, the time series is output per material number and plant.
  • When the vendor is specified, the time series is output per material number and plant.

If you specified a comparision period, the system outputs this below the evaluation period.

The system outputs the following information for the respective selection at the bottom of the list:

  • Number of purchase orders (only for selection per material or per vendor)
  • Number of goods receipts (movement types 101 and 102)
  • Number of goods issues (movement types 201 and 202)
  • Number of returns (movement types 122 and 123)
  • List of cost centers (for selection per material or per vendor - only with movement types 101 and 102)
  • List of vendors (for selection per cost center or per material - only with movement types 101 and 102)
  • List of material numbers (for selection per cost center or per vendor - with all movement types).

The system outputs the most recent posting date in the list of cost centers, vendors and material numbers. It only displays the 10 most recent materials in the respective period.

The Material Document List function provides you with a list of the various documents (corresponding to the transaction MB51) for the current selection. The system lists the various material documents for the evaluation and comparison period taking into account the selections of the current report.

Note that the cost center is not available as standard on the selection screen in the material document list. If you selected the view per cost center in the ad hoc purchasing and consumption analysis and wish to branch into the material document list, you have to add the cost center to the visible fields using the IMG activity Define Field Selection for MaterialDocument List.

Activities

Example






PERFORM Short Reference   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Length: 6346 Date: 20240531 Time: 234117     sap01-206 ( 109 ms )