SAP Master Data


SAP Master Data – Foundation of Data Analytics

Nobody notices a home’s foundation. A good home foundation will not make its presence known, whereas a poor foundation will manifest itself in continued problems – in cracks in walls, uneven floors, doors that won’t shut, gaps in windows, and so on!

Master data is very much like the home foundation. Nobody notices master data when it is good. When it is poor, it shows up in every business process – painfully! Every employee, customer, and vendor feel the pain of not having company-wide, reliable, well-maintained, easily updated, secure and compliant master data.

SAP Master Data – Foundation of Data Analytics

Nobody notices a home’s foundation. A good home foundation will not make its presence known, whereas a poor foundation will manifest itself in continued problems – in cracks in walls, uneven floors, doors that won’t shut, gaps in windows, and so on!

Master data is very much like the home foundation. Nobody notices master data when it is good. When it is poor, it shows up in every business process – painfully! Every employee, customer, and vendor feel the pain of not having company-wide, reliable, well-maintained, easily updated, secure and compliant master data.

In an era where data analytics drives the revenue bus for all companies, a reliable single source of truth of company data is mandatory. Without this foundational truth, all analytics are garbage-in, garbage-out leading to sub-standard decisions and immense amount of frustration.

There are several huge advantages in having reliable and comprehensive master data in all the relevant domains – vendor, customer, materials/products, employee, etc.

  1. Efficient business processes
  2. Reduced time to market
  3. Faster and better data analytics
  4. Better compliance
  5. Reduced workload

Yet, SAP master data has become a highly challenging asset to maintain for many reasons – a SAP+third-party applications model, legacy applications, global footprint, compliance constraints, and finally, the increasing multi-cloud, hybrid deployment models.

Once upon a time, SAP was a monolith in many companies, and it was possible to maintain one-source for master data. However, with the proliferation of solutions around SAP, master data is strewn across the company within SAP and non-SAP systems. With complex business processes and supply chains that cut across internal and even vendor, partner or customer systems, master data becomes very difficult to maintain and govern. Vendors such as Laidon solve this with a low-code, prebuilt master data governance solution on the cloud. SimpleMDG’s streamlined user interface retrieves real-time ERP master data and initiates maintenance requests for all CRUD (Create, Read, Update and Delete) processes.

Companies with legacy systems also struggle to migrate their old master data to new systems – the complexity, the costs and the business risks pose difficult hurdles.

Some significant problems in today’s master data involve duplication – lack of proper tools to validate and prevent duplications, lack of well-defined, unique ids and disparate systems make it very easy to generate duplications. Vendors such as Winshuttle enable automation to solve duplication challenges.

Compliance and security are additional complexities today with cloud-based data stores, especially with compliance requirements on who can access personal customer data, where it can be stored and how it should be archived. Governance is the key as this article outlines.

SAP’s own MDM solution with its governance module also continues to provide robust functionality.

 

885 results

  1. Display Characteristic Values by Key with Longer Text Descriptions

    Reading time: 9 mins

    When displaying a characteristic by key and text, the BEx Query Designer automatically displays the shortest available text from the InfoObject’s text table. But what if you want to have longer descriptions? The author presents a way to automatically provide long text descriptions with a characteristic’s key without taking drastic steps such as deleting text...…

  2. Combine Data from Multiple R/3 Tables into One BW Table

    Reading time: 14 mins

    Having to combine data from multiple R/3 sources into one BW table is a common requirement. Fortunately, BW 3.x provides a means – flexible staging – to carry out this requirement. The author shows how to configure flexible staging using an real-world example.   Many of you have faced a business requirement similar to this...…

  3. Enhancing DataSources in Standard Business Content to Suit Your Needs

    Reading time: 10 mins

    Sometimes the SAP-delivered Business Content does not map exactly to your requirements and you must modify it. This article explains how to add a field to an existing DataSource.   One of BW’s biggest strengths is the amount of standard Business Content that is delivered with it. Business Content includes DataSources, InfoObjects, data targets, and...…

  4. Easily Configure European Article Numbers and Universal Product Codes in SAP Materials Management

    Reading time: 11 mins

    Gain a deeper knowledge of what European Article Numbers (EAN) and Universal Product Codes (UPC) mean. Save valuable time by understanding how you can configure EANs and UPCs in the system and the reports you can run to validate the correctness of the configuration. Key Concept A Universal Product Code is a 12-digit code that...…

  5. Increase Load Performance by Buffering Number Ranges

    Reading time: 8 mins

    Learn how number range buffering can improve the performance of your SAP NetWeaver BI or SAP BW system. Key Concept By buffering the number ranges, the system reduces the number of database reads to the NRIV table, thus speeding up large data loads. The SAP BW system uses number ranges when loading master data or...…

  6. Reduce Costs for Compliance by Implementing a Risk-Based Internal Control Solution

    Reading time: 19 mins

    Costs for compliance and fraud prevention have risen significantly in recent years and with the current economic situation we’re likely to manage more regulations in the future, further driving costs up. Companies relish efficiency in the GRC space to garner the true benefits of compliance. One means of more efficient compliance is an integrated solution...…

  7. Improve Your Web Intelligence Report Navigation with Sections and Breaks

    Reading time: 13 mins

    Walk through common scenarios for adding sections and breaks to a Web Intelligence report, and learn how to edit section and break properties. These steps make information easier to use and improve navigation for users. Key Concept Section master cells are generated for every distinct value in an object when it has been “set as...…

  8. Use Order Change Management to Automatically Apply Last-Minute Changes to Production Orders

    Reading time: 8 mins

    Discover how order change management (OCM) improves manufacturing accuracy and customer satisfaction by ensuring that production orders conform to the latest product structure and sales order data. OCM is well integrated with sales orders for configurable products. It also helps prevent the cancellation and repetition of sales orders by ensuring that changes to product features...…

  9. Building a Better Business Process Hierarchy (BPH)

    Reading time: 13 mins

    ManagerLeverage these techniques and standards to produce a business process hierarchy (BPH) that accurately represents your “to be” solution, improves solution documentation, reduces effort, and provides more intuitive navigation. Key Concept Taking advantage of standards for naming conventions, using shortcuts, and document linking can provide more insight into your solution design, improve transparency of process...…

  10. Outsourcing Operations? How to Design an Undisrupted Supply Plan in SAP APO

    Reading time: 35 mins

    See how a manufacturing company created a new third-party logistics (3PL) code to represent a third-party logistics service provider. By incorporating 3PL into supply chain planning, the manufacturing company could plan against changing demand and supply position at 3PL and replenish the 3PL site to achieve the desired customer service level. Key Concept A purchase...…