Value and Quantity Field Mapping („FP Mode“)

FD_ELEMENT

* effective from version 3.4.35

This constant allows to use a different satellite structure for posting to CO/PA. Characteristics of different value and quantity fields are no longer provided by separate table columns but only by a single column. CO/PA value and quantity field names are assigned to these values/quantities in a different column.

These two table columns are defined by the constant FD_ELEMENT as follows:

· Enter the satellite column containing the CO/PA value and quantity field name in Value from.

· Enter the satellite column containing the characteristics, meaning values and quantities, in Value to. These may be period columns (without period suffix) as well as an annual column. Annual values may still be distributed using a distribution table. Annual values may also still be distributed using a distribution table.

Note:

There should be no value (“V“), quantity (“Q“) and unit fields (“U“) mapped in table „Field assignment“ of the CO/PA constant maintenance. Since there must always be a unit included when posting quantities, also the constant FD_UNIT is required in this case (see there). This is not required if only values are posted. The setting ‚T‘ in column ‚TS‘ of the Read/Write parameter triggers an aggregation routine merging the related data records. In doing so, this routine also ensures that satellite rows are added up with identical characteristic combinations.