SAP
E_HANAAW151 · Question #4
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID). Which SELECT statement would you use in the definition? Please choose…
The correct answer is D. select from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id. See the full explanation below for the reasoning.
Question
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SO_ID). Which SELECT statement would you use in the definition? Please choose the correct answer. Response:
Options
- Aselect from snwd_so { so_id, sum(net_amount) as sum_amount } order by so_id
- Bselect from snwd_so { so_id, sum(net_amount) as sum_amount } group by net_amount
- Cselect from snwd_so { so_id, sum(net_amount) as sum_amount }
- Dselect from snwd_so { so_id, sum(net_amount) as sum_amount } group by so_id
How the community answered
(44 responses)- A2% (1)
- B16% (7)
- C7% (3)
- D75% (33)
Community Discussion
No community discussion yet for this question.