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