Part 9 Variant Configuration – Updating the BOM Quantity
Hi all,
The lesson in this post is about updating the BOM quantity based on selections made by the user.
In the SAP help they cover this a little, but the solution they give is very basic. Basically they use a simple procedure where they set the quantity based on some IF logic. Taking our box example the SAP solution would have a series of statements for each box size.
eg “Set qty to 0.5kg IF is a small box, Set qty to 1.2 kg IF is a medium box, etc”
In the demo we are doing it differently. I like to separate the data from the code if possible. So I am using a variant table to store the BOM quantity for each box size. If we do it this way it is a lot easier to add a new box size later, by adding a new size to the characteristic BOX_SIZE, and a new entry in the variant table. We do not have to change any object dependencies if we do it this way.
So here is the demo
Hey Phil,
Excellent work here!!, have learnt a ton, thanks to you, am looking forward to the pricing section for variant conditions
thanks
Manik
Hiiiiiiiiiiiiiiiiiiii Phil,
It’s very nice to see your blogs. You have made VC a bit simpler than what it seems in SAP help files.
Ihave gone through your all the blogs which I found very helpful to all who are beginner in VC.
It’s nice to see someone like you dares to put so valuable information in the blog instead of heavy competition.
Please keep writting such a beautiful literature.
you will be blessed by all those whom you are helping.
At any cost don’t stop your work.
I would like to suggest you that keep the option in your blog wherein one can upload VC related data then you just go through it and cross verify it.As you are an experienced one you can correct the things and can put it in the blogs ready reaconer for others.
signing off for the time being,
see you in the blogs again and again
Byeeeeeeee
This is an excellent demo. But can you please add a similar demo, to change the BoM quantity of several materials based on a characteristic selected at the header or root? In this example we are considering only ONE material. But the BoM may contain several materials, and each component’s quantity to be fixed is different, which can be maintained in a table
MATNR Characteristic Value Qty
matnr1 chr1 10 ea
matnr2 chr1 7 ea
matnr1 chr2 17 ea
matnr2 chr2 12 ea….etc
Can you please throw some light?
Thanks
Srinivasan
Hi,
Dont fully understand the question, but basically you set up the variant table to contain the quantities. On my current project we have a wide variety of materials and tables and updates. We try to use characteristics in tables that hold a “core” value. Then we use this in formulas in the procedure that sets the BOM quantity. For example if the floor area of a house is 200m2 then we can use this to determine the m3 of concrete using a formula in the procedure.