Skip to Content
author's profile photo Former Member
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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.