Plant Level of Analysis
A plant analysis is the same as the classic ABC-XYZ analysis for SAP ERP data. Which plant is analyzed depends on the entry in the analysis scope. The following data sources are possible for the plant analysis:
Material Consumption Table [Table MVER]
The analysis is only possible with the periodicity for which the update was activated (see period indicators). Make sure that the periodicity is the same for all selected materials and has not been changed in the analysis period. Otherwise, it can lead to data inconsistencies. Besides uncorrected total consumption, you can also use manually corrected total consumption as a basis.
Material Documents [Material Documents Aggregated Based on Table MSEG in Corresponding Tables of the MRP Monitor]
An analysis based on this data source is only possible if the material documents are first aggregated for the periodicity set in the period of analysis. To do this, you use material document aggregation. The material document aggregation is a program that is delivered with the MRP monitor (transaction /SAPLOM/MDA). The material document aggregation is described in more detail in the documentation for the comprehensive functions.
Info Structures
If you want to use this data source, you first need to activate the update of info structures in Customizing for the Logistics Information System (there may be deviations here depending on which info structure is activated in the system). Filling of different info structures is dependent on the system constellation. If the info structures contain the relevant data, an analysis can be run for info structures filled in this way. If you want to use info structures filled based on your own logic, open a ticket with the component XX-PROJ-CON-DM.
Sales Orders
In some cases, consumption irregularities may not be the result of irregular incoming orders. If there is a lack of delivery capacity, consumption accumulates at specific times even though incoming orders remain regular. To allow you to compare consumption irregularity in such cases, which may be caused by a lack of delivery capacity, against incoming order regularity, the MRP monitor supports the ABC/XYZ analysis for materials based on incoming orders. The only difference in this analysis is the data source of the underlying data. All other features of the ABC/XYZ analysis are the same as the material consumption analysis. Furthermore, this analysis selects sales orders that match the material, plant, and sales organization combination and the selected time period. This analysis is only useful for materials that are continuously used in sales orders.
You can further restrict the relevant sales orders using additional selection criteria such as the rejection reason. The selection criteria are visible on the Data basis tab as soon as you have selected Sales Orders as the data source.
Invoices
As with the evaluation of sales orders, you can perform this analysis based on all billing documents that match a material, plant, and sales organization combination and the selected time period. Moreover, this analysis is only useful for materials that are continuously used in billing documents.
You can also use the billing type and billing category as selection criteria.
Planned Requirements
The analysis of planned requirements enables – in contrast to the aforementioned past-oriented data sources – the examination of future developments. However, you can only analyze materials for which planned requirements exist in the system. You can choose between the versions. This enables you to use the active or inactive version and the combination of versions.
Requirements
With the requirements data source, you can also perform a forward-looking analysis for non-planned materials. Here you can select which MRP elements you want to analyze.
Combine Material Consumptions and Planned Requirements
Not only historical data but future data can be relevant for an analysis. In this case, two different data sources need to be taken into account. The function for combining consumption tables and planned requirements therefore allows you to include material consumption for the historical values and the planned requirements for the future values in the selected analysis period. These values are totaled for each material and used as the basis for determining the classification into ABC/XYZ materials. For planned independent requirements, you can choose between the versions. This enables you to use the active or inactive version and the combination of versions.
Combine Material Documents and Requirements
In contrast to the combination of material consumptions and planned requirements, this function involves the values that are determined from the Material Documents and Requirements. Here you can restrict the data using the same selection options as for the individual functions. In the case of requirements, for example, you can even analyze only the values of special requirement types (such as requirements in accordance with production orders, forecast values, and so on). Here, too, the values are totaled for each material and used as the basis for determining the classification into ABC/XYZ materials.
