Defining Filters for Objects (SAP Library - CRM Integration Services)

Defining Filters for Objects

Under Filter Settings you can set filters for a business object. If you use more than one filter entry per object, filters to the same table field are linked with an OR. Filters to different table fields are linked by AND.

Example

The filter condition VKORG = 0001, VKORG = 0002 results in a set that contains both the first and second sales organization.

The filter condition VKORG = 0001, VTWEG = 01 results in objects that fulfill both conditions at the same time.

Note

For Customizing and condition objects the filters can be defined only using tables/structures and the table-related filter symbol.

Proceed as follows:

Field	Procedure
Source site	Use the input help to select the site you want to set the filter criteria for. For example, for an initial data transfer from SAP R/3, this is the R/3 System from which the data is to be transferred. Note: The selection is dependent on the allowed flow contexts (SMOFINICON).
Table	Use the input help to select a table, for example, KNA1 for customer master.
Field	Use the input help to select a field.
OP (Operator)	Select an operator.
LOW	Specify the lower limit for the filter condition. If the field you selected is a date field, enter the date with the format YYYYMMDD. Leading zeros should be used as values for example, for customer and material numbers.
HIGH	Specify the upper limit.
Incl./Excl.	Specify whether the stated value/interval range should be included or not. Inclusive: the resulting set lies within the range. Exclusive: The resulting set lies outside the range.
Inactive	Set your filter conditions to active.

To save the values you have entered go back to the initial screen. Saving takes approximately one minute as several actions are performed:

The Repository tables are saved

Filter modules are generated

Transport request may be created (optional)

When the filters have been created, the message Filter module for object <X> has been generated appears.

Note

The Generate Filter pushbutton located below the menu is only used for regenerating filter modules for selected objects, and should only be used in exceptional cases.

The fields for filtering are available predefined for the objects. You will find the values allowed for each object when you make your selection.
Some objects are delivered with predefined filters. SAP recommends that you do not change or delete. If necessary, you should define new filters. The purpose of filters is to reduce the size of the dataset transferred. You can find the predefined filters in the change functions of the Adapter Framework and in table SMOFFILTAB.
Filters from CRM to CDB are currently not supported, only filters from R/3 OLTP to CRM are supported.
Filter conditions are only stored locally and are not contained in the transport of adapter objects. In this way filters are not transported from the development system to the production system. This is because filter conditions are site-specific and are defined differently in the development system to the production system. New filter settings have to be defined in each system.