HOW TO USING EXPERT ROUTINE IN TRANSFORMATION

By: P Renjith Kumar SDN Article (PDF 382 KB) 18 August 2010

OVERVIEW
This document will give you a basic overview of creating an expert routine in transformation.


http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a056f726-59eb-2d10-9db3-eb11f0c1e9e4?QuickLink=index&overridelayout=true

All SAP Standard Reports

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