Every organization strives for efficiently running operational processes which are enabled by governing the basic data types that form the foundation any (SAP) system. However, one of the most fundamental data types is mostly forgotten in this picture – reference data. To tackle this topic, Camelot ITLab has developed a new solution to govern reference data in a centralized system. Find out more about the Why’s and How’s in this blog.

Why You Should Care about Reference Data

In general, we can look at data as a hierarchical pyramid consisting of the different data types like transactional data, conditional data, master data and reference data.

The data pyramid shows different data types
Fig. 1: The Data Pyramid shows different data types

As a basic definition, reference data forms the data foundation of any system and provides a structured approach to master data maintenance. This data is used to classify and categorize other data types. By utilizing this structured approach, the operational business processes can run efficiently and smoothly as they can rely on the quality of the data used.

Looking from an end-user’s perspective of a system, reference data is usually what they will find in a drop-down field or list of values.

Looking at reference data from the perspective of an SAP system it is nothing more and nothing less than customizing.

The Challenge of Keeping your Systems’ Data Foundation Clean

Depending on your system usage (may it be a system for master data maintenance of a system to do customer relationship management) a considerable amount of fields will be based on reference data, already highlighting its relevance and importance. Subsequently, reference data have an impact on the efficiency of business processes. Having a standardized set of high-quality reference data surely enables them to run more efficiently.

Keeping the data maintenance process in mind, it is also important to have these foundational data maintained only once in a centralized system and have them distributed across the entire system landscape. Imagine the introduction of a new purchasing group in the organization and having to maintain the same data in a multitude of systems, e.g., the operational S/4 HANA system or the CRM system, to make this set available for use in the P2P processes of these systems.

The same goes for the accountability of changes. As reference data can influence nearly all business processes, it is of high importance to create and change this data in a governed way. This means that the data changes must be approved via workflows, creating accountability for the changes. It also ensures the transparency and traceability of any data changes.

Camelot’s Take on Reference Data Maintenance: Reference Data Management with SAP MDG

Camelot’s Reference Data Management was developed and implemented by reusing the SAP Master Data Governance’s custom object framework. Therefore, the solution enables the maintenance of Reference Data by integration into already existing MDG governance concepts.

This makes the solution easily accessible to users that already work with MDG because the general principles are the same.

On the technical side, the solution integrates with SAP’s Transport Management as well. In that way, it is possible to create and change Reference Data in the governed RDM solution and distribute the approved data via existing transport routes of all connected systems, adhering to the SAP systems’ fundamentals.


Existing Approach

Camelot‘s Solution


– Structure is not defined in the system and cannot be enforced
– Maintain data with informal rules
– no hard checks- Manual checks need to be performed
– Enforcement of rules – therefore ensuring data quality and structure of data
– Derivation rules reduce maintenance efforts and ensure correctness of data
– Data fully standardized across system landscape

Process Transparency

– No approval for new data sets
– Wide range of user can apply changes- Each system / client is responsible for data maintenance
– No orchestration across the system landscape
– Automatically synchronized data throughout all the systems
– Full traceability of changes via change documents
– UI containing all relevant data point in one place
– Transparent and comprehensible maintenance
– Involvement of all relevant stakeholders


– Each data set exists on their own
– No control over changes
– No entire traceability of changes
– Customizable workflow with dynamic agent determination
– Assignment of roles and authorizations to relevant parties
– Automatic creation of transport in all target systems / replication via web service or RFC
– Monitoring of replication and Transports



By loading the video, you agree to YouTube’s privacy policy.
Learn more

Load video

Bringing the Future of Reference Data Management to You

Our solution Camelot Reference Data Management is available via the SAP Store.

If this piqued your interest, please feel free to contact Thomas Tolksdorf (tto@camelot-itlab.com) or Tobias Balogh (tbal@camelot-itlab.com) to learn more about our ideas and solutions regarding Reference Data Management.

We would like to thank Luis Morantes for his valuable contribution to this article.

Recommended articles


The 9th “R” of logistics – Implementing the Strategy

With the increasing level of vertical integration, the eight Rs of logistics become more and more crucial. Besides the right (“R”) …

read more
Future Value Chain

Made in China 2025 – Chemicals, Too?

The chemical industry in China has seen enormous growth over the past 10 years, outpacing the EU by far. Currently, the Chinese …

read more
Data & Analytics

Triple A in Inventory Optimization

Triple A stands for Analytics, Acceptance, Architecture. Before applying this formula in the context of inventory optimization, it is first necessary …

read more

Reimagine your Value Chain with us

Contact us