Skip to Content

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

Hi Everyone,

We have a query.

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


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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers