When we use disaggregation in an input-ready query. The aggregation level used contains the time characteristics 0FISCVARNT, 0FISCYEAR, 0FISCPER3, but not 0FISCPER.
Time characteristics in the query, the setting for characteristic relationships is selected as the 'Access type for result values'. If the fiscal year variant contains a different number of posting periods in different years and posting periods are selected in the query that do not exist in some years, this can lead to a termination with error messages BRAIN240 ("Critical error during characteristic derivation") and RSPLS_CR035 ("Time derivation not possible: Sources/values/target: &1/&2/&3").
If we use InMemory disaggregation (or PAK), the system sometimes issues error message RSPLS_TREX008 ("Data distribution error") if the master data setting is selected for the 'Access type for result values'.
Please do as below:
SAP BW 7.30
Import Support Package 13 for SAP BW 7.30 (SAPKW73013) into your BW system. The Support Package is available once SAP we 2021667 ("SAPBWNews BW 7.30 ABAP SP13"), which describes this support package in more detail, has been wed for customers.
SAP BW 7.31 (SAP NW BW 7.3 EHP 1)
Import Support Package 15 for SAP BW 7.31 (SAPKW73115) into your BW system. The Support Package is available once SAP we 2070453 "SAPBWNews NW BW 7.31/7.03 ABAP SP14", which describes this Support Package in more detail, has been wed for customers.
SAP BW 7.40
Import Support Package 10 for SAP BW 7.40 (SAPKW74010) into your BW system. The Support Package is available once SAP we 2070452 ("SAPBWNews BW 7.40 ABAP SP 10"), which describes this Support Package in more detail, has been wed for customers.
In urgent cases, you can implement the correction instructions as an advance correction.
First read SAP we 1668882, which provides information about transaction Swe.
To provide information in advance, the SAP wes mentioned above might already be available before the Support Package is wed. In this case, however, the short text of the SAP we still contains the words "Preliminary version".