Attribute view blank fields during LEFT OUTER JOIN

[agentry_src]

Hi,

I have created an attribute view, for learning purposes.

I have joined three tables SFLIGHTxSBOOKxSCUSTOM, as shown in the below image, using LEFT OUTER JOIN.

The 'Raw Data' output of this view looks like below.

Why are Telephone and Email empty for multiple entries, despite having the same Customer ID?

Please help me understand what is happening here.

Thanks.

[agentry_src]

Please provide the SQL script that you are executing. It looks like you have some sort of Cartesian product with your outputs instead of single results. I would also recommend reversing the order of your join and start with the Customer rather than the Flight.

Regards, Mike

[michael_eaton3]

Is it possible you have multiple SAP Client's data?

While HANA can automatically filter views by MANDT (SAP Client), you might not be applying that in this case. Try adding MANDT to the output to check.

Michael

[Former Member]

Thank you Michael.

You are correct. They are from different clients. It became clearer once i added MANDT to output and join condition.

Edit: I think your response is a comment instead of an answer. So i could not mark it accepted!

[michael_eaton3]

Glad you solved it.

I didn't post it as an answer, as I was unsure whether it was an answer, or even the answer. 🙂

[michael_piesche]

michael.eaton3, you can still change a comment to an answer with the EDIT button 😉

[michael_eaton3]

Well, I never knew you could do that! Thanks for the tip.