SAP ABAP IMG Activity /TDAG/CP_IMDS_SYNC (Set Up Daily Synchronization with IMDS System Using IMDS Daily Files)
Hierarchy
☛ TDAGBCA (Software Component) TechniData Basic Components
   ⤷ EHS (Application Component) Environment, Health and Safety
     ⤷ /TDAG/CP_IMDS (Package) IMDS Advanced Interface Integration
IMG Activity
ID /TDAG/CP_IMDS_SYNC Set Up Daily Synchronization with IMDS System Using IMDS Daily Files  
Transaction Code /TDAG/13000070   (empty) 
Created on 20101115    
Customizing Attributes /TDAG/CP_IMDS_SYNC   Set Up Daily Synchronization with IMDS System Using IMDS Daily Files 
Customizing Activity    
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name /TDAG/CP_IMDS_SYNC    

Use

In this Customizing activity, you set up a daily job to import the daily files from the International Material Data System (IMDS) to update the local IMDS data and keep it synchronized with the IMDS system.

Requirements

  • You have created the download, archive, and error folders on the application server for the import of IMDS daily files. We recommend that you use the following folder structure:
    • Download folder: \\Application_Server\…\SPRC_Files\Import\IMDSDaily\
    • Archive folder:\\Application_Server\…\SPRC_Files\Archive\IMDSDaily\
    • Error folder:\\Application_Server\…\SPRC_Files\Error\IMDSDaily\
      • To customize the directories, use the FILE transaction:

  1. Create the following logical path:
  • Logical File Path: SPRC_HOME_PATH
  • Name: Product and REACH Compliance Home Path
  1. Create the following logical file name definitions:

Logical file    Name    Physical File    Data Format    Application Area    Logical Path   

SPRC_ARCHIVE_DIR    Product and REACH Compliance Archive Directory    import\archive    DIR        SPRC_HOME_PATH

SPRC_ERROR_DIR    Product and REACH Compliance Error Directory    import\error    DIR        SPRC_HOME_PATH

SPRC_IMPORT_DIR    Product and REACH Compliance Import Directory    import    DIR        SPRC_HOME_PATH

Standard settings

Activities

IMDS Daily File Processing

  1. Specify the following variants that are used for the download and import:

    Variants for Download from IMDS (/TDAG/CPR_IMDS_DOWNLOAD):

Variant    Type of Download    Download Date    Target Server Directory

SBDaily    SBDaily        \\application_server\...\SPRC_Files\Import\IMDSDaily\

CCDaily    CCDaily        \\application_server\...\SPRC_Files\Import\IMDSDaily\

REQDaily    REQDaily        \\application_server\...\SPRC_Files\Import\IMDSDaily\

MPDaily    MPDaily        \\application_server\...\SPRC_Files\Import\IMDSDaily\

CMSDaily    CMSDaily        \\application_server\...\SPRC_Files\Import\IMDSDaily\

MODDaily    MODDaily        \\application_server\...\SPRC_Files\Import\IMDSDaily\

Variants for the Import from Application Server program (/TDAG/CPR_IMP_APPL_BATCH_JOB):

Variant    Import Type    Source Directory    Archive Directory    Directory Error Files    Only Error/Warning Messages

IMDS_PURE    IMDS_PURE    \\application_server\...\SPRC_Files\Import\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Archive\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Error\IMDSDaily\    Yes

IMDS_ORG    IMDS_ORG    \\application_server\...\SPRC_Files\Import\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Archive\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Error\IMDSDaily\    Yes

IMDS_REQ    IMDS_REQ    \\application_server\...\SPRC_Files\Import\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Archive\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Error\IMDSDaily\    Yes

IMDS_MODUL    IMDS_MODUL    \\application_server\...\SPRC_Files\Import\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Archive\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Error\IMDSDaily\    Yes

IMDS_MODUL    IMDS_MODUL    \\application_server\...\SPRC_Files\Import\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Archive\IMDSDaily\    \\application_server\...\SPRC_Files\Import\Error\IMDSDaily\    Yes

Variants for the Filter and Split program (/TDAG/CPR_IMP_FILE_FILTER):

MPDaily

  • Source File: \\application_server\...\SPRC_Files\Import\IMDSDaily\mpdaily*.dat
  • Split Size: 7 MB
  • Target File Prefix:
  • Delete Source File After Processing: Yes
    • Specify filter criteria if necessary (We recommend that you specify filter criteria when processing the MPDaily file due to the large amount of data. For example: Published data sheets from the IMDS Committee and from selected suppliers as well as own published data sheets. We recommend that you use the same filter criteria that you previously used for processing the MPAll file.)

    MODDaily (optional, only needed if MODDaily file processing is performed)

  • Source File: \\application_server\...\SPRC_Files\Import\IMDSDaily\moddaily*.dat
  • Split Size: 7 MB
  • Target File Prefix:
  • Delete Source File After Processing: Yes
    • Specify filter criteria if necessary

  1. Create a job in underSchedule Jobs with the following conditions:
    • Job Name: Download IMDS daily files
    • Job Class: C
    • Start Condition: Periodic job, Daily at 5:00 a.m. (GMT+1) (IMDS recommendation is not to download before 5:00 a.m. (GMT+1))
  2. Define the following steps in the following order:

    Substance data import (mandatory steps)

Step    Description    Name    Variant    Language

1    ABAP Program Download SBDaily file    /TDAG/CPR_IMDS_DOWNLOAD    SBDaily    EN

2    ABAP Program Import SBDaily file    /TDAG/CPR_IMP_APPL_BATCH_JOB     IMDS_PURE     EN

Company and contact data import(mandatory steps)

Step    Description    Name    Variant    Language

3    ABAP Program Download CCDaily file    /TDAG/CPR_IMDS_DOWNLOAD     CCDaily     EN

4    ABAP Program Import CCDaily file    /TDAG/CPR_IMP_APPL_BATCH_JOB     IMDS_ORG        EN

Request data import (optional steps - only necessary if you use the IMDS request function)

Step    Description    Name    Variant    Language

5    ABAP Program Download REQDaily file    /TDAG/CPR_IMDS_DOWNLOAD     REQDaily     EN

6    ABAP Program Import REQDaily file    /TDAG/CPR_IMP_APPL_BATCH_JOB     IMDS_REQ     EN

Published data sheet import (optional steps)

Step    Description    Name    Variant    Language

7    ABAP Program Download MPDaily file    /TDAG/CPR_IMDS_DOWNLOAD     MPDaily     EN

8    ABAP Program Filter and split MPDaily file    /TDAG/CPR_IMP_FILE_FILTER    MPDaily     EN

9    ABAP Program Import MPDaily file    /TDAG/CPR_IMP_APPL_BATCH_JOB     IMDS_MODUL     EN

MDS specific data import (mandatory steps)

Step    Description    Name    Variant    Language

10    ABAP Program Download CMSDaily file    /TDAG/CPR_IMDS_DOWNLOAD     CMSDaily     EN

11    ABAP Program Import CMSDaily file    /TDAG/CPR_IMP_APPL_BATCH_JOB     IMDS_MODUL     EN

Module import (optional steps)

Step    Description    Name    Variant    Language

12    ABAP Program Download MODDaily file    /TDAG/CPR_IMDS_DOWNLOAD     MODDaily     EN

13    optional - ABAP Program Filter and split MODDaily file    /TDAG/CPR_IMP_FILE_FILTER    MODDaily     EN

14    ABAP Program Import MODDaily file    /TDAG/CPR_IMP_APPL_BATCH_JOB     IMDS_MODUL     EN

IMDS Result File Processing

The IMDS result file includes information and results of user activities. This file is to be imported periodically to update the communication status and results.

  1. Create a job in underSchedule Jobs with the following conditions:

Job Name    Job Class    Start Condition

Download IMDS result files    C    Periodic job, every 10 minutes

  1. Define the following step:

Name    Variant    Language

/TDAG/CPR_IMDS_RESULT_DWNLOAD        EN

You can use the alert monitor to monitor your jobs. For more information, see SAP Library for Alert Monitor on SAP Help Portal at http://help.sap.com.

Example

Business Attributes
ASAP Roadmap ID 204   Establish Functions and Processes 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG /TDAG/CP_IMDS_SYNC 0 HLA0003435 Environment, Health and Safety 
Maintenance Objects
Maintenance object type    
History
Last changed by/on PROSSER  20101115 
SAP Release Created in 200_600