SAP WHERE LOGEXP SELTAB Get Example source ABAP code based on a different SAP tableSAP Help
Short Reference ABAP_SQLCOND - IN range_tab ABAP_SYNTAX ... operand $[NOT$] IN @range_tab ... What does it do? IN checks whether the operands on the left side match a ranges condition in a ranges table. The relational expression is true if the value of the operand operand is (is not) in the result set described in the rows of the ranges table range_tab specified as a host variable. The following applies to operand: SQL expressions except for aggregate expressions and window expressions can be specified. In a HAVING clause, aggregate expressions can also be used. Any internal table whose row type corresponds to that of a ranges table can be specified for the ranges table range_tab. selection tables. comparison expressions, with the difference that any comparisons using the operators CP and NP are transformed into LIKE conditions for which the AB-SQL escape character # is defined. The pattern after CP or NP is transformed to a pattern for LIKE as follows: If the AB-SQL wildcard characters % and _ are contained in the pattern, the # escape character is inserted in front of these characters. Any wildcard characters * and + that are not prefixed with the escape character # are transformed to the AB-SQL wildcard characters % and _. Any # escape characters that do not prefix themselves or the AB-SQL wildcard characters % and _ are removed. IN range_tab is always true. This overrides the general rule that the result of a relational expression is unknown if an operand has the null value. LOW and HIGH in the ranges table must match the data type of the operand in accordance with the rules for lossless assignments. strict modes of the syntax check from ABAP_RELEASE ABAP_740_SP08 and can raise an exception. Latest notes: LIKE conditions resulting from CP or NP are case-sensitive, which is not the case in ABAP comparison expressions. If no conditions are specified apart from IN range_tab, all rows of the data source are selected if the ranges table is initial. The conditions specified in the ranges table are passed by the database interface to the database as SQL statement input values. The maximum number of input values depends on the database system and is usually between 2000 and 10000. If the maximum number is exceeded an exception of the class CX_SY_OPEN_SQL_DB is raised. For an initial ranges table, no condition is passed to the database and therefore, the result is always true. If the ranges table contains invalid values, an uncatchable exception is raised. No host expression can be specified on the right side whose result represents a ranges table. ABAP_EXAMPLE_VX5 SIGN OPTION LOW HIGH sql_cond, this generates the following combination of relational expressions: ... ( ID = '01104711' OR ABAP_EXAMPLE_VX selection screen with SELECT-OPTIONS in a WHERE clause. ABAP_EXAMPLE_V5 WHERE clause.
