Firming Types of the MRP Types and the Planning Time Fence

Background

There are a number of different MRP Types in the SAP ERP that are simply related to different fixing types. Here are several of the different MRP “MRP Types.”

P1 MRP, fixing type -1-
P2 MRP, fixing type -2-
P3 MRP, fixing type -3-
P4 MRP, fixing type -4-

“Fixing types” control several features of the MRP run. Some of the functions of the fixing type are documented in the SAP Help, and some are not. One of the most important which does not appear to be documented is if PReqs can be created in the past in the system. The graphic is the full description of firming types that I have compiled from SAP Help combined with observation of how the system works.

Planning Time Fence

A main component of how the Firming Types work is within the context of the Planning Time Fence. SAP’s definition of the Planning Time Fence is listed below:

You can protect the master plan from any automatic changes to master schedule items in the near future by using a planning time fence. Within the planning time fence, the system does not automatically schedule or change the procurement proposals. Therefore, the MRP controller has time to plan the master schedule items manually. However, to support the MRP controller, the system can create necessary procurement proposals and schedule them for the end of the planning time fence. You can then schedule these procurement proposals manually as you wish. – SAP Help

This point here is to twofold:

  1. Either do not auto-create any procurement proposals at all (this happens to be fixing type
  2. Or create new procurement proposals at the end of the planning time fence

In order to visualize the Planning Time Fence and how it interacts with various MRP Types, the graphic below has been included:

The Planning Time Fence can be set per product location combination.

Conclusion

Its interesting that so many funationalities are included in the MRP Type. The article below describes how the MRP Type was misnamed from the beginning.

http://www.scmfocus.com/sapplanning/2011/10/11/was-the-mrp-type-field-named-correctly/

For instance, one MRP Type is turns off the planning method so an external system can apply its own planning method, and only explodes the BOM. However, why try to combine BOM explosion and the planning method in a single field? This issue comes up again with respect to the different MPS MRP Types. One problem is that one of four factors of the MPS is that the BOM is not exploded. However, it does not explicitly state this in the MRP Type as it does with the X0 MRP type. SAP has tried to control too many factors with one field which leads to a lack of visibility with respect to everything that is controlled by the field. For instance it would have made more sense to have a separate field that controlled for BOM explosion that would have looked like the following:

 

 

Was the MRP Type Field Named Correctly?

Background

The MRP Type is a field on the Material Master in ERP which does two things:

  1. It controls the planning method (whether its MRP, MPS, Re-order Point Planning, etc..)
  2. It also serves as a “switch” which can prepare the ERP system to take a subordinate role (and can do so for any grouping of product location combinations), which can then allow an external planning system like APO or any other third-party system, to perform its own planning procedures.

One of the general misconceptions about MRP Types is that they only perform the first activity, when in fact the second activity is also important. A major problem with the MRP Type field is that it is not actually what it says it is and was misnamed from the beginning. Why I have never heard someone bring this up is strange because it is obviously the case. A simple example can prove this point. For instance, Time-phased planning and Manual reorder point planning, which are two of the MRP Types listed below, are not “types of MRP,” they are planning methods. Therefore calling the field MRP Type makes little sense. The only MRP types that are actual types of MRP are those colored in blue below:

Eleven MRP types are dedicated to both MRP and MPS. The four MPS are listed below in orange, and the 7 MRP are listed in blue.

M0 MPS, fixing type -0-
M1 MPS, fixing type -1-
M2 MPS, fixing type -2-
M3 MPS, fixing type -3-
M4 MPS, fixing type -4-
ND No planning
P1 MRP, fixing type -1-
P2 MRP, fixing type -2-
P3 MRP, fixing type -3-
P4 MRP, fixing type -4-
PD MRP
R1 Time-phased planning
R2 Time-phased w.auto.reord.point
RE Replenishment plnd externally
RF Replenish with dyn.TargetStock
RP Replenishment
RR Tmphsd. repl. w. dyn.trgt.stck
RS Time-phased replenishment plng
V1 Manual reord.point w. ext.reqs
V2 Autom. reord.point w. ext.reqs
VB Manual reorder point planning
VI Vendor Managed Inventory
VM Automatic reorder point plng
VS Seasonal MRP
VV Forecast-based planning
X0 W/O MRP, with BOM Explosion

The one above which is in red, says “MRP,” but of course it is without MRP. X0 does not perform MRP but does perform BOM Explosion. XO is the most common

These are the differences between the different MPS runs; these are the same differences between the 4 listed MRP runs.

Why So Many MRP and MPS Selections?

The reason there are so many MRP and MPS selections is because they are slight variations of each other that primarily have to do with firming and when procurement proposals are created.

0 – Procurement proposals are not firmed
1-Procurement proposals within the planning time fence are firmed automatically as soon as their date is at least one day before the end date of the planning time fence. The date of new procurement proposals created in the planning time fence is moved to the end date of the planning time fence. As a result, these new procurement proposals are not firmed.
2 -Procurement proposals within the planning time fence are firmed automatically as soon as their date is at least one day before the end date of the planning time fence. No new procurement proposals are created automatically within the planning time fence; that is, the shortage situation is not adjusted within the planning time fence.
3 – Procurement proposals within the planning time fence are not firmed automatically. All procurement proposals required to cover the requirements are moved to the end of the planning time fence.
4 -No procurement proposals are created automatically within the planning time fence; that is, the shortage situation is not adjusted within the planning time fence. - http://help.sap.com/saphelp_46c/helpdata/en/f4/7d30b644af11d182b40000e829fbfe/content.htm

Interestingly, the SAP documentation on this topic is incomplete. This is because some of these MRP types allow procurement proposals to be created in the past, which is not covered in the documentation. The graphic below shows the official SAP documentation converted to a matrix for better understanding.

 

The first five columns are from SAP documentation, and the sixth column is from observation of how the system operates. Obviously the SAP documentation does not explain all the differences between the firming types because if it did, some of the firming types would be duplicates.

MPS MRP Type?

MRP is one way of (sort of) implementing MPS, however MPS is not a form or type of MRP. In fact because MRP cannot be constrained, there is a question whether MRP can be a pure MPS. MRP can always be capacity leveled, but one of the requirements of MPS is that it is constrained. Constraining is one factor, but there are four factors that make up an MPS, which is listed in the link below.

http://www.scmfocus.com/supplyplanning/2011/10/02/the-four-factors-that-make-up-the-master-production-schedule/

Therefore, it is also inaccurate to list MPS as an MRP type, and in fact the field’s name is inaccurate in a number of different dimensions.

The APO Relevant Field

The APO Relevant Field controls if a product location combination will be “planned” in APO. However, its important to add more specifics to the term planned. This is because we generally speak of a product being planned in one system or another. For instance, the most common distinction is between critical products planned entirely in APO versus non-critical products being planned entirely (usually with MRP) in the ERP system. Under this design, the delineation between being “planned” in one system or another is very clear. However, this distinction becomes less clear when one of the planning stages is performed in one system and a second in another. This is because “planned in” is not a sufficiently detailed description to explain what is happening and where it is happening. A product can have the finished good planning performed in APO, but then the sub-components planned, either with MRP or with simple BOM explosion. For products with multiple nesting in their bill of material, the finished good could be planned in APO, with the semi-finished good and raw material planned in R/3, or both the finished good and semi-finished good could be planned in APO, and only the raw material planned in R/3.

Field Specifics

For a product to be planned in APO, the master data such as the product and location must be setup in APO, but also the transaction information must flow between APO and R/3. The APO Relevant Field sets this up properly for product locations that are not entirely planned in R/3 (again, a product location combination can be partially planned in APO and partially planned in R/3, however if any planning at all is to occur on a product location in APO, the APO Relevant Field on the Material Master in R/3 should be checked.) Without this field being checked, data will not flow between APO and R/3 as R/3 will assume all planning is being performed internal to R/3.

Conclusion

The MRP Type is not was it says it is, and has been misnamed. A better name would have been “planning method.” The frequent mis-naming of fields in SAP by people for which I can only suppose that English was a second language continues to cause large problems on SAP projects. I can think of no other supply chain vendor that continually mis-names its fields in this way, which is why it is important to describe the mis-naming for people on the project. The overall functionality of MRP and MPS could be explained better by SAP.

 

Field Drop Down for All Valid Values in SE16N

Background

Being a functional consultant I have always tended to go through the GUI transactions to get data in addition to SPRO. I have always been impressed with those who could navigate the tables in SAP and understand their relationships to one another. I have begun to use other best of breed applications by having Excel mapped to the tables, and I find it a much more logical and straightforward way to understand an application than by navigating through the user interface screens.

Extracting Data with SE16N on Sub-Fields

Something I started doing, which I though I would document is to use the SE16N transaction to find all options in a field rather than going through the transaction GUI and performing the drop down. See the screen shot below.

See below, I have performed a simple drop down and observed all the Material Types in the System.

I like to extract data from SAP and place master data like this in Excel, so I can use and external spreadsheet as a reference, and even keep it open on a separate screen while select or enter options into SAP. The print button will allow you to export the data contained in an *.xps file. This is a weird file format, but can be copied and pasted into Excel. I now have all the different material types kept separately.

Why MPS is Misnamed in SAP ERP

Background

On a number of occasions I hear the what is either the MRP run, the initial supply planning run or the network supply planning run referred to as the MPS (Master Production Schedule). Upon inquiring I often learn that the MPS is run for all products or for a single product. I have had a number of discussions with different people where I state that the MPS is not synonymous with the MRP run, or any of the other terms I have used above. They can be, but they are not necessarily the same.

How The Term MPS is Used

MPS is used in an indiscriminate manner. If the company is planning all products in ERP with MRP, they call that an MPS. Which in fact it isn’t. I find most companies using the term incorrectly. Secondly, even the official definition of MPS seems to have changed over time. If the main point is to describe the non-DRP/Deployment supply plan procedure, I think network or initial supply plan is better and actually much more accurate. These two terms do not change depending upon how many products (all or just the critical) are included in the planning run, and for that reason, it works better, it also works better in that its more descriptive of what is actually occurring.

MPS in SAP ERP

SAP’s use of the MRP terminology has not been helpful, and I think has led to more confusion on this topic. For instance, SAP places MRP functionality below a folder called “MPS.”

These are the same options, with slightly adjusted naming, that are found under the MRP folder under both normal production and process production. This is very common in SAP for the same functionality to be located in multiple places. Multilevel means exploding the BOM from top to bottom, while Single-Level means only planning at the level of product that is entered into the system.

If MPS were actually different from MRP, there would be some important differences. Notice the SAP statements below from SAP Help.

In the MPS menu there is a separate single-level planning run, which can be executed as single-item planning or total planning. This planning run only includes the master schedule items. Dependent requirements are created for the BOM level directly below the planning level. Levels below this, however, are not planned. This means that the MRP controller can authorize any changes to the master plan before they affect the various BOM levels. - SAP Help

That makes sense and meets the definition of an MPS. However, this in not reinforced by the menu items below. If what is documented in SAP Help is true, we would expect to find only “Single-Level Planning” under MPS, and not under MRP. However, we don’t find that in the SAP menu. Instead we find Single-Level Planning under both MRP and MPS. Why did SAP set this up in such a confusing manner?

Clearly, a user of the system could begin running this set of transactions and naturally begin to assume that they are running “MPS,” as SAP says they are.

Other Locations Where MPS or MRP are Indicated

The Material Master (product location combination) is coded with an MRP Type. However, this is another problem area terminologically because most of the methods have nothing to do with MRP. I would have preferred naming the field the “planning method.” This should be obvious as to why. For instance, Time-phased planning and Manual reorder point planning, which are two of the MRP Types listed below, are not “types of MRP,” they are planning methods. Therefore calling the field MRP Type makes little sense. The frequent misnaming of fields in SAP by people for which I can only suppose that English was a second language continues to cause large problems on SAP projects. I can think of no other supply chain vendor that continually misnames its fields in this way.

Ten MRP types are dedicated to both MRP and MPS. The four MPS are listed below in orange, and the 6 MRP are listed in blue.

M0 MPS, fixing type -0-
M1 MPS, fixing type -1-
M2 MPS, fixing type -2-
M3 MPS, fixing type -3-
M4 MPS, fixing type -4-
ND No planning
P1 MRP, fixing type -1-
P2 MRP, fixing type -2-
P3 MRP, fixing type -3-
P4 MRP, fixing type -4-
PD MRP
R1 Time-phased planning
R2 Time-phased w.auto.reord.point
RE Replenishment plnd externally
RF Replenish with dyn.TargetStock
RP Replenishment
RR Tmphsd. repl. w. dyn.trgt.stck
RS Time-phased replenishment plng
V1 Manual reord.point w. ext.reqs
V2 Autom. reord.point w. ext.reqs
VB Manual reorder point planning
VI Vendor Managed Inventory
VM Automatic reorder point plng
VS Seasonal MRP
VV Forecast-based planning
X0 W/O MRP, with BOM Explosion

The one above which is in red, says “MRP,” but of course it is without MRP. X0 does not perform MRP but does perform BOM Explosion. XO is the most common

Conclusion

A good starting place in building the understanding of something is to call things by the correct terminology. The overall functionality of MRP and MPS could be explained much better in SAP. Terminology inaccuracy is a major problem in supply chain planning because few people have undergraduate degrees or graduate degrees in these topics and tend to learn on the job or from books. I am afraid that the way SAP has named what is really just MRP functionality, in at least one of the folder trees in SAP ERP only serves to increase confusion with regards to the term MPS. In fact, there is a good argument that enhancements in computer hardware have reduced or even eliminated the need of having a separate MPS run. This perspective is described in this post below:

http://www.scmfocus.com/scmhistory/2011/10/how-mps-changed-through-time/

References

http://en.wikipedia.org/wiki/Master_production_schedule

Production and Inventory Control: Techniques and Principles 2nd Edition,” George Plossl, Prentice Hall, 1985

http://www.sap-img.com/production/difference-between-mrp-vs-mps.htm

Understanding MRP in APO and SAP ERP

Background

MRP is a mechanism for taking high level independent requirements and creating all of the sub-component and dependent requirements. How MRP is different from both advanced planning and another more advanced method of planning is discussed in this post.

http://www.scmfocus.com/inventoryoptimizationmultiechelon/2010/06/why-meio-is-as-different-from-aps-as-aps-is-from-mrp/

What is MRP?

This is a good description of MRP:

MRP works backward from a production plan for finished goods to develop requirements for components and raw materials. “MRP begins with a schedule for finished goods that is converted into a schedule of requirements for the subassemblies, component parts, and raw materials needed to produce the finished items in the specified time frame,” William J. Stevenson wrote in his bookProduction/Operations Management.”Thus, MRP is designed to answer three questions:whatis needed? how much is needed? and when is it needed?”

Using information culled from the bill of materials, master schedule, and inventory records file, an MRP system determines the net requirements for raw materials, component parts, and subassemblies for each period on the planning horizon. MRP processing first determines gross material requirements, then subtracts out the inventory on hand and adds back in the safety stock in order to compute the net requirements.

http://www.referenceforbusiness.com/small/Mail-Op/Material-Requirements-Planning-MRP.html#ixzz19eQzSfB1

Performing MRP in the Advanced Planning Engine?

MRP only exists in one place in APO. This is within two heuristics that have been created to emulate MRP. The two heuristics are listed below. One performs a top down MRP emulation, and the other performs a bottom up MRP emulation.

  • SAP_MRP_001 – Production planning (very fast) (applicable for mass applications) (shortage is shown using alerts) This procedure essentially blows out the MRP by the low level code (or the top item, then the subcomponents and so on). = MRP
  • SAP_MRP_002 – Product planning does the opposite. It plans all top level materials and components at once. (aka plan components immediately, if a dependent requirement was created for them in the planning of the superior product).

Read more about PP/DS heuristics here:

http://www.scmfocus.com/sapplanning/2008/09/21/ppds-and-snp-heuristics/

Its important to note that having MRP in an advanced planning engine such as APO is itself strange. APO is copied from other planning systems became commercially adopted in the mid 1990′s which were designed to be significant improvements over MRP, was found to have so many limitations. MRP is the oldest computerized material planning system and originates back in the 1960s. It was designed for the limited computing resources of the time.

How is MRP Used?

The normal use for MRP is for it to be performed in SAP ERP after the planning for critical items has been performed with CTM, heuristics or optimization in SAP APO. MRP is necessary in this instance, because both not all materials, and not all sub-components are actually in APO. Therefore, and MRP run is necessary once the planning results are passed to the execution system (SAP ERP), in order to “connect up the dots” Subcomponents and independent demand which is not considered critical (either unconstrained, or short lead time, or both) is typically not placed in the advanced planning engine, because its acquisition is considered automatic.


Reports from ECC with SAP1

Background

This transaction is very handy for listing all reports available within ERP. The transaction is SAP1. The results are sorted by area. Here I have opened the Sales Orders reports.

I ran into these reports when I needed to export data from ERP into APO and into a Key Figure in a Planning Book.