Entering content frame

Background documentation IN Condition Locate the document in its SAP Library structure

IN conditions are search conditions with an IN predicate, to which the following rules apply:

·        The operator is the operator IN.

·        IN conditions have one of the following formats:
<column_spec > IN (<extended_value_spec >,...)
<column_spec> IN <subquery >

The Optimizer can only use IN conditions that satisfy these prerequisites to determine an optimal search strategy.

Conditions in the format ...NOT (<column_spec> NOT IN (<extended_value_spec>,...)) or. ...NOT (<column_spec> NOT IN <subquery>)are, where possible, converted to an expression without NOT, and with a correspondingly negated operator. The system then continues processing the condition in this converted format.

 

 

Leaving content frame