ERP Reports

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 24

Options available for report

No Broad level Report Tcode in SAP


execution
By delivey schedule

1 Purhase order analysis By purchase order details ME80FN

By purchase order hostory

By supplier ME2L

By material ME2M
2 Purchase order display
By buyer

By plant

By Material

By buyer
3 Anlysis of order values ME81N
By supplier

By purchase order

4 Goods receipt forecast By vendorwise ME2V

By material wise

By Supplier
5 Stock lying with subcontractors ME2O
By material

By Supplier
6 Monitor supplier confirmation ME2A
By buyer

By buyer MCE1

By Material MCE3

7 Purchase analysis By commodity type MCE5

By supplier MCE7

MCE8

By supplier MCEA

8 Long term planning analysis By material MCEB

By commodity type MCEC


By Material

9 Material document listing By movement wise MB51

By supplier

By material
10 Account document listing MR51
By date

By material

11 Stock Overview By Plant MMBE

By batch

By material
12 Stock requirement list MD04
By material planner

By material MB52

By material type MB53

13 Plant Stock availability By buyer group MCBA

MCBE

MCBR

By material

14 Expiration date list By Plant MB5M

By batch

By material

15 Stock on posting date By Plant MB5B

By batch

By material

16 Stock in transit By supplying plant MB5T

By receiving plant

By plant

17 Stock with subcontractor By supplier MBLB

By plant
By material

By supplier
18 List of GR / IR balances MB5S
By buyer

By Purchase order

19 MRP Controller analysis By inventory controller MCBG

By usage MC40
20 Material usage based ABC Analysis
By requirement MC41

By usage MC42

By requirement MC43
21 Range of coverage
MC.G

MC.4

By material MC44

By commodity type MC.3

22 Inventory turnover By buyer MC.B

By material planner MC.7

Mc.O

By material

By commodity type
23 Slow moving items MC46
By buyer

By material planner

By material

By commodity type
24 Dead Stock items MC50
By buyer

By material planner

By material

By commodity type
25 Usage value MC45
By buyer
25 Usage value MC45

By material planner

By Customer MCTA

By material MCTC

26 Sales analysis By sales person MCTE

By sales office MCTI

MCTG

Report on: - By material MC(A

Incoming orders By Customer MC+A

Invoiced sales By sales channels MC+E


27
Credit Memo MC+I

Sales return MC+U

MC+Y

Sale report with option like By sales area MC+2

Area wise By customer MC+6


28
Statewise By material MCSI

Executive wise

By Supplier
29 Vendoe master list MKVZ
By Purchase group

By indent ME5A

30 Status of indents By material ME5K

By buyer

By suppliers ME4L

31 Quotations listing By mateial ME4M

By commodity group ME4C

By material ME1L

By plant ME1M
32 Commodity price
By Supplier ME1W
32 Commodity price

ME1P

By material
33 Planned share of business MEQM
By supplier

By commodity ME64

By commodity group ME6D


34 Vendor rating
By supplier ME6C

ME65

By commodity

35 Commodity listing By plant MM60

By commodity group

Purchase value MC$G

36 Purchase quantity MC$1

Quantity reliability MC$M

37 Availability overview CO09

38 Physical inventory listing MI24

Display BOM CS03

Display BOM allocation to Plant CS09

Where used list CS15


39 Bill of Materials
BOM Comparison CS14

BOM explode - Multi level CS12

Bom explode - Level by level CS11

By machine wise CR60

40 Work center information system By planner wise CR05

By plant wise

Work cener analysis By lead times MCPB

Operation analysis By date MCPY


41
41
By quantity MCPK

MCPQ

By lead times MCPW

By date MCPF

By quantity MCPO
42 Material analysis
By product cost MC89

By material consumption

By sales / production plan

Operation analysis By plant MCP1

Material analysis By material MCP3

Work center analysis By order MCP5


43
Production order analysis By machine MCPB

MCPU

MCPW

In repetitive manufacturing set up: - By plant MCRP

Production analysis By material MCRK


44
Material consumption analysis By component used MCP6

Product cost analysis

By plant

By material
45 Pull list MF60
By quantity

By storage location

For process industry: - By plant MCP5


Shop floor information system related to
By material MCRU
material analysis,
operation analysis, process order analysis,
material usage analysis, product cost By order MCRV
46 analysis
By machine MCRW

MCRX
46

MCRY

By plant

47 Kanban analysis By supply area MCQ.

By material

By demand source overview PK13

By supply source overview PK12


48 Kanban analysis
By plant overview PK11

PK18

By plant

By material
49 Material usage analysis MCRE
By component used

By order

By plant

By material
50 Product cost analysis MCRI
By component used

By order

By hierarchy
51 Product cost analysis - Summarised KKBC_HOE
By period

Cost Variance Target / Actual


S_ALR_870134
52 By plant
8
Variance analysis

By plant

By material
53 Missing parts checklist CO24
By component used

By order

By plant

54 Order progress report By material CO46

By order
By order

By Material
55 Production order information system COOIS
By plant

By production planner

56 Production order cost analysis By order KKBC_Ord

By GL Account S_ALR_870124
Actual comparison of financial results by 9 / 87012250 /
57
period with previous period 87012251 /
By Financial statement version 87012252

By financial statement
S_ALR_870122
58 Balance sheet / P&L statement
284
By company code
S_ALR_870122
59 Plan / actual comparison on periodic basis
53
S_ALR_870122
60 Cash flow report
71
S_ALR_870122
77
61 GL Balances
S_ALR_870123
01
S_ALR_870122
Document Journal at summary level
87
62
S_ALR_870122
Document Journal at line item level
91
By company

GL Account
Statement of customer / vendor / GL S_ALR_870123
63
Accounts 32
Customer account

Supplier Account
S_ALR_870121
64 Customer payment history
77
S_ALR_870121
65 Due date analysis for customer open items
68
S_ALR_870121
66 Account receivable information system
67
S_ALR_870121
67 Customer balances
72
By Customer
Customer evaluation with open item S_ALR_870121
68
sorted list 76
By Company

By company
S_ALR_870120
69 Vendor information system
77
By supplier
By company
S_ALR_870120
70 Vendor business
93
By supplier

By company
S_ALR_870120
71 Due date analysis for supplier open items
78
By supplier

By company
S_ALR_870120
72 Vendor payment history
85
By supplier

By bank
S_P99_4100010
73 Check register
1
By amount
S_ALR_870120
By Asset
75
74 Asset History By asset class AR02

By company code

By Asset
S_ALR_870129
75 Depreciation simulation / forecast By asset class
36
By company code

By Asset
S_P99_4100019
76 Posted depreciation
2
By company code

By Asset
77 Year end income tax depreciation report J1IQ
By company code
S_ALR_870119
78 Asset Inventory list
81
S_ALR_870136
By Cost Center
11
Cost center accounting - Plan / Actual S_ALR_870136
79 By cost center group
comparison 15
S_ALR_870136
By version
20
By Cost Center
Cost center accounting - Actual / Actual S_ALR_870136
80
comparison 40
By cost center group

81 Cost center plan By cost center KSBL


S_P99_4100011
By plant
1
82 Analyse / compare product cost estmates
S_ALR_870130
By material number
47
By sales order

83 Profitability report By material KE30

By plant
S_ALR_870107
77
84 Profit center report
S_ALR_870107
79
By machine number IH08

By plant IW29
85 Display machine list
By status IW33

IW39

MCJB
86 MTTR / MTBR for machine By machine number
MCJC

By machine
87 Damage analysis MCI5
By damage code

By machine
88 Breakdown analysis MCI7
By machine group

By machine
89 Maintenance cost analysis MCI8
By machine group

90 Customer notification analysis MCIA

91 History of inspection characteristics QGP1

QGC1

92 Control Chart QGC2

QGC3

QM11

93 Quality Notification analysis QM15

QM50

MCXX

94 Defect analysis report MCVX


94 Defect analysis report

MCOX

IP24

95 Calliberation inspection IP19

QA33
S_ALR_870135
31
96 Project cost / revenue / expenditure
S_ALR_870135
32
S_ALR_870129
97 Batch where used list
72
S_ALR_870129
75
98 Engineering change management
S_ALR_870129
76
99 All Standard SAP Reports -- Module wise Module wise SAP1

QA33 :
Inspection Lot
List
Quality report
against
Inspection Lot -
Results

QC55 : Quality
Certificate List
MMBE :
in Procurements
Material stock
overview u2013
Quality /
Unrestricted /
MB52 : Ware
Block etc.
House stock &
Valuation
(Quality /
Unrestricted /
Block etc.)

MB51 : Material
document List

CC04 : Display
product
Structure
MCXC :
Material
Analysis (Month
wise)
MCXI : Material
analysis
MCXB :
Material
inspection result
analysis
MCVA : Vendor
analysis u2013
material
inspection lot
MCOA :
wise
Customer
analysis u2013
material
inspection lot
wise

QGA2 :
Inspection
results day wise
QS28 : List of
Master
Inspection
Characteristics

QS26 : MIC
where used lists

QS38 : List of
Inspection
methods
QS36 :
Inspection
method where
used lists.

QS49 : Code
Groups & Codes

QS59 : Selected
sets

QM11 : Display
Quality
notification Lists
QM19 :
Multilevel
Quality
notification List
MCXV : Quality
Notification
analysis

QP61 :
Inspection plan
change
Remarks Used by Report area

This report can be used for displaying the information of purchase orders
Purchase Purchase
created and the transactions that has taken place.

Facility available to restrict the viewing based on the status of PO viz.


Partly received,
Closed, No GR made
Purchase Purchase
Bill passing not done , etc.

Totals analysis

ABC analysis
Purchase & Finance Purchase
Analysis using comparison period

Frequency analysis

Number of anticipated deliveries Pruchase & Stores Purchase

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 Pruchase & Stores Purchase
visibility of stocks lying at subcontractor.

This program is useful especially for imported purchase orders or such


Purchase & planning Purchase
cases where the lead time of procurement is very high.

This program will give you information on purchase value, invoice


value during a selected period. However for these reports it is necessary Purchase Executives Purchase
to update the relevant LIS structure.

This report can be used for Purchase budget requirement. However for
this report to work, long term planning functionality should be put in Purchase Executives Purchase
use.
This report provides you with a list of the material documents which
Stores / Finance Inventory
were posted for one or more materials.

The report Accounting documents for material produces a list containing


Finance Inventory
all accounting documents available for a selected material.

The stock overview provides you with an overview of the current


All Inventory
stocks of a material at all places within plant

This report will help you to analyse material requirement plan


Planning Inventory
considering stocks and future requirements.

This report provides an overview of the stock situation of a given


material in selected plants. If there are multiple plants where the same
Stores / Purchase Inventory
material exists, this report can give the information on stocks at various
places

This report provides an overview of the remaining shelf life of batches.


Stores / Planning Inventory
This report is generally useful in Pharma.

The report Stock for posting date lists a company's own stocks in a
Stores Inventory
particular time period.

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 Stores / Finance Inventory
material transfer is taking place.

This report provides an overview of the stocks of material provided to


Stores / Purchase / Accounts Inventory
vendor
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
Purchase / Accounts Inventory
can thus be used to check goods and invoice receipts when purchasing
documents show some discrepancy.

This report will help you in tracking the inventory by responsible


Executive Inventory
person.

This report will help you in identifying the fast moving, slow moving /
non moving items. The report can be executed at the material level / Executive Inventory
plant level

This report will help you in getting the information of coverage of the
material for production purpose based on the past consumption pattern.
Stores / Planning Inventory
The report can be executed material wise, commodity type wise,
material planner wise etc.

This report will help you in getting the information on the inventory turn
Executive Inventory
over ratio.

This report will help you to identify slow moving items. Executive Inventory

This report will help you to identify dead inventory Executive Inventory

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 Executive Inventory
screen.
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 Executive Inventory
screen.

These reports can give you information regarding incoming sales order,
All Sales
credit memos, quantity, value etc.

These reports can be used for seeking the information on billing All Sales

The standard report MC+2 & MC+6 can meet the reporting requirement.
However in case the standard report are not serving the reporting
All Sales
requirement user defined info structure can be created and transaction
MCSI can be used for sales analysis.

This report can give you the list of suppliers Purchase Purchase

Purchase
This report can be used to seek the information of status of indent raised,
Stores Purchase
purchase order number, goods receipt status etc.

This report is useful to view / extract information on quotations from


Purchase Executives Purchase
supplier in case the quotations are invited for a particular indent

Purchase Manager

Finance
This report is useful to view the purchase order price change history for
Purchase
various pricing conditions
This report is useful to view the purchase order price change history for
Purchase
various pricing conditions

This report can be useful to know the % share of business planned with a
Purchase Executives Purchase
supplier in case multiple sources exist for a commodity.

Purchase Manager

Quality Manager
This report is useful to extract information of supplier performance on
Purchase
various parameters such as delivery, quality, cost etc.

This report will give you the list of all materials created in the system
All Logistics
with the parameter values

This report can be used by purchase buyer / manager to track purchase


Purchase Executives Logistics
performance

This report gives you the information of material availble for production Stores Inventory

Stores
This report may be used in case physical inventory system is followed in
Inventory
an organization
Finance

This report can give you information related to Bill of materials,


All Production
comparison of BOM between two materials etc.

Shop floor
This report will give you information of the machines used for the
purpose of manufacturing. The machines / work center could be labor Costing Production
work center also

This report can be used to extract the information of operation qy, scrap
Shop floor Manager Production
qty, lead time, target lead time etc.
This report can be used to extract the information of operation qy, scrap
Shop floor Manager Production
qty, lead time, target lead time etc.

This report is useful for giving the information of Target vs actual lead
time,
Planned order qty vs actual order qty,

Planned cost vs actual cost,


Executive Production
Planned consumption vs actual consumption

The order information system is a tool for shop floor control with a
reporting function for production orders and planned orders. These Shop floor Production
reports are useful in discreet manufacturing set up.

These reports are extensively used for reporting purpose in the repetitive
Shop floor Production
manufacturing environment

Shop floor

Stores
This report can be used in repetitive manufacturing environment to
Production
know the shortage of material for production

These reports are useful only when PP-PI component is installed. Shop floor Production
These reports are useful only when PP-PI component is installed. Shop floor Production

This report will give the information of Kanban usage. Can be used only
Shop floor Production
when Kanban component is used

This report can be used only when Kanban feature of SAP is used. Shop floor Production

This report can be used for analysing the actual material usage against
All Production
plan in manufacturing process.

This report can be used for finding out planned cost vs. actual cost in the
All Production
manufacturing process

This report can give you summrised information of all the production
Executive Production
orders related to cost & quantity

This report can give you information on the cost variance analysis Executive Production

Missing Part list check

This report can give you information of the order which is in process. Shop floor Production
This report give information on production order Shop floor Production

This report can give you information on target cost against actual cost
Executive Production
for production order
This report can give you financial statement for the selected period with
comparison. The report can be viewed on half yearly / quarterly /
GL Finance
periodic basis as well. For 10year comparison use transaction
S_ALR_87012257

This report will give you balance sheet / P&L GL Finance

This report will be useful incase you are using GL planning. GL Finance

This report will give you cash flow. GL Finance

This report can be used to display GL balances GL Finance

This report is useful to extract information of GL entries GL Finance

This report will give you statement of customer wise / Vendor wise / GL
GL Finance
wise accounts

This report will help you to analyse history of customers. It contains a


AR Finance
forecast of payment volumes and arrears.
AR Finance
The report is used for displaying the evaluations available in the
AR Finance
customer information system.
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 AR Finance
period.

This report can give you open AR sorted in days bucket as per your
AR Finance
selection

This report is used for displaying the vendor payment information based
AP Finance
on due date, over due, currency etc.
This report is to be used when you want to see the information of
AP Finance
purchases made from a supplier

AP Finance

This report is used for determining the current payment status for
vendors. The report carrry out an analysis of the vendor open items AP Finance
according to user defined time pattern.

This report is used to extract the information of check issued Bank Finance

It is the most important and most coprehensive report for the year-end
Asset Finance
clsoing or for an interim financial statement

This is a report for the simulation of future depreciation Asset Finance

The report list the period values from posting depreciation Asset Finance

Asset Finance

Asset Finance

This report lists actual and plan figures for cost center . CCA Controlling

This report can be used to compare the actual costs on period basis CCA Controlling

This report can be used to view cost center plan CCA Controlling

This report can give you the information on standard cost of material PC Controlling
This report can give you profitability at the sales order level. However it
PA Controlling
is necessary to implement PA module

PA Controlling

This report will give you the list of machines installed in the plant Shop floor Maintenance

This report can be used for extracting information on Meant time to


Shop floor Maintenance
repair.

This report can be used to extract the information on damage analysis Shop floor Maintenance

This report can be used to extract the information on breakdown such as


Shop floor Maintenance
number of break down, MTTR, MTBF

This report will be used to extract information on planned cost and


Shop floor Maintenance
actual cost for different type of breakdown

This report can be used for reporting customer notifications. It can be


Service Maintenance
used if service management functionality is put in use.
You can use this report to display inspection results for a task list
Quality Quality Magt
characteristics

You can get quality control charts are lot level / characteristics level Quality Quality Magt

You can get list of quality notification by this report Quality Quality Magt

This report can be used to view quality defects at material / vendor /


Quality Quality Magt
customer level
This report can be used to view quality defects at material / vendor /
Quality Quality Magt
customer level

These reports can be used for extracting information related to


Quality Quality Magt
calliberation of equipments

These reports gives you cost related information of projects. However it


is necessary to implement Project systems module to extract these Projects Project System
reports

For extracting the information of batch traceability Logistics Logistics

For tracking engineering changes. Logistics Logistics

Displays all the Standard report available in SAP in each module Logistics Logistics

You might also like