| There are lot's of reports available in SAP. Some of them will be describe here under. for the bespoke reports starting with " Z", some are only available in WP1 and some only available in PF1 |
|---|
COHVPI or COOISPI (almost the same report) : scheduling report. This report shows planned orders and/or process orders that needs to be produced. For process orders, produced quantities can also be displayed. In the COHVPI report, there is a direct access to CORS/COGI/COR6 transactions and allows also some mass processing
ZWPP07R (WP1) : This report provide the comparison between the produced quantities versus the scheduled quantities for the current month in a month-to-date mode.
ZWOCR05 (WP1) This report display all open orders in WP1
MB52 : display stock per material - batch numbers - storage location. unrestricted stock is visible but also under quality retention, blocked stock or also stock in transit.
ZWPP01C (WP1) is a very similar transaction as MB52 but gives more options at the selection screen
ZWPPSTOCK : this report shows the projected stock for materials. Could be finished products, intermediates, raw or pack materials. having the visibility of the projected stock, with a quick overview, you can detect if there is a shortage issue in the future for a material. A direct link to MD04 allows you to quickly have a look on where the problem is coming from. Some filters are available to finetune your selection and the elements you want to be displayed.
MC.9 : sometimes, the stock we need is the month end closure stock. Most of the stock transactions show the online stock. This LC.9 transaction show the stock at month end
ZDP_FORECAST: This video shows the forecast accuracy. total forecast, allocated quantities, shipped quantities are displayed and compared to total forecast.
MD73 : Display how the customer orders are allocated to the forecast.
ZWPP31A :This This report allows to mass export all elements that are available in MD04. From there, only your imagination can limit your report
Examples of possible reports using ZWPP31A:
MB51: This transaction shows all the movements done in SAP
Queries: SQ00 : It exist several queries in SAP. Those are related to datas or master data. Here under some interesting queries in PF1 and WP1
Remark : Most of the users does not have access to the user groups : you can run SQ00 but there is only few queries available. You need then to raise a ticket asking authorisation to run som user groups.
Here under, few interresting queries but, don't hesitate to try others if you need.
| Query description | PF1 | WP1 | ||
|---|---|---|---|---|
| User Group | Query Name | User Group | Query Name | |
| Material Master Data analysis (MRP fields) | PP-USER-ALL | Z_PP_MM02_B2B | Z_E2E_B2B | Z_MM02_B2B |
| BOM'S | PP-USER-ALL | Z_PP_BOM | Z_E2E_B2B | Z_B2BBOM |
| PP-REM : rate routings with valid production version | PP-USER-ALL | Z_PPB2B | ||
| PP_PI : master recipes with valid production version | Z_E2E_B2B | Z_MASTER_R_V2 | ||
| Stock transport orders | Z_E2E_B2B | Z_B2B_STO_SHIP | Z_E2E_B2B | Z_MASTER_R_V2 |
| Special Procurement type (to allow MRP to manage the interco stock transport requirements) | Z_E2E_B2B | Z_SPK | Z_E2E_B2B | Z_B2B_SPK |