(2002) Lookup Translation

Owned by SNP
Jul 25, 2019
2 min read

Impact analysis supports two types of lookups:

  • Lookup - standard SQL statement in a report, class, routine, etc. that selects data from the active table of an InfoProvider
  • Dynamic lookup - a standard lookup, with the difference that the source table name is a variable (e.g. SELECT * FROM (lv_tabname) WHERE ...).

When the step Object adjustment is executed, DataTiering automatically adjusts the original report with the class /DVD/OFF_CL_DATAPROV_QUERY to read already archived data.

This ensures that the output data is enhanced with archived data. A step by step guide how to translate the standard lookups is in the section (2002) DataProvider Wizard.

 

How to translate dynamic lookups

Dynamic lookups are standard SQL select statements, but they contain a dynamic variable. For example SELECT * FROM (lv_table) where lv_table is a variable with a value that may change. Therefore, the select statement isn't associated with a particular DataProvider.

Dynamic Lookup Wizard can be accessed by a separate transaction /DVD/OFF_DLW.

The execution of the Impact analysis and Object adjustment is very similar to the standard lookup translation in the (2002) DataProvider Wizard. The difference is that after you click Execute analysis a filter screen appears, in which you set the objects that should be analyzed.


Search Pattern: If this select option is set, only objects with a source code that contains one of the entered substrings are analyzed.

Object ID: If this select option is set, only objects suiting this selection criteria are analyzed.