SAP NetWeaver MDM 7.1 is the proven infrastructure technology for cross-domain master data consolidation and harmonization across the enterprise.

 

See also below: Overview - benefits of NetWeaver MDM

 

The latest support package, released on March 28, 2013, provides you with the following benefits:

 

Integration with SAP Data Services and SAP Information Steward (DB-Views)

Now you can integrate MDM with other downstream systems via MDM DB Views.

You can enhance MDM capabilities using SAP Data Services (DS) for matching, cleansing, data enrichment, and ETL. You can also enhance MDM capabilities using SAP Information Steward (IS) for Data Profiling.

A new MDM CLIX command generates DB Views which can be consumed directly using the DBMS capabilities.

 

NW-MDM web-user capabilities

 

  • Export and Import via Web-Dynpro

In previous versions, via the WebDynpro, you could export only the display values of the lookup fields and you could not import this exported file.

As of MDM 7.1 SP10, "Advanced Export" functionality enables you to export all the values in a lookup field and you can also import this exported file via the WebDynpro.

The “Advance Export” / Import – is actually using the MDM-Syndication server and the MDM-Import server. It means that all the file formats which are supported by these servers are also supported by the WebDynpro “Advance Export” / Import. Also it means that all field types are supported: text, tuples, main table lookups, etc.

 

  • Now, via the basic export in WebDynpro you can export also the Qualified Lookup fields.

 

  • Finding data easily (lookup auto-suggest items).

As of MDM 7.1 SP10, the lookup fields could be configured for Auto-Suggest so at runtime as you starts typing text, the lookup field will display the lookup values that start with the entered text.

 

  • Sorting
    • Matching Enhancements: Now you can also sort the Class and Score matching fields (columns) in a Match WebDynpro component.
    • Item Details WebDynpro Component: Sorting of tuple member fields is supported.

 

 

Enhance data model of the master data (tuple)

Enhanced tuple (data type) functionalities - You can now define a currency field type within tuple member fields.

Up till now you could only store a maximum of 8 digits in a tuple field. Now you can use the currency data-type in a Tuple to store a number with a precision of about 16 digits. The Currency data-type can be used with or without the currency symbol.

 

Enhanced security

You can now enforce the use of strong and secure passwords in MDM by configuring password requirements including minimum and maximum password length, password complexity requirements (use of uppercase, lowercase, digits, special characters), and preventing re-use of previous passwords (by keeping a password history for users). The configured password requirements apply to all MDM client applications.

 

UI enhancements

In the GUI of MDM Data Manager, the fields for which the user has read-only access are now disabled by default and appear grayed out.

 

Enhanced MDM workflow administrator capabilities

Email destination is based on data field - You can now define for each record, the people that will be notified when a specific record is changed in an MDM table. For example - each SKU/Product in the main table has a different owner who should get a notification email upon a change in this product. You can add a text filed in any table in MDM (configurable in MDM) and fill it with the email address. The Notify step will read the data form this field and will send the email to this email address.

The Workflow Notify step contains two new properties to support this feature. In addition, you can now embed any main table field value into the email body or email title by using the new %Code=Name% variable workflow notifications code.

 

Enhanced MDM Client capabilities

You can now use MDM Data Manager to export data from lookup main fields to Excel, Access, or text files, in the same way as for any other field type.

 

Enhanced error reporting

MDM-Import-Manager logs into a file - Now, when there is any failure in the import process via the Import Manager, you will have a report file that you can send to other people in order to resolve the issue. The import log file contains Source record ID, Reason for failure to import, matching field names, and matching field values.

 

MDM Configuration Assistant

Now you can easily manage the configuration of all MDM Servers that are based on the keys in the ini files of the MDM server (MDS, MDIS, and MDSS).

This tool will also help you to validate the keys and will prevent errors in the MDM configuration. For more details see SAP Note 1543650

 

Improved supportability

  • Now you can better monitor the repository status by using the SAP Solution Manager Diagnostic (WILY) reporting metrics. This includes:

o    Method name that was executed in the performance metrics and repository status.

o    For import and syndication: performance metrics based on repository and remote systems; files in ready and exception folders.

  • Enhanced automatic SLD (System Landscape) registration

 

 

And What’s Next?

SAP NetWeaver MDM is a mature product on a stable core. Continuous improvements are planned as usual in annual Support Packages. SP11 is planned to be released in Q4 2013.

 

 

Overview- NetWeaver MDM benefits

 

The NetWeaver MDM has the following added value:

 

  • Low TCO:

o Quick and easy to install.

o Supporting most common database servers' vendors, including: Oracle, MS-SQL, DB2 and MaxDB.

o NW-MDM does not require an installed SAP-ECC system in order to run the NW-MDM.

o Easier backup with archives, user maintenance, single console tool for all basis functions.

 

  • Governance can be achieved by using BPM (SAP NetWeaver Business Process Management) and reuse of validation rules.

 

  • PIM (Product Information Management) Support includes: Taxonomy, attributes, attached media (images/PDFs)

 

  • Flexible data-model - such as Tuples

 

  • Distributed scenario: NW-MDM enables each system to create its own new record.

 

  • Harmonization: You can syndicate data from MDM and import the same data into all systems within the customer company in order to harmonize the data

 

  • Consolidation - A single record in MDM (consolidated) now supports all occurrences of the record in all consuming systems each consuming system having its own unique key. NW-MDM match, merge and create persistency of best records based on a user review process.  NW-MDM is not embedded in the ECC system and stands for master data that consolidates data out of different systems from different landscapes.

 

  • Heterogeneous landscape: SAP NW MDM provides a solution for heterogeneous landscape related issues. This solution is also for landscapes that are not SAP system driven. MDM will integrate into a mixed SAP landscape of multiple (but differently configured) ECC clients, SRM and CRM clients as well as third-party ERP applications or legacy mainframe systems.  MDM can also speed the integration of mergers or acquisitions.

 

  • Data Quality (DQ) for cleaning - SAP NW MDM provides integration with SAP BODS DQ tool solution.

Hi All,

 

Am using SAP MDM 5.5 Version and it has Database MS SQL 2000 as the Back-end and the OS is MICROSOFT Windows Server 2003 R2.

 

I would like to upgrade the Database from MS SQL 2000 to MS SQL 2005.

 

Can anyone help me to know whether SAP MDM 5.5 supports MS SQL 2005. Through PAM, I understand it supports MS SQL 2005.

 

Can any of the experts available here reply back to me from your real time experience.

 

Regards,

 

Ganesh Mani. K

In order to achieve SSO between SAP Netweaver MDM and SAP portal trusted connection needs to be set up. A trusted connection is the only authentication type supported in this version. A trusted connection is useful when the user has already logged on to the application and does not have to provide yet another password just for MDM.

The NetWeaver Web AS user must also exist as an MDM User (defined in the MDM repository). You can authenticate a session by using a trusted connection between the server where the MDM Java API is deployed, and the server where the MDM server is running.

You establish a trusted connection between the environment running the API and the MDM server by modifying a configuration file located in the MDM server installation directory. In this way the server is aware of which clients to trust.

Procedure to define trusted connection.

Trusted connection to the MDM server can be defined as follows.

1.    allow.ip file : Create a flat text file with the name allow.ip, this file contains IP addresses of trusted partners.  For each connection there is a separate entry.  IP address can be fully specified address e.g. 10.17.79.12 or it’s also possible to use wild card to signify the entire subnet.

For instance 10.17.79.* indicates that any address within the 10.17.79 network is considered to be trusted. Other possible variants: {10.17.*|10.*}, but not just {*}.

Comments can be inserted by placing a number character (#), in the first column.

 

2.    deny.ip file: Create the deny.ip file if required, to allow an entire network while specifying some exceptions, create a deny.ip file according to the same rules as the allow.ip file:

 

For example, if 10.17.79 is to be trusted, with the exception of the address

  1. 10.17.79.23, insert 10.17.79.* for the allow.ip file, and 10.17.79.23 for the
  2. deny.ip file.

If an entry is found in the deny.ip file, the server defines it as not trusted.

 

The same behavior is defined for all IP addresses that are not found in allow.ip.

For example, a consumer with IP 10.89.50.99 requests data from the server. If the IP is not found in allow.ip, then the request is refused.

Only if the IP address is found in the allow.ip file and not restricted in the deny.ip file,  is the caller categorized as a trusted partner.

Comments can be inserted by placing a number character (#), in the first column.

 

3.    Location of ip files:

By default the allow.ip and deny.ip files should be located in {MDM Server root}\exe.

 

In other words these files have to be stored in the folder in which the executable is located.

For example, if the MDM system ID is M01, the location of the trusted configuration files is usr\sap\M01\MDS01\exe.

Alternative location for these files can be specified by entering a line in the mds.ini file.

For example, TrustFiles Dir={folder path}, indicating that both the allow.ip and deny.ip files are in the folder, {folder path}.

 

When the MDM server runs on an AIX platform, the mds.ini file must contain the parameter, TrustFiles Dir = {folder path}.

After the initial configuration, the trusted partners are configured, enabling trusted cooperation between the Web AS servers and the MDM server.

 

After making above changes its mandatory to restart MDM server instance.

SAP NetWeaver MDM 7.1 is the proven infrastructure technology for cross-domain master data consolidation and harmonization across the enterprise. The latest support package, released on August 24; provides you with the following benefits:

 

Improvements related to PIM and Web-channel Experience:

  • Import images by Java API. You can now run a batch/automatic import of images and documents. This can be used to import thumbnails that were generated outside of MDM.
  • Taxonomy attribute with remote system keys. You can now define key mapping  of remote keys for attribute definitions.
  • Search by tuple value. You can now sort main table records by tuple field value.

 

Core MDM data model, usability, processing, data integration and administration enhancements:

 

  • Data Model:  Additional coverage for Tuples; Setting access rights at field level in a Tuple; Adding new timestamp, user stamp, create stamp and Auto-ID fields in a Tuple; Assignments into tuple member fields.

These enhancements allow you to:

1. Better control the security on tuple level

2. Better manage the data in a tuple

3. Better manipulate the data in the tuple

 

  • Usability, Processing; Administration:

End-User / Web Component (Web Dynpro). Within Web Dynpro components the following can be controlled:

    • Language inheritance in Lookup fields: You can now display the language inheritance values in the Lookup that are in Web Dynpro.
    • The tuple comparison feature in Web Dynpro now indicates whether the tuples are equal or not. This lets you find out very easily whether any changes were made to the tuples in a checked-out record compared to the original record’s tuples.
    • You can now configure "word wrap" for the label in a Search component.
    • You can add new events for:
      • Load of the Merge Component. This allows you, for example, to perform additional validations on the resulting record of a merge operation.
      • Getting records to merge & remove record. This allows you, for example, to store the data from records to be merged before the merge operation.
      • Tuple selected record as part of an Item Details view. This allows you to display the selected tuple record in the Item Details view when it represents a tuple as a flat structure.


 

  • Data Integration: Import, Export / Syndication:  You can now define permissions for exporting read-only tables and fields to Excel.

 

  • Schema Transport: The "Import Change File" in the MDM Console now displays the schema change files that were transported by the CTS+.

 

  • Publishing/Print: Support of InDesign CS5.5.

 

  • UOM (Units Of Measure): The UOM Manager is now integrated within the MDM Console; This allows you to control the measurements on a Win64 bit system (e.g.: Windows 7) and also provides support for all the MDM-supported databases including those that were not previously supported by the legacy UOM Manager.

 

  • New CLIX command to output the current list of MDS connections..

 

And What’s Next?

SAP NetWeaver MDM is a mature product on a stable core. Continuous improvements are planned as usual in annual Support Packages. SP10 is planned to be released in Q2 2013.

babu kotana

MDMGX extraction

Posted by babu kotana Jun 7, 2012

Hi,

while i am trying to extract data from ECC using MDMGX not able to extract lookup(hierachy) tables.please help in this.

 

Thanks in advance.

coti

EIM.jpg

A book on SAP Enterprise Information Management is planned to be published in May. Content includes, for example:

  • Step-by-step instructions for working with SAP Data Services
  • Most important tasks in SAP Information Steward, SAP Master Data Governance, SAP NetWeaver Information Lifecycle Management and more

All royalties donated to Doctors Without Borders.

For more information, see the SAP Press bookstore.

What are your requirements for, and experience with  “analytical master data management (MDM)”?


Analytical MDM is the provision of authoritative master data for enterprise-wide reporting and analysis.  This research sponsored by SAP seeks to understand how organizations such as yours are approaching the need for analytical MDM, and how well the products in the market are meeting those challenges. 

What is the difference between analytical MDM and operational MDM?

 
Analytical MDM is focused on the management of master data and associated hierarchies that are required for aggregation and analysis within the data warehouse and in business intelligence reporting tools.  Operational MDM, by contrast, provides authoritative master data to operational applications such as ERP and CRM systems.  SAP has commissioned a survey from market research firm The Information Difference to help us gain this insight.

 

The survey will take around 10 minutes of your time.  As thanks for your time, SAP will send you a summary of the analysis when it is complete.  In addition, you will automatically entered into a prize draw that may win you an Information Difference “Vendor Profile” report of your choice, a value of US $ 495.   We will also donate US $ 2 per completed survey to the International Red Cross. 

Please take the survey!

The Customer: Surgutneftegas

Surgutneftegas, one of the largest oil and gas producers in Russia, employs innovative technologies and automated processes. To create an IT infrastructure and facilitate its transition to service-oriented architecture, the company deployed sophisticated SAP® software and technology. By helping to raise data quality, the solutions allowed Surgutneftegas to optimize inventory, reduce purchasing costs, and achieve a dramatic return on investment.

“SAP Consulting professionals helped us build a solution that supports our business processes with current, consistent master data. This project is the first step in building our new, service-oriented IT architecture.”

Rinat Gimranov, CIO, Surgutneftegas

Key software components involved:

  • SAP NetWeaver Master Data Management
  • SAP NetWeaver Portal
  • SAP NetWeaver Process Integration
  • SAP NetWeaver Business Warehouse
  • SAP ERP

For complete scenario and implemetation details, click the link above.

Stay tuned for the next customer example.

Regards,

 

Markus

TechEd

Markus Ganser wrote a great blog on some See what Enterprise Information Management has in the bag at SAP TechEd 2011. I’m going to highlight a few from the TechEd Las Vegas session, because that’s where I get to go. J I’m also including Expert Networking Sessions and Pod discussion topics from the show floor. Because Information Governance spans so many technology areas, I thought I’d pull them together for you.

Pre-conference seminar: Newly-added SAP Master Data Governance session on Monday.

Key Hands-On sessions

  • EIM266: Next Generation Archiving: Extend Compliance in Your Corporate Environment
  • EIM161: Using Business Content Extractors in SAP BusinessObjects Data Services
  • EIM164: SAP Data Migration Solution Overview: Best Practices Hands-On
  • EIM163: Profile and Create Data Quality Scorecards to Understand the Health of Your Data
  • EIM267: The Importance of Cleansing and Standardizing Product Data
  • PMC265: Accelerating Business Rules with SAP NetWeaver BRM
  • PMC263: Process Analytics with SAP NetWeaver Business Process Management
  • EIM260: Getting Started with SAP Master Data Governance
  • EIM262: SAP NetWeaver Master Data Management and SAP BusinessObjects Information Steward

Key Lecture sessions

  • SAP BusinessObjects Data Services 4.0 and Beyond
  • EIM102: SAP Data Migration Solution Overview: Best Practices
  • EIM204: Connecting ECM to Business Processes: Evolving Needs and Technologies
  • EIM100: Enterprise Information Management Overview
  • PMC228: IDEXX Runs Marketing Points Program on BRF Rules Engine
  • PMC228: Applied NetWeaver BPM and BRM in Agile and High Volume Scenarios
  • PMC102: Business Rules Management with SAP: BRFplus and SAP NetWeaver BRM
  • EIM203: SAP BusinessObjects Information Steward 4.0 Product Overview
  • EIM112: Strategies and Tools to Ensure the Quality of Your SAP Data
  • EIM114: Information Governance: Reducing Costs and Increasing Customer Satisfaction
  • EIM211: Showcasing MDM Workflow Integration with BPM and Data Services
  • EIM106: SAP NetWeaver MDM for Customer Data Integration: Rapid Delivery in Eight Weeks
  • EIM201: Applying Information Governance in End-to-End MDM Scenarios

Pod topics on the SAP Show Floor

  • EIM-P11: Access and transform data from any source (Tuesday at 10am)
  • EIM-P01: SAP BusinessObjects Data Services Roadmap (Tuesday at 11am)
  • EIM-P19: SAP NetWeaver Information Lifecycle Management (Tuesday at 12pm)
  • PMC-P06: Business Rules Management with SAP (Tuesday at 2pm)
  • EIM-P17: Master Data Management at SAP (Wednesday at 10am)
  • PMC-P02: SAP NetWeaver Business Process and Rule Management (Wednesday at 1pm)
  • EIM-P14: Support your Information Governance program with Information Steward (Thursday at 2pm)

Expert Networking Sessions

  • Tuesday at 2pm: Guidelines on Starting a SAP Data Archiving Project (Karin Tillotson)
  • Wednesday at 11:30am: Build your own network with SAP StreamWork (Sharon Haver)
  • Wednesday at 1:30pm: Getting started with Information Governance (me!)
  • Thursday at 6pm: How to organize and deliver a business rules project (Carsten Ziegler)

PLEASE join me in the Influence Council session for EIM350: Enterprise Information Management on Tuesday afternoon.

To get a complete picture of the lectures and hands-on sessions offered in the Enterprise Information Management track, click the EIM session overview link and select the topics that you are interested in and would like to attend. To display the overall education and session catalogue, click the URL at the top of the blog.

Mark your calendars! Join us at a lecture, hands-on session, Expert Networking Lounge, or Expert Pod. Find us when we're there by sending a tweet to @InaSAP, @SAPMDMGroup, @SAPILM, @SAPECM, or @SAPBOEIM. 

The Customer's Voice: Votorantim

Present in 20 Brazilian states and 15 countries, the Votorantim Group operates in industry, finance, and new business development. Votorantim implemented SAP NetWeaver® Master Data Management to improve the management and standardization of its material registration and request system, in line with UNSPSC standards.

“In an innovative project in Brazil, we implemented SAP NetWeaver MDM and received a total commitment from the team throughout the stabilization actions. Today we consider SAP NetWeaver MDM an extremely useful tool in Votorantim’s business processes.”

Nayla Alves Santos, SAP Coordinator, Votorantim Group

For a summary of the MDM scenario set-up and implemetation details, click the link above.

Stay tuned for the next customer example.

Regards,

Markus

General Information About the Blog Series

In this SCN blog series, we'd like to let you hear directly the customer's voice when it comes to mastering master data in the enterprise. The blogs include video statements, podcasts or blogs from SAP MDM customers plus additional info on the MDM initiatives.

The Customer's Voice: Colgate Palmolive

Part Three features Colgate Palmolive. This global consumer products powerhouse uses SAP NetWeaver MDM Global Data Synchronization for streamlined trade item data transfer to retailers, core SAP NetWeaver MDM to improve global spend analysis, achieving a single version of the truth, and synchronize vendor data to and improve processes. What is more, Colgate also has implemented domain-specific SAP Master Data Governance to establish governed data maintenance and stewardship processes embedded in SAP ERP.

More Information on Colgate-Palmolive's MDM Initiative

 

Multi-facetted MDM Initiative comprising SAP NetWeaver MDM, GDS and SAP Master Data Governance

Master Data Governance for financial data and material data

Establish embedded data governance and upfront stewardship for financial data and material data on top of SAP ERP.  Read the A bucket of smart ideas - Master Data Governanace Framework for Enterprises by Pratik Talwar, SAP Mentor and software developer for Colgate Palmolive Co.

Consolidation of vendor data and global spend analysis

Provide single version of the truth and high-quality vendor information to streamline procurement processes. Also aggregate spend information as a basis for procurement savings. For more, watch customer video at sap.com.

Global Data Synchronization

Transmission of global trade item data to retailers according to industry standards, using 1SYNC data pool as single point of entry. To secure that products make it to the retailers' shelves as quickly as possible.
See Enterprise Master Data Management and watch customer video at sap.com.

Stay tuned for the next session.

Regards,

Markus

General Information About the Blog Series

In this SCN blog series, we'd like to let you hear directly the customer's voice when it comes to mastering master data in the enterprise. The blogs include video statements from SAP MDM customers plus additional info on the MDM initiatives.

The Customer's Voice: SentrySafe

Part Two features Sentry Group, a privately held manufacturer of fireproof files and safes. The company uses SAP NetWeaver Master Data Management to get a single view of their product data.

http://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/80415b75-328b-2d10-d1ad-cc0d8a8e0fff&overridelayout=true

Click the image to start the video and listen to Gregg Griebel, ERP Program Manager at Sentry Group.

More Information on SentrySafe's MDM Initiative

Type of MDM Initiative

Consolidation of Product Data to provide one single source of truth

Aggregate and consolidate product information from various sources into central MDM repository. Feed SAP ERP back-end with consolidated product information required for streamlined transactional processing.

Stay tuned for the next session.

Regards,

Markus

General Information About the Blog Series

In the upcoming blog series, we'd like to let you hear directly the customer's voice when it comes to mastering master data in the enterprise. The blogs are planned to include video statements from SAP MDM customers and links to detailed project descriptions.

The Customer's Voice: Lexmark International Inc.

Part One features Lexmark International Inc., leading company in the printing and imaging industry, and winner of the 2011 Gartner MDM Excellence awards.

“To stay competitive in today’s complex business landscape, a company needs to make quick decisions based on timely analysis [...] But what good is analysis if you don’t trust the data it’s based on?"

Click the image to start the video and listen to Joe Young, Information Delivery Manager at Lexmark International Inc.

More Information on Lexmark's MDM Initiative

Type of MDM Initiative

Multi-domain master data consolidation/harmonization from disparate applications to ensure trusted company analytics and streamlined business processes.

Data Domain(s)

• Customer data
• Product data
• Material data
• Supplier data
• Employee data

System Landscape/Architecture

• SAP NetWeaver MDM
• SAP NetWeaver Portal
• SAP NetWeaver Process Integration
• SAP BusinessObjects™ Data Services
• SAP ERP application

More details 

 Read the Solution Brief

 

I hope this brief journey into real-life MDM scenarios helps you in getting a clear picture of how customers use SAP MDM and what it can do for big enterprises running an MDM initiative.

Stay tuned for the next session.

Regards,

Markus

Introduction

Master data management initiatives that we find at our customers are manifold. They range from Indexing & Grouping of master data for analytical purposes, via Consolidation of duplicates into “golden records” or Harmonization of master data attributes across a system landscape, to various Central Maintenance scenarios.

SAP’s master data management portfolio covers these broad customer needs with a comprehensive portfolio of MDM infrastructure and MDM applications. You might be well aware of our proven multi-domain infrastructure SAP NetWeaver Master Data Management, and of SAP BusinessObjects Data Services for Extract Transform and Load (ETL) scenarios as well as for Data Quality improvements like address cleansing or duplicate detection.

With SAP Master Data Governance (SAP MDG), we are complementing this portfolio with an increasing number of governance applications for selected master data domains, all tailored for centralized data maintenance and ready to run in SAP environments. SAP Business Suite 7 Innovations 2010 provides you not only with an extension for SAP MDG for financials master data but also with new SAP MDG applications for supplier and material master data.

This new version of SAP Master Data Governance goes into ramp-up shipment to customers on December 20, 2010 together with Enhancement Package 5 for SAP ERP 6.0.

SAP Master Data Governance

SAP Master Data Governance is a family of process-centric applications that provide centralized governance for selected master data domains based on SAP's standard data models. The applications come with a native integration with the Business Suite, using existing business logic and customer-specific configuration for validation of master data while it is being created. SAP MDG integrates with SAP Business Objects Data Services (DS) for data quality and enrichment. It uses the data quality engine in DS to inform the user about duplicate data sets and uses DS’s rich address enrichment features to support users in entering correct addresses for their business partners.

SAP MDG allows for designing workflows for the central master data creation or maintenance process. These workflows will typically involve multiple people adding their expertise to complex master data – like one person editing classification information in a material master and another one adding alternative units of measurement and their conversions. The workflows will also include workflow steps for approval of the changed data. Until the approval, the data is kept in a so called staging area, separate from productive master data, and only after approval it will be posted to the master data tables in the SAP system and distributed to all systems that subscribed to these master data changes. Through this, SAP MDG delivers consistent definition, authorization and replication to corporate systems, like SAP Business Suite and non-SAP systems. Through tracking all changes and approvals, SAP MDG supports compliance and a complete audit trail.


 
What’s the Value for Your Organization?

Did you ever hear your Finance people or your CFO ask questions like:

  • How can I reduce manual work when updating financial master data and at the same time increase quality in my multi-system environment?
  • How can I efficiently and safely execute and track required changes (who changed what, when and why)?

Or did your VP of Procurement ever ask:

  • How can I maximize financial benefits (i.e. discounts, conditions, central contracts) through correct and complete supplier data?
  • How can I improve my procurement decisions, i.e. supplier performance / evaluation, duplicates, spend analysis that falsify my view on my suppliers?

Did the Manufacturing head ever challenge you:

  • How can I establish a “maintain once – use everywhere” best practice?
  • How can I reduce redundant effort to maintain master data, i.e. through avoiding duplicates?
  • How can I accelerate availability of up-to-date master data in my business network?

And maybe your CIO added that while accomplishing all that, how can you best leverage your investment in SAP?

The Innovations 2010 version of SAP Master Data Governance will help you to address all these questions. Let me tell you how.

SAP Master Data Governance Applications

SAP MDG offers you master data maintenance capabilities through a role-based domain-specific WebDynpro user interfaces or through Internet Service Request (ISR) forms. You can access the screens either through SAP Enterprise Portal or through SAP NetWeaver Business Client. In addition to central maintenance, data from external sources is supported. For example, you can upload data into SAP MDG via file or services, and then further process (or enrich) the data in SAP MDG. You can also use the search capabilities to start processing. These include database search, exact or fuzzy search via SAP Enterprise Search, and a fuzzy address search via SAP BusinessObjects Address Services.

Data in process through so called Change Requests is stored in a separated repository (staging area), and will be transferred to active area after approval. Active area can be the operational SAP database (“re-use option”) or generated within SAP MDG (“flexibility option”). SAP delivers standard data models and user interface configurations out-of-the-box. These data models are based on SAP Business Suite (financial data, business partner data, and material data)  and can be extended by customers. Also the user interfaces can be changed to meet the users' needs. Single item maintenance as well as mass maintenance is available.

Data can be validated against certain rules during entry or maintenance. Validation is done against SAP Business Suite logic, wrapped by the Business Rules Framework (BRFplus) and supported by SAP BusinessObjects Data Quality Services (like address verification and completion) or external services (like DUNS numbers). Customer specific validation logic can be added. During validation the system also checks for duplicates – optionally again using SAP BusinessObjects Data Services. Data can be enriched using BRFplus.
 
Figure 1: Illustration of the Master Data Governance process

Figure 1: Illustration of the Master Data Governance process

The entire master data governance process is flexible and can be adapted and tailored based on defined responsibilities existing in a company across various business units. The underlying SAP Business Workflow is rule based. For example that means that the next step can be derived from results in the rules framework (BRFplus). Besides the actual maintenance and approval, workflows can include steps such as activation, replication etc.

Approved and activated data changes can be replicated to SAP systems (delivered out-of-the-box) and non SAP systems. The replication is controlled by the so called Data Replication Framework (DRF). This provides the flexibility to replicate selected data only to specific client systems by defining filters. It supports peer-to-peer communication as well as replication via a broker (like SAP PI). Replication can be handled via various means (like Enterprise Services, ALE / IDOC, RFC, or File) all control through the same framework. The DRF supports Key Mapping and Value Mapping and monitors replication activities, failures etc. through all channels. Replication can be started manually, or can be scheduled, or can be automatically triggered as part of a workflow. In order to support flexibility in data ownership, some data can be maintained in the SAP MDG hub, other data would be added in the client systems after replication.

SAP Master Data Governance for Financial Master Data

In the Innovations 2010 version, SAP MDG provides governance applications for a broad set of financial master data, these include Charts of Accounts, General Ledger Accounts, Companies and Group Companies, Consolidation Units, Profit Centers and Cost Centers including their hierarchies, Cost Elements and Cost Element Hierarchies.

As mentioned before, Change Requests organize the data changes and the workflow across the various users and they document all changes for auditing purposes. Typically Change Requests are for a single master data object. If you want to synchronize multiple changes, you can cluster them into so called Editions. These allow you to, for example, group all changes for the chart of account for the next financial quarter into one Edition and then to activate all approved Change Requests of that Edition at the same time.

All changes are kept in the central system’s staging area until approval. They can then be distributed to operational Group systems or to Local financial systems. The distribution is possible via Enterprise Services or file download- upload.

Figure 2: Editions group multiple Change Requests for approval and distribution

Figure 2: Editions group multiple Change Requests for approval and distribution

Figure 3: Creating a Change Request for a Group Account 

Figure 3: Creating a Change Request for a Group Account

SAP Master Data Governance for Supplier Master Data

With the Innovations 2010 version, SAP Master Data Governance now also supports governance of supplier master data creation and changes. The focus of the first release is on corporate, company and purchasing attributes of suppliers. Search, display, change, and creation of single supplier master data is supported as well as mass processing or changes to supplier hierarchies.

Again, Change Requests steer the maintenance and approval process of new or changed data, based on a workflow-driven creation and change process for suppliers. And they document all changes for later audits. SAP Business Objects Data Services supports data quality services in SAP MDG such as duplicate check or address validation during the maintenance. There is an option for file upload for initial load scenarios or for supplier on-boarding.

All changes are kept in the central system’s staging area until approval. They can then be distributed to operational systems. The distribution is possible via Enterprise Services or Application Link Enabling (ALE).

Figure 4: Maintaining the Master Data of a new supplier

Figure 4: Maintaining the Master Data of a new supplier

Figure 5: Work lists provide information which due changes need the user’s attention

Figure 5: Work lists provide information which due changes need the user's attention

SAP Master Data Governance for Material Master Data

Also new in the Innovations 2010 release, SAP MDG allows for central creation and change processes for material master data. The focus for now is on identifying and descriptive attributes of material master including basic data and classification. Again, search, display, change, and creation of single material master data is supported as well as mass processing or file upload.

As before, workflows and Change Requests document and steer the complete process of maintenance and approval. The non-approved data is kept inactive in the staging area, from where it is distributed after approval into the active data sets and to other systems - typically via ALE. As with the other domains, work lists inform users of due changes.

Figure 6: Changing the Product Hierarchy of an existing material

Figure 6: Changing the Product Hierarchy of an existing material

Figure 7: You can access the change requests that you triggered yourself to track their progress 

Figure 7: You can access the change requests that you triggered yourself to track their progress

We are planning to extend the standard scope of SAP Master Data Governance per master data domain and also to cover additional domains with the next releases of SAP MDG in the coming years.

A Great Extension to SAP's Master Data Management Portfolio

As said in the beginning, together with SAP NetWeaver Master Data Management, and SAP BusinessObjects Data Services, SAP Master Data Governance complements SAP's Master Data Management (MDM) portfolio. Being one of the key pillars of Enterprise Information Management, MDM helps customers manage and govern multi-domain master data across heterogeneous IT landscapes. Typical usages are, for example, customer data integration, product information management, or global data synchronization.

Typically, when companies adopt an enterprise MDM strategy, they either pursue a decentralized or a centralized approach:

  • In de-central authoring and consolidation, data originates in the local systems and the MDM instance serves as a central hub for subsequent consolidation of globally relevant master data information. This consolidated information can then be propagated across the system landscape to ensure overall data quality.
  • In central authoring and governance, the primary goal is to drive data quality already at the point of creation. The data is created on a central system and distributed to other systems to be used in operational or analytical processes there.

Following a very typical path towards central master data management, companies might start an MDM strategy at a local system scale by verifying the data quality, then integrating the data into a global MDM hub for central consolidation and harmonization across multiple system, and finally adopting central data governance mechanisms to ensure data accuracy upfront.

Accordingly, SAP's master data management portfolio supports the manifold customer needs in a holistic way, including data integration & cleansing, de-central authoring, consolidation and harmonization, up-to central master data management and governance.

In this context, SAP BusinessObjects Data Services is SAP's strategic go-forward data integration and data quality solution that can access, transform, cleanse, and deliver any type of data from anywhere at any frequency. In this capacity it supports SAP NetWeaver MDM as well as SAP Master Data Governance with data quality services in all relevant scenarios. You can find more information on the Data Services site on SDN.

SAP NetWeaver MDM is the proven generic infrastructure for analytical and operational MDM use cases like master data Consolidation and Harmonization, as well as Central Master Data Management scenarios focusing on globally relevant master data attributes for use in heterogeneous environments, consisting of SAP and non-SAP applications. More information can be found on the Enterprise Master Data Management.

As laid out in detail above, SAP Master Data Governance focuses on comprehensive master data ready for use in SAP applications, through ready-to-run governance applications for specific master data domains. It provides pre-built validation against SAP business logic and customer's configuration settings, and can distribute master data to SAP and non-SAP systems. For additional information, visit the Embedded Master Data Management.

SRM Catalogue in Innovations 2010

SAP NetWeaver Master Data Management is also the foundation of the buy-side catalogue of SAP SRM. You can find more information in the Procurement in SAP Business Suite 7 Innovations 2010 blog and at the SAP MDM Procurement Catalog Management.

Global Data Synchronization 2.1

With the new version of SAP NetWeaver MDM for Global Data Synchronization (GDS) SAP provides superior process automation (like exchange of catalogue selections via peer-to-peer exchange, connectivity to the data pools of SA2 Worldsync, or Web-Service enablement for key processes). GDS 2.1 also enables more flexibility (like displaying images assigned to trade items, or improved value based restrictions). In addition, it offers enhanced process logging capabilities and the ability to exchange prices in compliance with the GS1 format.

Accordingly customers can now select between the two leading data pools of the world and eliminate the number one error root cause between manufacturers and retailers. They can also communicate with trading partners not participating in GDS using the GS1 standard, or trigger GDS processes from external applications.
Other key benefits include increased usability and clearly separated areas of responsibility, simplified handling of products, and easier error reconciliation. For more information please refer to the SAP MDM Global Data Synchronization.

In this new SAP How it Works podcast, listen to Masato Inoue as he walks you through a brief introduction to MDM ABAP API for SAP NetWeaver Master Data Management 7.1 (SAP MDM 7.1).

He shows the deployment of the MDM ABAP API add-on to your ABAP system and configuration of the ABAP system and MDM system. Some sample programs are also introduced also.

Filter Blog

By author: By date:
By tag: