Skip to Content
Author's profile photo Anurag Jain

BOM Explosion on HANA in SAP ERP EhP 7

Business Context

  1. Bill of Material is a formally structured list of the components that make up a product or assembly. The list contains the object number of each component, together with the quantity and unit of measure.
  2. BOMs are used in their different forms in various situations where a finished product is assembled from several component parts or materials. Depending on the industry sector, they can also be called recipes or lists of ingredients and so on.
  3. Time validity and changes to a document structure can be controlled by using Engineering Change Number.
  4. Explosion of BOM is used in MRP, Material provisions for production,  Product costing,  Plant maintenance

Motivation

Big data: Explosion of Bill of Material becomes very complex considering big amount of data as BOM being multilevel and also having complexity of Parameter Effectivity, Change numbers etc.

    1. BOM on HANA enables customers to directly have faster explosion on HANA, which can be consumed by various applications.
    2. Providing various modular part of BOM explosion like parameter effectivity etc. which could be plugged in or out with minimal efforts
    3. Supporting Order BOM, WBS BOM in one BOM explosion transaction.

Solution Sketch

Code Push Down to HANA is taken as approach for BOM Explosion on HANA. This approach is selected as there is no single expensive statement which can be pushed to DB layer and rest of the code be at application layer. In case of BOM explosion entire code involves lot of uncertainty in terms of number of levels, BOM determination, date validity etc.

BOMONHANASOLUTIONSKETCH.png

Business Benefits & robustness of the Solution

    1. There are new transaction provided for HANA based BOM explosion CS11h, CS12h, CS13h so that there is no disruption to existing transactions.
    2. Customers can use new transactions with new function module for consuming HANA based BOM explosion.
    3. There are two flavors of BOM explosion i.e. BOM explosion for MRP and BOM explosion for single BOMs
    4. Interface can take multiple material at a time for BOM explosion.
    5. BOM Explosion with HANA show significant improvement for big DATA and benefit becomes more and more if DATA volume and BOM Explosion Complexity increases.


Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Greetings, in the food industry we can only produce a work in progress material when seasonal products are available.  The same BOM can be used year after year so using production versions are a better option than BOM validities, and we also send production versions to APO.

      Transactions like CS11 can select the BOM even if the production version is not valid.  Can the new transactions handle this scenario?

      Thanks, Martin

      Author's profile photo Anurag Jain
      Anurag Jain
      Blog Post Author

      Hello Martin,

      Thanks for comment. This is also a direction on which we are looking so that we can avoid complex logic for BOM determination.

      Anurag

      Author's profile photo Former Member
      Former Member

      Hi Anurag,

      We are going to deliver a POC to one customer.  What are the detailed steps to activate these new transactions? Is there an implementaiton guide?

      Thanks, Jerry

      Author's profile photo Anurag Jain
      Anurag Jain
      Blog Post Author

      Hello Jerry,

      Can you please schedule a short call with me so that I can help you in this.

      Author's profile photo Sanyasirao Garikipati
      Sanyasirao Garikipati

      Hi Anurag,

      I am going to deliver a POC for BOM in SAP HANA with multi-level. Any help would be appreciated greatly. Let me know if I can setup a call.

      Thanks,

      Sunny.

      Author's profile photo Krishan Kant Agarwal
      Krishan Kant Agarwal

      Hi Anurag,

      We want to do BOM explosion inside HANA as the ECC system is too slow as our BOMs can get really complex(Aerospace)

      Could you give some pointers how to do this?

      Thanks

      Krishan

      Author's profile photo Rolf Ulrich Müller
      Rolf Ulrich Müller

      Hi Anurag,

      is there a way to reuse these procedure from HANA studio? We need to offer a view on HANA for Reporting with multi level BOM.

      I see 35 procedures under erp.sappl.lo.md.bom. Is there any documentation on how they could be reused?

      Checking HANA Live Explorer I only find single level explosions.

      Cheers

      Uli

       

      Author's profile photo Former Member
      Former Member

      Hi Anurag,

      thanks for your great post!

      Could you please do me a favor and tell me if there is any HANA Live Calculation View using/ showing the Explosion level?

      Thanks a lot!

      Best regards,

      Jianping

      Author's profile photo Sanyasirao Garikipati
      Sanyasirao Garikipati

      Hi Jianping, Did you get a chance to find the Explosion level?. I cant find any field to identify the level in SAP Live views(Query View:  BOMEXPLOSIONQUERY  ).

      Thanks,

      Sunny.