Skip to Content
Author's profile photo Stefan Weisenberger

How to model cream cheese coils in SAP?


Picture courtesy of GroupRecipes

After work, I love to bake with my kids – mostly pastry, cakes and the likes. When I came across this recepy for cream cheese coils I realized there is more to coil than steel. And encounters at various Sapphire’s and other large events came to my mind – there has always been the occasional visitor at the mill products booth asking for SAP for flour & millers. Well, you can discuss cakes & buns with me – but not in SAP.


When I am asked (especially in geographies where “mill products” is not a common term) why we group industries like paper, metals, flat glass, textiles and others: they struggle with similar challenges in master data modeling. I even read an analyst quote that a standard ERP package would not fit this industry. His main point was that this industry does not operate with SKUs, but with dimensions and attributes. I agree.


Steel coils, sheets of flat glass, rolls of paper, plastic tubes or drums of cable are rarely described with a single product code like an off-the-shelf product. More often it’s a range of attributes that describe it. Sometimes just a few, sometimes several hundred.  Take the cable example. The single most important characteristics is length. For a sheet it’s length and width. For a plate add thickness.
Surely, with grades, surface treatments, and more sophisticated shapes like a tube or even a corrugated box (check out the fefco codes – you will be amazed by the varieties) you will result in many more attributes.


How do we typically model these in SAP’s master data model?

Before I try to answer this, let us introduce the candidates:

  1. The classical material master– simple, straightforward  and a little rigid
  2. The configurable material – highly flexible, but how do you deal with this in inventory?
  3. The material variant – the smaller brother of the configurable material
  4. The batch – neither the chemical batch, nor production lot – but an even leaner entity in inventory.


Each of these can carry attributes in various classtypes, and I have seen actually all of these in use in the one or the other implementation project in mill products. So the answer is not all that obvious. I would like to start this blog series with the simple one – the “ordinary” batch.  (Why ordinary? I will not talk about original batch, WIP batch, documentary batch or other special concepts in this first blog).



Some typical use cases for batches in mill products

  1. A coil of steel with dimensional attributes length, width and thickness (and many more to describe other aspects of this specific item)
  2. One single piece of cable with a specific length
  3. Several pieces of cable, all with the same length
  4. A single steel tube with inner, outer diameter and length
  5. A bundle of tubes – all identical
  6. Tubes in a rack that are grouped in a length range e.g. 5,5 -6m


Looking at these examples – we in mill products use SAP batches for a different purpose than you would in chemicals. For them a batch is a production lot. For us more a logistical entity, a piece, or a group of pieces with certain attributes.


Customers using batches often do this to simplify their master data. They can manage millions of batches under one material master. All of them share BOM, routing, costing and valuation and many of the other features related to the material master. But they are managed separately in the logistic processes.

And this is also one of the main reasons why some customer do not use batches: They do not want to enter material master plus batch during all goods movements and inventory operations. If you are not interested in the different attributes or dimensions per item but only in serialization of items (as often in high tech or component manufacturing) a batch may be too heavy for your users. If you need the dimensions, as we do in most mill use cases, the batch is your friend.


We use batch classification to describe the attributes of an item, or a group of items.

We use batch specific units of measure, or product units of measure, if we need to manage items in several units of measure e.g. manage a steel plate both in pieces and in kilogramm. The SAP documentation gives an easy example how to calculate the weight of plate in kilogram (in many cases the base unit of measure) from the length, width, thickness and density by a formula (which we call “object dependency). At the 2012 Configuration Workgroup conference this was explained in much more depth (get registered for free, and check this presentation.)


When I would not use a batch?

  • Standard lengths that you would like to sell through a separate material master and SKU name
    Here a material variant is my preferred option – I find this easier to integrate in the sales process.
  • Serialized items which only need an individual name and no further logistical support
    Typically our discrete colleagues use the serial number. But as soon you need more logistics and traceability for the item, a batch may be the better choice.

The batch is my best friend – how about you?

Did you try to model without batches, and would like to share your experiences?
Did you use batches – what were your biggest challenges?


In the next issue of this blog series I will discuss the other canditates, specifically variant configuration, and how you could use this across the different industries in mill products and mining.

Assigned tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ritesh Dube
      Ritesh Dube

      A very nice and informative blog Stefan Weisenberger, thanks for sharing it.

      Author's profile photo abilash n
      abilash n

      Informative blog.. please continue excellent work...

      Author's profile photo Stefan Weisenberger
      Stefan Weisenberger
      Blog Post Author

      If you are interested in a concise overview of batch management, there is a new book announced by SAP Press. I had several touch points with Andreas, the author.

      Currently, the announcement is out only in German for Chargenverwaltung mit SAP (Batch Management with SAP):

      Author's profile photo Former Member
      Former Member

      Nice writeup. Looking forward to the Documentary Batch (for situations when your distribution center really doesn't like to deal with batches of cream cheese coils, but Mfg wants traceablity). Also when I make many batches of cream cheese coils and use many batches of flour - how do I trace what batch of flour went into what batch of cream cheese coils - all on the same order? (WIP batch?) or Auto goods receipt?

      Author's profile photo Stefan Weisenberger
      Stefan Weisenberger
      Blog Post Author

      Hi Charles,

      if we are talking about n:m batch assignment in detail, there are 2 options:

      • WIP batch

      I know this concept exists in repetitive manufacturing and can be posted if you post GR and GI in one step (at the same time).

      We also have this in the context of subcontracting. There we actually link goods issue batches and goods receipt batches by material document, and not by subcontractor purchase order.

      So imagine you post first goods issue for component batch CB1 and CB2, and in the same goodsmovement document the receipt for "finished product" FB3, the batch where used list would build the link based on this goods movement doc, and not by merging all posting of a purchase order into one batch whereused entry.

      Hope this helps.

      Regards, Stefan


      Author's profile photo Former Member
      Former Member

      I have one more question for you. When you use batches to differentiate rolls but the rolls are certified at a higher level (lets say "run" - which would represent a set of rolls/batches) how do you avoid a WRICEF when it comes time to create a certificate of analysis for the "run"?  Run as a batch characteristic can be used to group. No out of the box SAP functionality I've ever seen can do this.

      Author's profile photo Stefan Weisenberger
      Stefan Weisenberger
      Blog Post Author

      Sorry Charles, I would have assumed you can create a certificate based on an original batch, and the original batch would be a good bundling object for the run.
      But I am not consultant and have never tried to create a certificate myself.

      Author's profile photo Nguyen Cong Tan
      Nguyen Cong Tan

      Dear Stefen,

      I have problem a about how to define batch model for each cone.
      My customer is the Synthertic Fiber company.

      Every day, 35000 cones has been producted.

      If i define what each cone is a batch, there are many material document line for issue/ receipt every day.
      So that, my system is very slow and i can not run tcode MB51, MB52,... to control data.

      Please help me solve this problem!

      Thanks for your support!



      Author's profile photo Stefan Weisenberger
      Stefan Weisenberger
      Blog Post Author

      Hello Binh,

      there are different modeling approaches, and this answer cannot replace a consulting engagement.

      The key questions, in my opinion, is the granularity of information you need further on.

      Often, we model all similar cones (with the same length of yarn and the same dye lot) as instances of the same batch. I have seen similar approaches for metals tube, cable drums etc.

      If each is different (and requires different batch classification attributes) each is a separate batch.
      Same applies if you need traceability for each separate cone.

      Does this help?

      Regards, Stefan

      Author's profile photo Nguyen Cong Tan
      Nguyen Cong Tan

      Dear Stefan,

      Thank for your support.

      Currently, the weight of cones are difference, all characteristisc of each cone is the same.

      In this case, i must be define a batch = cone hay set of cones  = batch?

      Please help me about this


      Thank you,



      Author's profile photo Stefan Weisenberger
      Stefan Weisenberger
      Blog Post Author

      Dear Binh,

      let me ask the question differently: does each cone have a different length and a different length on it? What is you base unit of measure, and how do you calculate inventory value?

      My second question would be: what do you do with the information of each cone in the further logistics process? For example. if you receive a sales order, do you currently select individual cones to satisfy the order - based on the individual characteristics of each cone?

      Or do you rather assume the cones from one production lot or dye lot to be similar? Does the customer order and pay in cones (or in weight, length etc.)

      Thanks and regards,