Skip to Content
0
Jul 30, 2023 at 10:00 AM

SAP BW Lookup Scenario in SAP HANA

95 Views

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.