How To Fix BRAIN_DEV645 - Query enthält Bestandskennzahlen und inkompatible Formeln

SAP Error Message - Details

• Message type: E = Error

• Message class: BRAIN_DEV - BRAIN messages (for use by development)

• Message number: 645

• Message text: Query enthält Bestandskennzahlen und inkompatible Formeln

Was verursacht dieses Problem?

The query contains non-cumulative key figures and exception aggregated
formulas. These formulas contain constants or variables with replacement
path from an attribute.
During non-cumulative processing, non-cumulative key figure values are
calculated for time periods for which there need not be any postings in
the posted data. In order to calculate values like this, the time
reference of the posted data is changed. If a characteristic value of
any characteristic is now not posted within the requested time period,
it might still be projected into the requested time period by
non-cumulative processing.
If a variable with replacement path from an attribute is defined on
characteristic M, or if characteristic M is a reference characteristic
for a formula that contains a constant with its own data representation
(for example <NP>SUM(1) over M</> ), the result depends on whether or
not the query contains a non-cumulative key figure in addition to this
formula.
Example
booked data
M,,CALDAY,,Delta of non-cumulative key figure
a,,01.03.2013,,5
a,,02.03.2013,,17
b,,05.03.2013,,19
In a query with filter on 5.03.2013 the result of <NP>SUM(1) over M</>
is 1.
Calculated non-cumulative values for 5.03.2013
M,,CALDAY,,Calculated non-cumulative key figure
a,,05.03.2013,,22
b,,05.03.2013,,19
In a query with filter on 5.03.2013 the result of <NP>SUM(1) over M</>
is 2.

Systemantwort

The system behaves for queries as described above.

Wie behebe ich diesen Fehler?

If a formula <NP>SUM(1) over calday</> should always count the days
resulting from non-cumulative processing, it is more precise and safe to
use a formula <NP>COUNT(non-cumulative keyfigure) over calday</>
instead.

Vorgehensweise für Systemadministratoren

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE