No
|
Broad level Report
|
Options available for report execution
|
Tcode
|
Remarks
|
Used by
|
Report area
|
1
|
Purhase order analysis
|
By delivey schedule
|
ME80FN
|
This report can be used for displaying the information of purchase orders created and the transactions that has taken place.
|
Purchase
|
Purchase
|
By purchase order details
| ||||||
By purchase order hostory
| ||||||
2
|
Purchase order display
|
By supplier
|
ME2L
|
Facility available to restrict the viewing based on the status of PO viz. Partly received,
|
Purchase
|
Purchase
|
By material
|
ME2M
|
Closed, No GR made
| ||||
By buyer
|
Bill passing not done , etc.
| |||||
By plant
| ||||||
3
|
Anlysis of order values
|
By Material
|
ME81N
|
Totals analysis
|
Purchase & Finance
|
Purchase
|
By buyer
|
ABC analysis
| |||||
By supplier
|
Analysis using comparison period
| |||||
Frequency analysis
| ||||||
4
|
Goods receipt forecast
|
By purchase order
|
ME2V
|
Number of anticipated deliveries
|
Pruchase & Stores
|
Purchase
|
By vendorwise
| ||||||
By material wise
| ||||||
5
|
Stock lying with subcontractors
|
By Supplier
|
ME2O
|
Can be useful in deciding which component is to be given to supplier if the procurement is on subcontracting basis. It also helps in giving the visibility of stocks lying at subcontractor.
|
Pruchase & Stores
|
Purchase
|
By material
| ||||||
6
|
Monitor supplier confirmation
|
By Supplier
|
ME2A
|
This program is useful especially for imported purchase orders or such cases where the lead time of procurement is very high.
|
Purchase & planning
|
Purchase
|
By buyer
| ||||||
7
|
Purchase analysis
|
By buyer
|
MCE1
|
This program will give you information on purchase value, invoice value during a selected period. However for these reports it is necessary to update the relevant LIS structure.
|
Purchase Executives
|
Purchase
|
By Material
|
MCE3
| |||||
By commodity type
|
MCE5
| |||||
By supplier
|
MCE7
| |||||
MCE8
| ||||||
8
|
Long term planning analysis
|
By supplier
|
MCEA
|
This report can be used for Purchase budget requirement. However for this report to work, long term planning functionality should be put in use.
|
Purchase Executives
|
Purchase
|
By material
|
MCEB
| |||||
By commodity type
|
MCEC
| |||||
9
|
Material document listing
|
By Material
|
MB51
|
This report provides you with a list of the material documents which were posted for one or more materials.
|
Stores / Finance
|
Inventory
|
By movement wise
| ||||||
By supplier
| ||||||
10
|
Account document listing
|
By material
|
MR51
|
The report Accounting documents for material produces a list containing all accounting documents available for a selected material.
|
Finance
|
Inventory
|
By date
| ||||||
11
|
Stock Overview
|
By material
|
MMBE
|
The stock overview provides you with an overview of the current stocks of a material at all places within plant
|
All
|
Inventory
|
By Plant
| ||||||
By batch
| ||||||
12
|
Stock requirement list
|
By material
|
MD04
|
This report will help you to analyse material requirement plan considering stocks and future requirements.
|
Planning
|
Inventory
|
By material planner
| ||||||
13
|
Plant Stock availability
|
By material
|
MB52
|
This report provides an overview of the stock situation of a given material in selected plants. If there are multiple plants where the same material exists, this report can give the information on stocks at various places
|
Stores / Purchase
|
Inventory
|
By material type
|
MB53
| |||||
By buyer group
|
MCBA
| |||||
MCBE
| ||||||
MCBR
| ||||||
14
|
Expiration date list
|
By material
|
MB5M
|
This report provides an overview of the remaining shelf life of batches. This report is generally useful in Pharma.
|
Stores / Planning
|
Inventory
|
By Plant
| ||||||
By batch
| ||||||
15
|
Stock on posting date
|
By material
|
MB5B
|
The report Stock for posting date lists a company's own stocks in a particular time period.
|
Stores
|
Inventory
|
By Plant
| ||||||
By batch
| ||||||
16
|
Stock in transit
|
By material
|
MB5T
|
This report issues a list with all stocks that are located in a plant's stock in transit. This information is useful when interplant / intercompnay material transfer is taking place.
|
Stores / Finance
|
Inventory
|
By supplying plant
| ||||||
By receiving plant
| ||||||
17
|
Stock with subcontractor
|
By plant
|
MBLB
|
This report provides an overview of the stocks of material provided to vendor
|
Stores / Purchase / Accounts
|
Inventory
|
By supplier
| ||||||
By plant
| ||||||
18
|
List of GR / IR balances
|
By material
|
MB5S
|
The report compares the GR quantities and values relating to a purchase order with the invoice quantities and values for the same PO. The report can thus be used to check goods and invoice receipts when purchasing documents show some discrepancy.
|
Purchase / Accounts
|
Inventory
|
By supplier
| ||||||
By buyer
| ||||||
By Purchase order
| ||||||
19
|
MRP Controller analysis
|
By inventory controller
|
MCBG
|
This report will help you in tracking the inventory by responsible person.
|
Executive
|
Inventory
|
20
|
Material usage based ABC Analysis
|
By usage
|
MC40
|
This report will help you in identifying the fast moving, slow moving / non moving items. The report can be executed at the material level / plant level
|
Executive
|
Inventory
|
By requirement
|
MC41
| |||||
21
|
Range of coverage
|
By usage
|
MC42
|
This report will help you in getting the information of coverage of the material for production purpose based on the past consumption pattern. The report can be executed material wise, commodity type wise, material planner wise etc.
|
Stores / Planning
|
Inventory
|
By requirement
|
MC43
| |||||
MC.G
| ||||||
MC.4
| ||||||
22
|
Inventory turnover
|
By material
|
MC44
|
This report will help you in getting the information on the inventory turn over ratio.
|
Executive
|
Inventory
|
By commodity type
|
MC.3
| |||||
By buyer
|
MC.B
| |||||
By material planner
|
MC.7
| |||||
Mc.O
| ||||||
23
|
Slow moving items
|
By material
|
MC46
|
This report will help you to identify slow moving items.
|
Executive
|
Inventory
|
By commodity type
| ||||||
By buyer
| ||||||
By material planner
| ||||||
24
|
Dead Stock items
|
By material
|
MC50
|
This report will help you to identify dead inventory
|
Executive
|
Inventory
|
By commodity type
| ||||||
By buyer
| ||||||
By material planner
| ||||||
25
|
Usage value
|
By material
|
MC45
|
This report identifies the share of the usage value to the total usage. You can also see the report graphically for a selected material in detail screen.
|
Executive
|
Inventory
|
By commodity type
| ||||||
By buyer
| ||||||
By material planner
| ||||||
26
|
Sales analysis
|
By Customer
|
MCTA
|
These reports can give you information regarding incoming sales order, credit memos, quantity, value etc.
|
All
|
Sales
|
By material
|
MCTC
| |||||
By sales person
|
MCTE
| |||||
By sales office
|
MCTI
| |||||
MCTG
| ||||||
27
|
Report on: -
|
By material
|
MC(A
|
These reports can be used for seeking the information on billing
|
All
|
Sales
|
Incoming orders
|
By Customer
|
MC+A
| ||||
Invoiced sales
|
By sales channels
|
MC+E
| ||||
Credit Memo
|
MC+I
| |||||
Sales return
|
MC+U
| |||||
MC+Y
| ||||||
28
|
Sale report with option like
|
By sales area
|
MC+2
|
The standard report MC+2 & MC+6 can meet the reporting requirement. However in case the standard report are not serving the reporting requirement user defined info structure can be created and transaction MCSI can be used for sales analysis.
|
All
|
Sales
|
Area wise
|
By customer
|
MC+6
| ||||
Statewise
|
By material
|
MCSI
| ||||
Executive wise
| ||||||
29
|
Vendoe master list
|
By Supplier
|
MKVZ
|
This report can give you the list of suppliers
|
Purchase
|
Purchase
|
By Purchase group
| ||||||
30
|
Status of indents
|
By indent
|
ME5A
|
This report can be used to seek the information of status of indent raised, purchase order number, goods receipt status etc.
|
Purchase
|
Purchase
|
By material
|
ME5K
|
Stores
| ||||
By buyer
| ||||||
31
|
Quotations listing
|
By suppliers
|
ME4L
|
This report is useful to view / extract information on quotations from supplier in case the quotations are invited for a particular indent
|
Purchase Executives
|
Purchase
|
By mateial
|
ME4M
| |||||
By commodity group
|
ME4C
| |||||
32
|
Commodity price
|
By material
|
ME1L
|
This report is useful to view the purchase order price change history for various pricing conditions
|
Purchase Manager
|
Purchase
|
By plant
|
ME1M
|
Finance
| ||||
By Supplier
|
ME1W
| |||||
ME1P
| ||||||
33
|
Planned share of business
|
By material
|
MEQM
|
This report can be useful to know the % share of business planned with a supplier in case multiple sources exist for a commodity.
|
Purchase Executives
|
Purchase
|
By supplier
| ||||||
34
|
Vendor rating
|
By commodity
|
ME64
|
This report is useful to extract information of supplier performance on various parameters such as delivery, quality, cost etc.
|
Purchase Manager
|
Purchase
|
By commodity group
|
ME6D
|
Quality Manager
| ||||
By supplier
|
ME6C
| |||||
ME65
| ||||||
35
|
Commodity listing
|
By commodity
|
MM60
|
This report will give you the list of all materials created in the system with the parameter values
|
All
|
Logistics
|
By plant
| ||||||
By commodity group
| ||||||
36
|
Purchase value
|
MC$G
|
This report can be used by purchase buyer / manager to track purchase performance
|
Purchase Executives
|
Logistics
| |
Purchase quantity
|
MC$1
| |||||
Quantity reliability
|
MC$M
| |||||
37
|
Availability overview
|
CO09
|
This report gives you the information of material availble for production
|
Stores
|
Inventory
| |
38
|
Physical inventory listing
|
MI24
|
This report may be used in case physical inventory system is followed in an organization
|
Stores
|
Inventory
| |
Finance
| ||||||
39
|
Bill of Materials
|
Display BOM
|
CS03
|
This report can give you information related to Bill of materials, comparison of BOM between two materials etc.
|
All
|
Production
|
Display BOM allocation to Plant
|
CS09
| |||||
Where used list
|
CS15
| |||||
BOM Comparison
|
CS14
| |||||
BOM explode - Multi level
|
CS12
| |||||
Bom explode - Level by level
|
CS11
| |||||
40
|
Work center information system
|
By machine wise
|
CR60
|
This report will give you information of the machines used for the purpose of manufacturing. The machines / work center could be labor work center also
|
Shop floor
|
Production
|
By planner wise
|
CR05
|
Costing
| ||||
By plant wise
| ||||||
41
|
Work cener analysis
|
By lead times
|
MCPB
|
This report can be used to extract the information of operation qy, scrap qty, lead time, target lead time etc.
|
Shop floor Manager
|
Production
|
Operation analysis
|
By date
|
MCPY
| ||||
By quantity
|
MCPK
| |||||
MCPQ
| ||||||
42
|
Material analysis
|
By lead times
|
MCPW
|
This report is useful for giving the information of Target vs actual lead time,
|
Executive
|
Production
|
By date
|
MCPF
|
Planned order qty vs actual order qty,
| ||||
By quantity
|
MCPO
|
Planned cost vs actual cost,
| ||||
By product cost
|
MC89
|
Planned consumption vs actual consumption
| ||||
By material consumption
| ||||||
By sales / production plan
| ||||||
43
|
Operation analysis
|
By plant
|
MCP1
|
The order information system is a tool for shop floor control with a reporting function for production orders and planned orders. These reports are useful in discreet manufacturing set up.
|
Shop floor
|
Production
|
Material analysis
|
By material
|
MCP3
| ||||
Work center analysis
|
By order
|
MCP5
| ||||
Production order analysis
|
By machine
|
MCPB
| ||||
MCPU
| ||||||
MCPW
| ||||||
44
|
In repetitive manufacturing set up: -
|
By plant
|
MCRP
|
These reports are extensively used for reporting purpose in the repetitive manufacturing environment
|
Shop floor
|
Production
|
Production analysis
|
By material
|
MCRK
| ||||
Material consumption analysis
|
By component used
|
MCP6
| ||||
Product cost analysis
| ||||||
45
|
Pull list
|
By plant
|
MF60
|
This report can be used in repetitive manufacturing environment to know the shortage of material for production
|
Shop floor
|
Production
|
By material
|
Stores
| |||||
By quantity
| ||||||
By storage location
| ||||||
46
|
For process industry: -
|
By plant
|
MCP5
|
These reports are useful only when PP-PI component is installed.
|
Shop floor
|
Production
|
Shop floor information system related to material analysis,
|
By material
|
MCRU
| ||||
operation analysis, process order analysis, material usage analysis, product cost analysis
|
By order
|
MCRV
| ||||
By machine
|
MCRW
| |||||
MCRX
| ||||||
MCRY
| ||||||
47
|
Kanban analysis
|
By plant
|
MCQ.
|
This report will give the information of Kanban usage. Can be used only when Kanban component is used
|
Shop floor
|
Production
|
By supply area
| ||||||
By material
| ||||||
48
|
Kanban analysis
|
By demand source overview
|
PK13
|
This report can be used only when Kanban feature of SAP is used.
|
Shop floor
|
Production
|
By supply source overview
|
PK12
| |||||
By plant overview
|
PK11
| |||||
PK18
| ||||||
49
|
Material usage analysis
|
By plant
|
MCRE
|
This report can be used for analysing the actual material usage against plan in manufacturing process.
|
All
|
Production
|
By material
| ||||||
By component used
| ||||||
By order
| ||||||
50
|
Product cost analysis
|
By plant
|
MCRI
|
This report can be used for finding out planned cost vs. actual cost in the manufacturing process
|
All
|
Production
|
By material
| ||||||
By component used
| ||||||
By order
| ||||||
51
|
Product cost analysis - Summarised
|
By hierarchy
|
KKBC_HOE
|
This report can give you summrised information of all the production orders related to cost & quantity
|
Executive
|
Production
|
By period
| ||||||
52
|
Cost Variance Target / Actual
|
By plant
|
S_ALR_8701348
|
This report can give you information on the cost variance analysis
|
Executive
|
Production
|
Variance analysis
| ||||||
53
|
Missing parts checklist
|
By plant
|
CO24
|
Missing Part list check
| ||
By material
| ||||||
By component used
| ||||||
By order
| ||||||
54
|
Order progress report
|
By plant
|
CO46
|
This report can give you information of the order which is in process.
|
Shop floor
|
Production
|
By material
| ||||||
By order
| ||||||
55
|
Production order information system
|
By order
|
COOIS
|
This report give information on production order
|
Shop floor
|
Production
|
By Material
| ||||||
By plant
| ||||||
By production planner
| ||||||
56
|
Production order cost analysis
|
By order
|
KKBC_Ord
|
This report can give you information on target cost against actual cost for production order
|
Executive
|
Production
|
57
|
Actual comparison of financial results by period with previous period
|
By GL Account
|
S_ALR_8701249 / 87012250 / 87012251 / 87012252
|
This report can give you financial statement for the selected period with comparison. The report can be viewed on half yearly / quarterly / periodic basis as well. For 10year comparison use transaction S_ALR_87012257
|
GL
|
Finance
|
By Financial statement version
| ||||||
58
|
Balance sheet / P&L statement
|
By financial statement
|
S_ALR_870122284
|
This report will give you balance sheet / P&L
|
GL
|
Finance
|
By company code
| ||||||
59
|
Plan / actual comparison on periodic basis
|
S_ALR_87012253
|
This report will be useful incase you are using GL planning.
|
GL
|
Finance
| |
60
|
Cash flow report
|
S_ALR_87012271
|
This report will give you cash flow.
|
GL
|
Finance
| |
61
|
GL Balances
|
S_ALR_87012277
|
This report can be used to display GL balances
|
GL
|
Finance
| |
S_ALR_87012301
| ||||||
62
|
Document Journal at summary level
|
S_ALR_87012287
|
This report is useful to extract information of GL entries
|
GL
|
Finance
| |
Document Journal at line item level
|
S_ALR_87012291
| |||||
63
|
Statement of customer / vendor / GL Accounts
|
By company
|
S_ALR_87012332
|
This report will give you statement of customer wise / Vendor wise / GL wise accounts
|
GL
|
Finance
|
GL Account
| ||||||
Customer account
| ||||||
Supplier Account
| ||||||
64
|
Customer payment history
|
S_ALR_87012177
|
This report will help you to analyse history of customers. It contains a forecast of payment volumes and arrears.
|
AR
|
Finance
| |
65
|
Due date analysis for customer open items
|
S_ALR_87012168
|
AR
|
Finance
| ||
66
|
Account receivable information system
|
S_ALR_87012167
|
The report is used for displaying the evaluations available in the customer information system.
|
AR
|
Finance
| |
67
|
Customer balances
|
S_ALR_87012172
|
This report will give you balance at the period start, debit total & credit total for the reporting period and closing balance at the end of reporting period.
|
AR
|
Finance
| |
68
|
Customer evaluation with open item sorted list
|
By Customer
|
S_ALR_87012176
|
This report can give you open AR sorted in days bucket as per your selection
|
AR
|
Finance
|
By Company
| ||||||
69
|
Vendor information system
|
By company
|
S_ALR_87012077
|
This report is used for displaying the vendor payment information based on due date, over due, currency etc.
|
AP
|
Finance
|
By supplier
| ||||||
70
|
Vendor business
|
By company
|
S_ALR_87012093
|
This report is to be used when you want to see the information of purchases made from a supplier
|
AP
|
Finance
|
By supplier
| ||||||
71
|
Due date analysis for supplier open items
|
By company
|
S_ALR_87012078
|
AP
|
Finance
| |
By supplier
| ||||||
72
|
Vendor payment history
|
By company
|
S_ALR_87012085
|
This report is used for determining the current payment status for vendors. The report carrry out an analysis of the vendor open items according to user defined time pattern.
|
AP
|
Finance
|
By supplier
| ||||||
73
|
Check register
|
By bank
|
S_P99_41000101
|
This report is used to extract the information of check issued
|
Bank
|
Finance
|
By amount
| ||||||
74
|
Asset History
|
By Asset
|
S_ALR_87012075
|
It is the most important and most coprehensive report for the year-end clsoing or for an interim financial statement
|
Asset
|
Finance
|
By asset class
|
AR02
| |||||
By company code
| ||||||
75
|
Depreciation simulation / forecast
|
By Asset
|
S_ALR_87012936
|
This is a report for the simulation of future depreciation
|
Asset
|
Finance
|
By asset class
| ||||||
By company code
| ||||||
76
|
Posted depreciation
|
By Asset
|
S_P99_41000192
|
The report list the period values from posting depreciation
|
Asset
|
Finance
|
By company code
| ||||||
77
|
Year end income tax depreciation report
|
By Asset
|
J1IQ
|
Asset
|
Finance
| |
By company code
| ||||||
78
|
Asset Inventory list
|
S_ALR_87011981
|
Asset
|
Finance
| ||
79
|
Cost center accounting - Plan / Actual comparison
|
By Cost Center
|
S_ALR_87013611
|
This report lists actual and plan figures for cost center .
|
CCA
|
Controlling
|
By cost center group
|
S_ALR_87013615
| |||||
By version
|
S_ALR_87013620
| |||||
80
|
Cost center accounting - Actual / Actual comparison
|
By Cost Center
|
S_ALR_87013640
|
This report can be used to compare the actual costs on period basis
|
CCA
|
Controlling
|
By cost center group
| ||||||
81
|
Cost center plan
|
By cost center
|
KSBL
|
This report can be used to view cost center plan
|
CCA
|
Controlling
|
82
|
Analyse / compare product cost estmates
|
By plant
|
S_P99_41000111
|
This report can give you the information on standard cost of material
|
PC
|
Controlling
|
By material number
|
S_ALR_87013047
| |||||
83
|
Profitability report
|
By sales order
|
KE30
|
This report can give you profitability at the sales order level. However it is necessary to implement PA module
|
PA
|
Controlling
|
By material
| ||||||
By plant
| ||||||
84
|
Profit center report
|
S_ALR_87010777
|
PA
|
Controlling
| ||
S_ALR_87010779
| ||||||
85
|
Display machine list
|
By machine number
|
IH08
|
This report will give you the list of machines installed in the plant
|
Shop floor
|
Maintenance
|
By plant
|
IW29
| |||||
By status
|
IW33
| |||||
IW39
| ||||||
86
|
MTTR / MTBR for machine
|
By machine number
|
MCJB
|
This report can be used for extracting information on Meant time to repair.
|
Shop floor
|
Maintenance
|
MCJC
| ||||||
87
|
Damage analysis
|
By machine
|
MCI5
|
This report can be used to extract the information on damage analysis
|
Shop floor
|
Maintenance
|
By damage code
| ||||||
88
|
Breakdown analysis
|
By machine
|
MCI7
|
This report can be used to extract the information on breakdown such as number of break down, MTTR, MTBF
|
Shop floor
|
Maintenance
|
By machine group
| ||||||
89
|
Maintenance cost analysis
|
By machine
|
MCI8
|
This report will be used to extract information on planned cost and actual cost for different type of breakdown
|
Shop floor
|
Maintenance
|
By machine group
| ||||||
90
|
Customer notification analysis
|
MCIA
|
This report can be used for reporting customer notifications. It can be used if service management functionality is put in use.
|
Service
|
Maintenance
| |
91
|
History of inspection characteristics
|
QGP1
|
You can use this report to display inspection results for a task list characteristics
|
Quality
|
Quality Magt
| |
92
|
Control Chart
|
QGC1
|
You can get quality control charts are lot level / characteristics level
|
Quality
|
Quality Magt
| |
QGC2
| ||||||
QGC3
| ||||||
93
|
Quality Notification analysis
|
QM11
|
Quality
|
Quality Magt
| ||
QM15
| ||||||
QM50
| ||||||
94
|
Defect analysis report
|
MCXX
|
This report can be used to view quality defects at material / vendor / customer level
|
Quality
|
Quality Magt
| |
MCVX
| ||||||
MCOX
| ||||||
95
|
Calliberation inspection
|
IP24
|
These reports can be used for extracting information related to calliberation of equipments
|
Quality
|
Quality Magt
| |
IP19
| ||||||
QA33
| ||||||
96
|
Project cost / revenue / expenditure
|
S_ALR_87013531
|
These reports gives you cost related information of projects. However it is necessary to implement Project systems module to extract these reports
|
Projects
|
Project System
| |
S_ALR_87013532
| ||||||
97
|
Batch where used list
|
S_ALR_87012972
|
For extracting the information of batch traceability
|
Logistics
|
Logistics
| |
98
|
Engineering change management
|
S_ALR_87012975
|
For tracking engineering changes.
|
Logistics
|
Logistics
| |
S_ALR_87012976
| ||||||
99
|
All Standard SAP Reports -- Module wise
|
Module wise
|
SAP1
|
Displays all the Standard report available in SAP in each module
|
Logistics
|
Logistics
|
All SAP Standard Reports
Posted by Sharath Labels: Difference between DTP and Infopackage, Extraction, Reporting, Routines, SAP bi certification material, SAP BI INTERVIEW QUESTIONS, sap BI support issues, Why DTP and not Infopackage in SAP BI
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment