Hi Dears, Could anyone help me with this. Thank you so much! Getting syntax error in CDS view: Column _afvc.aufpl is not contained in the entity selection list
@AbapCatalog.sqlViewName: 'ZMMLeistungePlan'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Basic view for MM_Leistungen_Plan'
define view ZMAMW_I_MM_Leistungen_Plan as select from ZMAMW_I_ESLL_PACKNO
association [1..*] to afvc as _afvc on ZMAMW_I_ESLL_PACKNO.Packno = _afvc.packno
association [1..*] to afko as _afko on _afvc.aufpl = _afko.aufpl
{
key ZMAMW_I_ESLL_PACKNO.Extrow,
ZMAMW_I_ESLL_PACKNO.Del,
ZMAMW_I_ESLL_PACKNO.Srvpos,
ZMAMW_I_ESLL_PACKNO.Menge,
ZMAMW_I_ESLL_PACKNO.Meins,
ZMAMW_I_ESLL_PACKNO.Ktext1,
ZMAMW_I_ESLL_PACKNO.Packno,
ZMAMW_I_ESLL_PACKNO.SubPackno,
_afvc.mandt as Mandt,
_afvc.aufpl as Aufpl,
_afko
}