Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Joins in Logical View

Hi Friends,

I am new to SAP HANA.
1. I created attribute view on MARA table (ZMAT_ATTV) and selected MATNR, MEINS AND MATKL. Activated and did the data preview-- Successful


2. Created Analytical view on EKPO table (ZPUR_ANAV) and selected EBELN, EBELP, MATNR, MEINS AND MENGE. Activated and did the data preview--successfull.

Now in logical view I added ZMAT_ATTV and linked MATNR to MATNR and selected RIGHT OUTER JOIN with cardinality 1:n. Data preview shows results. Next i selected LEFT OUTER JOIN with cardinality 1:n, Here no change in result.
I selected all types of joins and cardinalities but result remains the same.

if i select left outer join, then i should get only 1 record per material as MARA holds only one record but tats not happening. Am i missing something.

Thanks
Sri

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question