Formula for value on a component in a BOM... or suggestions for the right direction

[Elle]

Hello,

I have a question regarding BOM formulas for calculating ink cartridge consumption in a printing company scenario.

Scenario:

I use a BOM to manage ink cartridges for printed labels. The current formula calculates ink based on a ratio (e.g., 5 cartridges per 1000 sheets). However, this results in underestimation for quantities exceeding the base unit (1000 sheets).

For example:

• Printing 1100 sheets should require 10 cartridges, not 5.1 (rounded to 6) or 5 (standard rounding).
• Printing 3000 sheets should require 15 cartridges.

Desired Functionality:

I'd like to implement a rounding rule in the BOM that mimics Excel's "CEILING" function. This would ensure we account for the full cartridge needed when exceeding the base quantity.

Formula Example that I can use (if it is possible to insert it on SAP):

ROUND(Order Quantity / 1000 sheets) * Cartridge Consumption Rate

Using this formula with the 1100 sheet example:

• ROUND(1100 sheets / 1000 sheets) * 5 cartridges= round( 1,1) * 5 = 2 * 5 = 10 cartridges

Question:

Can I achieve this rounding behavior using CS02 or another standard SAP transaction?

Additional Notes:

• The number of cartridges per label can vary depending on customer colour requests (3, 4, etc.).
• BOM variants are not suitable as customer order volumes are unpredictable (1000, 1,000,000, or 10,000,000 labels).

Reason for Request:

This functionality is crucial for accurate cost estimation in CK11N, which the finance department uses to understand material costs per printed label.

Looking Forward:

Appreciate any suggestions on achieving the desired rounding behavior within the BOM structure. If there are limitations in the standard functionality, please let me know what alternative solutions I can explore. I'm in production and not an SAP expert, but I'm happy to learn new things if you can point me in the right direction. 😀

Thank you

[arjuna_bandara · Accepted solution]

Hi,

This could be achieved via SAP variant configuration functionality.

Please refer the below for details on the concept. You can also research more on SAP variant configuration functionality in the community.

https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/a73402f511734e6eac56063e631bf24e/c162b6531de6b64ce10...

Also refer below for using dependency formula with rounding up, similar to your case.

https://community.sap.com/t5/crm-and-cx-questions/round-up-of-value-output-coming-through-dependency...

Hope this will assist you.

[Elle · Accepted solution]

Thank you! The provided insights have offered me a valuable starting point for exploring potential solutions!