Skip to Content
0

Populate new column in Calculation view through self look-up in HANA

Dec 26, 2016 at 01:24 PM

48

avatar image

Hi Everyone,

We have a query.

We have the source table data in which has a column 'valid from' .

e.g

the output it should compare the records in the tables and populate valid till in the column just one day before of next the record which exists in the table for the same exchange rate ,currency and inf1 combination. For the last record, it should populate 31.12.9999

Please let me know if which scenario to use( CV with SQL or procedure)?

We cannot create a new table here as per restriction and therefore need to look for other solutions.

untitled.png (3.2 kB)
untitled1.png (4.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers