The Data Integration Service can push Filter transformation logic to SAP sources for expressions that contain a column name, an operator, and a literal string. When the Data Integration Service pushes transformation logic to SAP, it converts the literal string in the expressions to an SAP data type.

Filter transformation expressions can include multiple conditions separated by AND or OR. If the conditions apply to multiple SAP tables and the SAP data object uses the Open SQL ABAP join syntax, the Data Integration Service can push transformation logic to SAP. Configure the Select syntax mode in the read operation of the SAP data object.