Skip to Content
User Experience Insights
Author's profile photo Narasimha Prasad Bhat

Master Data Migration Relevancy Rules -6- BOM- Bill of Material

Purpose: One of the main requirements to migrate master data is to set up migration relevancy rules for each master data object.  I have implemented many projects, and everyone spends a considerable amount of time on this topic in every project. I have tried to consolidate the relevancy rules object-wise so that this effort can reduce your project implementation timeline. Use this as a template and modify the rules as necessary. do share any additional relevancy rules to make this blog post better.

The below table gives possible rules for migrating purchased Materials.

Data Data Elements Criteria to Migrate to SAP Criteria for no migration/ data cleansing.
BOM BOM header material Header material status should be active. Inactive status. Since such materials are not migrated, their BOMs will not be migrated or require further analysis for cleansing
BOM Item-Assembly SFG Active SFG Assemblies are migrated with their BOM along with the header BOM. If SFG material is not active, either replace SFG with active SFG and migrate or cleanse the SFG and its BOM and make it active again for migrating with its parent BOM.
BOM component Active components are migrated along with the BOM. If the SFG/FG material is active, but the component material is not active, either replace the component with the active component or make the inactive component active.
Material Active BOM Header/Assembly/Components are migrated and follow relevancy rules, as per my previous blog posts. If any Material in the BOM is inactive, then BOM can’t be migrated. Data cleansing would be required to replace it with active material or make those materials active.
Open transactions If we have open production/process/sales orders using production or sales order BOMs, they have to be migrated BOMs are inactive, and no open transactions exists, then no need to migrate such BOMs.

The relevancy rules for BOM is heavily dependent on the material statuses. Deep analysis and cleansing of material statuses is required for proper migration of BOMs.

Sales order BOMs and WBS Boms have some other special requirements, which I would cover in another blog post.

Do visit my other blog posts in this series

Migration of Customers.

Migration of Vendor/Suppliers.

Migration of Material Master – Finished Goods.

Migration of Material Master – Semi-Finished Goods.

Migration of Material Master – Purchased Components.

Migration of Bill of Material

 

Do provide your feedback to make this blog post an universal template.

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sahil K
      Sahil K

      Looking forward to other master objects like Routing, PIR etc

      Author's profile photo Narasimha Prasad Bhat
      Narasimha Prasad Bhat
      Blog Post Author

      Thanks SAHIL. Will do slowly.

      Author's profile photo Vrinda B
      Vrinda B

      Very good series. BOM also has other types of components like DIR. Relevancy rules should be included for those too.

      Author's profile photo Narasimha Prasad Bhat
      Narasimha Prasad Bhat
      Blog Post Author

      Good point, will include that

      Author's profile photo Harsh Banda
      Harsh Banda

      I love your blogs due to their authenticity. You cover topics that are very useful for implementation.