Skip to Content
0
Former Member
Jul 03, 2019 at 03:11 AM

HANA XS ASSOCIATION SYNTAX ERROR

118 Views Last edit Jul 03, 2019 at 03:14 AM 2 rev

Hello Friends, i have a requirement for which building HANA CDS, where currently i have used joins . i want to replace those joins with Associations. How to achieve it.?

namespace NS.DDL.Entities;
@Schema: 'MYSCHEMA'
context Test {
    view ZIPO as 
    select from EKKO as EKKO
    associationName: association[1] to EKPO
        on EBELN = associationName.EBELN
        {

ebeln
        };
};

the error on cursor is at : near association name .
Could you please help me with HANAXS syntax for association in HANA CDS???