topic Re: Hanatize code in Application Development and Automation Discussions

Hanatize code

former_member737178 — Tue, 23 Mar 2021 08:14:31 GMT

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.

Re: Hanatize code

matt — Tue, 23 Mar 2021 10:23:38 GMT

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

Re: Hanatize code

former_member737178 — Tue, 23 Mar 2021 14:25:29 GMT

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.