SAP ERP Standard Reports

Download (0)

Full text

(1)

No Broad level Report Options available for report execution

Tcode in SAP Remarks Used by Report area

1 Purhase order analysis By delivey schedule By purchase order details By purchase order hostory

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

Purchase Purchase

2 Purchase order display By supplier By material By buyer By plant

ME2L ME2M

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

Closed, No GR made Bill passing not done , etc.

Purchase Purchase

3 Anlysis of order values By Material By buyer By supplier

ME81N Totals analysis

ABC analysis

Analysis using comparison period Frequency analysis

Purchase & Finance

Purchase

4 Goods receipt forecast By purchase order By vendorwise By material wise

ME2V Number of anticipated deliveries Pruchase &

Stores

Purchase

5 Stock lying with subcontractors

By Supplier By material

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

6 Monitor supplier confirmation By Supplier By buyer

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

7 Purchase analysis By buyer By Material By commodity type By supplier MCE1 MCE3 MCE5 MCE7 MCE8

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

8 Long term planning analysis By supplier By material By commodity type

MCEA MCEB MCEC

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

9 Material document listing By Material By movement wise By supplier

MB51 This report provides you with a list of the material documents which were posted for one or more materials.

Stores / Finance

Inventory

10 Account document listing By material By date

MR51 The report Accounting documents for material produces a list containing all accounting documents available for a selected material.

Finance Inventory

11 Stock Overview By material By Plant By batch

MMBE The stock overview provides you with an overview of the current stocks of a material at all places within plant

All Inventory

12 Stock requirement list By material By material

MD04 This report will help you to analyse material requirement plan considering stocks and future requirements.

(2)

planner

13 Plant Stock availability By material By material type By buyer group MB52 MB53 MCBA MCBE MCBR

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

14 Expiration date list By material By Plant By batch

MB5M This report provides an overview of the remaining shelf life of batches. This report is generally useful in Pharma.

Stores / Planning

Inventory

15 Stock on posting date By material By Plant By batch

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

Stores Inventory

16 Stock in transit By material By supplying plant By receiving plant

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

17 Stock with subcontractor By plant By supplier By plant

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

Stores / Purchase / Accounts

Inventory

18 List of GR / IR balances By material By supplier By buyer By Purchase order

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

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 By requirement

MC40 MC41

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

21 Range of coverage By usage By requirement

MC42 MC43 MC.G MC.4

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

22 Inventory turnover By material By commodity type By buyer By material planner MC44 MC.3 MC.B MC.7 Mc.O

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

Executive Inventory

23 Slow moving items By material By commodity type By buyer By material planner

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

(3)

By commodity type By buyer By material planner

25 Usage value By material By commodity type By buyer By material planner

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

26 Sales analysis By Customer By material By sales person By sales office MCTA MCTC MCTE MCTI MCTG

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

All Sales 27 Report on: - Incoming orders Invoiced sales Credit Memo Sales return By material By Customer By sales channels MC(A MC+A MC+E MC+I MC+U MC+Y

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

28 Sale report with option like Area wise Statewise Executive wise By sales area By customer By material MC+2 MC+6 MCSI

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

29 Vendoe master list By Supplier By Purchase group

MKVZ This report can give you the list of suppliers Purchase Purchase

30 Status of indents By indent By material By buyer

ME5A ME5K

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

Purchase Stores

Purchase

31 Quotations listing By suppliers By mateial By commodity group ME4L ME4M ME4C

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

32 Commodity price By material By plant By Supplier ME1L ME1M ME1W ME1P

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

Purchase Manager Finance

Purchase

33 Planned share of business By material By supplier

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

34 Vendor rating By commodity By commodity group By supplier ME64 ME6D ME6C ME65

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

Purchase Manager Quality Manager

(4)

35 Commodity listing By commodity By plant By commodity group

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

All Logistics 36 Purchase value Purchase quantity Quantity reliability MC$G MC$1 MC$M

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

Purchase Executives

Logistics

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 Finance

Inventory

39 Bill of Materials Display BOM Display BOM allocation to Plant Where used list BOM Comparison BOM explode - Multi level Bom explode - Level by level CS03 CS09 CS15 CS14 CS12 CS11

This report can give you information related to Bill of materials, comparison of BOM between two materials etc.

All Production

40 Work center information system By machine wise By planner wise By plant wise CR60 CR05

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 Costing

Production

41 Work cener analysis Operation analysis By lead times By date By quantity MCPB MCPY MCPK MCPQ

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

Shop floor Manager

Production

42 Material analysis By lead times By date By quantity By product cost By material consumption By sales / production plan MCPW MCPF MCPO MC89

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,

Planned consumption vs actual consumption

Executive Production

43 Operation analysis Material analysis Work center analysis Production order analysis

By plant By material By order By machine MCP1 MCP3 MCP5 MCPB MCPU MCPW

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

44 In repetitive manufacturing set up: - Production analysis Material consumption analysis By plant By material By component used MCRP MCRK MCP6

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

(5)

Product cost analysis

45 Pull list By plant

By material By quantity By storage location

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

Shop floor Stores

Production

46 For process industry: - Shop floor information system related to material analysis, operation analysis, process order analysis, material usage analysis, product cost analysis

By plant By material By order By machine MCP5 MCRU MCRV MCRW MCRX MCRY

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

47 Kanban analysis By plant By supply area By material

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

Shop floor Production

48 Kanban analysis By demand source overview By supply source overview By plant overview PK13 PK12 PK11 PK18

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

49 Material usage analysis By plant By material By component used By order

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

All Production

50 Product cost analysis By plant By material By component used By order

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

All Production

51 Product cost analysis - Summarised

By hierarchy By period

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

Executive Production

52 Cost Variance Target / Actual Variance analysis

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

53 Missing parts checklist By plant By material By component used By order

CO24 Missing Part list check

54 Order progress report By plant By material By order

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

55 Production order information system

By order By Material By plant

(6)

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 By Financial statement version 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

58 Balance sheet / P&L statement

By financial statement By company code

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

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

S_ALR_87012301

This report can be used to display GL balances GL Finance

62 Document Journal at summary level

Document Journal at line item level

S_ALR_87012287

S_ALR_87012291

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

63 Statement of customer / vendor / GL Accounts By company GL Account Customer account Supplier Account

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

GL Finance

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 By Company

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

AR Finance

69 Vendor information system By company By supplier

S_ALR_87012077 This report is used for displaying the vendor payment information based on due date, over due, currency etc.

AP Finance

70 Vendor business By company By supplier

S_ALR_87012093 This report is to be used when you want to see the information of purchases made from a supplier

AP Finance

71 Due date analysis for supplier open items

By company By supplier

S_ALR_87012078 AP Finance

(7)

By supplier vendors. The report carrry out an analysis of the vendor open items according to user defined time pattern.

73 Check register By bank By amount

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

74 Asset History By Asset By asset class By company code

S_ALR_87012075 AR02

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

Asset Finance 75 Depreciation simulation / forecast By Asset By asset class By company code

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

76 Posted depreciation By Asset By company code

S_P99_41000192 The report list the period values from posting depreciation Asset Finance

77 Year end income tax depreciation report

By Asset By company code

J1IQ Asset Finance

78 Asset Inventory list S_ALR_87011981 Asset Finance

79 Cost center accounting - Plan / Actual comparison By Cost Center By cost center group By version S_ALR_87013611 S_ALR_87013615 S_ALR_87013620

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

80 Cost center accounting - Actual / Actual comparison

By Cost Center By cost center group

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

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 By material number S_P99_41000111 S_ALR_87013047

This report can give you the information on standard cost of material PC Controlling

83 Profitability report By sales order By material By plant

KE30 This report can give you profitability at the sales order level. However it is necessary to implement PA module

PA Controlling

84 Profit center report S_ALR_87010777

S_ALR_87010779

PA Controlling

85 Display machine list By machine number By plant By status IH08 IW29 IW33 IW39

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

86 MTTR / MTBR for machine By machine number

MCJB MCJC

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

Shop floor Maintenance

87 Damage analysis By machine By damage code

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

88 Breakdown analysis By machine By machine group

MCI7 This report can be used to extract the information on breakdown such as number of break down, MTTR, MTBF

Shop floor Maintenance

(8)

By machine group actual cost for different type of breakdown

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

QGC2 QGC3

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

93 Quality Notification analysis QM11 QM15 QM50

Quality Quality Magt

94 Defect analysis report MCXX

MCVX MCOX

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

Quality Quality Magt

95 Calliberation inspection IP24 IP19 QA33

These reports can be used for extracting information related to calliberation of equipments

Quality Quality Magt

96 Project cost / revenue / expenditure

S_ALR_87013531

S_ALR_87013532

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

97 Batch where used list S_ALR_87012972 For extracting the information of batch traceability Logistics Logistics

98 Engineering change management

S_ALR_87012975

S_ALR_87012976

For tracking engineering changes. Logistics Logistics

99 All Standard SAP Reports -- Module wise

Figure

Updating...

References

Related subjects :