Catch Weight Management
In some industry sectors (for example, diary/meat, pharmaceutical, chemical, steel, or paper industry sectors), the composition or attributes of products vary to some degree. Therefore, you cannot use a fixed conversion factor to convert quantities of these products into various units of measure. Instead, each batch has to be given an individual conversion factor.
The weights can vary from piece to piece, either due to biological variations or because of weight loss during storage. This variability should not be lost by using fixed conversion factors, because this would mean that many business processes would be based on incorrect values.
In SAP such process can be mapped by two ways
· Batch-Specific Units of Measure
· Catch Weight Management – IS-CWM Functionality
This document will give you some light on these SAP functionalities.
1. Catch Weight with Batch-Specific Units of Measure
Customization Requirement
Create ‘No Dimensions’ Unit of Measurement
Create two no dimensions units LBI and CS/LB. LBI will represent as ‘Batch Specific Unit of measurement’ which will assigned to its original unit of measurement i.e. LB (Pounds). CS/LB is a no dimension unit which will be used to define fraction between cases (CS) and Pounds (LB).
Click on Unit of measurement to create units LBI and CS/LB. Please refer the screen below.
Maintain the details of LBI and CS/LB as per the above screen.
Activate Batch Specific Unit of Measurement
The batch-specific material unit of measure is an alternative unit of measure of a material, for which base unit of measure can be defined on a batch-specific basis.
While the conversion ratio for other alternative units is predefined in the material, for batch-specific material units of measure, we define:
- The planned conversion in the material
- The actual conversion ratio to the base unit of measure for the batch.
Batch-specific material units of measure are used when the conversion ratio for the unit of measure to the base unit may vary for different batches of a material.
In this case, Base unit of measure is CS (Case) and valuation unit is LBI (Pounds). Planned conversion ratio between these units is defined in the material master, but actual conversion ratio varies batch to batch which may depend on the environmental factors.
To control these situations in SAP, we need to activate ‘Batch-Specific material units of measure’.
We need to activate batch specific UOM as per the above screen.
Define Batch Specific Unit of measurement
Create a ‘Batch specific UOM’.
We need to execute process step as mentioned above.
Click on New Entries in the screen above to define batch specific UOM.
Define the Batch Specific UOM and linked it with actual UOM. Here LBI is batch specific UOM which is linked to actual weight unit (dimension ‘Mass’) LB.
Define Calculation of Proportion quantity from Base Quantity
Define the ratio of the proportion unit to the base unit. This ratio is needed to convert base units to proportion units of measure.
Click on New Entries in the screen above to define calculation of proportion/product quantity from base quantity.
As per screen above, we have linked batch specific UOM with base unit of measurement.
Define Calculation of Base Quantity from Proportion quantity
Define the quantity calculation with reference to base unit of measurement.
Here we have defined CS and LBI calculation for no dimension unit CS/LB.
Define attributes of system messages
We need to maintain message XU-033 as information message. In standard SAP, this message would set to error message. Please remove message category ‘E’ and set as blank.
In standard SAP, fraction between two units of measurement is set till two decimal points. If fraction value is defined for three or more decimal value, then system will issue this as error message XU-033.
In our case, we need are considering fraction value till five decimal points, so that we can get more accurate values after conversion. Take the following case:-
Number of Cases |
10 |
Catch Weight (LB) |
39 |
Ration (CS/LB) = 0.26 when only two decimal allowed
Ration (CS/LB) = 0.25641 when five decimal allowed
From the calculation above, it’s clear that we would get more accurate result when we go for higher decimal points.
So as per the screen below, we have changed error message category to blank.
Master Data Requirement:
Create following master data for catch weight management,
Create Characteristics CT04
Create three characteristics. One characteristic will store the actual fraction between number of cases and actual catch weight. So we have characteristics ‘CATCHFRACTION’, ‘CATCHWEIGHT’ and ‘NUMCASES’ to create. We need to call CT04 transaction code to create these characteristics in SAP.
Below mentioned screen shots will tell about the properties of these characteristics.
Above screen tells about ‘CATCHFRACTION’ property.
Above screen tells about ‘CATCHWEIGHT’ property.
Above screen tells about ‘NUMCASES’ property.
Maintain Dependency
Dependency will be used to calculate the fraction between number of cases and actual catch weight. Call SAP transaction CU01 to create dependency.
Create Class CL01
Create class for catch weight material. We need to assign all characteristics as mentioned above Important thing to note is that ‘organization area’ in the class must be equal to ‘S’. Call CL01 to create class and assign the characteristics.
Assign Characteristics to Batch Class
Assign characteristics to class CL01
See the screen above for characteristics assignments. We must put ‘Organizational Area’ equal to ‘S’ against the characteristics which will be used for CS/LB conversion.
Maintain Material Master MM02
Assign the catch weight class to material master classification view and update other parameters in the material master. please see the screen below to know about various important data in material master.
Select the additional data information in the material master and click on the ‘proportion/prod unit’ tab to maintain planned conversion factor.
Maintain the planned conversion value into ‘plan value’ as per the screen below.
Valuation category of material must be equal to ‘X’.
Create vendor Info record
Maintain the vendor info record for batch specific UOM.
Price are maintained at batch specific UOM.
Transaction Data:-
Receiving actual CW at the time of MIGO
Create Purchase Order
Use ME21N transaction to create Purchase Order. Here we are using material 69 for which Batch specific UOM is active.
Perform goods receipt (MIGO)
We need to enter actual CW and GR quantity in the classification view as,
Display Stock (MMBE)
Here we can see that, inventory is as per actual CW. System is showing actual CW for the batch GR.
2. Catch Weight Management – IS-CWM Functionality
IS-CWM is the industrial solution developed by SAP AG The term “Catch Weight materials” or CW materials for short, is used for materials with variable weight.
Catch weight management business scenario has variants across process such as
(a) Procure to Pay
(b) Order to Cash
(c) Manufacturing
(d) Inbound and Outbound Logistic
(e) Inventory Controlling & Accounting
- IS-CWM enables use of one UOM in Logistics and another UOM suitable for Financials and Controlling for the same material.
- Relationships between the two UOM’s can be variable and defined in the material master.
- Goods movement can be recorded in both UOM’s – base unit of measurement as well as parallel unit of measure.
- The valuation UOM can be either the Base UOM or the parallel UOM – this can be specified in the material master.
- CWM is based on a new Architecture comprising of
a) LIME – Lean Inventory Management Engine – Enables recording and reporting of Inventory in different UOM.
b) Inventory Accounting – Enables postings with new valuation UOM in FI and CO.
The fullfilment of purchase orders can be recorded and controlled more accurate for catch-weight materials. While posting goods receipt it is possible to post quantity in two different unit of measure.
For inventory, the logistics unit of measure (UOM e.g. EA ) and parallel unit of measure (e.g. KG)
Good Receipt MIGO
Same way it can be used for production/process order good receipts, posting of goods receipt is possible to post quantity in two different unit of measure EA and KG.
Stock Overview
You can view the stock in both the unit of measurement i.e; in Base unit of measure and Parallel unit of measure.
Material consumption in PI Sheet with CWM
The goods issues and goods receipts related to process or production orders can be recorded and controlled more accurate for catch-weight materials. All movements are posted in two units of measure (UOM) & parallel unit of measure
Delivery
In the sales order the price is calculated based on sold number of Kilo, number of Each is charged. The actual weight is assumed to be entered into the “Net weight” field in the delivery document.
Reference:
Batch-Specific Units of Measure in Logistics – Batch Management (LO-BM) – SAP Library
Note 863498 – functional restricions in SAP Catch Weight Management
Note 956923 – IDES ECC 6.0 Catch Weight Management Version 2
Hello Rupesh,
Much Informative document. Thanks for sharing.
Regards
Mangalraj.S
Thanks a Mangalraj.
Hi Rupesh,
Nice document, Keep posting.
Regards,
Anupam Sharma
Thanks a lot Anupam.
Hello Rupesh,
Really nice and thoughtfull document.thanks a lot for sharing.
Best Regards,
Quite elaborate and informative!
May I point out cpl of oversights
I think you have used the same screenshot for Char catchweight as catchfraction.
Also i couldn't find the assignment of dependency to characteristic.
Ajit
Hi Ajit,
Thanks for the pointing, I have correct the same. Yes we need to assign dependency to characteristic.
Regards,
R.Brahmankar
Hi Rupesh,
Its a good document mate...and thanks for sharing....
Thanks & Regards,
Madhu.G
Thanks a lot Madhu.
Hi Rupesh,
Thanks for sharing....documented is detailed and clearly describes the process......
Regards,.
Sandeep
Thanks for the feedback.
Very clear and Helpful.Thanks for sharing.
Regards,
Vibin.V.Joseph
Thanks for the compliment.
Dear Rupesh,
Very much clear & understandably explained concept. Thank you for sharing and keep educating us on more concepts like this. You have really good amount of knowledge & experience in SAP production modules.
Thank you,
Sharat
Thanks a lot of compliment Sharat.
Thanks for putting this together. I had almost missed it because it was posted when I started with my vacation.
I am already certain that I often share this document as it is frequently discussed in MM
Thanks a lot Jurgen.
Hi Rupesh.
Nice you spent your time sharing knowledge.
Just for more info, IS-CWM is quite common in Poultry Farming & meat production, some years ago I participate in a proyect and discover the complex requirements of this industry and the way this IS help to face their requirements.
Arturo.
Hi Arturo,
Thanks a lot yes, IS-CWM is very useful in Poultry Farming & meat production.
Regards,
R.Brahmankar
Rupesh:
Thanks for sharing with us...btw,Where do u assign the dependency?
Hi Monst Yang,
You can assign dependency to characteristic. In CT04 (Characteristic) there is an object dependency Assignment.-- Extras > Object Dependencies > Assignment and Editor.
Regards,
R.Brahmankar
Dear Rupesh,
Nice document.Thanks for sharing it.............................
Thanks for your feedback..Why not assign the dependency to class? Does it take effect the same in your example?
Hi Monst Yang,
Thanks for the update yes you can assign dependency to class too.
Regards,
R.Brahamnakar
Hi Rupesh,
Very good document. Thanks for sharing.
Regards,
Krish
Thanks Krish. Much appreciated your comments.
Regards,
R.Brahmankar
Hello Rupesh Brahmankar
Comprehensive and Infromative Document.
Thanks for sharing.
ThanksSunil, much appreciated.
Appreciable effort dear 🙂
Thanks Amala..!!
Very Informative Rupesh,
Thanks for sharing it.
Ritesh
Hi Brahmankar,
Thanks a lot for sharing the knowledge with us. There are not more than 5 stars !!
Regards,
Subbu
Ritesh Dube and Subrahmanyam B Thanks for your message.
Hi Rupesh,
Very useful document. Thanks for sharing.
Truly appreciated.
Regards,
Senthil
Hi rupesh..
Really gud one...
Simply Brilliant document .
well done Rupesh.
Hi Rupesh,
Excellent document. Thanks for Sharing.
Regards,
Ashok Kumar Telugu
Hello Rupesh,
Thanks a lot for such wonderful doc for our reference.
As well can you please elaborate Doc for PI Sheets more precisely as PI Sheet and XSteps concept are not that much using / awareness in region Asia.
Best regards,
Sujeet
Hi Rupesh,
Very informative document. Thanks for sharing such document.
Regards,
Dhaval
Hi Rupesh,
Its really very tough for me to understand the batch specific UoM and its functionality.But this documents is really very so much user friendly for fresher as well as for experienced one to understand the concept in a very well behave manner.
Thanks a lot for sharing it.Hats Off to you.
Regards.
Hi Rupesh,
Thanks for sharing this wonderful document.
Regards,
Kartik Rohilla
Thanks for sharing this document.
Regards,
Rahul
nice doc with detail explanation thnx Rupesh
Hi Rupesh,
informative document. CWM will help to manage variable conversion factor between base & parallel UoM for a batch / HU, how will it be able to address weight loss process ?e.g. if I have CWM material for which I have posted GR (1 PAL = 350 kg = EUR 500). Over the period, the weight of this pallet is reduced to 325 Kg due to evaporation losses. So from quantitative perspective I have to reduce qty of this pallet but valuation should not change i.e. I now need 1 PAL = 325 KG = EUR 500). How will I manage this qty variation ? Of course material is Valuated, so physical Inv will result in accounting entry as well
What I've seen done in the past is create a custom program that:
-Captures the new weight of the product X
-Creates a Process Order with product X as both "a material and a finished product."
-Goods issue the old weight against the process order
-Goods receive the new weight against that same process order
-Posts/Confirm/Closes/Settle or whatever you call the final activity of the Process Order
As you should already know, the Process Order itself will calculate and update the cost for the new weight of its finished product.
In this case there must be another valuation segment (valuation type, WBS, plant) for finished product, otherwise a cycle and non-distributed costs appears in ML.
Hi,
Good Document
Hi ;
Well explained document, thanks for sharing.
Regards.
M.Ozgur Unal
Thanks a lot. 🙂
Hi R Brahmank ;
Have you been Sap PP project in poultry sector ? In sdn , there are a lot of discussion about PP scenerious. But , i am not sure how must be manage bill of material in this sector.
Someone is advised co-product.
Someonelse is advised catch weight solution.
What is your idea ?
Regards.
M.Ozgur Unal
Hello M.Ozgur Unal,
I would suggest you to go through OSS note 956923 there is PDF file attached , which give you details about it.
However I have done the solution design work for same industry area.
SAP Catch Weight Management is ideal solution but review the restriction given in OSS note 863498 - functional restrictions in SAP Catch Weight Management.
All the best. 🙂
Best Regards,
R.Brahmankar
Hello R Brahmankar ;
How did you solve co-product cost problem ? So , co-products have problem related with installation costs they are valuated proportion of co-products to my knowladge. But , CWM is built to collect differences...
For example : wing is co-product in poultry process that have a proportion but it is changable.
Regards.
M.Ozgur Unal
Hello Ozgur Unal,
When the main product (header material) in joint production is a cwm material, the quantities of co-products in the order precacluclation are correctly determined based on the default conversion factor of the header material.
Best Regards,
R.Brahmankar
Hello R Brahmankar ;
We activated catch weight management in our ides after that we get a lot of extended tables like LIPS Catch Weight tab etc. But , we do not get master datas like CW-HOG , CW-HAM etc. Is there a program to upload master data or anythingelse.
Thanks for advance.
Regards.
M.Ozgur Unal
Hello Rupesh,
Very Nice and informative document.
Keep Sharing !!
Regards,
Amit
hi Rupesh
A good informative document .thanks for the clear explanation.
Regards
Anandh
Hi Rupesh,
Nice document!
What is the way of clearing remaining quantities ?
0 PC --> 10 KG etc....
Thanks so much Sir!!
Is a important information for this functionality!! tks again
HI R Brahmankar ,
Thanks a lot for sharing this very interesting blog, I really like it!
I have the question below: Is it possible to update characteristic value when doing MIGO automatically without entering in double quantities in quantity tab and in characteristic, I see that it can be possible to do that using user exist, is there any reference table that can help !
Thanks for your support.
Farid.
Hello,
Which characteristic value you would like to update?
You can do the batch classification in background during MIGO with OMCV setting.
Best Regards,
R.Brahmankar
Hi R Brahmankar
The idea behind my question is to update values of characterisitcs NUMCASES, CATCHWEIGHT in the blog directly from quantities that will be entered during MIGO.
Regards.
Hi R Brahmankar
Nice Document
If we implement CWM in the meat industry, as per your document which one is preferable
What are the new functionalities in S4 Hana CWM?
Hello,
As batch specific units of measure have different conversion ratios compared to the planned conversion of the material master, some settings were helpful for CWM with its variable ratio.
As a consequence, some restrictions from the proportion / product unit of measure might apply for CW materials.
For meat industry I would prefer the CWM, by considering all the functionality and restrictions.
Please refer SAP note Note 863498 – functional restricions in SAP Catch Weight Management which has never version 34 from 2018.
I am not sure is there any new functionalities in S4 Hana for CWM
Best Regards,
R.Brahmankar
Very nice and helpful posting.
But i have a question for below, so how to make two UOM be variable maintenance in material master data ? I know use this function, the stocks can be variable stored in the inventory, but in the material master data anyway it's a fix conversion, isn't it ?
Hello,
Yes that's right you can have the proportion/prod unit’ tab to maintain planned conversion factor. During the posting you can have the quantity with respective to your actual.
Best Regards,
R.Brahmankar
Excellent blog & easy to understand. A question- Why did you use Case as Base UOM & LB & LBI as alternate UOM? I m not too much into procurement but I think SAP suggests smallest UOM as base unit of measure?
Regards
Pankaj