Column... is not contained in the entity selection list

[ganesh1993]

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

}

[thkolz]

Please have a look at https://me.sap.com/notes/3076602

You need to add the following:

_afvc.packno as Packno,

[ganesh1993]

Hi Kolz.

Thank you so much for your support.

Tried as mentioned above but it still not fixed

[ganesh1993]

Thanks Kolz it worked with $projection as well what you mentioned on above.

[Sandra_Rossi]

Mess in the formatting, hopefully there'll be new SAP Community web site soon...

[Sandra_Rossi]

Could you please edit your question (menu Actions > Edit) and again format your code with button ABAP?

Thank you!

[ozturkozan]

You can try to use $projection.Aufpl instead of _afvc.aufpl

[ganesh1993]

Hi Ozan,

it worked

thanks you so much

[thkolz]

Just found out the same 😉