Ansicht
Dokumentation

EHPRC_IMDS_FILL - Set Up System with IMDS All Files

BAL Application Log Documentation   General Material Data  
This documentation is copyright by SAP AG.

In this customizing activity, you enter master data and company-specific data from the International Material Data System (IMDS) into the system, to use SAP S/4HANA as an IMDS in-house solution. The IMDS provides the data (IMDS initial files and IMDS all files). You can download this data by using the IMDS Advanced Interface and then import the data into your system.

When importing the files as described below the system does the following in the background:

• It creates or updates the pure substances imported from the IMDS SBALL file.

• It creates a new regulatory list revision for GADSL with status In Process or updates the existing GADSL revision.

• If the SBAll file contains entries for substances listed by REACH-SVHC, a new regulatory list revision for REACH-SVHC is created with status In Process or the existing REACH-SVHC revision is updated.

• It checks, by using the CAS number, for each pure substance from IMDS, whether the corresponding listed substance exists in the GADSL list.

• If yes: everything is ok.

• If no, the system checks if the corresponding listed substance is there in the delivered content.
  Is there the corresponding listed substance, then the system uses this one to create the new listed substance.
  Is there no corresponding listed substance, then the system creates a new listed substance without a relation to the content list.

• It checks the mapping between pure substance and listed substance and adds necessary entries.

At the end of the import process, the user only has to release the new regulatory list revision of GADSL in the regulatory list management.

Hint
For further import and export options of other regulatory list revisions, see the customizing activity Export and Import of Regulatory List Revisions.
For updating regulatory list revisions from SAP Product Stewardship Network, see the customizing activity Specify SAP Product Stewardship Network Integration.

Download Files

• You have requested the company-specific IMDS all files. For more information about requesting company-specific IMDS all files, see the IMDS download manual.

Import Files

• You have completed the Customizing activity Specify Logical File Names and File Paths.

Download and import the company-specific IMDS all filesand the common IMDS all files.

• Company-specific IMDS all files
  These files include all company-specific data up to a specified key date. The following files are required:

IMDS File	Description
CMSAll	All complete material data sheets (MDSs) specific to the company up to the key date
MODAll	Modules released up to the key date
REQAll	All complete requests specific to the company up to the key date
Note:	These files are company-specific; request them for your company at the IMDS host for a specific date.

• Common IMDS all files
  These files include common data such as substance groups, pure substances, and contact data. The following files are required:

IMDS File	Description
CCAll	All company and contact data up to the key date
MPAll	All MDSs published up to the key date
MPSAll	All IMDS committee MDSs published up to the key date
SAAll	Substance Applications IDs up to key date
SARAll	Substance Application Relations up to key date
SBAll	All pure substances up to the key date
SGAll	All pure substance groups up to the key date
SACAll	All SCIP article categories up to the key date
SMCAll	All SCIP material categories up to the key date

SMCAll

Download Files

1. Download CMSAll and MODAll. If you want to use the request function, download REQAll, too.
2. Download the following common files directly from the IMDS: CCAll, MPAll, MPSAll, SBAll, SGAll, SAAll, SARAll, SACAll, and SMCAll.
   You can download these files and directly store them in the download folder on the application server using the transactionDownload from IMDS (EHPRC_CPI02).
1. Select the download type to specify the file type that you want to download.
2. Select the download date. This field is prefilled with the previous day, so the newest file is always available.
3. Set Target Server Directory as the download folder.

Import Files

You can import the files using the transaction Import from Application Server (EHPRC_CPI03) or you can perform the import in the background (F9).
Import the files in the following order:

1. SBAll
   Select the SBAllfile and choose Create Import Job (F9). All substance data is imported. Select the file again and choose Move File to Archive Directory.
2. SGAll
   Select the SGAllfile and choose Import. Groups are imported. (Here, you find a list of imported groups). Select the file again and choose Move File to Archive Directory.
3. CCAll
   Select the CCAllfile and choose Import. All company and contact person data is imported. Select the file again and choose Move File to Archive Directory.
4. SAAll
   To import the substance application IDs, select the SAAllfile, and choose Import. Select the file again and choose Move File to Archive Directory.
5. SARAll
   Select the SARAllfile and choose Create Import Job (F9). All substance relations for application IDs are imported. Select the file again and choose Move File to Archive Directory.
   Be aware: In the application log, you find errors, such as: A listed substance assigned to IMDS node ID...does not exist. You can ignore them, in case these errors occur when entries in the SARAll file correspond to substances in the SBAll file that aren't regulated.
6. REQAll
   This file is optional. Import it if you want to use the IMDS request function. Select the REQAll file and choose Import. Request data is imported. Select the file again and choose Move File to Archive Directory.
7. MPAll or MPSAll
   Split the MPAll/MPSAll file before performing the import. To filter and split the file, choose Filter (Ctrl+F2). You can also use the Filter and Split report (R_EHPRC_IMP_FILE_FILTER). Enter the following values:

• File Name

• Split Size (MB)

• Target File Prefix: MPAll.dat/MPSAll.dat
  Each of the split files receives a numeric extension, for example, MPAll_0001.dat/MPSAll_0001.dat, MPAll_0002.dat/MPSAll_0002.dat, MPAll_0003.dat/MPSAll_0003.dat.

• Final delete of source file: Yes
  When processing the MPAll/MPSAllfile, specify filter criteria due to the large amount of data. The data in the MPALLfile are the published data sheets from IMDS committee, from suppliers, and from your own published data sheets. The published data sheets are identified by the sender organization ID.
  The MPSAllfile instead only includes the published data sheets from IMDS committee. Use the same filter criteria later for processing the MPDaily/MPSDaily file.
  The split files are stored automatically in the download folder of your application server.

You can start the import for all parts of the MPAll/MPSAllfile by selecting all MPAll/MPSAllfiles and choosing Create Import Job (F9). After the import, select the files and choose Move File to Archive Directory.
Note: If you only want to import the IMDS committee MDSs, use the MPSAllfile. If you want to import all MDSs that have been published including the IMDS committee MDSs, import the MPAllfile and filter out the relevant MDSs.

1. CMSAll
   If the file is larger than 10 MB, split the file. You can use the Filter and Split report (R_EHPRC_IMP_FILE_FILTER) to split the file. Select the CMSAllfile and choose Create Import Job (F9). All MDS data is imported. Select the file again and choose Move File to Archive Directory.
2. MODAll
   This file is optional. If the file is too large, you can use the Filter and Split report (R_EHPRC_IMP_FILE_FILTER) to split it. Select the MODAll file and choose Import. All module data is imported. Select the file and choose Move File to Archive Directory.
3. SACAll
   Select the SACAll file and choose Import. All SCIP article category data is imported. Select the file again and choose Move File to Archive Directory.
4. SMCAll
   Select the SMCAll file and choose Import. All SCIP material category data is imported. Select the file again and choose Move File to Archive Directory.

SMCAll




PERFORM Short Reference   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 12542 Date: 20240523 Time: 171405     sap01-206 ( 148 ms )