Former Member

HANA Calculation View Join

Hi All,

I am looking for help on below issue:

I have requirement join below 2 tables to combine sales and invoice data. Joined in Calculation view using left outer join where

PO No of Table A = Po no of Table B and

PO Line of Table A = Po Line of Table B

Table-A:

PO No Po Line Product Price Qty 4500360244 10 Article1 100 10 4500360244 20 Article2 200 5

Table-B:

PO No Po Line Invoice # Invoice Amt Currency 100 10 11 400 USD 100 10 12 600 USD 100 20 13 1000 USD

First PO cleared with 2 invoices (11&12) and expecting below output

PO No Po Line Invoice # Price Qty Invoice Amt Currency 100 10 11 100 10 400 USD 100 10 12 0 0 600 USD 100 20 13 200 5 1000 USD

But PO Price and Qty values are getting doubled and below is the output it is giving .

PO No Po Line Invoice # Price Qty Invoice Amt Currency 100 10 11 100 10 400 USD 100 10 12 100 10 600 USD 100 20 13 200 5 1000 USD

Any early help is highly appreciated.

Regards,

Kotesh

10|10000 characters needed characters exceeded

Related questions

Posted on Dec 14, 2015 at 03:44 AM

Hi,

The only differences between the "expected" and "actual" outputs are the Price and Qty fields in the second line.

The "actual" output is exactly what you will get if you join the two tables that you have. Why do you expect these to be zero?

Regards,

Suhas

10|10000 characters needed characters exceeded
• Former Member Suhas Karnik

Thanks all for your support. Going with different design solutions and hence closing.

• Former Member
Posted on Dec 11, 2015 at 06:26 PM

Sorry guys.. Wrong PO number updated in Table A.

PO No is same in both the tables i.e PO No = 100.