TIP: Seeing what views are missing from your material master

When you create a material master you may not have all the information available to generate all the required views. The nice thing is that there is a table in SAP that stores an entry for each view that has not been created. It would be a simply thing to write a report or better still, create a workflow to ensure that all the required views for you materials have been created before they are made available for use. To review this tables details let's run through an example.

Report to check if finance or sales view missing for a customer master record

ISSUE

You find that your master data process leads to customer records that occasionally have missing sales or finance views. How can we easily find these records and address them.

SOLUTION

1. I like to use Workflow to manage the creation of master data to ensure proactive maintenance of master data views - i.e. When a customer is created and it's missing the sales or finance view then send a work item to the sales or finance team in order to have them create it. The workflow is only terminated once the view has been created. Businesses that need to follow a compliance process often use this technique and have the QA team be the last in the process to release the master data object for general use.

Changing master data in mass

Use transaction MASSD to change attributes of your various master data elements. The following master data objects can be changed using this transaction:

1. BUS0015    Profit center
2. BUS1001    Materials (industry)
3. BUS1001001    Materials (retail)
4. BUS1006    Business Partner
5. BUS1133    Rental units
6. BUS1178001    Mass Maintenance Mat
7. BUS2012    Purchase orders
8. BUS2013    Purch. Sched. Agrmt
9. BUS2014    Purchase Contract
10. BUS2031    Customer Quotation
11. BUS2032    Sales orders
12. BUS2034    Customer Contract
13. BUS2104    Appropriation Req.
14. BUS2105    Purchase Requisition
15. BUS3003    Purchasing Info Rec.
16. BUS3006    G/L Account
17. CA_CONTACC    Contract Account
18. FORCE_LS    ForceEl (Log. Syst.)
19. KNA1    Customers
20. LFA1    Vendors

Global MDM versus Local BPM | Liliendahl on Data Quality

The linkage between Master Data Management (MDM) and Business Process Management (BPM) was intensively discussed at a workshop on a MDM conference organized by Marcus Evans in Barcelona, Spain today. More than 30 master data professionals from a range of large mainly European originated companies attended the workshop.
There was a broad agreement about that the intersection between MDM and BPM is growing – and should be doing so.
One of the challenges identified is that MDM tends to be global within the enterprise while BPM tends to be local. Read the full article at http://liliendahl.com/2015/04/22/global-mdm-versus-local-bpm/

The role of application metadata in a Master Data implementation

We would like to congratulate IBM, Informatica, SAP and Oracle on their continued strong showing in the latest Gartner Magic Quadrant for Master Data Management (MDM) of Customer Data Solutions. I am not going to spend time restating the benefits that organisations can reap from a properly implemented Master Data strategy in terms of increased revenues […]


http://silwoodtechnologyblog.com/2014/12/10/the-role-of-metadata-in-a-master-data-implementation/

Digital Assets and Product MDM

Digital Asset Management (DAM) solutions are often seen working beside or within product Master Data Management (MDM) solutions. I guess I might have been some of the first folks working with relating digital assets and enterprise software. That was in the early 90’s when I worked with Wang Laboratories that was a pioneer in handling […]


http://liliendahl.com/2014/11/18/digital-assets-and-product-mdm/

From Business Glossary to Full-Blown Metadata Management or Vice Versa

A very common starting point for producing tangible outcomes in a data governance programme is setting up a business glossary. The alternatives, or next/previous steps, for a business glossary were discussed in the post Metadata Musings by a Nerd. First, in my eyes a business glossary (or whatever you call such a thing) is indeed […]


http://liliendahl.com/2014/11/21/from-business-glossary-to-full-blown-metadata-management-or-vice-versa/

PIM, Product MDM and Multi-Domain MDM

Over on the Informatica Perspectives blog Monica McDonnell of Informatica seems to be determined to separate Product Information Management (PIM) and Product Master Data Management (Product MDM) as we now have the second attempt in the post PIM is not Product MDM Part 2. I can easily see the reason for this quest for Informatica, […]


http://liliendahl.com/2014/11/24/pim-product-mdm-and-multi-domain-mdm/

The Multi-Domain Data Quality Tool Magic Quadrant 2014 is out

Gartner, the analyst firm, has a different view of the data quality tool market than of the Master Data Management (MDM) market. The MDM market has two qudrants (customer MDM and product MDM) as reported in the post The Second part of the Multi-Domain MDM Magic Quadrant is out. There is only one quadrant for […]


http://liliendahl.com/2014/11/28/the-multi-domain-data-quality-tool-magic-quadrant-2014-is-out/

Data Governance, Santa Style

Multi-Domain MDM, Santa Style, is the title of a post on this blog made a couple of years ago. This post was about how a multi-domain Master Data Management solution could look like in an organization doing business as we think Santa Claus do. Many organizations around the world who has recently embraced Master Data […]


http://liliendahl.com/2014/12/20/data-governance-santa-style/

MDM 3.0 Musings

The term Data Quality 3.0 has been around on this blog for nearly 5 years and was recently aired again in the post Data Quality 3.0 Revisited. A natural consequence of the concept of Data Quality 3.0 is something we may call Master Data Management (MDM) 3.0. Master Data Management has in a large degree […]


http://liliendahl.com/2015/03/08/mdm-3-0-musings/

To-Be Business Rules and MDM

An important part of implementing Master Data Management (MDM) is to capture the business rules that exists within the implementing organization and build those rules into the solution. In addition, and maybe even more important, is the quest of crafting new business rules that helps making master data being of more value to the implementing […]


http://liliendahl.com/2015/03/10/to-be-business-rules-and-mdm/

Automate or Obliterate, That is the Question

Back in 1990 Michael Hammer made a famous article called Reengineering Work: Don’t Automate, Obliterate. Indeed, while automation is a most wanted outcome of Master Data Management (MDM) implementations and many other IT enabled initiatives, you should always consider the alternative being eliminating (or simplifying). This often means thinking out of the box. As an […]


http://liliendahl.com/2015/03/18/automate-or-obliterate-that-is-the-question/

Three Stages of MDM Maturity

If you haven’t yet implemented a Master Data Management (MDM) solution you typically holds master data in dedicated solutions for Supply Chain Management (SCM), Enterprise Resource Planning (ERP), Customer Relation Management (CRM) and heaps of other solutions aimed at taking care of some part of your business depending on your particular industry. In this first […]


http://liliendahl.com/2015/03/24/three-stages-of-mdm-maturity/

Master Data and Business Processes

The intersection of Master Data Management (MDM) and Business Process Management (BPM) is a very interesting aspect of implementing MDM solutions. We may divide this battleground into three sectors: Business processes that purely consumes master data Business processes that potentially changes master data Business processes that purely updates master data Business processes that purely consumes […]


http://liliendahl.com/2015/03/25/master-data-and-business-processes/

The Pros and Cons of MDM 3.0

A recent post on this blog was called Three Stages of MDM Maturity. This post ponders the need to extend your Master Data Management (MDM) solution to external business partners and take more advantage of third party data providers. We may call this MDM 3.0. In a comment on LinkedIn Bernard PERRINEAU says: Starting with […]


http://liliendahl.com/2015/03/30/the-pros-and-cons-of-mdm-3-0/