VENKI

SAP BI IP

A filter’s functionality depends on its particular use in either a planning function or a query.
In connection with planning functions, a filter in the characteristic restrictions describes the data that is
used for executing a planning function. Selections in the default values are

You can also use a key date for the filter to determine time-dependent selections.

The values defined in a query’s characteristic restrictions limit the volume of data that is available for
further filtering during a query’s runtime. It is then no longer possible to filter using a characteristic
value outside this value set. The default values determine the query’s initial filter state.
The settings & essentially refer to the use of filters with a
query:
determines whether the selection of values affected by the characteristic
restrictions can be changed when the query is executed. This setting is a prerequisite for the
definition of default values for a characteristic.
· If you select the option to
specify that only a single value can be used for filtering the query.
_ The two functionalities described above are described in more detail in the following units.


*********************************************************************************

Data: h_clean(3),
h_check,
h_off(2) type p.

h_clean = SOURCE_FIELDS-INCO1.
translate h_clean to upper case.

clear h_off.
do 3 times.
* (*****Loop number of times the length of the info object).
move h_clean+h_off(1) to h_check.
* if not h_check ca '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ-'.
if not h_check ca '1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZÖÜ-'.

move space to h_clean+h_off(1).
endif.
add 1 to h_off.
enddo.

* result value of the routine
RESULT = h_clean.