Restrict Selection of Reference Data via Additional Feature (2) with Empty Field Content

READ_EXCLUDING_FIELD

* from Allevo version 3.4

In single cases, it is necessary to restrict data selection in a way that only data records with empty field contents are included. Example: only direct postings to profit centers shall be included but not data records caused by direct postings from cost centers.

Constant READ_EXCLUDING_FIELD allows to query the prescribed fields for empty contents when selecting summary records; (e.g. query „RCNTR = empty“, to exclude postings with a cost center entered as origin object).

Activate the constant by entering the field name in column Value from. Multiple field names are possible as comma-separated list (then, only data records with all mentioned fields empty are read).

The relevant row definition may additionally be stored in column Value to; multiple entries are possible as comma-separated list. Without any specification, restriction during reading applies to all row definitions.

Note:

The constant is currently only realized for profit center planning (not for stat. key figures). See also constant READ_WITH_KEYR for restrictions when reading reference data; then, specific additional features are predefined by Excel.