How to Test BW Cube data with PSA Data
Objective
You would like to compare the contents of your InfoCube with data loaded from your source system into the PSA. In our example, we will check data that has been loaded for a specific customer.
Step 1
In the PSA tree of the Administrator Workbench, generate the Export DataSource on the PSA you want to check against via the context menu.
Step 2
In the source system tree, display the DataSource overview of the MYSELF BW system and locate your PSA Export DataSource. The technical name is the original DataSource name (to which the PSA belongs) prefixed with a “7”.
Step 3
From the context menu of the DataSource, choose “Assign InfoSource”.
Step 4
Enter a name for your new InfoSource and press the “Create”-button.
Step 5
Create an InfoSource for flexible update. This should be the default, so just press the green arrow to continue.
Step 6
Maintain the communication structure and transfer rules. Make sure that “REQUEST” is mapped to 0TCTREQUID (don`t change the default). The Transfer Method will automatically be set to “IDOC”. Activate your InfoSource.
Step 7
Create a RemoteCube to access data in the PSA.
Step 8
Choose a name and a description for the InfoCube. As InfoCube type choose “SAP RemoteCube” and enter the name of the InfoSource you have created in steps 4-6. Tick the “Clear Source System” checkbox since the BW System itself is the only source system of the RemoteCube.
Step 9
Select characteristics and key figures, create dimensions and assign the characteristics to the dimensions (no special modeling guidelines have to be followed for a RemoteCube). Activate your RemoteCube.
Step 10
From the context menu of the RemoteCube, choose “Assign Source Systems”
Step 11
Select the source system (the BW system itself) and save the assignment.
Step 12
Create a MultiProvider.
Step 13
Choose a name and a description for the new MultiProvider and press the “Create”-button.
Step 14
Select the InfoCube you want to check and the RemoteCube you have just created as the InfoProviders involved in the MultiProvider.
Step 15
Select the characteristics you need for your check reports. Make sure 0TCTREQUID is included.
Step 16
Identify characteristics and choose the key figures (from both InfoCubes) you would like to compare. Activate your MultiProvider.
Step 17
Create a query and include the characteristics you want to use, the Request ID from the DataPackage dimension and the Data Request (GUID) for the PSA request number. It is useful to include variables for your characteristics (otherwise you may get far too much data).
Step 18
Create selections for the Key Figures you want to check.
Step 19
In the first selection, use your Key Figures and the InfoProvider characteristic 0INFOPROV restricted to the InfoCube (0INFOPROV is automatically available in every MultiProvider).
Step 20
In the second selection, restrict the InfoProvider characteristic to the RemoteCube.
Step 21
Run the query. In our example, we are checking data for one customer.
Step 22
The result shows the data from PSA with corresponding Data Request (GUID) and the sum of the data from the InfoCube.
Step 23
If you drill down on Request ID, you get the data from the InfoCube displayed with the Request ID in the InfoCube (which you can see in the InfoCube Management).
Step 24
Optional: If you only want to check the data for the last request, you can add the variable 0LSTRQID to your InfoCube selection and…
Step 25
the variable 0MAPRQID to your RemoteCube selection. The latter is filled automatically with the PSA Request ID corresponding to the InfoCube Request ID filtered by in the first variable.
Step 26
The result will only show data loaded with the last request.
How to Test BW Cube data with PSA Data ( Data Reconsilation )
Posted by Sharath Labels: BI, Extraction, sap BI support issues, sap bw support issue, Supporting IssuesListed below are some of the frequently used Function Modules within BW.
Posted by Sharath Labels: BI, ExtractionFunction Module Description (Function Group RRMX)
RRMX_WORKBOOK_DELETE Delete BW Workbooks permanently from Roles & Favorites
RRMX_WORKBOOK_LIST_GET Get list of all Workbooks
RRMX_WORKBOOK_QUERIES_GET Get list of queries in a workbook
RRMX_QUERY_WHERE_USED_GET Lists where a query has been used
RRMX_JUMP_TARGET_GET Get list of all Jump Targets
RRMX_JUMP_TARGET_DELETE Delete Jump Targets
MONI_TIME_CONVERT Used for Time Conversions.
CONVERT_TO_LOCAL_CURRENCY Convert Foreign Currency to Local Currency.
CONVERT_TO_FOREIGN_CURRENCY Convert Local Currency to Foreign Currency.
TERM_TRANSLATE_TO_UPPER_CASE Used to convert all texts to UPPERCASE
UNIT_CONVERSION_SIMPLE Used to convert any unit to another unit. (Ref. table : T006)
TZ_GLOBAL_TO_LOCAL Used to convert timestamp to local time
FISCPER_FROM_CALMONTH_CALC Convert 0CALMONTH or 0CALDAY to Financial Year or Period
RSAX_BIW_GET_DATA_SIMPLE Generic Extraction via Function Module
RSAU_READ_MASTER_DATA Used in Data Transformations to read master data InfoObjects
RSDRI_INFOPROV_READ
RSDRI_INFOPROV_READ_DEMO
RSDRI_INFOPROV_READ_RFC Used to read InfoCube or ODS data through RFC
DATE_COMPUTE_DAY
DATE_TO_DAY Returns a number what day of the week the date falls on.
DATE_GET_WEEK Will return a week that the day is in.
RP_CALC_DATE_IN_INTERVAL Add/Subtract Years/Months/Days from a Date.
RP_LAST_DAY_OF_THE_MONTHS
SLS_MISC_GET_LAST_DAY_OF_MONTH Determine Last Day of the Month.
RSARCH_DATE_COVERT Used for Date Conversions. We can use in Info Package routines.
DATE_CHECK_PLAUSIBILITY - Used to validate dates
Avoid the SID Generation Error While Activating Data in a DSO
Posted by Sharath Labels: BI, ExtractionYou might run into one of these error messages while activating data in a DataStore object (DSO) either manually or from a process chain:
“Activation of M records from DataStore object terminated”
“Resource error. No batch process available. Process terminated”
“Time limit exceeded. No return of the split processes”
When you create a DSO, the system sets a system ID of SIDs Generation upon Activation by default. It is a check box option in the edit mode settings of the DSO. If this option is checked, the system checks the SID values for all of the characteristics in the DSO. If a SID value for the particular characteristic doesn’t exist, then the system generates the SIDs. So the SIDs Generation upon Activation option helps to improve the performance of the query as the system doesn’t have to generate SIDs at query runtime.
The general understanding is that the error messages in above Figure during activation of a DSO are due to the SIDs Generation upon Activation setting. However, we will show that the error messages are not due to this setting, but rather to incorrect parameterization of the processes to activate requests. This means that several background processes were running simultaneously (i.e., activation of requests in DSO and SID creation), resulting in the termination of the request. If a process chain is used for activation of a DSO, all the above processes still run simultaneously in the background. You can use transaction RZ04 to check how many background processes are available in the system at the time of load.
You can change the runtime parameters for this affected DSO by going to transaction RSODSO_SETTINGS. Note that transaction RSCUSTA2 is obsolete in SAP NetWeaver BI 7.0. In the RSODSO_SETTINGS screen select the DSO in question, Click on the Change button to change the runtime parameter. On the Maintenance of Runtime Param. screen click on the Change Process Params. button under Parameter for Activation as the issue right now is an activation error.
Alternatively, you can get to this screen from the context menu of the DSO by selecting Manage, which is the activation request that failed. Click on the Activate button just as you would to activate a request that is loaded to the activation queue. The Activate Data in DSO … window pops up. Click on the Activate in Parallel button. A pop-up window displays the process type ODSACTIVAT.
Maximum Wait Time for Process is set to 300 seconds by default, but you can increase it to a higher value if you think the system workload will be high. If you choose Dialog process as an option. then SAP recommends that the wait time in SAP NetWeaver BI should be three times higher than in R/3 (SAP Note 1118205). SAP Note 192658 also recommends that you set the maximum runtime for the work process as 3,600 seconds. After you click on the Change Process Params. button, you see the settings window.
Enter the Number of Processes. Under Parallel Processing, select Dialog. Select parallel generators in Server Group for Parallel Dialog Processing and then click on the save icon. You can re-initiate the failed activation again and the data should be activated now without any issues.
After the successful activation of data in the DSO, you can revert back to the normal settings for the DSO if necessary to avoid having too many dialog processes. If the activation of data in the DSO is done through process chains (transaction RSPC), you can access the settings. If many DSOs are failing in activation and the above parameters have to be changed for all of these DSOs, then SAP recommends updating the table RSBATCHPARALLEL directly. However, one should have security access to change the data in the tables directly and the steps we describe are easier to perform for individual DSOs.
MAINTAINING DATA QUALITY IN BW USING ERROR STACK
Posted by Sharath Labels: BI, End Routine, Expert Routine, Extraction, Start Routine, Supporting IssuesBy:Ramakrishna Gattikoppula (Infosys) Article (PDF 255 KB) 10 August 2010
OVERVIEW
This Article explains the different ways in which the incorrect data records can be moved to error stack when the data record is processed in the routines(Start, End, Characteristic or Expert Routines) of Transformation (In this case a data record is marked as incorrect based on Customer-specific requirements or Conditions).
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ebeb43-9e8a-2d10-b28e-825c0142ad4f?QuickLink=index&overridelayout=true
HOW TO USING EXPERT ROUTINE IN TRANSFORMATION
Posted by Sharath Labels: BI, End Routine, Expert Routine, Extraction, Routines, Start RoutineBy: 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
Duplicate record found when update master data
Posted by Sharath Labels: Data loading, Extraction, sap bi process chain issue, sap bi supportIt’s possible to select the following if update only to Master data.
Open the InfoPackage –> Update tab –> Error handling –>Valid records update, reporting possible
But if data is updated to both Master data and ODS, you don’t have above selection, or you get below error message.
You want to load data to a DataSource in an ODS, that requires serialization.
You are not able to filter out incorrect records and write them to a separate error request. Error handling reset to “No Update; No Reporting”
This method works.
Open infoPackage –> Processing tab –> Only PSA, update subsequently in Data Target
Also, you can change in Source system,
RSA2 –> find a pulldown list called “duplicate record” –> 0: do not allow duplicates
Also will help if you can remove duplicates in the package level. Sample:
# Keep the most recent record on top
Sort DATA_PACKAGE by [field 1] ascending
[field 2] ascending.
# Remove duplicates if not needed
Delete adjacent duplicates from DATA_PACKAGE comparing [field 1] [field 2].
If it happens in a data mart delta load to both Master data and other data targets, the default delta infoPackage doesn’t have a choice of PSA. You need to create your own infoPackage.
Also, program RSDMD_CHECKPRG_ALL can be used to correct inconsistencies on SID entries.
You can try RSRV as well.
All SAP Standard Reports
Posted by Sharath Labels: Difference between DTP and Infopackage, Extraction, Reporting, Routines, SAP bi certification material, SAP BI INTERVIEW QUESTIONS, sap BI support issues, Why DTP and not Infopackage in SAP BI
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
|