Question Re: Attribute view blank fields during LEFT OUTER JOIN in Technology Q&A

Attribute view blank fields during LEFT OUTER JOIN

Former Member — Thu, 12 Mar 2020 11:06:21 GMT

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.

Re: Attribute view blank fields during LEFT OUTER JOIN

michael_eaton3 — Thu, 12 Mar 2020 11:17:29 GMT

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

Re: Attribute view blank fields during LEFT OUTER JOIN

agentry_src — Thu, 12 Mar 2020 11:23:22 GMT

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

Re: Attribute view blank fields during LEFT OUTER JOIN

Former Member — Thu, 12 Mar 2020 11:32:47 GMT

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!

Re: Attribute view blank fields during LEFT OUTER JOIN

michael_eaton3 — Thu, 12 Mar 2020 11:50:04 GMT

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. 🙂

Re: Attribute view blank fields during LEFT OUTER JOIN

michael_piesche — Thu, 12 Mar 2020 15:57:53 GMT

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

Re: Attribute view blank fields during LEFT OUTER JOIN

michael_eaton3 — Thu, 12 Mar 2020 16:00:23 GMT

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