Exam4Training

Which SELECT statement would you use in the definition?

You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD).

Which SELECT statement would you use in the definition? Please choose the correct answer.
A . select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd
B . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd
C . select from snwd_so {sojd, sum(net_amount) as sum_amount}
D . select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

Answer: B

Exit mobile version