Analytical Query Inquiry

[#1]

Hi SAP Team,

I have a concern regarding the result I am getting.

First, I joined PurchaseOrderItem (POForStoreOrderSummary) with MaterialDocumentItem2.

When I check the data using Customer Data Browser, I get the following results:

• Goods Movement Type 643 = 10 quantity
• Goods Movement Type 101 = 4 × 1 = 4 quantity

In the Analytical Query, I applied the following filters:

• Goods Issue = 643
• Goods Receipt = 101

However, I am having an issue with the result because the Goods Issue quantity is showing as 14.

Could you please help me understand why the Goods Issue quantity includes the quantity from Goods Movement Type 101?

Thank you.

[HenrikeGroetecke]

#GenAI-Assisted Content

Hello,

Thank you very much for your question. 

I asked our internal chatbot for support, and here's the response. Please check whether the suggestions help you resolve your issue:

The issue you are experiencing with the Goods Issue quantity showing as 14 instead of 10 can be attributed to the way data is aggregated in your analytical query. This discrepancy often occurs due to the use of attributes from associations that have a ‘non-to-1’ cardinality. For more information, see the following knowledge base article: 3166853 - A custom analytical query results in larger values than expected.

Explanation:

• Cardinality Issue: When two tables are joined with a cardinality of X 1->n Y, entries from table X can appear multiple times, leading to duplicated data in the results. This is likely why the Goods Issue quantity is incorrectly aggregating values from Goods Movement Type 101.

• Resolution: To resolve this, you should review the associations in your query and ensure that they are correctly set to avoid duplication. Removing fields that contribute to data duplication can help achieve accurate results.

Steps to Fix:

1. Review Associations: Check the associations between your tables and ensure they are set correctly. Avoid using fields from ‘to many’ associations unless necessary.
2. Adjust Query: Remove or adjust fields that are causing duplication in your query.

Kind regards,

Henrike