Showing posts with label Routines. Show all posts
Showing posts with label Routines. Show all posts

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


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