Skip to main content

SYN410 - Create SAP System Type from System Type Model

Jenny Drummey
  • Updated

Procedure Overview

This standard operating procedure describes how to create an SAP (ECC or S/4HANA) System Type using the System Type Model import approach.

Dependencies

This activity is dependent upon the following:

  • Collect Set-up and the required DD* tables extracted in full.

Who Performs this Procedure?

Typically, this procedure is performed by someone who is responsible for configuring the Stewardship Tier's Advanced Data Migration (ADM) solution.

Users assigned the following roles would typically have access to perform this task: 

  • System Administrator
  • Migration Developer Advanced

Procedure Steps

Step 1: Download SAP Data Dictionary Tables

To create a System Type from the SAP Model you’ll need to download a set of DD tables from your target or source SAP system into a dg or an sdb.

  1. Select Common -> Configuration -> System Type Models.
    mceclip0.png
  2. Add these tables to the relevant Collect Target Source, then build and refresh the data. For the purposes of this article, the tables are stored in a target database called dgS4HANA.

Step 2: Create System Type Model Views

In this step, create the database views that the Stewardship Tier uses to create the System Type. The views are listed in the System Type Model in the picture above in step 1.

NOTE: This is a destructive process. If the views already exist in the database, they will be dropped and recreated.

To create the views using the Stewardship Tier:

  1. Select Common -> Configuration -> System Type Models. 
  2. Click the Vertical view of the SAP System Type Model.
  3. Click the Build Views icon.
    mceclip1.png
  4. Click Edit.
  5. Select dgS4HANA from the Build Data Source ID list box. 
    mceclip2.png
  6. Click the Save button, then click the Build Views icon again.

The Stewardship Tier has now built the System Type Model views in the dgS4HANA data source.

Step 3: Update System Type Model Views to Point to Correct Database

In SQL, check any of the views just created. You will notice that the views created reference the dgSAP database and NOT the target Data Source specified in Step 2. If these views are not repointed to the target DBs, the pre-delivered DD tables in dgSAP will be used to create the System Type instead of the intended DD tables in dgS4HANA.

 mceclip3.png

We need to change the views to point to their own database (dbo) instead of dgSAP.dbo.

  1. Select the views created in Step 2 and script them out as Drop and Create To a SQL Editor and replace dgSAP.dbo. with dbo. and run the script.

mceclip4.png

  1. Check the views. They should now be pointing to the DD tables in the dg database that is being used.

Step 4: Create New System Type Model

To create a new System Type Model (In this example we are creating one called S4HANA):

  1. In the Stewardship Tier, select Common -> Configuration -> System Type Models.
  2. Add a new System Type Model and select the Views in the same order as the SAP System Type Model.
    mceclip5.png

Step 5: Create New System Type

We are now ready to create the new System Type based on the SAP System Type Model. In this example, we use dgS4HANA.

  1. Select Common -> System Types and add a new System Type.
  2. On Save you will be taken to the Vertical View, add any other relevant information and save one more time.
  3. Click the Import from System Type or Model button.
    mceclip7.png
  4. Fill in the details following the example below. Replace dgS4HANA and S4HANA with the names of your database  and system type model.
    mceclip8.png

 A description of the fields on this view follows.

 Data Source ID is the database where the Data Dictionary tables are stored and where the “amended” views exist. This is a hard-required field on the page but is only used when importing the System Type from the database table definition. For consistency, use the target data source ID.

System Type Model is the newly created Model in the previous step. This example uses S4HANA.

Import the whole Model and not a Selected Group by selecting Import Tables from the Selected Model in the Import Model Option list box. 

Ensure the Exclude Client Fields check box is checked. If it is unchecked, the Client field will appear as a key field in ADM Map and Value Mapping.  

  1. Click Import Model to kick off the jobs that are going to create the system type.

This process may take some time. You can check progress by looking at the Job Monitor for Queue General.

mceclip9.png

These background jobs run to create the full System Type. Ensure that they all complete successfully.

 mceclip10.png

After the jobs complete, check the System Type. Ensure that the fields have lookup tables assigned to them.

 mceclip11.png

The System Type is now ready to use in ADM Design.

Related articles