Calculation view

[former_member254442]

Hi All,

I have below requirement in calculation view on HANA Live . Could anyone please give some suggestion .

List of PR ( BANFN) taken from EBAN table will be passed to table EKBN . I need to take those PR which are not available in table EKBN. Only those PR which have value of field account assignment such as cost center, network , order no etc .  are available in EKBN table .

Thanking you .

BR,

[Former Member]

Hi Prajnal,

Basically you need to do left outer join between EBAN and EKBN tables. Join based on your columns.

Now filter for not null condition on columns from your right table.

This is like,

Select a.column1,

          b.column2,

from table1 a left outer join table2 b on a.column1 = b.column1

where b.column2 is not null.

using not null condition, you are making sure you only get the records from table 1 that has entries in table 2.

Regards,

Venkat N.

[former_member254442]

Thanks venkat . Could you please elaborate how & where can I write this statment as simply joining with left or right outer joint is not working .

[former_member254442]

Hi Venkat,

Since I am using graphical calculation view , how & where can I write this statement ?

[SergioG_TX]

are you getting any errors or are you just asking how to create a calc view to consume your hana live ?

if the latter, just add a proj node for the tables, and the do a join (left/right) hope this is a simple question/answer