45 pág.


DisciplinaConsultoria909 materiais3.232 seguidores
Pré-visualização6 páginas
SAP R/3 
Certificación MM (7053) 
Juan Carlos Sarrasi-Xavier Rovira
TSCM 50-1ª parte (12-13) 
© SAP AG TSCM50 12-1 
\uf8e9 SAP AG 1999
Reporting in MM
z Reporting at Document Level
z Reporting with the Logistics Information System (LIS)
© SAP AG TSCM50 12-2 
\uf8e9 SAP AG 1999
At the conclusion of this unit, you will be able to:
Reporting in MM: Unit Objectives
z Explain the difference between standard reporting
and standard analysis
z Describe the basics of the Logistics Information
z Perform basic standard reporting and standard
© SAP AG TSCM50 12-3 
\uf8e9 SAP AG 1999
Reporting in Material Management: Course
Overview Diagram
Procurement of Stock 
Reporting in Material
External Procurement 
with mySAP SCM
Procurement of
External Services
Basic of Procurement
Master Data
Procurement of
Consumable Material
© SAP AG TSCM50 12-4 
\uf8e9 SAP AG 1999
Reporting in MM: Business Scenario
z Your company monitors all areas regarding
possibilities of reducing cost and improving
z The project team analyzes the reporting
functionality of SAP R/3 at transaction and
document level.
z The project team wants to find out if the SAP R/3
System is capable of providing management with
condensed key indicators for enterprise-relevant
processes in a timely manner.
© SAP AG TSCM50 12-5 
\uf8e9 SAP AG 1999
Standard reportingStandard reporting
GR doc.
Document entryDocument entry
Master dataMaster data
Standard Reporting
Info recordsInfo records
„ In Purchasing, you enter a variety of documents. The R/3 System updates these documents and stores 
them in database tables. In the R/3 System, you can use Standard Analysis to analyze the information 
contained in the documents. 
„ As the employee responsible in Purchasing, you want to obtain an overview of your vendors and 
purchasing organizations. For example, you want know: 
y Which purchase orders were effected at a particular vendor for a particular period. 
y The number of purchase orders for which you have already received goods. 
y Whether a vendor complies with his or her delivery dates. 
y Whether a goods receipt and invoice receipt are correct. 
y The average value of each purchase order for a purchasing group. 
„ You can also carry out analyses for master data, as well as for documents. For example, you can 
output a list of all purchasing info records for a material or vendor, or you can obtain an overview of 
the material master records in your enterprise, based on particular criteria. 
„ The analyses in the R/3 System provide you with a quick and convenient overview, enabling you to 
act accordingly. 
© SAP AG TSCM50 12-6 
\uf8e9 SAP AG 1999
Scope of List and Selection Parameters
Purch. organization
Scope of list
Selection parameters
Document type
Purchasing group
Item category
Acct assgmt cat.
Delivery date
Validity key date
Scope of list Description of scope of list
 : :
 : :
 : :
SelParam Descript. Selection parameters
Open invoices
Open goods receipt
 : :
 : :
 : :
GR 101
Outline agreements
Purchase orders
„ Scope of list parameters determine which data is displayed for a document. You can decide whether 
you want a list in short form or whether it should contain more information (for example, lines for 
open purchase order quantity and value or the validity period of outline agreements). You can 
configure scope-of-list parameters in Customizing for Purchasing. 
„ The selection parameter determines which purchasing documents the report evaluates. In this 
example, the system will only evaluate purchasing documents for which you have still to receive an 
invoice. In Customizing, you can define your own selection parameters. 
„ If, at regular intervals, you carry out a particular list display using the same selections, it is 
worthwhile creating a variant. This reduces data entry time and prevents errors during entry. 
You can store your own variants or use existing ones. 
„ You can define any number of variants for a report. 
© SAP AG TSCM50 12-7 
\uf8e9 SAP AG 2002
SAP List Viewer and ALV Grid Control
SAP List Viewer
ALV Grid Control
„ The SAP List Viewer and the ALV Grid Control standardize and simplify the handling of lists in 
the SAP R/3 System. There is a consistent interface and list format available for the lists. Redundant 
functions are therefore avoided. The ALV Grid Control is not only used to display lists (such as 
material document lists), but is also used in other transactions (for example, purchase requisitions). 
„ Not all lists in the components of the SAP R/3 System use the complete scope of the SAP List 
Viewer. Some lists also offer particular functions that overlap the scope of the SAP List Viewer. You 
can change the list display and contents using the layout. 
„ To summarize, the essential elements of the SAP List Viewer and the ALV Grid Control are: 
\u2022 consistent design of all lists and tables 
\u2022 cross-application standardized functions with consistent icons 
\u2022 simple creation and change of the layouts 
„ Note: Not all lists in the SAP R/3 System are prepared with one of these display tools. 
„ For more information about the SAP List Viewer, see the SAP R/3 documentation (Cross-
Application Components \u2013> General Application Functions; and Basis Components \u2013> Basis-
Services/Communication Interfaces). 
© SAP AG TSCM50 12-8 
\uf8e9 SAP AG 2002
Functions of the ALV / SAP Grid Control
Sort (ascending)
Total values
Select detail
Set filter 
Sort (descending)
Current layout
„ The SAP List Viewer and the ALV Grid Control offer the following functions: 
y Select detail: You receive further information about a selected line, and other information that is 
not shown in the list. 
y Set filter: With the filter function, you can only display the lines that fulfill particular criteria in 
one or several columns. To set a filter, select one or more columns by clicking on the column 
header, and select Set filter. In the dialog box, enter the required restrictions for the selected 
y Sort: Lists can be sorted in ascending or descending order. Select the column and choose one of 
these sort functions. 
y Total values: Within a list, you can total one or more selected columns. You can total both value 
columns and quantity columns. 
y Generate subtotal: If you have generated a sum for at least one column within a list, you can also 
generate subtotals. Subtotals can be generated for one or more selected columns without value or 
quantity columns. 
y Layout: You can use layouts to change how your list is displayed. For more information on this, 
see the next page. 
© SAP AG TSCM50 12-9 
\uf8e9 SAP AG 2002
Layout and Display Variant
Change layout
Show selected 
Select layout
Change layout
Save layout
Manage layout
Change display
Which fields are 
displayed for the 
selected objects and
in which order?
Select layout
Change layout
Save layout
Manage layout
Change display
Which fields are 
displayed for the 
selected objects and
in which order?
Hide selected
„ You can use layouts to