Skip to Content

Calculation view

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,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Aug 19, 2016 at 04:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 19, 2016 at 11:28 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded