Incorrect results with different joins

[Former Member]

Hi Experts,

The joining between header tables to item tables so confuse to me.

therefore, I have done 2 scenarios and tested the results.

1)   VBAK ---VBELN(1:N)---> VBAP       ----- (VBLEN -VGBEL)(N:M) --> LIPS    output :  order quantity = 1742310(VBAP)  weight =82620445.848 (VBAK)

2)    VBAK --VBLEN(1:N) ---->VBAP      ----- (VBLEN--VGBEL)(N:M) -->LIPS      output :  order Qunatity  = 1639961(VBAP) weight =81457827.308(VBAK)

                                                                 (POSNR-VGPOS)(N:M)

the results too confused more,please suggest and guide the linking approach to get achieve the correct results in HANA  modelling.

Thanks.

Br,

Edukondalu

[lbreddemann]

As often:

please provide more information.

What HANA version are you using?

How are you modelling the joins (information models? SQL?

How do the queries you built look like?

Right now I don't even get your problem...

- Lars

[Former Member]

Hi Lars,

HANA DB 1.0 and HANA STUDIO Version: 2.0.13

I have created 3 analytical views

1)  SalesHeader

2)  SalesItem

3) Delivery Item

then I have created 2 Calculation views for test the results with different joins.

1)  Calview with Header join only

VBAK ---VBELN(1:N)---> VBAP

----- (VBLEN -VGBEL)(N:M) --> LIPS

output :  order quantity = 1742310(VBAP)  weight =82620445.848 (VBAK)

2) Calview with Header and item joins

VBAK --VBLEN(1:N) ---->VBAP

----- (VBLEN--VGBEL)(N:M) -->LIPS

                        VBAP (POSNR-VGPOS) LIPS (N:M)

output :  order Qunatity  = 1639961(VBAP) weight =81457827.308

so which calculation view is better approach to join between  Sales order to delivery orders.

Thanks.

Br,

Ed

[lbreddemann]

Sorry but ALL HANA versions are v1.0 at the moment.

What revision do you use?

And I still don't get your question.

In your first example you  join VBAK - VBAP - LIPS

In the second example you join VBAK - VBAP - LIPS but you perform the join between VBAK and LIPS with a different column pair, right?

Why would it be the same in your opinion?

How do you come the conclusion that one is better than the other?

What is it you want to achieve in the first place?

[Former Member]

Hi Experts,

Any suggestion??

Thanks.

Br,

Ed