1
Materials Management –
Training agenda
Material management – Training agenda
George GUIU, Rompetrol
Augustin SANDU, Romsys
Nicolai BIRSAN, Romsys
04 - 08.07.2011
11-15.07.2011
Agenda
3
Agenda
4
Agenda:
DAY 1:
5
1. SAP Overview
Introduction – Benefits of SAP
SAP- Systems, Applications, Products in Data Processing
6
1. SAP Overview
Financial Accounting and Controlling Modules:
FI - Financial Accounting: A wide performance spectrum which includes: Cash Management/Electronic Banking, Cash Budget management and consolidation.
CO - Controlling: Closed cost accounting from cost center accounting and cost element accounting through to profitability analysis.
AM - Asset management: the complete management of all fixed assets, from traditional asset accounting and technical assets management up to investment controlling.
PS – The integrated cooperation of all service area for project planning, processing and control.
7
1. SAP Overview
8
1. SAP Overview
9
1. SAP Overview
10
1. SAP Overview
Logistic Module
SD – Sales and Distribution: The turnkey solution for the integrated handling of all tasks for sales, shipping and billing.
MM – Material Management: The integrated, closed procurement process with system-supported integration of results and production planning.
PP – Production Planning: The PPC system suitable for all type of production with system supported integration of results and production planning. Quality Management: The system for quality assurance in all areas of the logistic chain.
PM – Plan Maintenance: The industry-neutral solution for the administration and repair of technical systems.
11
1. SAP Overview
12
1. SAP Overview
13
1. SAP Overview
14
1. SAP Overview
15
1. SAP Overview
16
1. SAP Overview
17
1. SAP Overview
18
1. SAP Navigation
Application Server Selection:
19
1. SAP Navigation
Setting new password
Logon with the same user ID
20
1. SAP Navigation �
21
A typical screen layout (with different elements)
1. SAP Navigation and Overview�
22
User Menu and Favorites
1. SAP Navigation and Overview�
23
System and Help Menus
1. SAP Navigation and Overview�
24
1. SAP Navigation and Overview ��
If the command field is ready for input, you can use the F1 field help (icon on
screen or function key F1 on keyboard) to display possible entries for this field.
The following entries are possible:
You can find the transaction code XXXX for an application either in the overview
menu on the SAP Easy Access screen, in the status bar, or in the respective
application under System → Status. session.
25
1. SAP Navigation and Overview�
26
Personalization of the User Interface
1. SAP Navigation and Overview�
27
1. SAP Navigation and Overview�
28
Procurement Process Overview
1. SAP Navigation and Overview�
29
Purchase Orders
1. SAP Navigation and Overview�
30
Inventory Management
1. SAP Navigation and Overview�
31
Invoice Verification
2. Organizational Levels in Purchasing ��
32
Organizational Levels in the Procurement Process
2. Organizational Levels in Purchasing ��
The Client is the highest hierarchical level in the SAP system and from a business viewpoint, the client represents a corporate group, for example. It is uniquely defined in the system by a three-digit numeric key.
The Company code is the smallest organizational unit of external accounting for which a complete, self-contained bookkeeping system can be replicated. A company code is defined in the system by means of a four-character alphanumeric key that is unique in the client.
The Plant is an organizational unit within logistics that subdivides an enterprise from the viewpoints of production, procurement, and materials planning. A plant is defined in the system by means of a four-character alphanumeric key that is unique in the client.
33
Organizational Levels in the Procurement Process
2. Organizational Levels in Purchasing ��
The Storage location is an organizational unit that facilitates the differentiation of stocks of materials within a plant. A storage location is defined by means of a four-character alphanumeric key that is unique in the plant.
A Purchasing group is a key for a buyer or a group of buyers who is/are responsible for certain purchasing activities. Internally, the purchasing group is responsible for the procurement of a material or class of materials. Externally, it is the principal channel for an enterprise's dealings with its vendors.
The Purchasing organization is an organizational unit within logistics that subdivides the enterprise according to the purchasing requirements. A purchasing organization procures materials or services, negotiates conditions of purchase with vendors, and assumes responsibility for these transactions.
34
Organizational Levels in the Procurement Process
2. Organizational Levels in Purchasing��
35
Organizational Levels in Inventory Management
2. Organizational Levels in Purchasing��
36
Plant-Specific Purchasing Organization
2. Organizational Levels in Purchasing��
37
Cross-Plant Purchasing Organization
2. Organizational Levels in Purchasing��
38
Cross-Company-Code Purchasing Organization
3. Master Data in Materials Management
39
Master Data in the Procurement Process
3. Master Data in Materials Management
40
Vendor Master Data
3. Master Data in Materials Management
41
Vendor Master Record: Organizational Levels
3. Master Data in Materials Management
42
Account Group
3. Master Data in Materials Management�
43
Partner Functions
3. Master Data in Materials Management
Exercise : Create Vendor Master Record
Cod: T-K500Y##
Purchasing Organization: 1000
Company Code: 1000
Account Group: ZTMM ???
Reconciliation Account: ???
44
3. Master Data in Materials Management
45
Material Master Data
3. Master Data in Materials Management
46
Data Screens in Material Master Record Maintenance
3. Master Data in Materials Management
47
Organizational Levels
3. Master Data in Materials Management
48
Screen Sequence
3. Master Data in Materials Management
49
Material Type
3. Master Data in Materials Management
50
Material Type
3. Master Data in Materials Management
51
Industry Sector
3. Master Data in Materials Management
52
Extending a Material Master Record: Example
3. Master Data in Materials Management
Exercise : Creation Material Master Record
Code: T-M500Y##
Industry Sector: Mechanical Engineering
Material Type: Raw Material
Plant: 1000
Storage Location: 0001
53
3. Master Data in Materials Management
54
Sources of Supply: Overview
3. Master Data in Materials Management
55
Purchasing Info Record
3. Master Data in Materials Management
56
Purchasing Info Record
3. Master Data in Materials Management
57
Source List
END OF DAY 1
Thank you.
Questions?
58
Agenda:
DAY 2:
59
4. Procurement of Stock Materials�
60
4. Procurement of Stock Materials�
61
Stock Material Procurement
4. Procurement of Stock Materials�
62
Purchase requisition
4. Procurement of Stock Materials�
63
4. Procurement of Stock Materials�
64
RFQ and Quotation
4. Procurement of Stock Materials�
65
Collective Number
4. Procurement of Stock Materials�
66
Creating RFQs
4. Procurement of Stock Materials�
67
Quotation Processing
4. Procurement of Stock Materials�
68
Contract
4. Procurement of Stock Materials�
69
Contract
4. Procurement of Stock Materials�
70
Purchase Order
4. Procurement of Stock Materials�
71
4. Procurement of Stock Materials�
72
Purchase Order Format
4. Procurement of Stock Materials�
73
4. Procurement of Stock Materials�
74
Purchase Order Transaction . Navigation
4. Procurement of Stock Materials�
75
Create a Purchase Order
4. Procurement of Stock Materials�
76
Create a Purchase Order
4. Procurement of Stock Materials�
77
Item Categories
4. Procurement of Stock Materials �
78
Price condition
4. Procurement of Stock Materials �
79
Price condition
4. Procurement of Stock Materials �
80
Price condition
Gross price = Price without taking any other conditions (such as discounts/surcharges or delivery costs) into account (vendor's net price)
Net price = Price taking into account discounts and surcharges with reference to the gross price but excluding delivery costs
Effective price = Net price less cash discount and including miscellaneous provisions, delivery costs, and non-deductible tax
Freight (Value / % / per Q)
Custom (Value / % / per Q)
Discount (Value / % / per Q)
Surcharge (Value / % / per Q)
4. Procurement of Stock Materials�
81
Issue a Message
4. Procurement of Stock Materials�
82
Goods Receipt
4. Procurement of Stock Materials�
83
Goods Receipt
4. Procurement of Stock Materials�
84
Valuated Goods Receipts
4. Procurement of Stock Materials�
85
Transaction MIGO
4. Procurement of Stock Materials�
86
Enter GR Against a Purchase Order
4. Procurement of Stock Materials�
87
Invoice Receipt
4. Procurement of Stock Materials�
88
Invoice Receipt
4. Procurement of Stock Materials�
89
Invoice Entry . Transaction MIRO
4. Procurement of Stock Materials�
90
Enter Invoice Against Purchase Order
4. Procurement of Stock Materials�
Exercise - Procurement of Stock Materials
1. Create purchase requisition (NB)
Material code: T-M525C##
Plant: 1000
Storage Location: 0001
2. Create request for quotation (AN)
Purchase organization: 1000
Purchasing group: B##
Collective number: QT##
Vendors: T-K500A##, T-K500C##
91
4. Procurement of Stock Materials�
3. Entering quotation
Collective number: QT##
4. Compare prices
Collective number: QT##
5. Create contract (WK)
Purchase organization: 1000
Purchasing group: B##
6. Create purchase order (NB)
7. Create goods receipt
8. Create invoice
92
5. Procurement of Consumable Material �
93
Procurement for Consumption
5. Procurement of Consumable Material �
94
5. Procurement of Consumable Material �
95
5. Procurement of Consumable Material �
96
Single or Multiple Account Assignment
5. Procurement of Consumable Material �
97
Consumable Material Procurement: Purchase Order
5. Procurement of Consumable Material �
98
Non-Valuated Goods Receipt
5. Procurement of Consumable Material �
99
Postings for Valuated/Non-Valuated GR
5. Procurement of Consumable Material �
100
Stoc Material VS Consumable material
5. Procurement of Consumable Material �
Exercise: Procurement of Consumable Material
1. Create purchase requisition (NB):
Account assignment cat. Cost center - K
Delivery date: Today + 7 days
Plant: 1000
Requisitioner: IH##
Req. tracking no: GR##
Cost center: 4100
2. Create purchase order (NB):
Purchase Organization: 1000
Vendor: T-K521A##
101
5. Procurement of Consumable Material �
Exercise: Procurement of Consumable Material
3. Create goods receipt
Delivery Note: DEL##
Quantity: 10
4. Create vendor invoice
Reference: REF##
102
6. Blanket Purchase Order
103
Blanked order is a purchase order with the validity and limitations (value) to simplify the acquisition of materials and external services.
6. Blanket Purchase Order
104
6. Blanket Purchase Order
105
6. Blanket Purchase Order
Characteristics of Blanket Purchase Orders
The most important characteristics of a blanket purchase order are:
Order type FO (framework order)
Item category B (limit)
No goods receipt or service entry
Accounting data for the item suggested in invoices
Additional or multiple account assignment possible in invoice verification
106
6. Blanket Purchase Order
Exercise:
1. Create Purchase Order
Order type = FO
Purchase Organization: 1000
Purchase Group = 000 ; Company Code = 1000
AccAsignCat = U
ItemCat = B
Free text
Vendors: T-K500A##, T-K500C##
2. Create Vendor invoice
Reference: REF##
107
END OF DAY 2
Thank you.
Questions?
108
Agenda:
DAY 3:
109
7. Procurement of External Services
The following figure, .Process Flow of External Service Procurement, shows all the possible steps that can be involved in procuring external services.
110
7. Procurement of External Services
Service Master Record – Transaction AC03
111
7. Procurement of External Services
Service conditions
Prices for external services that are valid over a longer period can be recorded in the system in the form of service conditions. You can enter further conditions in the purchasing document itself.
112
7. Procurement of External Services
Purchase Order for Services (Transaction ME21N)
113
Assignment category = U (unknown)
Item category = D (service)
7. Procurement of External Services
Service Entry Sheet and Acceptance (Transaction ML81N)
The reference document for SES is the Purchase Order.
The system checks that the unplanned services do not exceed the limit set in the purchase order. Postings are not made in Financial Accounting when the service entry sheets are saved.
114
7. Procurement of External Services
115
7. Procurement of External Services
Invoice Entry
Invoice verification can be carried out with reference to the purchase order. In this case, the system suggests all accepted service entry sheets relating to this PO for invoice verification purposes.
The system compares the prices in the invoice with the prices from the service entry sheets. If there are no discrepancies, you can enter and post the invoice. If the system finds any discrepancies, it blocks the invoice for payment.
116
7. Procurement of External Services
117
7. Procurement of External Services
Purchase Order History
In the purchase order history, (PO history) all follow-on activities relating to a PO item are listed, that is, all services performed and entered (service entry sheet), all accepted services (material document) and all invoices that have been entered.
118
8. Procurement of Fix Assets��
119
8. Procurement of Fix Assets��
120
8. Procurement of Fix Assets��
121
Account assignment category A – Assets procurement
8. Procurement of Fix Assets��
122
8. Procurement of Fix Assets��
Exercise:
1. Create Purchase Order
Order type = NB
Purchase Organization: 1000
Purchase Group = 000 ; Company Code = 1000
AccAsignCat = A
Free text sau cod material + Asset No = 1120
Vendors: 5210
2. Create GR with reference to a PO
3. Create Vendor invoice with reference to a PO
123
9. Releasing purchasing documents���
124
One or several approvals may be required for the release. The release acts as an electronic signature.
It is necessary to differentiate between two types of release:
. Item-wise release
. Overall release
The aim of the release procedure for requisitions is to prevent that these can be converted into follow-on documents. Follow-on documents are requests, purchase orders and outline agreements.
9. Releasing purchasing documents���
125
Release Options for Blocked Purchase Requisitions
9. Releasing purchasing documents���
126
Key Terms
9. Releasing purchasing documents���
127
Overall Release of External Purchasing Documents
9. Releasing purchasing documents���
128
Definition of Release Criteria
9. Releasing purchasing documents���
129
Customizing of Release Procedure with Classification
9. Releasing purchasing documents���
130
Release Strategies
9. Releasing purchasing documents���
131
Authorization Objects
9. Releasing purchasing documents���
Exercise:
RN for approval: 10013838 🡪 10013858
132
Authorization Objects
10. Goods Receipt
A goods receipt (GR) is a goods movement that leads to an increase of stock.
There are two types of GR in SAP system:
133
10. Goods Receipt
134
Initial Entry of Stock Balances
Transactions: MIGO, MB1C: movement types:
561 – unrestricted use stock;
563 – quality inspection stock;
565 – blocked stock.
10. Goods Receipt
Without Purchase Order
Transactions: MIGO, MB1C: movement types:
501 – unrestricted use stock;
503 – quality inspection stock;
505 – blocked stock.
Without Production Order
Transactions: MIGO, MB1C: movement types:
521 – unrestricted use stock;
523 – quality inspection stock;
525 – blocked stock.
Delivery Free of Charge
Transactions: MIGO, MB1C: movement types:
511 – delivery free of charge;
135
10. Goods Receipt
136
10. Goods Receipt
137
Without Purchase Order
Transactions: MIGO
Reference Document = Purchase Order / Production Order
Movement type = 101
10. Goods Receipt
138
10. Goods Receipt
139
Automatic Generation of PO at Time of Goods Receipt
10. Goods Receipt
The system determines the data necessary for the automatic generation of a purchase order as follows:
140
10. Goods Receipt
Exercise:
1. Create GR with reference to a PO
Purchase Orders for GR: 4500017348 🡪 4500017365
141
11. Return Delivery��
Return Delivery
You have entered goods from a vendor in the system with reference to a purchase order. Now you determine that, for example, the incorrect material was delivered, or that the quality of the delivered material is insufficient. In this case, you return the material to the vendor. Such a return delivery can take place from unrestricted-use stock, stock in quality inspection, or blocked stock, but also from non-valuated GR blocked stock, according to the stock you posted the goods to on receipt.
142
11. Return Delivery �
143
11. Return Delivery �
Subsequent Delivery
If the vendor sends you a substitute delivery after the return delivery, you can enter the new goods receipt as a subsequent delivery. In a subsequent delivery, you refer to the material document of the original goods receipt or to the material document of the return delivery.
Entering a substitute delivery as a subsequent delivery is particularly useful in goods-receipt-based invoice verification. Even if a goods receipt is reversed and a new goods receipt is posted after you have entered the invoice, this should be a subsequent delivery for goods-receipt-based invoice verification.
144
11. Return Delivery �
145
11. Return Delivery �
Reason for Movement
If you want to be able to analyze why goods were sent back to a vendor, you can enter a reason when you enter the goods movement.
146
11. Return Delivery �
Returns for Purchase Order
Returns for a purchase order also concern return deliveries of materials to an external vendor. You therefore do not create a reference to the purchase order that you created for the original delivery or the goods receipt posted. For this type of return, you create a returns item in the purchase order.
147
11. Return Delivery �
Cancellation
If you make an error when entering a goods movement (for example, incorrect quantity, incorrect movement type), you have to cancel the material document, since the data in the material document can no longer be changed. Then enter the item with the correct data.
148
11. Return Delivery �
We recommend you to enter a cancellation document with reference to the original material document. This has several advantages:
149
11. Return Delivery �
Exercise:
150
END OF DAY 3
Thank you.
Questions?
151
Agenda:
DAY 4:
152
12. Goods Issue
A goods issue (GI) is a goods movement that leads to a reduction in stock.
153
12. Goods Issue
The most important effects of a goods issue are the following:
154
12. Goods Issue
There are two types of goods issue for withdrawals of components:
You enter this goods issue with reference to the dependent reservation for the order. The system automatically determines 261 (consumption for order from warehouse) as the relevant movement type.
You enter this goods issue without reference to a reservation as an other goods issue. In this case, too, you choose movement type 261 (consumption for order from warehouse). Specify the order number as the account assignment.
155
12. Goods Issue
GI without references:
Transactions: MIGO/MB1A
Movement types:
Consumuri cu referinta la BOM:
Transactions : MIGO/MB1A
Movement type: 261 – on Order (Production / Internal)
156
12. Goods Issue
157
Sampling (without referinta)
12. Goods Issue
158
Scrapping (without referinta)
12. Goods Issue
159
With Reference to a Reservation
12. Goods Issue
160
With Reference to an Order
13. Stock Transfers/Transfer Postings
In any enterprise, goods movements do not only take the form of goods receipts and goods issues. For organizational reasons (for example, decentralized storage) or due to other factors (such as quality assurance) internal transfer postings and physical stock transfers may be necessary.
In the case of transfer postings, the key aspect is a change in the stock ID number or the stock category of a material. Transfer postings need not involve an actual (physical) goods movement. In the case of stock transfers, on the other hand, there is always a physical movement of goods.
161
13. Stock Transfers/Transfer Postings
Transfer Postings (TP)
Stock to Stock
162
13. Stock Transfers/Transfer Postings
Transfer Postings (TP)
Material to Material
163
13. Stock Transfers/Transfer Postings
Transfer Stock (TR)
Between Storage Locations
164
13. Stock Transfers/Transfer Postings
Storage Location to Storage Location: One-Step Procedure
165
13. Stock Transfers/Transfer Postings
Storage Location to Storage Location: Two-Step Procedure
166
13. Stock Transfers/Transfer Postings
Stock Transfer Between Plants
167
13. Stock Transfers/Transfer Postings
Plant to Plant: One-Step/Two-Step Procedures
Possible reasons for a stock transfer using the two-step procedure are that the plants are located far away from each other and the goods remain in transit for a certain time, or that a different employee is responsible in each plant, each of whom can post movements only in his or her own plant.
168
14. Physical Inventory
169
14. Physical Inventory
Physical Inventory Document
A physical inventory document contains data that includes:
170
14. Physical Inventory
171
14. Physical Inventory
172
14. Physical Inventory
173
14. Physical Inventory
The SAP system provides two possible ways of avoiding errors in the physical inventory:
174
14. Physical Inventory
175
Blocking Goods Movements
14. Physical Inventory
176
Freezing Book Inventory
15. Logistic Invoice Verification Procedure����
177
Invoice Verification Environment
15. Logistic Invoice Verification Procedure����
178
Invoice Verification Environment
15. Logistic Invoice Verification Procedure����
179
Invoice Verification
15. Logistic Invoice Verification Procedure����
180
Invoice Verification: ex. 1
15. Logistic Invoice Verification Procedure����
181
Invoice Verification ex. 2
15. Logistic Invoice Verification Procedure����
182
Invoice Verification ex. 3
15. Logistic Invoice Verification Procedure����
183
Invoice Receipt
15. Logistic Invoice Verification Procedure����
184
Posting an Invoice
15. Logistic Invoice Verification Procedure����
185
Account Movements
15. Logistic Invoice Verification Procedure����
186
Price Control
15. Logistic Invoice Verification Procedure����
187
Logistics Invoice Verification: Initial Screen
15. Logistic Invoice Verification Procedure����
188
Invoice Verification Procedure: Allocation
15. Logistic Invoice Verification Procedure����
189
Invoice Verification Procedure: Item List
15. Logistic Invoice Verification Procedure����
190
Layouts for the Item List
15. Logistic Invoice Verification Procedure����
191
Other Functions
15. Logistic Invoice Verification Procedure����
192
Purchase-Order-Based Invoice Verification
15. Logistic Invoice Verification Procedure����
193
Goods-Receipt-Based Invoice Verification
15. Logistic Invoice Verification Procedure����
194
Document Parking
15. Logistic Invoice Verification Procedure����
195
Document Parking: Document Status
15. Logistic Invoice Verification Procedure����
196
Hold Document
15. Logistic Invoice Verification Procedure����
197
Document Parking and Saving as Complete
15. Logistic Invoice Verification Procedure����
Exercise – Logistic Invoice Verification with reference to OWN Purchase Orders (and Goods Receipts)
198
END OF DAY 4
Thank you.
Questions?
199
Agenda:����
DAY 5:
200
16. Vendor Consignment Process
Company is keeping in stock a quantity of materials (quantity without value) belonging to a Vendor.
To manage material in the consignment stores, you need the following master data:
When you manage the affected material as your own material, it is not necessary to create a new material master record for the consignment material. By using the same material number, the consignment stock can be included in the unrestricted-use stock of a material.
201
16. Vendor Consignment Process
202
16. Vendor Consignment Process
203
16. Vendor Consignment Process
204
16. Vendor Consignment Process
205
16. Vendor Consignment Process
206
16. Vendor Consignment Process
207
17. Subcontracting Process
The processing has the following characteristics:
208
17. Subcontracting Process
209
17. Subcontracting Process
210
The purchase order price is the price of the vendor subcontracting work and
the materials provided by the subcontractor. You can define conditions for
subcontracting in a subcontracting purchasing info record.
17. Subcontracting Process
Inventory Management supports the following functions within subcontracting:
211
17. Subcontracting Process
212
Stock of Material Provided to Vendor
17. Subcontracting Process
213
Provision of Components
17. Subcontracting Process
There are different options available for providing components:
Transaction: MBLB = Stock with Subcontractor
214
17. Subcontracting Process
215
17. Subcontracting Process
Subsequent Adjustment
If the subcontractor reports an excess consumption or under consumption of subcontracting components after delivery of the finished product, you have to post a subsequent adjustment to correct the component consumption.
In the transaction for goods movement, MIGO, choose Subsequent Adjustment from the list of business transactions. As a reference document, the system automatically chooses Purchase Order. Enter the document number of the purchase order and the item number for which
Transfer Postings of Stock of Material Provided
The following transfer postings are allowed for the stock of material provided to vendor special stock:
To execute these transfer postings for the stock of material provided to the vendor, you have to specify the special stock indicator O.
216
18. Vendor Evaluation��
217
Vendor Evaluation Analyses
18. Vendor Evaluation��
218
Vendor Evaluation in Source Determination
18. Vendor Evaluation��
219
Scoring Levels in Vendor Evaluation
18. Vendor Evaluation��
220
Types of Subcriteria
18. Vendor Evaluation��
221
Automatic Subcriteria
18. Vendor Evaluation��
222
Manual Maintenance
18. Vendor Evaluation��
223
Automatic Reevaluation
18. Vendor Evaluation��
224
Evaluation in the Background
18. Vendor Evaluation��
225
Quantity Reliability
18. Vendor Evaluation��
226
On-time Delivery Performance
18. Vendor Evaluation��
227
Price Level
19. Reporting and Analysis Functions �
Standard Reports at Document Level
In a production environment, you generate a wide variety of documents including purchasing documents, material documents, invoice documents, and accounting documents. The documents are posted in the system and stored in database tables.
Standard reports enable you to evaluate this document information.
As well as analyzing documents, you can also run analyses of master data. For example, you can output a list of all purchasing info records for a material or vendor, or obtain an overview of the material master records for a certain material type.
SAP List Viewer and ALV Grid Control
The SAP List Viewer and ALV Grid Control standardize and simplify the handling of lists in SAP systems. There is a uniform user interface and list format for lists.
In this way, redundant functions can be avoided. ALV Grid Control is used not only in list displays (such as the list of material documents), but also in other transactions (for example, purchase requisition).
228
Standard Reports
19. Reporting and Analysis Functions
229
Standard Reports
19. Reporting and Analysis Functions
Functions of the SAP List Viewer / ALV Grid Control
230
Standard Reports
19. Reporting and Analysis Functions
Layout (Display Variant)
You can use layouts or change variants to change the appearance of many lists.
231
Standard Reports
19. Reporting and Analysis Functions
Variants
If you have to run reports or analyses with the same selection values at regular intervals, it is advisable to use variants.
To create a variant for a report, first enter the desired selection values on the initial screen for the report. Then choose Goto → Variants → Save as Variant... or
Save. On the following screen, you enter a Variant Name and a Description
for the variant and reselect Save.
If, during the execution of a variant you want to access a variant, choose Goto →
Variants → Get... or Get Variants... .
232
Standard Reports
19. Reporting and Analysis Functions
Reporting and Analysis Functions in Purchasing
You want to know the following, for example:
In Purchasing, you can influence the appearance of your list by using the scope-of-list and selection parameters (ex. Transaction ME80FN)
The selection parameter determines which purchasing documents are analyzed by the report. You can generate reports that select only open purchase orders, POs for which no invoice has yet been received, or expired scheduling agreements, for example.
The scope-of-list parameter determines which data is displayed for a selected document (which lines appear in your report).
233
Standard Reports
19. Reporting and Analysis Functions
234
Standard Reports
19. Reporting and Analysis Functions
Reporting and Analysis Functions in Inventory Management can be divided into three groups:
Document lists:
Stock lists:
235
Standard Reports
19. Reporting and Analysis Functions
Valuations in Invoice Verification (ex. Transaction MIR5)
The information provided by the list of invoice documents includes the following:
236
Standard Reports
19. Reporting and Analysis Functions
237
Logistics Information System (LIS)
Basic Structure and Concept of the LIS
In Logistics, you can distinguish between the following information systems:
- Sales Information System (SIS)
- Purchasing Information System (PURCHIS)
- Inventory Controlling (INVCO)
- Warehouse Management Information System (WMIS)
- Shop Floor Information System (SFIS)
- Quality Management Information System (QMIS)
- Plant Maintenance Information System (PMIS)
- Retail Information System (RIS)
19. Reporting and Analysis Functions
238
Logistics Information System (LIS)
Logistics Data Warehouse
19. Reporting and Analysis Functions
The information systems of the LIS are continuously supplied with data from the operative applications (Sales and Distribution, Purchasing, Production, Plant Maintenance and so on). This level is also known as Online Transaction Processing (OLTP). The data is derived from documents from SAP R/2, SAP R/3, or external/non-SAP systems.
Above the OLTP level is the Logistics Data Warehouse. For each business transaction within the operative application, important information is stored in aggregated form in separate databases of the Logistics Data Warehouse parallel to the OLTP level. In the process, first a quantitative reduction in the data volume takes place as a result of the period-wise updating, and second the information is qualitatively reduced to the statistically relevant portions.
The databases of the Logistics Data Warehouse are known as information structures. They constitute the data basis of the LIS.
The evaluation of the data is carried out at Online Analytical Processing (OLAP) level. A variety of reporting and analysis tools are available at this level.
239
19. Reporting and Analysis Functions
Logistics Information System (LIS)
240
19. Reporting and Analysis Functions
241
Reports List
MB5M – Lista stoc expirat;
MB5B – Stoc la data postarii;
MB5T – Stoc in tranzit;
MBLB – Stoc la Subcontractor;
MB54 – Lista stoc in custodie proprie;
MB5S – Lista Balanta GR/IR ;
MI20 – Lista Diferente Inventar;
MIR5 – Lista Facturi;
b) LIS
MC.A – Receptii/Consumuri;
MC.2 – Analiza Plant: Receptii/Consumuri;
MC$G – Analiza Valori Aprovizionate per Material;
MC$I – Analiza Cantitati Aprovizionate per Material;
MC$4 – Analiza Valori Aprovizionate per Vendor;
a) Standard SAP - MM
ME1L – Lista Inforecorduri dupa Vendor;
ME1M – Lista Inforecorduri dupa Material;
ME1W – Lista Inforecorduri dupa Grup Material;
ME0M – Lista Sursa dupa Material;
MKVZ – Lista Furnizori;
MM60 – Lista Materiale;
AC06 – Lista de Servicii;
MB20 – Lista Rezervari;
ME5A – Lista RN General;
ME5K – Lista RN dupa Asignare Cont;
MSRV2 – Lista RN dupa Serviciu;
ME4L – Lista RFQ dupa Vendor;
ME4M – Lista RFQ dupa Material;
MSRV4 – Lista RFQ dupa Serviciu;
ME2L – Lista CA dupa Vendor;
ME2M – Lista CA dupa Material;
ME80FN – Lista Documente Aprovizionare - Analize Generale;
MSRV3 – Lista CA dupa Serviciu;
MB51 – Lista Documente de Material;
MR51 – Lista Documente FI;
MBSM – Lista Documente de Material Anulate;
MBGR – Lista Documente de Material dupa Motiv Miscare;
MB52 – Stoc depozit;
MB53 – Stoc plant;
20. Evaluation
242
END OF DAY 5
Thank you.
Questions?
243