Hi Expert,
I have SAP BW scenario, where we derived the lookup of a attribute based on certain other attributes in the end routine of BW transformation. Now I want to implement the same in SAP HANA using sqlscript. Below is the pseudo code.
SELECT F1,
F2 ,
F3
FROM TABLE1 FOR ALL ENTRIES IN ITAB
WHERE F1 = ITAB-F1.
LOOP AT RESULT_PACKAGE ASSIGNING <RESULT_FIELDS>.
READ TABLE ITAB INTO WA WITH KEY F1 = <RESULT_FIELDS>-F1.
<RESULT_FIELDS>-F3 = WA-F3.
ENDLOOP.
Could you please help me on this.
Thanks.