Skip to Content
0
Former Member
Aug 08, 2016 at 01:30 AM

Guide for Open SQL enhancements in SAP ABAP HANA

487 Views

Hi Gurus,

Before posting this question, I searched a lot on internet for a material/guide that explaining syntax with examples.For example , the below CDS (Core data services) with annotation, what does symbol '$' mean in open SQL , selected fields in flower brackets etc..

define view demo_cds_association

(_spfli_scarr, id, carrier, flight, departure, destination )

as select from spfli

association [1..1] to scarr as _spfli_scarr

on $projection.carrid = _spfli_scarr.carrid

{ _spfli_scarr,

key spfli.carrid,

key _spfli_scarr.carrname,

key spfli.connid,

spfli.cityfrom,

spfli.cityto }

I do understand that while creating the CDS views, the wizard comes up with a syntax.But I'm looking for a guide/material that explains the new enhancements in Open SQL with examples that SAP introduced as part of ABAP AS 7.4 SP08.

Thanks in Advance,