I try to create a CDS view and as I learn here from the blogs association is something to consider above using joins. Now I try to replace my joins with associations but get a problem with a join on a join. how can asscociations be nested?
here the sample code where I get the error on the line
on _module_group_data.category = _group_type_descr.category
Table name _module_group_data unknown or shadowed by an alias
define view ZCMOD_DD_MODULEGROUP_DATA with parameters p_idate:abap.dats, p_lang:abap.lang //will define validity -- The Main object as select distinct from hrp1000 as object association [0..1] to hrp1733 as _module_group_data on object.plvar = _module_group_data.plvar and object.otjid = _module_group_data.otjid -- Module Group data association [0..1] to t7piqmodgrpcatt as _group_type_descr on _module_group_data.category = _group_type_descr.category and _group_type_descr.spras = $parameters.p_lang -- Modulegroup Extra Data association [0..1] to hrp9102 as _modulegroup_extra_data on object.plvar = _modulegroup_extra_data.plvar and object.otjid = _modulegroup_extra_data.otjid <br>