Quantity and Amounts gets multiplied in HANA View

[former_member718715]

Hi All,

We came across one situation where QTY and Amount get multiplied in HANA View.

Please find the details below:

When we are pulling information from KNVK table values are getting multiplied. Because in KNVK table one customer can have multiple contact details.

Please find Example in Attached File.example.jpg

Note: Actual Quantity is 30 only, but as one Customer 'ABC' is having multiple contact details that is 'John' and 'Sam' values are getting multiplied and coming 60 for both. It should be 30 only for both and results also should be 30.

Temporary we removed SUM for measures from Semantic node and its working fine. But we need permanent fix for that. Request your kind suggestions for the same.

Thanks In Advance,

Asim.

[Abhishek_Hazra]

Hi,

You must be joining two tables if I am not wrong? Can you provide the details of the joining fields?

Best Regards,
Abhi

[former_member718715]

Hi Abhi,

Please find details below:

VBAK.KUNNR to KNVK.KUNNR (Left Join)

VBAK.VKORG to KNVK.VKORG (Left Join)

Thanks,

Asim