Table of Contents:

Supported Dynamic Lookups

Example of a supported SELECT statement

SELECT */list_of_fields (aggregation_functions-SUM, MIN, MAX, COUNT) (AS)
INTO (CORRESPONDING FIELDS OF) TABLE result_table
FROM ( Dynamic_table )
(FOR ALL ENTRIES IN fae_table)
WHERE (fae_table_cond AND ) where_cond-BETWEEN,OR,IN,().

Example of a supported WHERE condition

manager = fae_table-manager AND (city = ‘FRANKFURT’ OR city = ‘BERLIN’)

Example of a not supported WHERE condition

manager = fae_table-manager OR manager = ‘PETER’ AND (city = ‘FRANKFURT’ OR (country = ‘SVK’ AND date = ‘01012014’) )

Not supported dynamic lookups

Not supported dynamic lookups are the same as in (2202) Supported Standard Lookups as well as the below mentioned types:

1. SELECT with dynamic FIELDS

Fields are used to select only defined fields
This select is not supported by Lookup API and Data Tiering

2. SELECT with dynamic WHERE condition

Not supported SELECT with dynamic WHERE condition is the same as in (2202) Supported Standard Lookups. However, in this case, the complete dynamic where the condition is a variable:

Browser not supported