Hanatize code

[former_member737178]

Hi experts,

Could you please help me hanatize the below code. Any ideas would be awesome. Thanks in advance.

  SELECT DISTINCT m~ebeln
                  m~ebelp
                  e~netwr
    FROM eket AS m
   INNER JOIN ekpo AS e
      ON m~ebeln = e~ebeln
     AND m~ebelp = e~ebelp
    INTO (l_ebeln, l_ebelp, l_netwr)
   WHERE m~banfn = xs_banf-banfn
     AND m~bnfpo = xs_banf-bnfpo.

    xs_banf-ekpo_netwr = xs_banf-ekpo_netwr + l_netwr.
  ENDSELECT.

[matt]

The solution is just normal ABAP using SUM. Why hanatize it?

[former_member737178]

Hi Matthew,

What i am looking for is a way to move the operation in select statement so that the operation happens in database rather than application server.