SAP
E_HANAAW_16 · Question #117
You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOID). Which SELECT statement would you use in the definition? Please choose…
The correct answer is B. select from snwd_so {so_id(sum(net_amount) as sum_amount) group by sojd. 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 SOID). Which SELECT statement would you use in the definition? Please choose the correct answer.
Options
- Aselect from snwd_so {so_id(sum(net_amount) as sum_amount) order by sojd
- Bselect from snwd_so {so_id(sum(net_amount) as sum_amount) group by sojd
- Cselect from snwd_so {sojd, sum(net_amount) as sum_amount}
- Dselect from snwd_so {so_id(sum(net_amount) as sum_amount) group by net_amount
How the community answered
(34 responses)- A12% (4)
- B76% (26)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.