Get Example source ABAP code based on a different SAP table
ARTICLE Short Reference • IN WHERE • NOT IN WHERE
sql_cond - IN seltab
Syntax ... col [NOT] IN seltab ...
Effect This expression is true if the value of the column col is (not) in the result set described in the rows of the selection table seltab. Any internal table with a row type that corresponds to that of a selection table can be specified as the selection table seltab. This includes, in particular, ranges tables. The selection table is evaluated in the same way as in comparison expressions apart from the fact that in comparisons with the operators CP and NP the WHERE condition is case-sensitive, whereas in other comparison expressions it is not. The wildcard characters '*' and '+' of the selection options 'CP' and 'NP' are converted to the OpenSQL wildcard characters '%' and '_', whereby the escape character '#' is also handled correctly. If '%' and '_' are contained in the te mplate, an OpenSQL escape character is generated.