Skip to Content
0
Sep 14, 2023 at 06:38 AM

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

284 Views Last edit Sep 14, 2023 at 06:40 AM 3 rev

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

}

Attachments

image.png (75.1 kB)