When replicating data from a source system to a target system, map the source system database data types to the target system database data types.
This is a two-step process:
- First, map the data type of the source system database to the SAP Landscape Transformation Replication Server system data type (the ABAP dictionary data type). Source System Database Data Type → SAP LT Replication Server (ABAP Dictionary Data Type)
- Map the ABAP dictionary data type to the target system database data type. SAP LT Replication Server (ABAP Dictionary Data Type) → Target System Data.
If the source system is an ABAP-based SAP system, then step 1 is not required. Similarly, if the target system is an ABAP-based SAP system (and therefore not accessed by means of a database connection, but by an RFC connection), then step 2 is not required.
The SAP Landscape Transformation Replication Server uses default mapping values to map ABAP dictionary data types to target system database data types. The default mapping values to map ABAP dictionary data types to SAP HANA data types are shown in the figure below. The default mappings for other databases can be found in the application documentation.
Note
See SAP Note 2394986 for more information on Data Type Mapping.
See also SAP Note 2857334 - Unsupported Data Type DECFLOAT34 / D34N When Replicating from an SAP S/4HANA 1909 (or higher) on-premise system.
If these default mapping values do not meet your business requirements, you can specify your own mapping values. In transaction LTRS (advanced replication settings), you can specify mapping values for ABAP dictionary data types for an entire configuration (under global mapping values). You can also specify values for specific tables and fields (on the Mapping Values tab).
The default type mapping can be redefined for each configuration on table level. The individual type mapping for a table can be defined in Mapping Values and only affects the table. These settings will overwrite the global mapping values.
If you only want to have a single field changed from, for example, DATS to DATE, use the Table Fields mapping. The target database types have to be specified as a string, for example, DAYDATE CS_DAYDATE NOT NULL.
More information and further examples are mentioned in the application documentation.
Starting with DMIS2011 SP13, the Target DB Type field in the Table Fields screen area must no longer contain any field names. You can use the IUUC_FIX_FIELDNAME_MAPPING report to apply the new format for the Target DB Type field automatically.
Create a Table
Choose the Create Table button to display the SQL statement that will be used to create the table in the target system. On the dialog box, you can also run a first check to see if the syntax is correct.