Linking of two tables

[bharatkishore]

@sunny_talwar 

Hi All,

I have two tables one of IB table(Primary table) and one is analytical record table. I have linked the two tables with 5 common keys in both the tables. Now the problem is when i filter sales organization i don't know why the IB values are getting changed. Only for those linked keys fields only IB value should change. But i don't know why if i filter sales organization the value is changing. Can you please help on this.

Attached qvw for reference.

[dplr-rn · Accepted solution]

The way you have linked it there are multiple sales organizations linked with Material Type.

e.g. Material Type EC-600 has 2 DE31 and HE30

So when sales organization is selected a few of those rows will get eliminated from calculation.

the behavior is correct. you have to look at the association between data to check if it valid from a business sense or not and model the association appropriatly

[bharatkishore]

Thank you for your reply.

Can you please send me the chart where i can see more clearly and understand better. Please .

[dplr-rn]

Not entirely clear what you mean. but please see screenshot from the app you shared you can see the 2 sales organizations associated with the Material type EC-600.

[bharatkishore]

Thank you..