skip to Main Content

SAP Master Data Management + Google for Work

Thousands of organizations rely on SAP to run their operations effectively.  Extending and leveraging master data from SAP is an everyday occurrence, and becomes more challenging for organizations migrating toward Google Apps.


A first step in preparing to leverage Google Sheets for interaction with SAP master data is to determine who is currently using SAP data in programs such as Microsoft Excel or Access, for what purposes, and how frequently.


A current usage inventory should gather the following at a minimum:


  • Firstly, Description of the Activity
  • Secondly, Fields used in the Activity (i.e those being accessed/updated/loaded)
  • Reason for the Activity
  • How Frequent does the Activity occur
  • Which Business Unit/Department is the Activity serving
  • End-user initiating the Activity
  • Finally, IT or other supporting the Activity


We have seen organizations build on this basic “ETL”-like inventory with additional data, such as:
  • Firstly, Risk Level of the Activity
  • Secondly, ocation of the Master Data (i.e. Instance #, Prod, Test…)
  • Thirdly, Script #
  • Approver
  • Transaction Reference or Code
  • Finally, the date of last Run, etc.


Be sure to check every department for current Master Data access; we see scripts built that affect almost every part of the organization (Finance, HR, Production, Quality, Purchasing, Engineering/Manufacturing…).


It is not unusual to see several hundred existing processes identified using this method. Further, if “desired” applications are also part of your discovery, many more can be documented.


Mindset’s CloudSimple for Data™ enables master data management and collaboration within Google Sheets.  Authentication and security are robust, and the collaborative capabilities of Google Sheets permit faster and ‘true-source’ teamwork on an activity.  And at under $30/month per user, the budget needn’t restrict usage or collaboration.


For help in inventorying or leveraging your master data within Google for Work, give us a call.
If you are interested in viewing similar articles, visit our blog, here
View our LinkedIn, here

Peter Brasket has led the Business Operations of Mindset since 2016, and is an investor and director in the business. Prior to Mindset Peter was a co-founder of Jobs2Web (acquired by SAP in 2012), and retired from SAP in 2015 after serving as global evangelist post-acquisition. Prior to Jobs2Web Peter managed Business Development for, Channel Development for Gartner Group, International Sales for J3Learning, and International Sales for Varitronic Systems. Peter has is MIM degree from the University of St. Thomas and BS from St. John's University in Economics, and post-graduate work at Waseda University (Japan). Peter is also an investor in other projects locally, such as

Back To Top