User Experience Insights
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 Vendor/Suppliers.
Migration of Material Master – Finished Goods.
Migration of Material Master – Semi-Finished Goods.
Migration of Material Master – Purchased Components.
Do provide your feedback to make this blog post an universal template.
Looking forward to other master objects like Routing, PIR etc
Thanks SAHIL. Will do slowly.
Very good series. BOM also has other types of components like DIR. Relevancy rules should be included for those too.
Good point, will include that
I love your blogs due to their authenticity. You cover topics that are very useful for implementation.