cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member102099
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (0)