Did you know?
Did you know that you can also reach this blog by going to www.SAPMentalNotes.com?-
Recent Posts
Categories
Archives
Tag Archives: reporting
MC44 – Inventory Turnover (1)
Inventory Turnover is a prominent KPI in a lot of businesses. This post will give you some understanding on the concept. In another post I will give details on how the SAP report MC44 can be used to measure inventory turns and what data is used to calculate this ratio. Formula Inventory Turnover = Cost [...]
SQVI – Create quick report
In an earlier post I promised to give a quickguide to creating a query in SAP based in transaction SQVI. I’m going to show you how you can quickly build a custom report for reporting Sales Schedule Lines based on different filter criteria and multiple tables (VBAK, VBAP and VBEP: header, item and schedule line [...]
Test standard LIS analyses with different source versions
There are wonderful reports available in standard SAP’s Information Structures (E.g. MCxx reports). It can be so cruel though when data gets corrupted. You usually end up comparing report figures with whatever reasonable value you find elsewhere in SAP. If you want to be sure about the Information Structure’s reliability it is worthwhile to update [...]
Stock in previous periods: MC.9
Stock in previous periods can be a useful indicator in analyzing your stock positions through time per material or material group. Standard SAP report MC.9 offers this functionality:
Dead stock report – MC50
The dead stock report often leads to misinterpretations. Hence a little guidance on the dead stock report. The dead stock report analyses what part of stock is never touched in a defined period of time. If you look at the below graph you will see stock level through time. In analyzing stock movement between period [...]
Inventory Information System
I bet that if half the SAP end-users knew what wealth of stock information is stored in the inventory information system in SAP tons of money could be saved on custom reports (either R/3 or BW). You can find some cool KPIs in there: a.o. stock turnover, dead stock analysis, slow movers, ABC-analysis. Some fundamental [...]
MC44 – Inventory Turnover (2)