SAP for Utilities Blogs
Discover insights and practical tips to optimize operations, reduce costs, and deliver reliable energy with SAP technology. Contribute your own blog post!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Objective

The main objective to load legacy data into SAP using EMIGALL distributed mode usually during full loads. EMIGALL distributed mode also reduce efforts in scheduling jobs and easy to monitor them. Document is divided into following four topics:

  1. Converting Legacy file into Binary format (SAP format)
  2. Scheduling Distributed Import Jobs
  3. Changing scheduling parameters
  4. Monitoring Distributed Import Jobs

1. Converting Legacy File

     1.1 Go to transaction EMIGALL

     1.2 Double click on Migration Object for which we want to process import file

     1.3 Click Data Import

     1.4 In data import screen, go to menu: Utilities -> Convert migration file

     1.5 Enter Input directory (remember to put “\” at the end of input directory path)

     1.6 Enter input file name (including file extension )

     *Note: Input directory and file name should not be long. Sometimes, long file path and file name will cause system not to recognize file

     1.7 Enter output directory (remember to put “\” at the end of input directory path)

     1.6 Enter output file name (including file extension )

     1.8 Check Migration company and migration object values

     1.9 After entering values, go to menu: Program à Execute in Background

     Note: Remember the output file path and file name. This will be used in schedule distributed import job

     1.10 In Background Print Parameters, Press OK


    

     1.11 Press Immediately

    

     1.12 After scheduling the job Immediately, press save

    

     1.13 Go to Transaction SM37 and monitor job till it finishes

2. Schedule Distributed Import

     2.1 Use Transaction EMIGMASSRUN to launch Administration & Monitoring Screen

     2.2 Press Create button

    

     2.3 Enter Company and enter Migration Object

     2.4 Press OK

    

     2.5 Enter Migration Path & file name (Output file path & file name which was used earlier to convert input file)

     2.6 Enter Error File (with file extension “err”

     2.7 Enter Input file (generated) with ‘&’. ‘&’ will be replaced by sequence number when file split happens

     2.8 Enter Error file (generated) with ‘&’.

     2.9 Commit Interval: This should be maintained only if this field is enabled for input

     2.10 Press Analyse button adjacent to file name. This will list of import statistics

    

     2.11 Compare import statistics with legacy file statistics (if shared)

     2.12 Validate number of data types (if there is a relationship). For example in device groups for Meter and Module – Every one record, will have two device data types.

     2.13 After Analysis, go back to main screen

     2.14 Define number of Background Work Processes which we intent to use

     2.15 Enter Mass Import file size

     2.16 Save the Distributed Import identification

     Note: Based on mass import file size, main file will be split into multiple files for parallel processing

     2.17 Press Import Run

     2.18 Choose option – Start Later

     2.19 Change Start Date and Time well in future

     2.20 Press Distributed Import

     2.21 Distributed import job will be released

3. Change Job Scheduling Parameters

     3.1 Go to transaction SM37

     3.2 List jobs which were released

    

     3.3 Choose the job whose status is “Released”

    

     3.4 Go to menu: Job -> Change

     3.5 Press Step

     3.6 Place your cursor on the step and press change icon

     Note: Job is currently scheduled with user who has created distributed import job identification

     3.7 Change User to “MIGRATION” (or user id which has been setup for migration purpose)

     3.8 Press Save to save step

     3.9 Verify user for job is changed to “MIGRATION”

     3.10 Go back to main screen

    

     3.11 Press Start condition

     3.12 Press Immediately

     3.13 Press Save

     3.14 Press Save on job main screen

     3.15 Distributed Import job is now started with “MIGRATION” User id

4. Monitoring Job

     4.1 Use transaction EMIGMASSRUN

     4.2 Press “List of Distributed jobs” button and select job with your identification

     4.3 Go to Data for last import for statistics and monitor import job

     4.4 Go to Statistics for import runs for further details

     4.5 Double click on line item for further analysis


1 Comment
Top kudoed authors