Hi Paul,yes I can confirm loops in SQLScript, just look at the SQLScript reference here in the SCN. In the subsection Imperative SQLScript Logic-> Orchestration-Logic it says: Orchestration logic is used to implement data flow and control flow logic ...
Hi Anni,subselects are certainly on the backlog for the CDS Scrum team, unfortunately we have a long backlog.Regarding Loops, since CDS like SQL is a purely declarative language I do not think we will have any procedural elements like loops in the ne...
Hi Marek,if you multiply two decimal values the CDS compiler infers a type for the result and, thus, the number of decimals of the two operants are simply added up. You therefore easily exceed the max number of 31 in this release.If this fits to your...
Hi Franz,In the Open SQL, the associations have to be prefixed with a backslash '\' in order to distinguish them from usual columns.For example:Association in the select-list:SELECT salesorderuuid, \_PaymentTerms-SalesOrderPaymentTerm...
Hi Anita,currently the ABAP CDS does not support an ORDER BY clause yet. Since a "select top 5 ..." only make sense with a defined order, this feature is postponed as well. As soon as the ORDER BY is available, the LIMITS-clause will probably be supp...