standard sap reports

Standard SAP SD Reports S.No. T-Code1 Sales summary - VC/2 VC/22 Display Customer Hierarchy - VDH2 VDH23 Display Condition record report - V/I6 V/I64 Pricing Report - V/LD V/LD5 Create Net Price List - V_NL V_NL6 List customer material info - VD59 VD597 List of sales order - VA05 VA058 List of Billing documents - VF05 VF059 Inquiries list - VA15 VA1510 Quotation List - VA25 VA2511 Incomplete Sales orders - V.02 V.0212 Backorders - V.15 V.1513 Outbound Delivery Monitor - VL06o VL06O14 Incomplete delivery - V_UC V_UC15 Customer Returns-Analysis - MC+A MC+A16 Customer Analysis- Sales - MC+E MC+E17 Customer Analysis- Cr. Memo - MC+I MC+I18 Deliveries-Due list - VL04 VL0419 Billing due list - VF04 VF0420 Incomplete Billing documents - MCV9 MCV921 Customer Analysis-Basic List - MCTA MCTA22 Material Analysis(SIS) - MCTC MCTC23 Sales org analysis - MCTE MCTE24 Sales org analysis-Invoiced sales - MC+2 MC+225 Material Analysis-Incoming orders - MC(E MC(E26 General- List of Outbound deliveries - VL06f VL06F27 Material Returns-Analysis - MC+M MC+M28 Material Analysis- Invoiced Sales - MC+Q MC+Q29 Variant configuration Analysis - MC(B MC(B30 Sales org analysis-Incoming orders - MC(I MC(I31 Sales org analysis-Returns - MC+Y MC+Y32 Sales office Analysis- Invoiced Sales - MC-E MC-E33 Sales office Analysis- Returns - MC-A MC-A34 Shipping point Analysis - MC(U MC(U35 Shipping point Analysis-Returns - MC-O MC-O36 Blocked orders - V.14 V.1437 Order Within time period - SD01 SD0138 Duplicate Sales orders in period - SDD1 SDD139 VL22

Reports in Sales and Distribution(LIS-SIS):

Display Delivery Changes - VL22

STANDARD REPORTS IN SAP

No Broad level Report Tcode in SAP

1 Purhase order analysis

By delivey schedule

ME80FN

2 Purchase order display

By supplier ME2L

By material ME2MBy buyerBy plant

3 Anlysis of order values

By Material

ME81NBy buyerBy supplier

4 Goods receipt forecastBy purchase order

ME2VBy vendorwiseBy material wise

5 Stock lying with subcontractorsBy Supplier

ME2OBy material

6 Monitor supplier confirmationBy Supplier

ME2ABy buyer

7 Purchase analysis

By buyer MCE1By Material MCE3By commodity type MCE5By supplier MCE7

MCE8

8 Long term planning analysisBy supplier MCEABy material MCEBBy commodity type MCEC

9 Material document listingBy Material

MB51By movement wiseBy supplier

10 Account document listingBy material

MR51By date

11 Stock OverviewBy material

MMBEBy PlantBy batch

12 Stock requirement listBy material

MD04By material planner

13 Plant Stock availability

By material MB52

Options available for report execution

By purchase order detailsBy purchase order hostory

13 Plant Stock availabilityBy material type MB53By buyer group MCBA

MCBEMCBR

14 Expiration date listBy material

MB5MBy PlantBy batch

15 Stock on posting dateBy material

MB5BBy PlantBy batch

16 Stock in transitBy material

MB5TBy supplying plantBy receiving plant

17 Stock with subcontractorBy plant

MBLBBy supplierBy plant

18 List of GR / IR balances

By material

MB5SBy supplierBy buyerBy Purchase order

19 MRP Controller analysis By inventory controller MCBG

20 Material usage based ABC AnalysisBy usage MC40By requirement MC41

21 Range of coverage

By usage MC42By requirement MC43

MC.GMC.4

22 Inventory turnover

By material MC44By commodity type MC.3By buyer MC.BBy material planner MC.7

Mc.O

23 Slow moving items

By material

MC46By commodity typeBy buyerBy material planner

24 Dead Stock items

By material


25 Usage value

By material


26 Sales analysis

By Customer MCTABy material MCTCBy sales person MCTEBy sales office MCTI

MCTG

27

Report on: - By material MC(AIncoming orders By Customer MC+AInvoiced sales By sales channels MC+ECredit Memo MC+ISales return MC+U

MC+Y

28

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

Executive wise

29 Vendoe master listBy Supplier

MKVZBy Purchase group

30 Status of indentsBy indent ME5ABy material ME5KBy buyer

31 Quotations listingBy suppliers ME4LBy mateial ME4MBy commodity group ME4C

32 Commodity price

By material ME1LBy plant ME1MBy Supplier ME1W

ME1P

33 Planned share of businessBy material

MEQMBy supplier

34 Vendor rating

By commodity ME64By commodity group ME6DBy supplier ME6C

ME65

35 Commodity listingBy commodity

MM60By plantBy commodity group

36Purchase value MC$G

Purchase quantity MC$1Quantity reliability MC$M

37 Availability overview CO09

38 Physical inventory listing MI24

39 Bill of Materials

Display BOM CS03

CS09Display BOM allocation to Plant

39 Bill of MaterialsWhere used list CS15BOM Comparison CS14

CS12

CS11

40 Work center information systemBy machine wise CR60By planner wise CR05By plant wise

41

Work cener analysis By lead times MCPBOperation analysis By date MCPY

By quantity MCPKMCPQ

42 Material analysis

By lead times MCPWBy date MCPFBy quantity MCPOBy product cost MC89By material consumption

43

Operation analysis By plant MCP1Material analysis By material MCP3

Work center analysis By order MCP5Production order analysis By machine MCPB

MCPUMCPW

44

In repetitive manufacturing set up: - By plant MCRPProduction analysis By material MCRK

Material consumption analysis By component used MCP6Product cost analysis

45 Pull list

By plant

MF60By materialBy quantityBy storage location

46

For process industry: - By plant MCP5By material MCRU

By orderMCRV

By machine MCRWMCRXMCRY

47 Kanban analysisBy plant

MCQ.By supply areaBy material

48 Kanban analysis

PK13

PK12

BOM explode - Multi levelBom explode - Level by level

By sales / production plan

Shop floor information system related to material analysis,

operation analysis, process order analysis, material usage analysis,

product cost analysis

By demand source overviewBy supply source overview

48 Kanban analysisBy plant overview PK11

PK18

49 Material usage analysis

By plant

MCREBy materialBy component usedBy order

50 Product cost analysis

By plant

MCRIBy materialBy component usedBy order

51 Product cost analysis - SummarisedBy hierarchy

KKBC_HOEBy period

52Cost Variance Target / Actual By plant

S_ALR_8701348Variance analysis

53 Missing parts checklist

By plant

CO24By materialBy component usedBy order

54 Order progress reportBy plant

CO46By materialBy order

55 Production order information system

By order

COOISBy MaterialBy plantBy production planner

56 Production order cost analysis By order KKBC_Ord

57By GL Account

58 Balance sheet / P&L statementBy financial statement

S_ALR_870122284By company code

59 S_ALR_87012253

60 Cash flow report S_ALR_87012271

61 GL BalancesS_ALR_87012277S_ALR_87012301

62Document Journal at summary level S_ALR_87012287Document Journal at line item level S_ALR_87012291

63

By company

S_ALR_87012332GL AccountCustomer accountSupplier Account

64 Customer payment history S_ALR_87012177

65 S_ALR_87012168

Actual comparison of financial results by period with previous

period

S_ALR_8701249 / 87012250 / 87012251 / 87012252

By Financial statement version

Plan / actual comparison on periodic basis

Statement of customer / vendor / GL Accounts

Due date analysis for customer open items

66 S_ALR_87012167

67 Customer balances S_ALR_87012172

68By Customer

S_ALR_87012176By Company

69 Vendor information systemBy company

S_ALR_87012077By supplier

70 Vendor businessBy company


71By company


72 Vendor payment historyBy company


73 Check registerBy bank

S_P99_41000101By amount

74 Asset HistoryBy Asset S_ALR_87012075By asset class AR02By company code

75 Depreciation simulation / forecastBy Asset

S_ALR_87012936By asset classBy company code

76 Posted depreciationBy Asset

S_P99_41000192By company code

77By Asset

J1IQBy company code

78 Asset Inventory list S_ALR_87011981

79By Cost Center S_ALR_87013611By cost center group S_ALR_87013615By version S_ALR_87013620

80By Cost Center

S_ALR_87013640By cost center group81 Cost center plan By cost center KSBL

82By plant S_P99_41000111By material number S_ALR_87013047

83 Profitability reportBy sales order

KE30By materialBy plant

84 Profit center reportS_ALR_87010777S_ALR_87010779

85 Display machine list

By machine number IH08By plant IW29By status IW33

IW39

86 MTTR / MTBR for machineBy machine number MCJB

Account receivable information system

Customer evaluation with open item sorted list

Due date analysis for supplier open items

Year end income tax depreciation report

Cost center accounting - Plan / Actual comparison

Cost center accounting - Actual / Actual comparison

Analyse / compare product cost estmates

86 MTTR / MTBR for machineBy machine number

MCJC

87 Damage analysisBy machine

MCI5By damage code

88 Breakdown analysisBy machine

MCI7By machine group

89 Maintenance cost analysisBy machine

MCI8By machine group

90 Customer notification analysis MCIA

91 History of inspection characteristics QGP1

92 Control ChartQGC1QGC2QGC3

93 Quality Notification analysisQM11QM15QM50

94 Defect analysis reportMCXXMCVXMCOX

95 Calliberation inspectionIP24IP19QA33

96 Project cost / revenue / expenditureS_ALR_87013531S_ALR_87013532

97 Batch where used list S_ALR_87012972

98 Engineering change managementS_ALR_87012975S_ALR_87012976

99 Module wise SAP1All Standard SAP Reports -- Module wise

STANDARD REPORTS IN SAP

Remarks Used by

Purchase Purchase

Purchase PurchaseClosed, No GR madeBill passing not done , etc.

Totals analysis

Purchase & Finance PurchaseABC analysisAnalysis using comparison periodFrequency analysisNumber of anticipated deliveries

Pruchase & Stores Purchase

Pruchase & Stores Purchase

Purchase

Purchase

Purchase

Stores / Finance Inventory

Finance Inventory

All Inventory

Planning Inventory

Stores / Purchase Inventory

Report area

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

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

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.This program is useful especially for imported purchase orders or such cases where the lead time of procurement is very high. Purchase &

planning

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

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

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

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

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

This report will help you to analyse material requirement plan 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 material exists, this report can give the information on stocks at various places

Stores / Purchase Inventory

Stores / Planning Inventory

Stores Inventory

Stores / Finance Inventory

Inventory

Purchase / Accounts Inventory

This report will help you in tracking the inventory by responsible person. Executive Inventory

Executive Inventory

Stores / Planning Inventory

Executive Inventory

This report will help you to identify slow moving items.

Executive Inventory

This report will help you to identify dead inventory

Executive Inventory

Executive Inventory

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

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

The report Stock for posting date lists a company's own stocks in a 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 material transfer is taking place.

This report provides an overview of the stocks of material provided to vendor Stores / Purchase /

Accounts

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.

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

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.

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

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.

All Sales

These reports can be used for seeking the information on billing

All Sales

All Sales

This report can give you the list of suppliersPurchase Purchase

PurchasePurchaseStores

Purchase

Purchase Manager

PurchaseFinance

Purchase

Purchase Manager

PurchaseQuality Manager

All Logistics

Logistics

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

InventoryFinance

All Production

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

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.

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

This report is useful to view / extract information on quotations from supplier in case the quotations are invited for a particular indent Purchase

Executives

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

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

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

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

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

Executives

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

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

All Production

Shop floorProductionCosting

Shop floor Manager Production

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

Executive Production

Planned order qty vs actual order qty,Planned cost vs actual cost,Planned consumption vs actual consumption

Shop floor Production


Shop floor

ProductionStores

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



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


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

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

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

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.

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

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

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

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


All Production

All Production


This report can give you information on the cost variance analysisExecutive 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



GL Finance

This report will give you balance sheet / P&LGL Finance

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

This report will give you cash flow. GL FinanceThis report can be used to display GL balances

GL Finance

This report is useful to extract information of GL entriesGL Finance

GL Finance

AR Finance

AR Finance

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

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

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

This report can give you information on target cost against actual cost for production orderThis 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

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

This report will help you to analyse history of customers. It contains a forecast of payment volumes and arrears.

AR Finance

AR Finance

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

AP Finance

AP Finance

AP Finance

AP Finance

This report is used to extract the information of check issuedBank Finance

Asset Finance

This is a report for the simulation of future depreciationAsset Finance

The report list the period values from posting depreciationAsset Finance

Asset Finance

Asset FinanceThis report lists actual and plan figures for cost center .

CCA Controlling

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

This report can be used to view cost center plan CCA ControllingThis report can give you the information on standard cost of material

PC Controlling

PA Controlling

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 repair.Shop floor Maintenance

The report is used for displaying the evaluations available in the 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 period.

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

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

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.

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

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

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

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



Service Maintenance

You can use this report to display inspection results for a task list characteristics Quality Quality MagtYou can get quality control charts are lot level / characteristics level

Quality Quality Magt




Projects Project System

For extracting the information of batch traceability Logistics LogisticsFor tracking engineering changes.

Logistics Logistics

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

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

This report will be used to extract information on planned cost and actual cost for different type of breakdown

This report can be used for reporting customer notifications. It can be used if service management functionality is put in use.

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

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

These reports gives you cost related information of projects. However it is necessary to implement Project systems module to extract these reports

standard sap reports

Documents