Condition operators

Common operators

The following comparison operators are supported by the condition and doccondition XML elements:

Operator

Description

eq

The field content is equal to the specified value.
(Case-sensitive Java string comparison)

neq

The field content is not equal to the specified value.
(Case-sensitive Java string comparison)

in

Field content is equal to a specified value from a set of values. (Case-sensitive Java string comparison)

notin

Field content is not equal to a specified value from a set of values. (Case-sensitive Java string comparison)

Condition operators

Operator

Description

num_gt

Field content is greater than specified value.

num_geq

Field content is greater than or equal to the specified value.

num_lt

Field content is less than specified value.

num_leq

Field content is less than or equal to the specified value.

like

(for alphanumeric R/3 data types only, i.e., ACCP, CHAR, CLNT, CUKY, LCHR, NUMC, UNIT, VARC, TIMS, or DATS dictionary types)

Comparison of field values with a variable string
The following placeholders are permitted:
* No or any number of characters
? Any single character
\ Masking character for searching for
placeholders or masking characters in the
form: \\ or \* or \?

Example:

<condition fieldname="OBJECTID"
logicaloperator="like">

<value>*10?0\\20?0*</value>

</condition>

The search is performed for values such as
5551050\20106667 or 1080\204044 but not 34510550\2030*

creationtimestamp

Time stamps (date and time) are extracted from R/3 fields with times. Their values form the basis for restricting the data range to be extracted with the -begindate
(-begintime) or -enddate (-endtime) command line parameters [see  chapter Source system-specific arguments].
Multiple fields are separated by the character combination #-#. For each field, the format descriptions of the source system fields are specified in the value XML elements.

Example (for VBAP table):

<condition fieldname="ERDAT#-#ERZET"
logicaloperator="creationtimestamp">

<value>dd.MM.yyyy</value>

<value>HH:mm:ss</value>

</condition>

valueconstraint

Specifies an R/3 field with integer values that are used to delimit the data range to be extracted with the -valueconstraint
command line parameter [see chapter Source system-specific arguments].
The field to be extracted must be of the NUMC or INT4 data type.

Example (for VBAP table):

<condition fieldname="POSNR"
logicaloperator="valueconstraint"/>

doccondition operators

Operator

Description

exists

Field exists.

notexists

Field does not exist.