SAP Knowledge Base Article - Preview

2344284 - When source is SAP application and using dynamic where clause with "IN" operator does not return values in SAP Data Services


When fetching data from an SAP Application source and a global variable is dynamically created with a list of values to be used in the Where clause of the "IN" operator, no values that correspond to the column list provided by the "IN" operator is returned.



OS: Windows 2012 R2
Source: SAP Application table or Extractor


SAP Information Steward 4.2


Optimized SQL not passed to SAP, the list of values provided in the IN condition are not returned, NULL value from SAP application is returned. , KBA , EIM-DS-SAP , SAP Interfaces , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.