Display of Period Value sin Columns

MONTH_ACTIVE

* effective from version 3.3.22 (extended in 3.4)

Normally, the CO/PA interface expects data of single periods in different satellite rows. In single cases, it may be useful to display data in separate satellite columns (12 period columns, e.g. for a simplified entry of plan data). The constant MONTH_ACTIVE must be active for this purpose.

The display of period values in columns is available for reading and writing (planning). Also working simultaneously with annual values for different value fields is possible.

The constant MONTH_ACTIVE is set up as follows:

· Entry X in column Value from activates conversion to period values. The program then tries to interpret quantity and value fields (RWX column = “V” or “Q”) as prefix of a satellite append field in the field assignment: if 12 fields carrying this prefix as well as ending 01 to 02 are available in the satellite, period data are stored or expected there.

· Entry X in column Value to for the constant allows a defined sorting of read CO/PA period data, which is useful especially with new SAP versions (see notes below, „Value from“ does not need to be active at the same time).

Note:

When using the CO/PA reading feature, the characteristic PERDE must be active for reading („R“) for the use of MONTH_ACTIVE. See the Allevo CO/PA manual for further details.

* effective from version 3.4.5

The BAPI for reading CO/PA data usually provides them sorted (by periods). This sort sequence is not always ensured in new SAP versions (e.g. for HANA). This may lead to unwanted results especially when importing data to period columns.

In this case, resorting data before adopting them to the satellite is necessary. This may be accomplished with an entry X in column Value to of constant MONTH_ACTIVE. MONTH_ACTIVE itself does not need to be active here, resorting may therefore also be performed for other purposes. However, it is recommended to activate sorting only if necessary, that is: if test runs showed that data are returning from the SAP system in an unsorted way.