Saturday, July 15, 2017

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


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.



  1. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Personal Installment Loans
    Title Car loan
    Cash Advance Loan


  2. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.

    Pawn Shop

    Pawn Loans

    Pawn Shops

    Pawn Loan

    Pawn Shop near me

  3. 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"

  4. You got a good work for the blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.

    Bigdata Training in Chennai


  5. This is so informative blog and i have used this 5 minutes thing very useful too happy with this blog........
    SAP FICO Training in Chennai

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

  7. It was a very useful Information.... Thanks for sharing.
    SAP EHS Training institute in Noida