Joins in Logical View
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.