Saturday, July 15, 2017

Fundamentals of Implementing a Product Safety Module - Topic 2 Data Migration:

Hello,

As it is evident in all implementation projects, consultants needs to set up the master data during the initial system set up and move the legacy data. There are different methods one can follow to load the data into the system. The pre-requisite is cleansing the data and modifying the content and formatting the information into to a specified layout. There are different tools available to load the information into the SAP EHS systems. The different tools which can be used include i) SAP EHS OCC and ii) Data Editor and iii. Custom Excel templates.

The tools namely Data Editor has two functionalities called PIT and SIT. Phrase Import Tool and Substance Import Tool.  While SAP EHS OCC has similar functionality like Data Editor It has different options of loading the content with different validity / Usage area information directly from the import tool and also deleting the content and loading the information.

In order to load the content into the system it is always useful to load in sequences and parts like start with creation of Header Information, followed by Identifiers, references, Material assignments and property data and then compositions. Usually the Listed substances are created first, followed by Raw Substances / Vendor / Raw Substances. Then substances are loaded at product level.

For each of the data load there are two possibilities exist one is online load and other one is offline load. During online load system directly writes the data to the specification data, whereas during offline mode system generates a Dat File to load the information.

The sequences of steps you follows to load the data include i) Maintaining the data ii) saving as tab delimited Txt file iii) converting the dat file and importing the dat file into the system for directly loading the content to database following the step ii.

Once data is migrated system is checked for accuracy of the information and used for different substance maintenance.

Thanks 

11 comments:

  1. Nice Blog Content Thanks to Author. Australian Risk Services assists companies in performing confined spaces risk assessments.
    "We Provides best
    Dangerous Goods Assessment
    in Australia"

    ReplyDelete
  2. safety is most important factors of any business. we are the part of this. ADR gefahrgutbeauftragter

    ReplyDelete