45 pág.


DisciplinaConsultoria909 materiais3.246 seguidores
Pré-visualização6 páginas
z Info jump
Purchasing group: Morgan
Vendor: Smith Ltd
Month PO value
25 000
35 000
20 000
30 000
Purchasing group: Morgan
Vendor PO value Inv. amnt
60 000
40 000
50 000
40 000
Purchasing group analysis
PO value Inv. amnt
100 000
200 000
90 000
195 000
Drill down
Drill down
Miller Ltd
Russell Ltd
Inv. amnt
Data selection
z Multiple selection
z Self-defined hierarchies
z Selection options
z Variants
Reporting in Standard Analyses
„ Standard analyses provide a wide range of functions for creating presentations and analyses for the 
data basis in the LIS. 
„ The data basis for a standard analysis is established when you determine an object to analyze (for 
example, purchasing group, vendor, material group, and so on) and make selections. 
„ This data is then organized and can be displayed in an initial list and a variety of drill-down lists. 
Each analysis can be archived. 
„ You can use the standard transactions in the application to display the complete master record or 
document information from the various drill-down levels of the list. 
„ A wide range of functions can be used to individually examine the key figures and characteristic 
values on which the analysis is based from a business perspective. All the functions for statistical 
analyses are graphically supported. 
© SAP AG TSCM50 12-16 
\uf8e9 SAP AG 1999
You are now able to:
Reporting in MM: Unit Summary
z Explain the difference between
standard reporting and standard
z Describe the basics of the Logistics
Information System
z Perform basic standard reporting and
standard analyses
© SAP AG TSCM50 12-17 
Reporting in MM - Exercises 
Unit: Reporting in MM 
Topic: List Displays and the Logistics Information 
At the conclusion of this exercise, you will be able to: 
\u2022 Create list displays for various documents and transactions 
\u2022 Interpret the information in standard analyses 
To optimize internal processes, you regularly create list displays 
to inform you about the status of your purchase orders, info 
records, and other documents in the system. You already use 
condensed information from the Logistics Information System for 
your reports to management. 
1-1 Open goods receipts 
Display a list of all the purchase orders for purchasing organization 1000 and plant 
1000 for which goods receipts are still open. Limit the search period to the last 24 
To do this, choose the Document date field 
(From: Current date\u201324 months To: Current date). 
Optional: Define for yourself a variant for the purchase order document overview 
in accordance with these specifications. 
1-2 Goods receipts that have been posted 
You want a list of all material documents for materials T-RM1## to T-RM4## 
that were placed into storage in plant 1000 using movement type 101 (goods 
receipt into unrestricted-use stock). 
© SAP AG TSCM50 12-18 
1-3 Analyze purchasing values for purchasing groups 
You want to use the Purchasing Information System to determine a standard 
analysis for the scope of procurement for purchasing groups T01 to T18 for the 
purchasing organization 1000. Limit the analysis period from last month to the 
current and previous month. 
1-3-1 Change the characteristic display 
You want to display both the name of the purchasing group and the key for 
the characteristic. Choose the relevant characteristic display. 
1-3-2 Add key figures 
You need information about the number of purchase order items and the 
number of deliveries. Add these two key figures to the standard analysis. 
Make a note of the total purchase order value and the total number of 
purchase order items for your purchasing group T##. 
PO value:______________ No. of purchase orders:____________ 
What amount has already been settled? __________________ 
1-3-3 Display vendors for a purchasing group 
With which vendors have you effected purchase orders for purchasing group 
T##? Make a note of the number of vendors and the total purchase order 
Number_______________ PO value:________________________ 
1-3-4 Determine the top five purchasing groups 
Which purchasing groups had the five highest purchase order values during 
the analysis period? Make a note of the total PO value of the first 
purchasing group. 
PO value:______________________________________________ 
© SAP AG TSCM50 12-19 
1-3-5 Perform an ABC analysis 
Determine the most important vendor in terms of purchase order value for 
purchasing organization 1000 and the purchasing groups T01 to T18. To do 
this, carry out an ABC analysis for the value key Purchase order value. 
Choose the percentage total of the purchase order value. Segment A is 70 %, 
segment B is 20 %, and segment C is 10 %. 
Look at the complete list for the ABC analysis of the purchase order value. 
Which vendor has the highest purchase order value? 
Before you perform the ABC analysis, make sure you are 
in the initial list. From the initial list, you then switch the 
drill-down to the vendor. 
View \u2192 Switch drill-down... [X] \u2192 Vendor 
1-3-6 Display the selection log 
To interpret the result of your analysis correctly, it is important that you 
know the selection criteria used in the analysis. You should therefore look at 
the selection log for purchasing group analysis. What is the key and 
description of the info structure for this analysis? 
Info structure __________________________________________ 
1-4 Analysis of storage locations 
You want to use Inventory Controlling to analyze your storage location stocks and 
possibly transfer materials that are stored in the wrong place. Check which stocks 
are located in storage location 0001 of plant 1000. 
Analysis period: 
From the current date minus 12 months up to the current month. 
Choose the drill-down by material group and display as a graphic the receipt 
quantities per material group. 
Expand for each month the material group with the greatest receipt quantity and 
display the materials for the month that has the greatest receipt quantity. 
Create a top-ten list in terms of the consumption quantities. 
© SAP AG TSCM50 12-20 
Reporting in MM - Solutions 
Unit: Reporting in MM 
Topic: List Displays and the Logistics Information 
1-1 Open goods receipts 
Logistics \u2192 Materials Management \u2192 Purchasing \u2192 Purchase Order \u2192 List 
Displays \u2192 By Vendor 
Vendor (No entry) 
Purchasing organization 1000 
Scope of list BEST 
Selection parameter WE101 
Purchasing group (No entry) 
Plant 1000 
Document date (Period within the last 24 
1-2 Goods receipts that have been posted 
Logistics \u2192 Materials Management \u2192 Inventory Management \u2192 
Environment \u2192 List Displays \u2192 Material Documents 
Material T-RM1## to T-RM4## 
Plant 1000 
Movement type 101 
© SAP AG TSCM50 12-21 
1-3 Analyze purchasing values for purchasing groups 
Logistics \u2192 Materials Management \u2192 Purchasing \u2192 Purchase Order 
\u2192 Reporting \u2192 Purchasing Information System \u2192Standard Analyses \u2192 
Purchasing Group 
Logistics\u2192 Logistics Controlling \u2192 Purchasing Information System 
\u2192 Standard Analyses \u2192 Purchasing Group 
Purch. organization 1000 
Purchasing group T01 to T18 
Analysis period (Current month and previous 
1-3-1 Change the characteristic display 
\u2192 Settings \u2192 Char. display \u2192 Key and description 
If the column width is not sufficient to display the characteristics, you can 
increase the width by double-clicking