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;

Remark : if there is no link to a training material, this means the transaction is very simple to use.

SCHEDULING

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.

CM01 / CM50  : capacity analysis. this transaction allows to check capacity utilisation by production line.  In order to have arealistic report, it is mandatory to update the available capacity using CRC2 for PP-REM and CR02 for PP-PI plants.

SALES ORDERS

ZWOCR05 (WP1) This report display all open orders in WP1

Z1V_LIST_ORDERS. This report allow to display all sales orders shipped, not shipped yet, already converted to delivery etc...

STOCKS

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

MMBE : gives the stock for one material with all details by storage location and batch number

MB5B : gives the stock at a certain date + all movements done between 2 dates.

MB5T : in transit stock. The intransit stock needs to be checked on a regular basis.  This represent what is on the way between 2 plants.  The rule is to always good receipt what has been good issued at the sourcing plant.  If there i a difference  between the announced stock in the truck and the real stock, the correction needs to be done at the receiving plant or at the soucing plant but never let the stock in transit.

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

FORECAST REPORTING

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.

MISCELLANEOUS

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 descriptionPF1WP1

User GroupQuery NameUser GroupQuery Name
Material Master Data analysis (MRP fields)PP-USER-ALLZ_PP_MM02_B2BZ_E2E_B2BZ_MM02_B2B
BOM'SPP-USER-ALLZ_PP_BOMZ_E2E_B2BZ_B2BBOM
PP-REM : rate routings with valid production versionPP-USER-ALLZ_PPB2B

PP_PI : master recipes with valid production version

Z_E2E_B2BZ_MASTER_R_V2
Stock transport ordersZ_E2E_B2BZ_B2B_STO_SHIPZ_E2E_B2BZ_MASTER_R_V2
Special Procurement type (to allow MRP to manage the interco stock transport requirements)Z_E2E_B2BZ_SPKZ_E2E_B2BZ_B2B_SPK