(SM-2205) Type Mapping

Owned by SNP
May 18, 2022
2 min read

Type Mapping is a feature that enables you to change the mapping of DDIC data types to target data types.

Custom storage datatype mapping can be accessed in transaction /DVD/SM_SETUP by selecting the desired storage type from the context menu and choosing the edit mapping option.

It’s possible to edit mapping from DDIC to target storage types or storage types to DDIC (create table from external functionality) using tabs. 

Mapping can be edited by clicking on the edit button and changing the values in the ALV grid. Be careful to what datatypes you are changing the original ones as it might require using further field routines in the extraction process to transform the format or it can end up in failed extractions. After changing the datatypes click CTRL + S to save the configuration.

The settings are global for all storage connections of a particular storage type. Every Glue table created after saving the settings will have new custom datatypes. Already created GLUE tables won’t be affected by the mapping change.

Length and Decimals fields can be flat numerical values but also support formulas where <SRC> is referring to the original data type length/decimal value. Format: <SRC>[*/-+]([0-9]+)

In case of inconsistencies or problematic extractions, it’s possible to go back to the original settings by using the Reset mapping button.

Example: Map DATS to Snowflake Date

  1. Go to the transaction /DVD/SM_SETUP

  2. Select the Snowflake storage type from the context menu and pick the edit mapping option

  3. Click on the edit button and change the mapping of DATS -> STRING to DATS -> DATE

  4. Press CTRL + S to save changes

  5. All newly created Glue tables will map the DDIC datatype ‘DATS’ to Snowflake datatype ‘DATE’