Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

ganesh1993
Explorer
0 Kudos
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

}

1 ACCEPTED SOLUTION

ozturkozan
Explorer
0 Kudos

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

8 REPLIES 8

thkolz
Contributor
0 Kudos

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

You need to add the following:

_afvc.packno as Packno,

0 Kudos

Hi Kolz.

Thank you so much for your support.

Tried as mentioned above but it still not fixed

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

Sandra_Rossi
Active Contributor
0 Kudos

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

Sandra_Rossi
Active Contributor
0 Kudos

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

Thank you!

ozturkozan
Explorer
0 Kudos

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

0 Kudos

Hi Ozan,

it worked

thanks you so much

0 Kudos

Just found out the same 😉