Master Data Management

We are providing Industrial Asset Management & Technical services such as Master Data Management, Materials Management, Maintenance Management, Spare Parts Review, Inventory Analysis and Manpower Support to various Process Industries

Material Master

Material master contains descriptions of all materials that an enterprise procures, produces, and keeps in stock. It is the central repository of information on materials (such as inventory levels). Material master contains descriptions of a variety of data elements including part number, description, and stocking codes.


  • Purchasing data is required for ordering purposes
  • Spend Analysis on different segments
  • Inventory management data is needed to post goods movements and carry out physical inventories
  • Accounting data is required for material valuation
  • Materials planning data is needed for material requirements planning

Vendor Master

Vendor Master is fast emerging as an integral part of the procurement and related systems for enterprises. It checks and addresses issues pertaining to inefficient processes and erroneous reporting to the management. It also helps in standardizing various naming conventions for vendors


  • Duplication (rationalization of vendor base by cutting down on multiple suppliers)
  • Payment & taxation errors/frauds
  • Incomplete data (original vendor name, address, hierarchy, etc)
  • Lack of information (source of certifications, W9 forms, insurance certificates, etc)
  • The currency used for ordering from the vendor
  • Terms of payment
  • Names of important contact persons (sales staff)

Data Aggregation

  • Receive data from Business disc
  • Segregate data according to requirement
  • Convert to standard template
  • Concentrate data according to the compliance report

Data Cleansing

  • This step is essential for identifying duplicate vendors within the vendor data
  • All short forms/ Acronyms of Vendor Name, Vendor Address, Bank address, bank name need to be converted full forms
  • The cleansing team will convert each data field into the pre-decided data format to ensure uniformity
  • Vendor Address needs to be converted to a standard format in terms of sequence of entries
  • Define a standard format for each data column

(a) Data Collection Primary Sources

  • This involves collection and verification of mandatory data by contacting the vendor directly
  • Based on the phone number of the vendor as available in the vendor data, the vendor will be called for requesting the data
  • Once all the mandatory data is collected and verified the status on the vendor will be updated on the template
  • Vendor Address needs to be converted to a standard format in terms of sequence of entries
  • Define a standard format for each data column

(b) Data Collection Secondary Sources

  • This involves collecting un-available data from vendor company website
  • Through other third part database search (Example: D&B Website)
  • Update the vendor details in the prescribed format

Vendor Codification

  • This step provides the unique vendor code to all vendors across the group
  • The unique vendor code can be xxxx digit, running number
  • The unique vendor code will be sequentially assigned to each vendor by giving a running number starting from xxx1

Service Master

Service master is a consolidated list defining various services performed by the contractor in the plant. In case of various business units, it is advantageous to have a uniform structure / definition among various units of an organization to ensure standardization of service description and remove duplicates.

It is a Master file which contains all the information of a particular Service line-item material used in the organization depending upon the views selected from the user departments.

Vendor Codification

  • Spend on service
  • Resource Discovery
  • Product Awareness
  • Standardize records across locations and applications
  • Identify and consolidate significant spend from core suppliers
  • Recognize non-preferred suppliers and wastage of supplies
  • Spot saving opportunities for inventory management
  • Perform extensive and accurate spend analysis
  • Monitor item spend and utilization patterns

  • Determination of requirements

A requirement for certain external services may arise in a user department of the enterprise. It may involve a particular project (for example, the translation of software documentation) or maintenance work (for example, the outsourcing of electrical work that becomes necessary on company premises).

  • Creation of service specifications

When a requirement is established, a document is created in the system as the basis for the procurement process (this may be a purchase requisition, for instance). The document can contain a set of service specifications listing the necessary services in detail. However, in this early phase of the procurement process, you also have the option of doing without service specifications entirely and considering only the unplanned services by setting value limits.

  • Source determination/vendor selection

To be able to convert a requirement into a purchase order, you must determine a suitable bidder who is prepared to provide the necessary services. There are a number of different ways in which the system can support you in finding potential sources of external services. The source determination function is an instrument for analyzing and evaluating purchasing data that has already been entered in the system (in the form of service conditions or contracts, for example).  If services for which there has been no previous requirement (and thus for which no source is currently recorded in the system) are requested, a bid invitation process must be carried out. You can replicate this bid invitation process using the RFQ/quotation facility for services.

  • The UNSPSC Code
  • Segment: Building & Construction Maintenance Services – 72000000
  • Family: Heavy construction services – 72140000
  • Class: Infrastructure building and surfacing and paving services – 72141100
  • Commodity: Sidewalk construction and repair service – 72141105
  • Final Code – 721411050000

Product Data Management (PDM)

PDM is kind of a tool that provides a structure way to orderly and efficiently store, integrate, manage and control both data and the product development process (from design, manufacturing and distribution)

  • Manages all product related information
  • Manages the entire product life cycle
  • Allows information sharing regardless of data location or hardware platform

We at Technical Structures Co. Services offers the below

  • Product Data Management (PDM)
  • Engineering Data Management (EDM)
  • Document Management
  • Product Information Management (PIM)
  • Technical Data Management (TDM)
  • Technical Information Management (TIM)

Asset Register and Plant Maintenance

We can develop customized maintenance and job plans for your equipment, taking into consideration OEM Manual recommendations, regulatory and industry standards, company policies, appropriate predictive maintenance strategies, historical equipment data, environmental requirements, and operating conditions. This includes such data as a complete equipment hierarchy, equipment/asset register, PMs, spare parts/inventory, and bills of materials. This is a large part of our core business. We will also develop Business Rules to guide future data development and entry.

  • Development of Asset Register
  • Support services for CMMS implementation
  • Gap analysis on Existing CMMS data quality & Improvement plan
  • Function Location and Equipment Creation
  • Equipment Hierarchy Build
  • Bill of Material development (BOM)
  • Maintenance Plan data preparation & Alignment
  • Task list operations development
  • Maintenance Craft Procedure (MCP) Preparation
  • As-Build Asset Verification
  • Asset Data cleansing and Restructuring
  • Job Planning & Scheduling
  • Work Order Prioritization
  • Maintenance Strategy Development
  • Maintenance Processes Development
  • Performance Management
  • Equipment and Parts Criticality Analysis
  • PM Development (lubrication, predictive and preventative)

CMMS & SPARE Support and Activates


Spare parts are needed to provide an uninterrupted operation of certain equipment e.g., shafts, impellers for centrifugal pumps stocking of s/p justified only if it is foreseen, they will be used in near future where deterioration (wear) of equipment concerned.

Interchange ability:  A condition which exists two or more items possesses such functionally and physical characteristics as to be equivalent in performance and durability and are capable of being exchanged one another without modification in item nature.

  • Item description is enough to identify the spare
  • Part numbers provided are really a part number or a drawing position number
  • Drawing & position number matches with provided drawing manual
  • Equipment/Item specification is enough to assign MESC code
  • Specifications provided like Dimension; Material matches with the respective drawing information.
  • In case of generic items appearing as spare, check whether the OEM part number provided is complete Advisors program, all supplier E-SPIRs are collected in one file and Spare Parts Interchangeability Review
  • Duplicate items are eliminated in this process
  • Spares are formatted for items in generic nature
  • Material groups are provided
  • Vendor codes are verified
  • EAM and CMMS lifecycle

Technical Structures Co. provides services to facilitate every stage of the EAM and CMMS lifecycle by implementing and sustaining, including:

  • Current state assessment
  • Process and procedures development
  • Data gathering, organizing and assembly
  • Asset register and hierarchy development
  • Field verification of assets
  • Development of bill of materials
  • Equipment criticality and reliability analysis
  • Task list, job plan and PM development
  • Reliability centred maintenance (RCM)
  • Planning and scheduling optimization
  • Criticality assessment
  • Maintenance strategies
  • Preventive maintenance tasks
  • Hierarchal asset register development.

Solution manager

We at Technical Structures Co. helps in Systems Reliability, Supportability and Availability Analysis for all your manufacturing and maintenance need.

  • Identify policies that preserve the function of an asset in its operating context
  • Preserve the function not just maintain the equipment

SAP Support & Consultant Placements

Now that you have chosen the software, we’re here to help with on-going support – so you can go live faster and realize the full benefits of your SAP solution. With support for all stages of your solution’s lifecycle – from planning and implementation to operations and optimization – our full range of services can help reduce your total cost of ownership (TCO)

Get the most out of SAP Enterprise Support for seamless implementation, innovation, and operations. Plus, benefit from our tailored support engagements and project-based offerings that provide on-demand support and help you manage technical risk in all phases of the SAP application lifecycle.

Support Offerings Overview

We can help you maximize the stability, availability, and performance of your entire solution landscape – all by harnessing the strength of our global engineering organization. Under our guidance, you can implement better, operate better, and innovate better.

We can help you optimize the value for your support needs, regardless of your current application lifecycle phase. With SAP Enterprise Support, you can realize these advantages:

  • Accelerate implementations using a central platform for application lifecycle management
  • Lower project costs by avoiding unnecessary modifications
  • Establish a foundation for efficient and automated operations
  • Identify technical risks and optimize potential opportunities, continuously throughout a project
  • Prevent project delays by gaining fast track support, beginning from day one

Solution manager

  • The SAP standards for solution operations
  • The road map of Run SAP to implement end-to-end solution operations
  • Support services

On Demand Automation Support

We at Technical Structures Co. helps in the process of Data automation of updating your data on your open data portal programmatically, rather than manually

Automating the process of data uploading is important for the long-term sustainability of your open data program.

There are three common elements to data automation: Extract, Transform, and Load, or ETL.

Data Automation customizes and connects software so you can focus on building your business, we at Technical Structures Co. helps in form of all aspects.

  • Optimize Output
  • Take Back Your Time
  • Eliminate Human Error
  • Expand your service’s customer market and increase user retention
  • Minimize the time costs caused by inefficient and repetitive tasks
  • Automations improve workflow accuracy, so projects don’t fall through