(1808) Lookup Translation

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 (1808) DataProvider Wizard.

Lookup API documentation

Advanced users may use the class /DVD/OFF_CL_DATAPROV_QUERY to create their own reports. Below you can find API documentation of the SELECT( ) method for retrieving data.

CALL METHOD /dvd/off_cl_dataprov_query=>select
 EXPORTING
   iv_dataprov = ...
   it_fields   = ...
   iv_where    = ...
 CHANGING
   ct_data     = ...
 .

Description of the method parameters:

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 (1808) DataProvider Wizard. The difference is that after you click Execute analysis a filter screen appears, in which you can set objects, which 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.