Author Archives: Kowboy

Openbravo ERP : Moving into Open Source ERP

Openbravo ERP instead of SAP? The past six years I worked with much pleasure in the SAP arena. I had the opportunity to work together with some of the larger corporations to help them achieve their ambitions. Part of my experiences is written down in this blog. Many people visit this blog on a daily [...]
Posted in Uncategorized | Tagged , , | 3 Comments

Distribution of Planned Independent Requirements in MRP

Distribution of planned independent requirements can be key in getting your MRP results exactly right. This post is about how to break down your Sales and Operations Plan and schedule it for MRP. E.g. Assume your SOP is planned in monthly buckets, but you plan your production in weekly buckets and you use forward scheduling [...]
Posted in MM, PP | Tagged , | Leave a comment

MC44 – Inventory Turnover (2)

In MC44 – Inventory Turnover (1) I explained the concept of Inventory Turnover and how it can be used. In this post I will explain the transaction itself. The transaction is mostly self-explanatory, but there is one option of particular importance.
Posted in MM, Process | Tagged , , | 1 Comment

Forecasting – Copy history

In forecasting it is fair to say that most forecast models only sensibly apply to high volume materials and that for low volume materials (although specific models exist)more manual intensive forecasting practices apply. A lot of customers prefer to use historical data one on one for the future predictions: May 2008 – 120 boxes sold [...]
Posted in PP | Tagged , | Leave a comment

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 [...]
Posted in MM, Process | Tagged , , | 10 Comments

MD04 – Download planning to Excel

Sometimes a planner wishes to share the planning status of a particular material with colleagues or partners that are not SAP users. In this case it is useful to download the planning overview to Excel and perhaps pimp the lay-out with some colorful headers. To do this -from within MD04 or MD07- go to Menu [...]
Posted in MM, PP | Tagged , , , | 2 Comments

Batch determination for IM

This blog offers a quick guide on how to use standard SAP Batch Determination for a material transfer.  For an internal goods movement we need SAP to pick the batch from stock with the earliest Shelf Life Expiration Date (SLED). We don’t want our fresh products terminate themselves from stock… 1. For this we will [...]
Posted in MM, PP, SD | Tagged , | 7 Comments

Unblock SD Documents

This post is an extension to a previous post on Credit Checks exceeded. When you are in a testing environment it is common that it’s difficult to quickly process sales orders and/or deliveries because the credit check is exceeded for a customer. Credit is building up, since so many sales orders and deliveries are entered [...]
Posted in SD | Tagged | 1 Comment

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 [...]
Posted in Basis | Tagged , | 8 Comments

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 [...]
Posted in Basis | Tagged , | Leave a comment