2021443 SAP OSS Note - Non-cumulatives: Incorrect results for complex filter condit

SAP OSS Note 2021443 version 0003 contains details of a know issue related to Non-cumulatives: Incorrect results for complex filter condit . This includes any associated symptoms and instructions on how to fix it, see below for full details. Also check out the comments section to view/add related contributions, questions or screen shots, based on real life experience of this oss note and problem.

...For more information about the SAP support system known as OSS please check out the SAP OSS NOTES SECTION, whih includes how to download & implement them onto your SAP system using transaction code SNOTE.

Note 2021443 Details:

When does this problem occur

When you start a non-cumulative query, the system displays too little

data, incorrect data, or blank lines.

If you use an SAP HANA database, the execution of the query delivers

different results if you execute it in SQL mode and TREXOPS (mode

 0 = "No optimized operations in HANA/BWA") or in extended aggregate

mode (mode > 0).

The problem occurs in all databases.

Even if no aggregates exist, the results may be correct when you run in
RSRT - "Execute&Debug" - "Do not use aggregates".

Cause of the problem and Pre-requisites

This error occurs only if there are a lot of filter conditions with

different field element selections (FEMSs) in the query (for examp

le, restricted key figures). This error only occurs in case of an SQL


Solution instructions

,,SAP BW 7.40

,,Import Support Package 8 for SAP BW 7.40 (SAPKW74008) into your BW
system. The Support Package is available when SAP Note 2000326,, "S

AP BW News NW BW 7.4/ABAP SP08", which describes this Support Package in

more detail, is released for customers.

In urgent cases, you can implement the correction instructions as an

advance correction.

You must first read SAP Note 1668882, which provides information about

transaction SNOTE.

To provide information in advance, the SAP Notes mentioned above may

already be available before the Support Package is released. In t

his case, the short text of the SAP Note contains the words "Preliminary


Description of problem

Non-cumulative, non-cumulatives, query, incorrect data, TREXOPS, blank,

complex hull

Solution instructions

Please import the corrections attached to this OSS note into your SAP system using SNOTE.

You can also view the full details of this OSS note and download it to your SAP system ready for implementation using transaction code SNOTE. Once it has been downloaded you can read the full details, check out any installation instructions including manual changes and see if there are any pre-requisites.

You can also check if a new version of note 2021443 has been released as well as see if the note is valid for your current SAP system landscape.

Check if SAP OSS note 2021443 has already been downloaded and is valid

To check if this note has already been download, what status it has and if it is valid for your system first execute t-code SNOTE and click on the SAP Note Browser icon
Icon used to execute SAP Note Browser report within SNOTE

From here you can just enter the note number 2021443 and press execute. If the note already exists it's details will be displayed. See here for full step by step instructions on how to check if an SAP note has been downloaded and is valid for your system.

If note 2021443 does not exist on your system you will receive the message "Unable to find SAP Note that meets specified criteria"
Icon used to execute SAP Note Browser report within SNOTE

If this is the case you will need to download the note to you SAP system also using transaction SNOTE. For further details see Download note using SNOTE. Even if it does exist you may still want to check if you have downloaded the latest version of the note.

Alternatively you can find full details of this note on the SAP service market place(SNumber / Service market place login will be required)