SELECT
   SNWD_bpa~company_name,
   SNWD_SO_INV_ITEM~GROSS_AMOUNT,
   SNWD_SO_INV_ITEM~CURRENCY_CODE,
   snwd_so_inv_head~payment_status
 FROM
  SNWD_SO_INV_ITEM JOIN snwd_so_inv_head on snwd_so_inv_item~parent_key = snwd_so_inv_head~node_key
  JOIN snwd_pa on snwd_so_inv_head~buyer_guid = snwd_pa~node_key
 UP TO 100 ROWS
 INTO TABLE @DATA(lt_result)
 WHERE
  SNWD_SO_INV_ITEM~CURRENCY_CODE = 'EUR'