SAP OS QUERY FILTER COND
Get Example source ABAP code based on a different SAP table
ARTICLE
Filter Conditions
A filter condition is a logical expression that compares the attributes of a persistent class with free parameters or values. The syntax of a filter condition is based on the syntax of the
ITOC
When a query is executed using a class actor, the query is bound precisely to its persistent class. The attributes specified in a filter condition must be available in the persistent class as public persistent attributes, otherwise an exception occurs. On the other hand, a query that has been created can certainly be executed in succession by class actors of different persistent classes, as long as the specified attributes are available. When a query is executed, a
The elementary relational operators below are supported in a filter condition. An attribute,
The names of parameters can be defined freely by specifying a parameter list, which is a list of parameter names that can be used in the filter condition. The parameters position in the parameter list defines the parameters index in the parameter table. If no parameter list is specified, a predefined parameter list with the three parameter names
Literal values are generally enclosed by quotation marks. The semantics of the relational operators are defined by the corresponding
Note
The filter condition and its parameter list are analyzed when a query is executed and transformed into an internal display. To avoid parsing each time the query is executed, the methods of the interface
Security notes
ABAP Code Snippet If used wrongly, dynamic programming techniques can present a serious security risk. Any dynamic content that is passed to a program from the outside must be checked thoroughly or escaped before being used in dynamic statements. This can be done using the system class
ABAP Code Snippet
Relational Operators
Comparison of two object references. When the query is executed, parameter
The semantics of the boolean operators
Examples
( salary > '50000' AND currency = 'EUR' ) )