To read data from an SAP BEx query, configure a Source transformation in the mapping.
When you select an SAP BW BEx query connection for a Source transformation, you can select a read operation that represents the imported SAP BEx query from which you want to read data.
You can use the sample XML template provided to configure the request message in an XML format. You can also configure filter conditions in the request XML to filter the data that you read from an SAP BEx query. Configure the advanced properties to set the tracing level and the cache size for the Web service response.
You can view the response structure in the field mapping. When you map the elements from the response structure to the output fields, the Secure Agent creates an output group. Map the fields from the SAP BEx query to the output group, and then connect the output group to a transformation or target to which you want to write data.