Target Design

Target Lookup Table H

Target Lookup Table V

Use this page to Set up Lookup Tables.

To access this page:

  1. Select dspMigrate in the Navigation pane.
  2. Select Design in the Context bar.
  3. Select Configuration > Lookup Table Setup in the Navigation pane.

Field

Description

Value Mapping (Config)

Click to open the Value Mapping (Config) page in Map to refresh lookup table values after changers to configuration of a lookup table.

VALUE TABLE NAME

Displays the name of the table that contains the values used in the lookup table.

TYPE

Displays an option indicating whether fields in the lookup table should be value mapped.

VALUE TABLE COLUMN 1

Displays the first key in a value table with a multipart key.

Displays the key in a value table with a single key.

If more than one Value Table Column is entered for a table, one column name must be selected in the MULTI FIELD LOOKUP TABLE VALUE COLUMN on the Vertical View because tables with multipart keys require a column to be selected for the update rule.

For example, a lookup table for a city must also include the city’s state. In this case, the Value Table Column1 field contains the State column and the Value Table Column2 field contains the City column. The MULTI FIELD LOOKUP TABLE VALUE COLUMN uses the City column as the key, as the City column is what is being value mapped.

This value displays in Map in the Value Field1 field on the Vertical View of the Value Mapping (Config) page.

VALUE TABLE COLUMN 2

Displays the second key in a value table with a multipart key.

If more than one Value Table Column is entered for a table, one column name must be selected in the MULTI FIELD LOOKUP TABLE VALUE COLUMN on the Vertical View because tables with multipart keys require a column to be selected for the update rule.

This value displays in Map in the Value Field2 field on the Vertical View of the  Value Mapping (Config) page.

VALUE TABLE CLIENT COLUMN

Displays the column on the value table that stores the Client or Tenant of the data. Used with SAP only.

MULTI VALUE FIELD LOOKUP TABLE VALUE COLUMN

Displays the column containing the value to use if more than one value table column is set for the value table (for example, there is data in the VALUE TABLE COLUMN 1 and VALUE TABLE COLUMN 2 fields). This is the actual field that will be loaded into the Target table.

NOTE: This field is updated on the Vertical View.

DESCRIPTION TABLE NAME

Displays the name of the table that stores the descriptions for the values in the value table.

NOTE: This field displays in Map on the Vertical View of the Value Mapping (Config) page.

DESCRIPTION TABLE COLUMN

Displays the name of the column that stores the descriptions for the values in the value table for a table with a single key.

This value displays in Map in the Description Field field on the Vertical View of the  Value Mapping (Config) page.

DESCRIPTION TABLE KEY COLUMN

Displays the key column on the Description table used to uniquely identify values if the Description table key is different from the value table's key column.

This field is used by the T006 check table.

If this field is blank, the Description Table Key uses the Value Table Key.

DESCRIPTION TABLE LANGUAGE COLUMN

Displays the column on the Description Table that stores the language identifier column. Used with SAP only.

 

Target Lookup Table V

Target Lookup Table H

Use this page to Set up Lookup Tables.

Field

Description

Value Table

 

Type

Displays an option indicating whether fields in the check table should be value mapped.

Value Table Name

Displays the name of table that contains the values used in the lookup table.

Description

Displays a description of the lookup table. This field may be populated when a System Type was imported into Target Design, or may have been updated by a user. The description displays in Map on the Value Mapping page.

Value Table Column 1

Displays the first key in a value table with a multipart key.

If more than one Value Table Column is entered for a table, one column name must be selected in the MULTI FIELD LOOKUP TABLE VALUE COLUMN because tables with multipart keys require a column to be selected for the update rule.

For example, a lookup table for a city must also include the city’s state. In this case, the Value Table Column1 field contains the State column and the Value Table Column2 field contains the City column. The MULTI FIELD LOOKUP TABLE VALUE COLUMN uses the City column as the key, as the City column is what is being value mapped.

Value Table Column 2

Displays the second key in a value table with a multipart key.

If more than one Value Table Column is entered for a table, one column name must be selected in the MULTI FIELD LOOKUP TABLE VALUE COLUMN because tables with multipart keys require a column to be selected for the update rule.

This value displays in Map in the Value Field2 field on the Vertical View of the Value Mapping (Config) page.

Value Table Column 3

Displays the third key in a value table with a multipart key.

If more than one Value Table Column is entered for a table, one column name must be selected in the MULTI FIELD LOOKUP TABLE VALUE COLUMN because tables with multipart keys require a column to be selected for the update rule.

This value displays in Map in the Value Field3 field on the Vertical View of the Value Mapping (Config) page.

Value Table Column 4

Displays the fourth key in a value table with a multipart key.

If more than one Value Table Column is entered for a table, one column name must be selected in the MULTI FIELD LOOKUP TABLE VALUE COLUMN because tables with multipart keys require a column to be selected for the update rule.

This value displays in Map in the Value Field4 field on the Vertical View of the Value Mapping (Config) page.

Value Table Column 5

Displays the fifth key in a value table with a multipart key.

If more than one Value Table Column is entered for a table, one column name must be selected in the MULTI FIELD LOOKUP TABLE VALUE COLUMN because tables with multipart keys require a column to be selected for the update rule.

This value displays in Map in the Value Field5 field on the Vertical View of the Value Mapping (Config) page.

NOTE: If a table requires more than 5 key fields, a view must be written.

Value Table Client Column

Displays the column on the Value Table that stores the Client or Tenant of the data. Used with SAP only.

Value Table Language Column

Displays the column on the Value Table that stores the language identifier column. Used with SAP only.

Multi Value Field Lookup Table Value Column

Displays the column containing the value to use if more than one value table column is set for the value table (e.g., there is data in the VALUE TABLE COLUMN 1 and VALUE TABLE COLUMN 2 fields). This is the actual field that will be loaded into the Target table.

Description Table

Description Table Name

Displays the name of the table that stores the descriptions for the values in the value table.

NOTE: This field displays in Map in the Description Table field on the Vertical View of the Value Mapping (Config) page (Configuration > Value Mapping (Config)).

Description Table Column

Displays the name of the column that stores the descriptions for the values in the value table.

This field displays in Map in the Description Field field on the Vertical View of theValue Mapping (Config) page.

Description Table Key Column

Displays the key column on the Description table used to uniquely identify values if the Description table key is different from the Value table's key column.

This field is used by the T006 table.

If this field is blank, the Description Table Key uses the Value Table Key.

Description Table Client Column

Displays the column on the Description Table that stores the Client or Tenant of the data. Used with SAP only.

Description Table Language Column

Displays the column on the Description Table that stores the language identifier column. Used with SAP only.

Filter Criteria

Where Clause

Displays the Where Clause used to filter values in the value table column to restrict the values used in the lookup table.

Documentation

Comment

Displays user-entered text about the lookup table.

This field is for documentation purposes only.

Check Table System Type Table ID

Displays the name of the check table in the System Type upon which this lookup table is based. This field may be populated when a System Type was imported into Target Design, or may have been updated by a user.